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

oracle ֮ϵͳ±í µãµÎ »ýÀÛ

²é¿´ÕýÔÚÖ´ÐеÄsqlÓï¾ä
SELECT osuser, username, sql_text from v$session a, v$sqltext b where a.sql_address =b.address order by address, piece;
²¶×½ÔËÐкܾõÄSQL
 select username,sid,opname, round(sofar*100 / totalwork,0) || '%' as progress, time_remaining,sql_text from v$session_longops , v$sql where time_remaining <> 0 and sql_address = address and sql_hash_value = hash_value
Èç¹û¸ú×Ù×Ô¼ºµÄ»á»°»òÕßÊDZðÈ˵ĻỰ    
  [A]¸ú×Ù×Ô¼ºµÄ»á»°ºÜ¼òµ¥    
  Alter   session   set   sql_trace   true|false    
  Èç¹û¸ú×Ù±ðÈ˵ĻỰ£¬ÐèÒªµ÷ÓÃÒ»¸ö°ü    
  exec   dbms_system.set_sql_trace_in_session(sid,serial#,true|false)    
  or    
  exec   dbms_system.set_sql_trace_in_session(sid,serial#,8,’’)£¬ÕâÀïµÄ8ÊǸú×Ù¼¶±ð    
  ¸ú×ÙµÄÐÅÏ¢ÔÚuser_dump_dest   Ŀ¼Ï¿ÉÒÔÕÒµ½    
  ¿ÉÒÔͨ¹ýTkprofÀ´½âÎö¸ú×ÙÎļþ£¬Èç    
  Tkprof   Ô­Îļþ   Ä¿±êÎļþ   sys=n    
   
   
  ÔõôÉèÖÃÕû¸öÊý¾Ý¿âϵͳ¸ú×Ù    
  [A]ÆäʵÎĵµÉϵÄalter   system   set   sql_trace=trueÊDz»³É¹¦µÄ    
  µ«ÊÇ¿ÉÒÔͨ¹ýÉèÖÃʼþÀ´Íê³ÉÕâ¸ö¹¤×÷£¬×÷ÓÃÏàµÈ    
  alter   system   set   events    
      ‘10046   trace   name   context   forever,level   1’;    
  Èç¹û¹Ø±Õ¸ú×Ù£¬¿ÉÒÔÓÃÈçÏÂÓï¾ä    
  alter   system   set   events    
      ‘10046   trace   name   context   off’;    
  ÆäÖеÄlevel   1ÓëÉÏÃæµÄ8¶¼ÊǸú×Ù¼¶±ð    
  level   1£º¸ú×ÙSQLÓï¾ä£¬µÈÓÚsql_trace=true    
  level   4£º°üÀ¨±äÁ¿µÄÏêϸÐÅÏ¢    
  level   8£º°üÀ¨µÈ´ýʼþ   &n


Ïà¹ØÎĵµ£º

oracle database link

Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈ
ÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£ 
1¡¢   Á´½Ó×Ö·û´®¼´·þÎñÃû£¬Ê×ÏÈÔÚ±¾µØÅäÖÃÒ»¸ö·þÎñÃû£¬µØÖ·Ö¸ÏòÔ¶³ÌµÄÊý¾Ý¿âµØÖ·£¬·þÎñÃûȡΪ½«À´ÄãҪʹÓõÄÊý¾Ý¿âÁ´Ãû£º
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¬
½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁî£ ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç12


¹ØϵÐÍÊý¾Ý¿âÀíÂÛÖÐ×Ö¶ÎÖµ±ØÐëÊǵ¥Öµ£¬¶øoracleÖÐÔÊÐíÔÚÒ»¸ö×Ö¶ÎÖд洢һ¸ö±íµÄÄÚÈÝ¡£
È磺Ա¹¤±íÖеÄÍâ¼ü ²¿ÃűàºÅ£¬oracleÖÐÕâ¸ö×ֶοÉÒÔ´æ·Å²¿ÃŵļǼ¶ø²¢²»ÊÇÒ»¸öÍâ¼ü£¬ÕâÑù²éѯʱºòµÄЧÂÊ»áÌá¸ß¡£
¿É±äÊý×飺
´´½¨´øÓпɱäÊý×éµÄ±í
´´½¨¿É±äÊý×é»ùÀàÐÍ
create or replace type »ùÀàÐÍÃû as object(×Ö¶ÎÇåµ¥); ......

Oracle RAC ³£ÓÃά»¤¹¤¾ßºÍÃüÁî


Oracle µÄ¹ÜÀí¿ÉÒÔͨ¹ýOEM»òÕßÃüÁîÐнӿڡ£ Oracle ClusterwareµÄÃüÁ¿ÉÒÔ·ÖΪÒÔÏÂ4ÖÖ£º
½Úµã²ã£ºosnodes
ÍøÂç²ã£ºoifcfg
¼¯Èº²ã£ºcrsctl, ocrcheck,ocrdump,ocrconfig
Ó¦Óò㣺srvctl,onsctl,crs_stat
ÏÂÃæ·Ö±ðÀ´½éÉÜÕâЩÃüÁî¡£ 
Ò»£® ½Úµã²ã
Ö»ÓÐÒ»¸öÃüÁ¡¡osnodes£¬ Õâ ......

ÔÚOracleÖеÄÊ÷ÐβÙ×÷

ÔÚOracleÖеÄÊ÷ÐβÙ×÷
1.È¡×ӽڵ㼰·¾¶(ÕýÊ÷):
select t.id ,t.code, t.name ,t.pid
,SYS_CONNECT_BY_PATH(t.id,'.')||'.' as IdPath
from tas_catalog t
--where id!=110
start with id=110
connect by  pid = prior id
order siblings  by id
2.È¡¸÷¼¶¸¸½Úµã(µ¹Ê÷)£º
select t.id ,t.code, t.na ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ