本文共 1468 字，大约阅读时间需要 4 分钟。
解压zip包[oracle@vrh1 ~]$ unzip Pck.zipArchive: Pck.zip creating: Pck/ inflating: Pck/1_grants.sql inflating: Pck/2_Types.sql inflating: Pck/3_pkg.sql inflating: Pck/drop.sql inflating: Pck/howtoinstall.sql inflating: Pck/outputexplained.pdf inflating: Pck/sampleoutput.png[oracle@vrh1 ~]$ cd Pck[oracle@vrh1 Pck]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 8 02:08:49 2012Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing options1. 执行授权文件1_grants.sqlSQL> start 1_grants.sqlEnter value for _usr: maclean需要指定安装在哪个schema下2. 登录上面指定的schema，并执行 2_Types.sql 创建typeSQL> conn maclean/macleanConnected.SQL>SQL>SQL> start 2_Types.sqlType created.Type created.Type created.Type created.Type created.Type created.Type created.Type created.Type created.Type created.3. 执行3_pkg.sql 创建包体SQL> start 3_pkg.sqlPackage created.No errors.Package body created. 若想删除该工具吗，卸载的方法 SQL> connect maclean/macleanSQL> start drop.sql具体使用的方法如下：
SQL>set lines 190 pages 0 arraysize 50 SQL>select * from table(jss.gtop(50,10)) ;50代表 arraysize 一般不用修改10代表 10s采样一次，采样间隔
示例输出： 这很酷，仿佛文字版的spotlight
本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1278443
转载地址：http://xukja.baihongyu.com/