首页 > 应用开发 > IT综合 > use oraperf_lio
$ unzip oraperf_lio.zip
$ sqlplus -s "/ as sysdba"
SQL> @oraperf_package
Package created.
SQL> @oraperf_lio.plb
Package body created.
Run it like this:
The 10 means, 10 samples and the 2 means, at 2 second interval.
SQL> set serveroutput on
SQL> execute oraperf.analyze_lio(10,2);
Logical I/O Analyzer - Version 1.0.1 Alpha
Copyright (c) 2003, OraPerf.com. All rights reserved.
Connecting to Linuxi386/Linux-2.0.34-8.1.0 Version 9.2.0.1.0
TOTAL LIO ROWGET CHAIN UPD INS DEL KEY FTS SCAN SPACE UNDO ITL TTMP PTMP
=====================================================================================================
0058055297 33.33% 00.00% 00.00% 00.00% 00.00% 66.67% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00%
0058179236 33.33% 00.00% 00.00% 00.00% 00.00% 66.67% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00%
0058306210 33.33% 00.00% 00.00% 00.00% 00.00% 66.67% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00%
0058440641 33.33% 00.00% 00.00% 00.00% 00.00% 66.67% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00%
0058573271 33.33% 00.00% 00.00% 00.00% 00.00% 66.67% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00%
0058709540 33.33% 00.00% 00.00% 00.00% 00.00% 66.67% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00%
0058835438 33.33% 00.00% 00.00% 00.00% 00.00% 66.67% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00%
0058955714 33.33% 00.00% 00.00% 00.00% 00.00% 66.67% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00%
0059076116 33.33% 00.00% 00.00% 00.00% 00.00% 66.67% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00% 00.00%
PL/SQL procedure successfully completed.
In this example we can see that 33% of the LIO is for getting the rows from the block and that 66% of the LIO was used for accessing the index blocks for looking up a single key.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/178357/viewspace-903234/ ,如需转载,请注明出处,否则将追究法律责任。