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

Oracle DatabaseÖÐDBA³£ÓõıíºÍÊÓͼ


dba_¿ªÍ·
   dba_users     Êý¾Ý¿âÓû§ÐÅÏ¢
   dba_segments  ±í¶ÎÐÅÏ¢
   dba_extents    Êý¾ÝÇøÐÅÏ¢
   dba_objects    Êý¾Ý¿â¶ÔÏóÐÅÏ¢
   dba_tablespaces   Êý¾Ý¿â±í¿Õ¼äÐÅÏ¢
   dba_data_files    Êý¾ÝÎļþÉèÖÃÐÅÏ¢
   dba_temp_files   ÁÙʱÊý¾ÝÎļþÐÅÏ¢
   dba_rollback_segs   »Ø¹ö¶ÎÐÅÏ¢
   dba_ts_quotas   Óû§±í¿Õ¼äÅä¶îÐÅÏ¢
   dba_free_space  Êý¾Ý¿â¿ÕÏпռäÐÅÏ¢
   dba_profiles   Êý¾Ý¿âÓû§×ÊÔ´ÏÞÖÆÐÅÏ¢
   dba_sys_privs   Óû§µÄϵͳȨÏÞÐÅÏ¢
   dba_tab_privs  Óû§¾ßÓеĶÔÏóȨÏÞÐÅÏ¢
   dba_col_privs  Óû§¾ßÓеÄÁжÔÏóȨÏÞÐÅÏ¢
   dba_role_privs  Óû§¾ßÓеĽÇÉ«ÐÅÏ¢
   dba_audit_trail  É󼯏ú×ټǼÐÅÏ¢
   dba_stmt_audit_opts  Éó¼ÆÉèÖÃÐÅÏ¢
   dba_audit_object   ¶ÔÏóÉ󼯽á¹ûÐÅÏ¢
   dba_audit_session  »á»°É󼯽á¹ûÐÅÏ¢
   dba_indexes  Óû§Ä£Ê½µÄË÷ÒýÐÅÏ¢
user_¿ªÍ·
   user_objects   Óû§¶ÔÏóÐÅÏ¢
   user_source   Êý¾Ý¿âÓû§µÄËùÓÐ×ÊÔ´¶ÔÏóÐÅÏ¢
   user_segments   Óû§µÄ±í¶ÎÐÅÏ¢
   user_tables    Óû§µÄ±í¶ÔÏóÐÅÏ¢
   user_tab_columns   Óû§µÄ±íÁÐÐÅÏ¢
   user_constraints   Óû§µÄ¶ÔÏóÔ¼ÊøÐÅÏ¢
   user_sys_privs   µ±Ç°Óû§µÄϵͳȨÏÞÐÅÏ¢
   user_tab_privs   µ±Ç°Óû§µÄ¶ÔÏóȨÏÞÐÅÏ¢
   user_col_privs   µ±Ç°Óû§µÄ±íÁÐȨÏÞÐÅÏ¢
   user_role_privs   µ±Ç°Óû§µÄ½ÇɫȨÏÞÐÅÏ¢
   user_indexes   Óû§µÄË÷ÒýÐÅÏ¢
   user_ind_columns  Óû§µÄË÷Òý¶ÔÓ¦µÄ±íÁÐÐÅÏ¢
   user_cons_columns   Óû§µÄÔ¼Êø¶ÔÓ¦µÄ±íÁÐÐÅÏ¢
   user_clusters   Óû§µÄËùÓÐ


Ïà¹ØÎĵµ£º

OracleµÄredo ºÍundoµÄÇø±ð

дµÄ´ÎÐò:
redo--> undo-->datafile
insertÒ»Ìõ¼Ç¼ʱ, ±í¸úundoµÄÐÅÏ¢¶¼»á·Å½ø redo ÖÐ, ÔÚcommit »ò֮ǰ, redo µÄÐÅÏ¢»á·Å½øÓ²ÅÌÉÏ. ¹ÊÕÏʱ, redo ±ã¿É»Ö¸´ÄÇЩÒѾ­commit Á˵ÄÊý¾Ý.
redo->ÿ´Î²Ù×÷¶¼ÏȼǼµ½redoÈÕÖ¾ÖУ¬µ±³öÏÖʵÀý¹ÊÕÏ£¨Ïñ¶Ïµç£©£¬µ¼ÖÂÊý¾ÝδÄܸüе½Êý¾ÝÎļþ£¬ÔòÊý¾Ý¿âÖØÆôʱÐëredo£¬ÖØÐ ......

oracleË÷ÒýË鯬

author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......

oracle 10g em¡¢isqlplus·ÃÎʲ»Á˵ÄÎÊÌâ½â¾ö

Èç¹ûweb·½Ê½µÄem£¬isqlplus·ÃÎʲ»ÁË¡£
1. ¼ì²éÖ÷»úÃû/IP¡¢¶Ë¿ÚÊÇ·ñÕýÈ·
°²×°Ê±µÄÖ÷»úÃû/IP¡¢¶Ë¿Ú¼Ç¼ÔÚ$ORACLE_HOME/install/portlist.ini ÎļþÖС£
ȱʡÊÇ£º
Ò»°ãÓû§                    
http://ip:5560/isq ......

oracle×Ö·û´®·Ö¸îºÍÌáÈ¡º¯Êý¶¨Òå


oracle×Ö·û´®·Ö¸îºÍÌáÈ¡
·Ö¸î
create or replace function Get_StrArrayLength
(
  av_str varchar2,  --Òª·Ö¸îµÄ×Ö·û´®
  av_split varchar2  --·Ö¸ô·ûºÅ
)
return number
is
  lv_str varchar2(1000);
  lv_length number;
begin
  lv_str:=ltrim(rtrim(av_str));
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ