1、kDv;Bg;s;G;? kuQ?5Kw;Xk; _s44E59 /$#: ,!# ;Y ; N; ;Xf5 6 ,!#746 ,!#746 ,!#7S; 5Kht; kL;IK!N=! 5LNfu;IBM Nmon9fX AIX Linux: Oracle OSWatcher D=f Oracle S spack AWR ; Oracle Database 10g ;l;D9?; 7 :5 (*) !.%#,XN;Nmon E OSWatcher n;9 ios 4vms 4nets 4mps 4top :;hL;Z5Nmon f;?;Rf; 18-1 Nmonf Logo 18-1 Nmo

2、n ;)LG Logo : =RQ# X Nmon ;IBM xU NMON_YSER ;f Nmon huM;gMExcel ;z; 18-2? Nmon ;fr CPU4IO 503640; k 18-2 V Nmon 8:/A# OSWatcher Oracle ?;Nu9Windows4Linux4AIX4HP-UX4Solaris :; 18-3 Logo 18-3 OSWatcher : LogoOSWatcher UQf;X; 18-4 vv 18-4 OSWatcher 8: H/AI;z;b;fgu503650; k .!.-+!& Oracle S spack a Orac

3、le 8.1.6 Oracle;BM DBA Oracle F 5L; S spack ;$ORACLE_HOME/rdbms/admin C5X Oracle 8.1.6;h?f s h;a Oracle 8.1.7 ;f sp ; ? S spack ?Kh; Oracle Database 10g L5 S spack ;f5a Oracle Database 10g ;Oracle ?;U AWR9Automatic Workload Reitory;u:;AWR ?; SYSAUX L; 7 5 f AWR M Oracle Database/Grid Control a4BB?;

4、Web; 18-5 Grid Control Q? 18-5 Grid Control : =# ASH4AWR4ADDM j; Database/Grid Control ;M Oracle Database 10g Uz5o Database/Grid Control D?K;Lc9c h Diagnostics Pack4Tuning Pack4Change Management Pack4Configuration Management Pack4 Provi ing Pack for Database4Data Masking Pack :5Database/Grid Control

5、 Lh Diagnostics Pack;Khx ;CN!Automatic Workload Reitory=!Automatic Database Diagnostic Monitor (ADDM)=03660; k!Active SesHistory (ASH)=!Performance monitoring (database and host)=!Event notifications: notification methods, rules, and schedules=!Event history and metric history (database and host)=!B

6、lackouts=!Dynamic metric baselines=!Monitoring templates=!Memory-acs based performance monitoring=!Supporting functionality to perform per stream bottleneck detection and per component top wait event ysis5MUvB;BT Diagnostic Pack; Oracle Database 11g L;?KX Diagnostic Pack Tuning Pack v;K CONTROL_MANA

7、GEMENT_ PACK_ACS;AK5DIAGNOSTIC+TUNING Diagnostic Pack and Tuning Pack =DIAGNOSTIC Diagnostic Pack =NONEDiagnostic Pack Tuning pack 5Z Pack f Ent rise Manager e API ;?Z License 5o?Zw;g AWR ;fZ ;oU;f DBA_HIST_ License ;U Oracle Database 11g L;Oracle UfCwDBA_HIST_SNAPSHOT, DBA_HIST_DATABASE_INSTANCE=DB

8、A_HIST_SNAP_ERROR, DBA_HIST_SEG_S=_OBJ, DBA_HIST_UNDOS5DBA_HIST_SEG_SRZfv5?ZB;Z5 UNQ;gfKU;DfU;fpE5AWR E OSWatcher w?L;U?K weblogic 503 950311Service Unavailable:; K;l ; weblogic 5 OSWatcher |9 18-6 :;g?91:552:15:; IO U 100%5 Database Control f9 18-7 :;U?K;User I/O ; I/O u503670; k 18-6 OSWatcher 8:?

9、CJE/A 18-7 Database Control 8:?CJE ?;fK;SQL L?K SQL U 50%; 18-8 5 18-8 SQL 5 H# ; SQL 18-9 9 SQL LM:503680;k 18-9 F:UK76D: SQL gfKC SQL Q;gf L;aq ; 5;gK ?U5C?y; AWR 9 18-10 :;f N 75%;Zf5 ; ;vKM ; Lh 5X SQL IO ;IO 5M;?k 18-10 AWR :?CN1% ?; 18-11 ;KMP# gf a ; NM 8GB; SGA 2.5GB ; 400 4GB ;vC;t 900MB1GB

10、 ;v 18-12 5 18-12 OSWatcher 9/A ;X ;Df ? SWAP ;fCgM q; X= h;= k; k; 5C;Uh;U ;aU5Sspack QwwL;UvB;x S spack L;gU?Z SQL q;fCIKL03700SnaSnap TimeSess Curs/Sess CommentBegin Snap:2788 24-Aug-08 20:05:172133,575.0End Snap:2789 24-Aug-08 21:59:412213,446.6Elapsed:114.40 (mins); kTop SQL LC SQL ;Z9 3 ?K SQL

11、:; G; CPU Time R9?K Oracle Database 9i RAC : End Buffer Gets Threshold:10000- Notet resourreported for PL/SQL includes the resourused byall SQL sements called withhe PL/SQL code. As individual SQLsements are also reported, it issible and valid for the summedtotal % to exceed 100CPUElapsdBuffer GetsE

12、xecutions Gets per Exec %Total Time (s) Time (s) Hash Value19, 152, 34877124, 840. 99. 7320. 59313. 59 3703718686Module: javadbweb8 (TNS V1-V3)SELECT SYS_TOPIC,SYS_OURCETYPE,PUBOUTER_SID,AV_LENGTH,SYS_LASTMODIFIED,PUB_SE,DOC_LENGTH,EXT_WIDTH,DOC_REALTYPE,SYS_DELETEFLAG,EXT_HEIGHT,SYS_HAVERELATION,SY

13、S_DOCLIBID,SYS_AUTHORS,D OC_WRITEDATE FROM DEM_RL_CATEGORY_FENL Where ( class_5=179 ) AND( (DOC_LEVEL = 1) AND (DOC_REALTYPE=2 OR DOC_REALTYPE=6) ) Ord14, 324, 01151427, 867. 77. 3286. 16280. 071569658304Module: javadbweb7 (TNS V1-V3)SELECT SYS_TOPIC,SYS_OURCETYPE,PUBOUTER_SID,AV_LENGTH,SYS_LASTMODI

14、FIED,PUB_SE,DOC_LENGTH,EXT_WIDTH,DOC_REALTYPE,SYS_DELETEFLAG,EXT_HEIGHT,SYS_HAVERELATION,SYS_DOCLIBID,SYS_AUTHORS,D OC_WRITEDATE FROM DEM_RL_CATEGORY_FENL Where ( class_3=58947 ) AND ( DOC_LEVEL = 51 ) Order by DOC_WRITEDATE DESC14, 224, 46555825, 491. 97. 2300. 38294. 282107787906Module: javadbweb7

15、 (TNS V1-V3)SELECT SYS_TOPIC,SYS_OURCETYPE,PUBOUTER_SID,AV_LENGTH,SYS_LASTMODIFIED,PUB_SE,DOC_LENGTH,EXT_WIDTH,DOC_REALTYPE,SYS_DELETEFLAG,EXT_HEIGHT,SYS_HAVERELATION,SYS_DOCLIBID,SYS_AUTHORS,D OC_WRITEDATE FROM DEM_RL_CATEGORY_FENL Where ( ( class_3=22532 )AND ( (DOC_REALTYPE=2) ) ) AND ( DOC_LEVEL

16、 = 51 ) Order by DOCX? SQL vM;4;f f Top SQL k5gk SQL;Of5QfBg SQL v; SQL n;Rn;n SQL44;fk;?C SQL ;fC?K SQL SELECT sys_topic, sys_id, av_length, sys_lastmodified,pub_sourcetype, pubouter_se, doc_length, ext_width, doc_realtype, sys_deleteflag, ext_height, sys_haverelation, sys_doclibid, sys_authors, do

17、c_writedateFROM DEM_RL_CATEGORY_FENL03710; kWHERE (class_3 = 35) AND (doc_level = 101)ORDER BY doc_writedate DESC;?; SQL*Plus AutoTrace ;f?CCK SQL 5KU 3 9 Autotrace :;U 42 072 set timing onSQL set autotrace traceonlySQL SELECT 234sys_topic, sys_id, av_length, sys_lastmodified,pub_sourcetype, puboute

18、r_se, doc_length, ext_width, doc_realtype, sys_deleteflag, ext_height, sys_haverelation, sys_doclibid, sys_authors, doc_writedateDEM_RL_CATEGORY_FENL56FROMWHERE (class_3 = 35) AND (doc_level = 101) ORDER BY doc_writedate DESC;42072rowected.Elapsed: 00: 00: 03. 91 IDX_CLASS3 INDEX RANGE SCAN;CExecuti

19、on Plan012SELECT SEMENT Optimizer=CHOOSE (Cost=815 Card=16310 Bytes=2087680)01SORT ( ORDER BY) (Cost=815 Card=16310 Bytes=2087680)TABLE ACS ( BY INDEX ROWID) OF DEM_RL_CATEGORY_FENL (Cost=484 Card=16310 Bytes=2087680)INDEX ( RANGE SCAN) OF IDX_CLASS3 (NON-UNIQUE) (Cost=78 Card=16310)32 SQL ; 19 116

20、Sistics00191160034028513149528061042072recursive calls db block gets consistent gets physical reads redo sizebytes sent via SQL*Net to cntbytes received via SQL*Net from cntSQL*Net roundtrips to/from c sorts (memory)sorts (disk)ntrows prosedfBgXK SQL 5 C?CDEM_RL_CATEGORY_FENL;H?K;Kh|;ln SQL5MU;KBU 4

21、5 K select count(*) from dba_indexeswhere table_name=DEM_RL_CATEGORY_FENL and owner=NWKEDIT; COUNT(*)45; kfB IDX_CLASS3 ?K9 10 K; 10 K:IndexNameColumnNameCol ColumnDetailsIDX_CLASS1CLASS_1 DOC_LEVEL CLASS_10 DOC_LEVEL CLASS_2DOC_LEVELNUMBER(38,0)NUMBER(38,0) NOT NULL 1 NUMBER(38,0)2 NUMBER(38,0) NOT

22、 NULL 1 NUMBER(38,0)2 NUMBER(38,0) NOT NULLIDX_CLASS10IDX_CLASS2IDX_CLASS3CLASS_31NUMBER(38,0)DOC_LEVEL2 NUMBER(38,0) NOT NULL DBA_TABLES ;fXK?|; 18-13 ; ;K 100 ;vU 95 777 K;L 479 K;U?K AVG_SPACE M 5 297?gDK;RD;L 18-14 18-14 AVG_SPACE ,2 :*MR;L9Free:;K BLOCK_SIZE 8KB;AVG_SPACEK 8KB B; 5297 Bytes 5 ;

23、vD;Xu;v;GU503730AVG_SPACENUMBERAverage amount of free space, in bytes, in a data block allocated to the table; kEkD;lv HWM D;Dl;Rl 5XD;?Ku5fU;f 292.5MB select segment_name,bytes/1024/10242from dba_segments where owner=&OWNER AND segment_name=&SEGMENT_NAME;Enter value for owner: EYGLEEnter value for

24、segment_name: DEM_RL_CATEGORY_FENLSEGMENT_NAMEBYTES/1024/1024DEM_RL_CATEGORY_FENL292.5vR 13.5MB create index EIDX_CLASS3 on eygle.DEM_RL_CATEGORY_FENL (CLASS_3) ; Index created.SQL select segment_name,bytes/1024/1024 from dba_segments where segment_name=EIDX_CLASS3;SEGMENT_NAMEBYTES/1024/1024EIDX_CL

25、ASS313.5L;? 78MBvgQ?;L;D; rrk;f;fJ5KwL;fL?u;f;om u;?;5Bn;y9 Schema Lu: create table DEM_RL_CATEGORY_FENL_REaect * from DEM_RL_CATEGORY_FENL;Table created.SQLyze table DEM_RL_CATEGORY_FENL_REcompute sisctics;Tableyzed.C SQL f|M select segment_name,bytes/1024/1024 from SEGMENT_NAMEBYTES/1024/1024dba_s

26、egments where segment_name=IDX_CLASS3;IDX_CLASS378.125; kSELECT column_name FROM dba_tab_columnsWHERE table_name = DBA_TABLES ORDER BY column_id;BEGINOPEN c_colnm;LOOPFETCH c_colnmO l_colnm;EXIT WHEN c_colnm%NOTFOUND;l_string :=select | l_colnm| from dba_tables where table_name=| | &TABLE_NAME| | &O

27、WNER | ;| and owner= | EXECUTE IMMEDIA_stringO l_colvl;DBMS_OUTPUT.put_line (RPAD (l_colnm, 30, ) | :| TO_CHAR (l_colvl);END LOOP;END;/?C9 18-15 :;f AVG_SPACE qU;R 95 777 Kq 37 647 K;B 18-15OB :-H H: # C TOM RUNS connect /as sysdba SQL grant select on v_$s SQL grant select on v_$mysS_PKG 9U?:?C5name

28、 to public;to public;03750; kSQL grant select on v_$latch to public; SQL connect eygle/eygleConnected.SQL 234Viewcreate or replace view ssaect Sfrom v$s. | name, b.valuename a, v$mysb where a.sistic# = b.sistic#union all select LATCH. | name, gets from v$latch;created.SQL 2345create global te

29、mporary table run_s ( runid varchar2(15),name varchar2(80), value)on commit preserve rows;sTable created.N Package 234567create or replace package runs asprocedure rs_start;procedure rs_middle;s_pkgprocedure rs_stop( p_difference_threshold in number default 0 ); end;/Package created.SQL 234567891011

30、121314151617181920212223242526create or replace package body runss_pkgasg_start number; g_run1number;g_run2number;procedure rs_start isbegindelete from run_ss;inserto run_ssselect before, ss.* from ss;g_start := dbms_utility.get_time;end;procedure rs_middle isbeging_run1 := (dbms_utility.get_time-g_

31、start);inserto run_ssselect after 1, ss.* from ss;g_start := dbms_utility.get_time;03760; k2728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273end;procedure rs_stop(p_difference_threshold in number default 0) isbeging_run2 := (dbms_utility.get_time-g_start);

32、dbms_output.put_line( Run1 ran in | g_run1 | hsecs ); dbms_output.put_line( Run2 ran in | g_run2 | hsecs ); dbms_output.put_line( run 1 ran in | round(g_run1/g_run2*100,2) | % of the time );dbms_output.put_line( chr(9) );inserto run_ssselect after 2, ss.* from ss;dbms_output.put_line( rpad( Name, 30

33、 ) | lpad( Run1, 10 ) |lpad( Run2, 10 ) | lpad( Diff, 10 ) );for x in( select rpad( , 30 ) |to_char( b.value-a.value, 9,999,999 ) | to_char( c.value-b.value, 9,999,999 ) |to_char( ( (c.value-b.value)-(b.value-a.value), 9,999,999 ) datafrom run_ss a, run_ss b, run_s where = and b.n

34、ame = and a.runid = beforeand b.runid = after 1 and c.runid = after 2and (c.value-a.value) 0s cand abs( (c.value-b.value) - (b.value-a.value) ) p_difference_thresholdorder by abs( (c.value-b.value)-(b.value-a.value) loopdbms_output.put_line( x.data ); end loop;end;end;/Package body created.v

35、SQL ; 100 ; DECLARE234567891011121314151617181920212223242526272829303132t NUMBER;BEGINruns for is_pkg.rs_start;in 1 . 100 loopSELECT COUNT (*)OtFROM (SELECTsys_topic, sys_id, av_length, sys_lastmodified,pub_sourcetype, pubouter_se, doc_length, ext_width,doc_realtype, sys_deleteflag, ext_height, sys

36、_haverelation, sys_doclibid, sys_authors, doc_writedateFROM DEM_RL_CATEGORY_FENLWHERE (class_3 = 35) AND (doc_level = 101) ORDER BY doc_writedate DESC);end loop;runsfor is_pkg.rs_middle;in 1 . 100 loopSELECT COUNT (*)OtFROM (SELECTsys_topic, sys_id, av_length, sys_lastmodified,pub_sourcetype, pubout

37、er_se, doc_length, ext_width,doc_realtype, sys_deleteflag, ext_height, sys_haverelation, sys_doclibid, sys_authors, doc_writedateFROM eygle.DEM_RL_CATEGORY_FENL_reWHERE (class_3 = 35) AND (doc_level = 101) ORDER BY doc_writedate DESC);end loop;runs END;/s_pkg.rs_stop (10);Run1 ran inRun2 ran in4507

38、hsecs1997 hsecsrun 1 ran in 225.69% of the timeL;IU;?t;Cr;consistent gets a Oracle Database 10g ;Oracle Onligment Spahrink ;f;?9;m:= Oracle 9i L;H;f?K; move9move Q:u=fh9:;?Q;f9Truncate:;5 Q;D?KL; DML u;4XQ8Cache E Nocache XX;kQ? Keep L5Oracle Buffer Cahce ;f LRU 5LRU DlB; D23;a5f Keep ;f9XZL:;fq9 La

39、tch v:5KL;X DEM_RL_CATEGORY_FENL ;f Keep L;a 5;Rfrr5o; C;RlL;D5MU;f Default qp5fC?K; DB_KEEP_CACHE_SIZE ; alter system set db_keep_cache_size=400M; System altered.SQL connect eygle/eygle Connected.SQL create table DEM_RL_CATEGORY_FENL_CACHE aect * from DEM_RL_CATEGORY_FENL;SQL create index EIDX_CACH

40、E_CLASS3 on eygle.DEM_RL_CATEGORY_FENL_CACHE (CLASS_3);SQL alter table DEM_RL_CATEGORY_FENL_CACHE storage (buffer_pool keep);n; 100 ;b 234567DECLAREt NUMBER;BEGINrunsfor is_pkg.rs_start;in 1 . 100 loopSELECT COUNT (*)Ot03790; k891011121314151617181920212223242526272829303132Run1FROM (SELECTsys_topic

41、, sys_id, av_length, sys_lastmodified,pub_sourcetype, pubouter_se, doc_length, ext_width,doc_realtype, sys_deleteflag, ext_height, sys_haverelation, sys_doclibid, sys_authors, doc_writedateFROM DEM_RL_CATEGORY_FENLWHERE (class_3 = 35) AND (doc_level = 101) ORDER BY doc_writedate DESC);end loop;runss

42、_pkg.rs_middle;for i in 1 . 100 loopSELECT COUNT (*)OtFROM (SELECTsys_topic, sys_id, av_length, sys_lastmodified,pub_sourcetype, pubouter_se, doc_length, ext_width,doc_realtype, sys_deleteflag, ext_height, sys_haverelation, sys_doclibid, sys_authors, doc_writedateFROM DEM_RL_CATEGORY_FENL_cacheWHERE

43、 (class_3 = 35) AND (doc_level = 101) ORDER BY doc_writedate DESC);end loop;runs END;/s_pkg.rs_stop (10);ran in 10522 hsecsRun2 ran in 7236 hsecsrun 1 ran in 145.41% of the time;?;fCU 25%NameRun1 819515117630094410,4671,591,8001,598,2006,822,6001,598,5011,598,504Run200001021,2047,1971,660,8001,667,2

44、006,753,6001,667,5061,667,518Diff-81-95-151-176-198260-3,27069,00069,000-69,00069,00569,014- 417, 925- 417, 925S S S S S S S S S S S S SS.pinned buffers inspecte.dirty buffers inspected.messages sent.free buffer inspected.shared hash latch upgra.redo size.recursive cpu usage.buffer is not pinned co.

45、no work - consistent re.buffer is pinned count.consistent gets.seslogical reads. free buffer requested418, 0007575. physical reads418, 000PL/SQL procedure sucsfully completed.L Cache wM Cache ;g?Kw;_?C? 503800; k Oracle Database 10g AWR L;UX|9 18-16 :;ZX4EV;Z|f 18-16 WR CI% : S +(4CI fC?Kkw; Nmon ;

46、IO ;H;X 100%9 18-17 : 18-17 Nmon N1% K?L; DB Time 9DB Time X:; DB Time/Elapsed w 4.179 18-18 : 18-18 V .N1 DB Time # User I/O KN9 18-19 : 18-19 Top 5 Timed Events # 03810; kTop SQL |LUK; 18-20 TOP Gets SQL 18-20 SQL ordered by Gets # Top SQL ;UK 50%; 18-21 18-21 Segments by Logical Reads # gUKf Keep

47、 L;fCI9 18-21 :L DB Time/Elapsed q 2 18-22 .N1 DB Time # Buffool 9 18-23 :;Keep LM 100%;LU;KL;Keep 03820; k 18-23 Buffool S istics # 18-24 18-24 Segments by Logical Reads # ZM| Oracle 9i ;o Sspack ;KMV$SEGS4V$SEGS_NAME4V$SEGMENT_SISTICS5o; 9i L;?KBug; V$SEGSl; ORA-04031 59i LUC? select name from v$s

48、egs_name; NAMElogical reads buffer busy waits db block changes physical reads physical writesphysical reads direct physical writes directglobal cache cr blocks served global cache current blocks served ITL waitsrow lock waitsf;|;fC?K Oracle 9i ; global cache current blocks served | SELECT a.inst_id,

49、 a.owner, a.object_name, a.VALUE, b.segment_type,23456b.BYTES / 1024 / 1024 mb FROM (SELECT *FROM (SELECT inst_id, owner, object_name, VALUE, object_typeFROM gv$segment_sisticsWHERE sistic_name = global cache current blocks served03830; k78910ORDER BY 4 DESC)WHERE ROWNUM 21) a, dba_segments bWHERE a

50、.object_name = b.segment_name ANbject_type = b.segment_type ORDER BY 1, 4 DESC;INST_IDOWNEROBJECT_NAMEVALUESEGMENT_TYPEMB11111111111222222222CNYY CNYY CNYY CNYY CNYY CNYY CNYY CNYY CNYY CNYY CNYY CNYY CNYY CNYY CNYY CNYY CNYY CNYY CNYYCNYYZZSF104_1 MM101_2 YJ111_1 YF202 MM101 MM_JZB BQ115Z BQYS_YZ M

51、M_YS_CF MM101_2 BB102 ZZSF104_1 MM101_2 YF202 YJ111_1 MM_JZB MM101 MM_YS_CF BBYS_YZBB115Z88703361857762113421077890056611746565639600438597730674525911225881521282881205439838598589380452560332776308437298983262846TABLE TABLE TABLE TABLE TABLE TABLE TABLE TABLE TABLE INDEX TABLE TABLE TABLE TABLE TA

52、BLE TABLE TABLE TABLE TABLETABLE30148491131851698087383651481383014849185113801695183687320 rowected.Xk_Qw;g SQL;? SQL BM?K;D?5fC SQL Q?rUXK SQL ; IDX_CLASS3 INDEX RANGE SCAN;Execution Plan012SELECT SEMENT Optimizer=CHOOSE (Cost=815 Card=16310 Bytes=2087680)01SORT ( ORDER BY) (Cost=815 Card=16310 By

53、tes=2087680)TABLE ACS ( BY INDEX ROWID) OF DEM_RL_CATEGORY_FENL (Cost=484 Card=16310 Bytes=2087680)INDEX ( RANGE SCAN) OF IDX_CLASS3 (NON-UNIQUE) (Cost=78 Card=16310)3203840SELECT SYS_TOPIC,SYS_ ID,AV_LENGTH,SYS_LASTMODIFIED,PUB_S OURCETYPE,PUBOUTER_S E,DOC_LENGTH,EXT_WIDTH,DOC_REALTYPE,SYS_D ELETEF

54、LAG,EXT_HEIGHT,SYS_HAVERELATION,SYS_DOCLIBID,SYS_AUTHORS,D OC_WRITEDATE FROM DEM_RL_CATEGORY_FENL Where ( class_3=58947 ) AND ( DOC_LEVEL = 51 ) Order by DOC_WRITEDATE DESC; k SQL ; 19 116 Sistics001911600recursive calls db block gets consistent gets physical readsredo sizeh Hibernate ; SQL 50 ;C; K

55、;n SQL SELECT *2345678910111213141516171819202122FROM (SELECTthis_.sys_id AS sys1_0_0_,this_.sys_authors AS sys2_0_0_, this_.av_lengS av3_0_0_,this_.class_1 AS class4_0_0_, this_.class_2 AS class5_0_0_, this_.class_3 AS class6_0_0_, this_.class_4 AS class7_0_0_, this_.class_5 AS class8_0_0_, this_.c

56、lass_6 AS class9_0_0_, this_.class_7 AS class10_0_0_,this_.sys_deleteflag AS sys11_0_0_,this_.doc_lengS doc12_0_0_,this_.doc_level AS doc13_0_0_,this_.doc_realtype AS doc14_0_0_, this_.ext_height AS ext15_0_0_,this_.ext_widS ext16_0_0_,this_.sys_lastmodified AS sys17_0_0_, this_.sys_doclibid AS sys1

57、8_0_0_, this_.pub_sourcetype AS pub19_0_0_, this_.sys_topic AS sys20_0_0_, this_.doc_writedate AS doc21_0_0_DEM_RL_CATEGORY_FENL this_FROMWHERE this_.class_2 = 32 AND this_.doc_level = 101 ORDER BY this_.doc_writedate DESC)WHERE ROWNUM = 50;50 rowected.Execution Plan01234SELECT SEMENT Optimizer=CHOO

58、SE (Cost=1172 Card=50 Bytes=212150)0123COUNT (STOPKEY)VIEW (Cost=1172 Card=27930 Bytes=118506990)SORT (ORDER BY STOPKEY) (Cost=1172 Card=27930 Bytes=4077780)TABLE ACS (BY INDEX ROWID) OF DEM_RL_CATEGORY_FENL (Cost=558 Card=27930 Bytes=4077780)INDEX (RANGE SCAN) OF IDX_CLASS2 (NON-UNIQUE) (Cost=126 C

59、ard=27930)54Sistics37476 consistent getsphysical readssorts (memory)50 rows prosed03850; kB;kf5M;fCKNB;h ROWID; ROWID 5NAK;CLWhere ( class_3=58947 ) AND ( DOC_LEVEL = 51 ) Order by DOC_WRITEDATE DESC;h ROWID; ROWID fCvKL;a 19 555 q 206 ;qD 1 9 Autotrace : SELECT sys_topic, sys_id, av_length, sys_las

60、tmodified, pub_sourcetype,2345678910111213pubouter_se, doc_length, ext_width, doc_realtype, sys_deleteflag, ext_height, sys_haverelation, sys_doclibid, sys_authors, doc_writedateFROM DEM_RL_CATEGORY_FENL t, (SELECT ridFROM (SELECT ROWNUM rn, t.ridFROM (SELECT /*+ index(DEM_RL_CATEGORY_FENL EIDX_CLSD