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 Óû§µÄËùÓÐ
Ïà¹ØÎĵµ£º
дµÄ´ÎÐò:
redo--> undo-->datafile
insertÒ»Ìõ¼Ç¼ʱ, ±í¸úundoµÄÐÅÏ¢¶¼»á·Å½ø redo ÖÐ, ÔÚcommit »ò֮ǰ, redo µÄÐÅÏ¢»á·Å½øÓ²ÅÌÉÏ. ¹ÊÕÏʱ, redo ±ã¿É»Ö¸´ÄÇЩÒѾcommit Á˵ÄÊý¾Ý.
redo->ÿ´Î²Ù×÷¶¼ÏȼǼµ½redoÈÕÖ¾ÖУ¬µ±³öÏÖʵÀý¹ÊÕÏ£¨Ïñ¶Ïµç£©£¬µ¼ÖÂÊý¾ÝδÄܸüе½Êý¾ÝÎļþ£¬ÔòÊý¾Ý¿âÖØÆôʱÐëredo£¬ÖØÐ ......
author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......
Èç¹ûweb·½Ê½µÄem£¬isqlplus·ÃÎʲ»ÁË¡£
1. ¼ì²éÖ÷»úÃû/IP¡¢¶Ë¿ÚÊÇ·ñÕýÈ·
°²×°Ê±µÄÖ÷»úÃû/IP¡¢¶Ë¿Ú¼Ç¼ÔÚ$ORACLE_HOME/install/portlist.ini ÎļþÖС£
ȱʡÊÇ£º
Ò»°ãÓû§
http://ip:5560/isq ......
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 ......