??????????Я????????1???÷з??????????????????????????????????????????????????????????????????????????????????????????????У???????????lesson learn???????????????飬?????淶??
???????????????????????????ж???????????????????????????儀??????????仰???????ü??????????????????????????????????
??????????????????????????????????????????????1????????????????????в??????????????????????????????????????????????????ο?????
??????????Щ??????Щ??????????????Щ????·????????????????????????????????????????????????????????????????????????????????Щ?????????????????
????????1?????sql?????????ū? ???? http://blog.itpub.net/23718752/viewspace-1141131/
???????????????????????????????????????
?????????????????????alter system set sga_target=xxxG; ????????????????????崻?????????????????????Щ???????????????????Oracle bug?й??
????Bug 10173135 - Resize SGA_TARGET crashes instance with ORA-600 [kmgsb_resize_sga_target_1] (Doc ID 10173135.8)
?????????????????????????????????????е?????????????????????????????????????ú?????????????н???????????????????????????????????е???????????????????????з???????????
????????2??kernel???e??????ūhang http://blog.itpub.net/23718752/viewspace-1417471/ ???
??????????????????????????????????????????????????????????ū崡???????????????????swap????????????????????????????sga???????????hugepage?????????????
????????????????????????????hugepage??????????????????????
????****************** Huge Pages Information *****************
????Huge Pages memory pool detected (total: 30000 free: 27287)
????Huge Pages allocation failed (free: 29431 required: 32457)
????Allocation will continue with default/smaller page size
????**********************************************************
???????????????????????????????linux?????????????????????????????????????С???
????????3???????ι?????????
??????ι????????????л??????????Ч?????????????????Щ???????????????е??Щ???????????????????????????????????ν?????????????°????????????????????1???????????????????????????????ж????????????????????????????????????в????????????????????????????????????????????????????????????????Щ?????????????????re-create??????drop????????????????????????????????μ??????????????????????????????????????????????????????????????????????????к????????????????????????????????????????????????????????????
?????????????е???????????????????????????????????á?????????????????????
????????4:??????????е?exp??????Щ???????  http://blog.itpub.net/23718752/viewspace-773852/
??????????????????????????????????????????????????????????????з???????????Σ?????з???????????????л?????????????????????С?????????exp ???consistent=y?????????????????????????????????????
????exp APP_ROLLBK/APP_ROLLBK file=test.dmp tables=AAAAA  consistent=y
????Export: Release 11.2.0.2.0 - Production on Tue Oct 8 08:30:08 2013
????Copyright (c) 1982?? 2009?? Oracle and/or its affiliates.  All rights reserved.
????Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
????With the Partitioning?? OLAP?? Data Mining and Real Application Testing options
????Export done in UTF-8 character set and UTF8 NCHAR character set
????About to export specified tables via Conventional Path ...
????. . exporting table                  AAAAA 76 rows exported
????EXP-00008: ORACLE error 1466 encountered
????ORA-01466: unable to read data - table definition has changed
????Export terminated successfully with warnings.
????????????????????????????????Щ??????purge recyclebin????????????? mealink?е??????????????????????bug?????????????????????????????????????????????10???С??????????????????????????
????????4:pl/sql???????????????????? http://blog.itpub.net/23718752/viewspace-1172818/
?????????????????????????????????????????????????????????????????????????????????в??????????????????????????в????????????????pl/sql?????ü???С????????????????????????????????
?????????pl/sql???sql?????????????????????????????????????′?????Щ????????
????.....
??????????????к??????????????????????????????????????????????????Щ?????????μ???????????????????????????
???????????????? ????????????????1??????????????????????????????????????????磬?????????UPS?????????????????????????????????????????????????????????????????С??????????????????????????????????????Ц?????о???