Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±í¹ÜÀí_3ÔÂ6ÈÕ

3ÔÂ6ÈÕ£º
¾Å¡¢±í¹ÜÀí£º
Ò»¡¢ÔÙ±í¹ÜÀíÖÐÐèҪѧϰµÄÄÚÈÝ£º
1¡¢  ´´½¨±í
2¡¢  ³£ÓõÄÊý¾ÝÀàÐÍ
3¡¢  ɾ³ý±í
4¡¢  ¸´ÖƱí
5¡¢  Ð޸ıí
6¡¢  ±íÖØÃüÃû
7¡¢  ½Ø¶Ï±í
8¡¢  ±íµÄÔ¼ÊøÌõ¼þ
¶þ¡¢´´½¨±í
³£¼û±íÓï·¨£º
´´½¨±íÓï·¨£º
CREATE TABLE ±íÃû
(
   &nb ......

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


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

ORACLE 10 ѧϰ±Ê¼ÇÃüÁî µÚÒ»¿Î¡£(¸¶Ê×ê¿)

ORACLE 10 ѧϰ±Ê¼ÇÃüÁîµÚÒ»¿Î¡£
1.
sqlplus /nolog
connect /as sysdba
alter user scott account unlock;
alter user scott identified by manager;
2.
grant  select on dept to nmerp;
revoke select on dept to nmerp;
select * from scott.dept
create table abc(a varchar2(10),b char(10));
alter& ......

ÔÚOracleÖÐʹÓÃGuid

ÔÚOracleÖÐʹÓÃGuid
ÔÚOracleÖпÉÒÔÓÃSYS_GUID()À´Éú³ÉÒ»¸öguid,Ï൱ÓÚmsSqlÖеÄnewid()¡£
ÔÚOracle9iºÍOracle 10g ÀïSYS_GUID²úÉúµÃµ½µÄÊý¾ÝÊÇ32 λµÄ£¬È磺234E45F0077881AAE0430AA3034681AA
µ«OracleÖеÄguidÓëmsSqlÖеÄguid¸ñʽ²»ÍêÈ«Ïàͬ¡£
½«OracleÖеÄguid·Ö¸î³ÉΪ Windowsϵͳ ObjectId µÄ¸ñʽ£º{8-4-4-4-12} £ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ