ITPub博客

首页 > 应用开发 > IT综合 > use oraperf_lio

use oraperf_lio

原创 IT综合 作者:davies 时间:2007-03-07 14:02:54 0 删除 编辑
use oraperf_lio[@more@]

$ 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/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    81
  • 访问量
    507774