oracle statspack学习（一）(四)
- ------------
2738540715 1 RHYS RHYS oracle-one
Using 2738540715 for database Id
Using 1 for instance number
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing without
specifying a number lists all completed snapshots.
Listing all Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level Comment
------------ ------------ --------- ----------------- ----- --------------------
RHYS RHYS 1 14 Sep 2013 19:52 5
2 14 Sep 2013 19:53 5
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 1
Begin Snapshot Id specified: 1
Enter value for end_snap: 2
End Snapshot Id specified: 2
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is sp_1_2. To use this name,
press to continue, otherwise enter an alternative.
Enter value for report_name:
Using the report name sp_1_2（（（（（指定名字））））
STATSPACK report for
Database DB Id Instance Inst Num Startup Time Release RAC
~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
2738540715 RHYS 1 14-Sep-13 18:34 11.2.0.4.0 NO
Host Name Platform CPUs Cores Sockets Memory (G)
~~~~ ---------------- ---------------------- ----- ----- ------- ------------
oracle-one Linux x86 64-bit 1 0 0 1.2
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- --------- ------------------
Begin Snap: 1 14-Sep-13 19:52:48 33 1.3
End Snap: 2 14-Sep-13 19:53:06 33 1.3
Elapsed: 0.30 (mins) Av Act Sess: 0.1
DB time: 0.03 (mins) DB CPU: 0.02 (mins)
Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache: 128M Std Block Size: 8K
Shared Pool: 124M Log Buffer: 3,604K
到这里，这个工具你算是会用了，但是要让它真的给dba带来问题的解决途径，那又是另一个深入问题了。那是一门艺术。
6）报告对应的数据表信息：
对于有哪些表，我们一个是可以看statspack创建脚本中的spctab.sql
create table STATS$DATABASE_INSTANCE
(dbid number not null
,instance_number number not null
,startup_time date not null
,snap_id number not null
,parallel varchar2(3) not null
,version varchar2(17) not null
,db_name varchar2(9) not null
,instance_name varchar2(16) not null
,host_name varchar2(64)
,platform_name varchar2(101)
,constraint STATS$DATABASE_INSTANCE_PK primary key
(dbid, instance_number, startup_time)
using index tablespace &&tablespace_name
storage (initial 1m next 1m pctincrease 0)
) tablespace &&tablespace_name
storage (initial 1m next 1m pctincrease 0) pctfree 5 pctused 40;
create public synonym STATS$DATABASE_INSTANCE for STATS$DATABASE_INSTANCE;
/* ------------------------------------------------------------------------- */
"spctab.sql" 2258L, 94461C
这都是内