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
Ïà¹ØÎĵµ£º
Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈ
ÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£
1¡¢ Á´½Ó×Ö·û´®¼´·þÎñÃû£¬Ê×ÏÈÔÚ±¾µØÅäÖÃÒ»¸ö·þÎñÃû£¬µØÖ·Ö¸ÏòÔ¶³ÌµÄÊý¾Ý¿âµØÖ·£¬·þÎñÃûȡΪ½«À´ÄãҪʹÓõÄÊý¾Ý¿âÁ´Ãû£º
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¬
½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁî£ ......
¹ØϵÐÍÊý¾Ý¿âÀíÂÛÖÐ×Ö¶ÎÖµ±ØÐëÊǵ¥Öµ£¬¶øoracleÖÐÔÊÐíÔÚÒ»¸ö×Ö¶ÎÖд洢һ¸ö±íµÄÄÚÈÝ¡£
È磺Ա¹¤±íÖеÄÍâ¼ü ²¿ÃűàºÅ£¬oracleÖÐÕâ¸ö×ֶοÉÒÔ´æ·Å²¿ÃŵļǼ¶ø²¢²»ÊÇÒ»¸öÍâ¼ü£¬ÕâÑù²éѯʱºòµÄЧÂÊ»áÌá¸ß¡£
¿É±äÊý×飺
´´½¨´øÓпɱäÊý×éµÄ±í
´´½¨¿É±äÊý×é»ùÀàÐÍ
create or replace type »ùÀàÐÍÃû as object(×Ö¶ÎÇåµ¥);
......
Oracle µÄ¹ÜÀí¿ÉÒÔͨ¹ýOEM»òÕßÃüÁîÐнӿڡ£ Oracle ClusterwareµÄÃüÁ¿ÉÒÔ·ÖΪÒÔÏÂ4ÖÖ£º
½Úµã²ã£ºosnodes
ÍøÂç²ã£ºoifcfg
¼¯Èº²ã£ºcrsctl, ocrcheck,ocrdump,ocrconfig
Ó¦Óò㣺srvctl,onsctl,crs_stat
ÏÂÃæ·Ö±ðÀ´½éÉÜÕâЩÃüÁî¡£
Ò»£® ½Úµã²ã
Ö»ÓÐÒ»¸öÃüÁ¡¡osnodes£¬ Õâ ......
ÔÚ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 ......