CREATE UNIQUE INDEX ICX.ICX_TRANSACTIONS_U1 ON ICX.ICX_TRANSACTIONS
 (TRANSACTION_ID) LOGGING  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE
 STATISTICS  TAB...]]> blog veteransa Fri, 25 Apr 2008 16:47:55 GMT http://space.itpub.net/8324643/viewspace-64877 blog veteransa Mon, 31 Dec 2007 22:47:13 GMT http://space.itpub.net/8324643/viewspace-65130 ¾­³£Íü¼Ç£¬¼Ç¼ÕâÀÒԱ㱸²é£º

PGAµÄÄÚ´æÃüÖУº

SELECT name profile,cnt,decode( total, 0, 0, round( cnt * 100 / total)) percentage
FROM ( SELECT name, value cnt, ( SUM( value ) OVER()) total
FROM v$sysstat
WHERE name LIKE '...]]> blog veteransa Mon, 29 Oct 2007 00:00:00 GMT http://space.itpub.net/8324643/viewspace-65128 ת×Ô£ºhttp://ningoo.itpub.net/post/2149/287794

Oracle³£ÓÃdumpÃüÁ¼Ç¼һϱ¸²é¡£

Ò».Memory Dumps blog veteransa Tue, 23 Oct 2007 00:00:00 GMT http://space.itpub.net/8324643/viewspace-65129 ½ñÌì¿´µ½¸öÌû×Ó£¬¹ØÓÚË÷ÒýÖÐÊÇ·ñ°üº¬ROWID£¬×ö¸öDUMP¸ú×ÙÏ¿´£¬ÒÔÏÂΪÏêϸµÄ¸ú×ټǼ£º blog veteransa Tue, 23 Oct 2007 00:00:00 GMT http://space.itpub.net/8324643/viewspace-65126 ¡¡¡¡×òÌìÔÚ¸øÓ¦ÓÃϵͳ×öÉý¼¶µÄʱºò£¬½Å±¾ÀÏÊÇÖ´Ðе½Ò»°ë£¬¾Í³öÏÖ£¬ÒѶϿªÊý¾Ý¿âÁ¬½Ó£¬¸ú×Ùºó·¢ÏÖ£¬Ö´Ðе½Öмä»Ø³öÏÖ£¬ora-03113´íÎó(ͨÐÅͨµÀµÄÎļþ½áÊø),½ÓמÍÊÇora-03114(ʧȥoracleÁ¬½Ó£©£®

blog veteransa Fri, 19 Oct 2007 00:00:00 GMT http://space.itpub.net/8324643/viewspace-65127 ÓÉÓÚÐèÒª£¬ÐèËõСһÊý¾Ý¿âµÄ£Ó£Ç£Á£¬²¢ÖØзÖÅä:

alter system set sga_max_size=500m scope=spfile;

alter system set sga_target=500m scope=spfile;

shutdown immediate;

startup;

alter system system set shared_poll_size=300m sc...]]> blog veteransa Fri, 19 Oct 2007 00:00:00 GMT http://space.itpub.net/8324643/viewspace-65125 Ô­ÌùµØÖ·£ºhttp://bbs.chinaunix.net/viewthread.php?tid=88178