Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle»¹Ô­Êý¾Ý¶Î³£ÓùÜÀí²Ù×÷

²ÎÊý
UNDO_MANAGEMENT = AUTO      --¹ÜÀíģʽ,¿ÉΪAUTO»òMANUAL.Ö»ÄÜÔÚÆôʼ²ÎÊýÎļþÀïÃæÐÞ¸Ä
UNDO_TABLESPACE = undo             --ÖÆ¶¨´æ´¢»¹Ô­Êý¾ÝµÄ±í¿Õ¼ä,Òà¿ÉÓÃALTER SYSTEM SET undo_tablespace = 'abc'À´¸ü¸Ä
UNDO_RETENTION = 1800               --Ö¸¶¨Êý¾ÝÌá½»ºó»¹Ô­¶Î¼ÌÐø±£´æ¶à¾ÃµÄʱ¼ä,ÃëÖÓ. Òà¿ÉÓÃALTER SYSTEM SET undo_retention = 900À´¸ü¸Ä
UNDO_SUPRESS_ERRORS = true      --ÔÚ×Ô¶¯Ä£Ê½ÏÂÊÖ¶¯¹ÜÀí»¹Ô­¶ÎÊÇÊÇ·ñ±¨´í,TRUEΪºöÂÔ´íÎó.²»»áÓиºÃæÓ°Ïì. Òà¿ÉÓÃALTER SESSION SET UNDO_SUPRESS_ERRORS = flaseÀ´±ä¸ü ´´½¨»¹Ô­±í¿Õ¼ä
CREATE UNDO TABLESPACE abc_undo DATAFILE 'c:\abc_undo.dbf' SIZE 20M; ÆäËû±í¿Õ¼ä²Ù×÷ÓëÆäËû±í¿Õ¼äÏàͬ,ΪÁ˿ռ乻ÓÃ×îºÃ½«»¹Ô­±í¿Õ¼äÉèΪ×Ô¶¯ÍØÕ¹. Çл»»¹Ô­±í¿Õ¼ä
ALTER SYSTEM SET UNDO_TABLESPACE = 'abc_undo' ɾ³ý»¹Ô­±í¿Õ¼ä,×¢Òâ²»ÄÜɾ³ýµ±Ç°»¹Ô­±í¿Õ¼ä
DROP TABLESPACE abc_undo; ²é¿´µ±Ç°»¹Ô­¶Î×´¿ö
SELECT name, value from v$parameter WHERE name LIKE '%undo%'; »ñÈ¡»¹Ô­Êý¾ÝÐÅÏ¢
a.) »ñÈ¡»¹Ô­Êý¾Ýͳ¼ÆÐÅÏ¢
SELECT TO_CHAR(begin_time, 'HH:MM:SS') begin_time, TO_CHAR(end_time, 'HH:MM:SS') end_time, undoblks, txncount, maxquerylen from v$undostat;
     ÆäÖÐundoblksΪ¸Ãʱ¼ä¶ÎÄÚÏûºÄµÄ»¹Ô­Êý¾Ý¿éÊýÁ¿,txncountΪ¸Ãʱ¼ä¶ÎÖÐÊÂÎñµÄ×ÜÊý, maxquerylenΪ¸Ãʱ¼ä¶ÎÖÐÖ´ÐÐ×µÄ²éѯ(ÃëÊý).
b.)»¹¿ÉÒÔʹÓÃÒÔϸ÷ÊÓͼ»ñÈ¡ÓÐÓÃÐÅÏ¢
     dba_tablespaces, dba_data_files, dba_rollback_segs, v$rollname, v$rollstat, v$session, v$transaction


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

sdeÓëoracleµÄ°æ±¾ÎÊÌâ

1.ʹÓòúÆ·£ºarcsde 9.3+oracle 10.2.0.1
2.ÎÊÌâÃèÊö£ºÓÃarcmap·ÃÎʿռäÊý¾Ý£¬²Ù×÷¼¸·ÖÖÓ£¬arcmapÎÞ·´Ó¦£¬Êý¾Ý¿â·þÎñÆ÷¶ËcpuÕ¼ÓÐÂÊ100%£¬gsrvr.exe½ø³ÌÊý10+¡£
3.½â¾ö°ì·¨£ºÉý¼¶oracle°æ±¾´Ó10.2.0.1Éý¼¶µ½10.2.0.3»òÕß.2.0.4¡£
4.Ô­Òò£º¾Ýesri¹¤³ÌʦËù³Æ£¬oracle10.2.0.1°æ±¾´æÔÚÓëarcgis²»¼æÈݵÄÎÞ·¨µ÷½ÚµÄbug¡£Ä¿Ç°Éý ......

Oracle objectѧϰ±Ê¼Ç 1

 1 ¾Û¼¯(cluster)
1.1 ¸ÅÄ
ÓÃÓÚ½«²»Í¬±íÖеÄÊý¾Ý´æ´¢µ½ÏàͬµÄÎïÀíÊý¾Ý¿éÖУ¬ÓÃÓÚ¶à±íÊý¾ÝÐèҪƵ·±½øÐÐÁªºÏ²éѯµÄÇé¿öÏ¡£¶à±íÊý¾Ý´æ´¢ÔÚÏàͬÊý¾Ý¿éºó£¬ÔÚ¶Ô¶Ô±í½øÐÐÁªºÏ²éѯʱ£¬ËùÐè¶ÁÈ¡µÄÎïÀí¿éÊý¼õÉÙ£¬´Ó¶øÌá¸ß²éѯÐÔÄÜ¡£
ÐèҪעÒâµÄÊǶԾۼ¯Öе¥±íµÄ²éѯºÍ¶Ô¾Û¼¯ÖбíÊý¾Ý½øÐÐÐ޸Ļò²åÈëµÈÊÂÎñ²Ù×÷ʱ£¬ÐÔÄܽ«Ê ......

Oracle start with ... connect by prior Ó÷¨

 Óï·¨£º
select *
from ±íÃû
where Ìõ¼þ1
start with Ìõ¼þ2
connect by prior µ±Ç°±í×Ö¶Î=¼¶Áª±í×Ö¶Î
start withÓëconnect by priorÓï¾äÍê³ÉµÝ¹é¼Ç¼£¬ÐγÉÒ»¿ÃÊ÷Ðνṹ£¬Í¨³£¿ÉÒÔÔÚ¾ßÓвã´Î½á¹¹µÄ±íÖÐʹÓá£
start with±íʾ¿ªÊ¼µÄ¼Ç¼
connect by prior Ö¸¶¨Ó뵱ǰ¼Ç¼¹ØÁªÊ±µÄ×ֶιØÏµ
´úÂ룺
--´´½¨²¿Ãű ......

ÔÚOracleÖд´½¨ÊÓͼ£¬ÌáʾÎÞȨÏÞ ORA

 ½ñÌìÔÚ¶Ô±í´´½¨ÊÓͼµÄʱºò£¬Óû§Ìáʾ ORA-01031Óû§È¨ÏÞ²»×ã 
ʹÓÃsystemÓû§¶ÔÆä·ÖÅädbaµÈȨÏÞ£¬ÒÀÈ»ÎÞ·¨´´½¨ÊÓͼ¡£ 
¼ÌÐø¸³ÓèȨÏÞ 
grant select any table to AAA; 
ÊÚÓèÓû§Ñ¯ËùÓбíµÄȨÏÞ 
grant select any dictionary to AAA; 
ÔÙ´ÎÊÚÈ¡Óû§selectÈκÎ×ÖµäµÄȨÏÞ 
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ