我安装好了statspack 执行@spreport.sql的是否要求你输入很多参数
我执行两次 exec statspack.snap
生成两次快照两次快照
然后执行@spreport.sql
他要求我输入很多次 前几次是出现提示的 后面连提示都不出现就让我输
网上找了很多资料都说只说输入3次
begin_snap 值
end_snap 值
report_name 就是报告路径
为什么我这要输入好多 而且也不出现提示
oracle 9i + win server 2003
能说明下spreport.sql需要输入的一些参数吗
我执行两次 exec statspack.snap
生成两次快照两次快照
然后执行@spreport.sql
他要求我输入很多次 前几次是出现提示的 后面连提示都不出现就让我输
网上找了很多资料都说只说输入3次
begin_snap 值
end_snap 值
report_name 就是报告路径
为什么我这要输入好多 而且也不出现提示
oracle 9i + win server 2003
能说明下spreport.sql需要输入的一些参数吗
2、如果成功,使用spreport输入起始id和结束ID和报告名称三个参数就行了。
首先弹出语句
Current Instance
~~~~~~~~~~~~~~~~ DBID DB_NAME INST_ INST_NAME
---------- ------------ ----- ------------
548478458 CHINA 1 serverchina
Cannot SET TRIMSPOOL
Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DBBID INSTT DBB_NAME INSTT_NAME HOST
---------- ----- ------------ ------------ ------------
548478458 1 CHINA serverchina SERVER0407
然后让我输入两次然后弹出
Using 1 for database Id
Using 2 for instance number
这个1 2 是我输入的 我没明白这是什么意思
然后要你输入起始ID跟解释ID还有报告名字
能解释下之前让我输的2次值是什么嘛 谢谢啦
Package created
No errors for PACKAGE PERFSTAT.STATSPACK
Creating Package Body STATSPACK...Package body created
No errors for PACKAGE BODY PERFSTAT.STATSPACKNOTE:
SPCPKG complete. Please check spcpkg.lis for any errors.Stopped spooling to E:\Program Files\PLSQL Developer\spcpkg.lis
Creating Package STATSPACK...Package created
No errors for PACKAGE PERFSTAT.STATSPACK
Creating Package Body STATSPACK...Package body created
No errors for PACKAGE BODY PERFSTAT.STATSPACKNOTE:
SPCPKG complete. Please check spcpkg.lis for any errors.
没有错误啊
DBID DB_NAME INST_ INST_NAME
---------- ------------ ----- ------------
548478458 CHINA 1 serverchina
Cannot SET TRIMSPOOL导致脚本没有通过查询自动取到dbid和inst_num
要求你手动输入上述两个值,其实你可以手动输入上面的dbid值:548478458
和实例号:1 试一上。另外,你在什么环境下执行的@spreport?
oracle 9201在命令行sqlplus下是没有问题的。
我输了生成以下一部分是这样的
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as perfstat
SQL> Current Instance
~~~~~~~~~~~~~~~~ DBID DB_NAME INST_ INST_NAME
---------- ------------ ----- ------------
548478458 CHINA 1 serverchina
Cannot SET TRIMSPOOL
Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DBBID INSTT DBB_NAME INSTT_NAME HOST
---------- ----- ------------ ------------ ------------
548478458 1 CHINA serverchina SERVER0407Using 548478458 for database Id
Using 1 for instance numberPL/SQL procedure successfully completed
dbid
---------
548478458
inst_num
---------
1INST_NAME DB_NAME SNAP SNAPDAT LV COMMNT
------------ ------------ ---- ----------------- -- ----------------------
serverchina CHINA 1 12 12ÔÂ 2010 00:1 5
0 serverchina CHINA 2 12 12ÔÂ 2010 00:1 5
0 serverchina CHINA 3 12 12ÔÂ 2010 00:1 5
9 serverchina CHINA 4 12 12ÔÂ 2010 01:2 5
4 serverchina CHINA 5 12 12ÔÂ 2010 12:1 5
6 dbid
---------
548478458
inst_num
---------
1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Begin Snapshot Id specified: 4End Snapshot Id specified: 5
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is d:\text1.txt. To use this name,
press <return> to continue, otherwise enter an alternative.
Using the report name continue
Started spooling to E:\Program Files\PLSQL Developer\continue.lstinst_num
---------
1
dbid
---------
548478458
bid
---------
4
dbid
---------
548478458
inst_num
---------
1
eid
---------
5
dbid
---------
548478458
inst_num
---------
1
bid
---------
4
eid
---------
5
dbid
---------
548478458
inst_num
---------
1
bid
---------
4
eid
---------
5
dbid
---------
548478458
inst_num
---------
1
bid
---------
4
eid
---------
5
dbid
---------
548478458
inst_num
---------
1
Cannot SET NEWPAGEPL/SQL procedure successfully completed
之后还要你输入很多次 我真没理解
是在麻烦你了 我们应用现在很卡是在要生成报告研究可以遇到这样的问题
出现下面的
bid
---------
4
eid
---------
5
dbid
---------
548478458
inst_num
---------
1
para
---------
d:\text1.txt
lhtr
---------
0.950900048588876
bfwt
---------
94038
tran
---------
5329
chng
---------
378850
ucal
---------
1408047
urol
---------
0
rsiz
---------
45892360
phyr
---------
77778483
phyrd
---------
2358288
phyrdl
---------
0
phyw
---------
2399816
ucom
---------
5329
prse
---------
179752
hprs
---------
23157
recr
---------
355686
gets
---------
172053574
rlsr
---------
0
rent
---------
194961
srtm
---------
2971702
srtd
---------
119
srtr
---------
338272670
strn
---------
1
lhr
---------
0.000770712784522016
bc
---------
385875968
sp
---------
1149239296
lb
---------
524288
bs
---------
8192
twt
---------
71040276695
logc
---------
430
prscpu
---------
13185
tcpu
---------
361059
exe
---------
224224
prsela
---------
13364
bspm
---------
1166016512
espm
---------
1166016512
bfrm
---------
227915276
efrm
---------
64447088
blog
---------
19
elog
---------
23
bocur
---------
59
eocur
---------
88
dmsd
---------dmfc
---------dmsi
---------pmrv
---------pmpt
---------npmrv
---------npmpt
---------dbfr
---------dpms
---------dnpms
---------glsg
---------glag
---------glgt
---------glsc
---------glac
---------glct
---------glrl
---------gcdfr
---------gcge
---------gcgt
---------gccv
---------gcct
---------gccrrv
---------gccrrt
---------gccurv
---------gccurt
---------gccrsv
---------gccrbt
---------gccrft
---------gccrst
---------gccusv
---------gccupt
---------gccuft
---------gccust
---------msgsq
---------msgsqt
---------msgsqk
---------msgsqtk
---------msgrq
---------msgrqt
---------call
---------
1763733
STATSPACK report forDB_NAME DBID INST_NAME INST_ VERSN PARA HOST_NAME
------------ ---------- ------------ ----- ----------- ------- ------------
d:\text.txt 548478458 d:\text.txt 1 d:\text.txt d:\text d:\text.txt
1.txt db_name
---------
d:\text.txt
dbid
---------
548478458
inst_name
---------
d:\text.txt
inst_num
---------
1
versn
---------
d:\text.txt
para
---------
d:\text1.txt
host_name
---------
d:\text.txt
Snap Id Snap Time Sessions Curs/Sess Comment ------- ------------------ -------- --------- ------------------- Begin Snap: 4 12-12ÔÂ-10 01:24:51 19 3.10526315789474 End Snap: 5 12-12ÔÂ-10 12:16:08 23 3.82608695652174 Elapsed: 651.283333333333 (mins)
blog
---------
19
bocur
---------
59
elog
---------
23
eocur
---------
88
bid
---------
4
eid
---------
5
dbid
---------
548478458
inst_num
---------
1begin
:btim := 'd:\text1.txt';
:etim := 'd:\text1.txt';
:ela := d:\text1.txt;
:instart := 'd:\text1.txt';
:bbgt := d:\text1.txt;
:ebgt := d:\text1.txt;
:bdrt := d:\text1.txt;
:edrt := d:\text1.txt;
:bet := d:\text1.txt;
:eet := d:\text1.txt;
:bsmt := d:\text1.txt;
:esmt := d:\text1.txt;
:bvc := d:\text1.txt;
:evc := d:\text1.txt;
:bpc := d:\text1.txt;
:epc := d:\text1.txt;
end;ORA-06550: µÚ 4 ÐÐ, µÚ 18 ÁÐ:
PLS-00103: ³öÏÖ·ûºÅ ":"ÔÚÐèÒªÏÂÁÐ֮һʱ£º
. ( * @ % & = - + ; < / > at
in is mod not rem <an exponent (**)> <> or != or ~= >= <= <>
and or like between ||
---------etim
---------ela
---------instart
---------bbgt
---------ebgt
---------bdrt
---------edrt
---------bet
---------eet
---------bsmt
---------esmt
---------bvc
---------evc
---------bpc
---------epc
---------Cache Sizes (end) ~~~~~~~~~~~~~~~~~ Buffer Cache: 368M Std Block Size: 8K Shared Pool Size: 1,096M Log Buffer: 512K
bc
---------
385875968
bs
---------
8192
sp
---------
1149239296
lb
---------
524288
Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 8611.81 Logical reads: 32286.28 Block changes: 71.09 Physical reads: 14595.32 Physical writes: 450.33 User calls: 264.22 Parses: 33.73 Hard parses: 4.35 Sorts: 557.67 Logons: 0.08 Executes: 42.08 Transactions: % Blocks changed per Read: 0.22 Recursive Call %: 20.17 Rollback per transaction %: 0 Rows per Sort: 113.83
rsiz
---------
45892360
ela
---------tran
---------
5329
gets
---------
172053574
chng
---------
378850
phyr
---------
77778483
phyw
---------
2399816
ucal
---------
1408047
prse
---------
179752
hprs
---------
23157
srtm
---------
2971702
srtd
---------
119
logc
---------
430
exe
---------
224224
recr
---------
355686
call
---------
1763733
urol
---------
0
srtr
---------
338272670
Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 99.95 Redo NoWait %: 100 Buffer Hit %: 56.16 In-memory Sort %: 100 Library Hit %: 95.09 Soft Parse %: 87.12 Execute to Parse %: 19.83 Latch Hit %: 99.92 Parse CPU to Parse Elapsd %: 98.66 % Non-Parse CPU: 96.35
bfwt
---------
94038
gets
---------
172053574
rent
---------
194961
rlsr
---------
0
phyr
---------
77778483
phyrd
---------
2358288
phyrdl
---------
0
srtm
---------
2971702
srtd
---------
119
lhtr
---------
0.950900048588876
hprs
---------
23157
prse
---------
179752
exe
---------
224224
lhr
---------
0.000770712784522016
prsela
---------
13364
prscpu
---------
13185
tcpu
---------
361059
Shared Pool Statistics Begin End ------ ------ Memory Usage %: 80.4535121368847 94.4728837596427 % SQL with executions>1: 29.1919334367508 34.2407919638958 % Memory for SQL w/exec>1: 40.3932635437421 42.0252214438866
bfrm
---------
227915276
bspm
---------
1166016512
efrm
---------
64447088
espm
---------
1166016512
bid
---------
4
eid
---------
5
inst_num
---------
1
dbid
---------
548478458'-------------------------------------------------------------'ORA-00900: ÎÞЧ SQL Óï¾äEVENT WAITS TIME PCTWTT
-------------------------------------------- ---------- ---------- ----------
library cache pin 11759 40633.8972 54.4319163
db file scattered read 6812566 18059.3661 24.1917702
db file sequential read 5263379 9739.12671 13.0462339
CPU time 3610.59 4.83663507
buffer busy waits 94048 1617.13059 2.16625830
twt
---------
71040276695
tcpu
---------
361059
bid
---------
4
eid
---------
5
dbid
---------
548478458
inst_num
---------
1
Cannot SET SPACE
db_name
---------
d:\text.txt
inst_name
---------
d:\text.txt
bid
---------
4
eid
---------
5
gcge
---------gcgt
---------gccv
---------gcct
---------gccrsv
---------gccrbt
---------gccrft
---------gccrst
---------gccrrv
---------gccrrt
---------gccusv
---------gccupt
---------gccuft
---------gccust
---------gccurv
---------gccurt
---------gets
---------
172053574
gcdfr
---------dpms
---------phyr
---------
77778483
phyw
---------
2399816
dbfr
---------glag
---------glsg
---------glgt
---------glac
---------glsc
---------glct
---------glrl
---------msgsq
---------msgsqt
---------msgsqk
---------msgsqtk
---------msgrq
---------msgrqt
---------pmrv
---------pmpt
---------npmrv
---------npmpt
---------dmsd
---------dmsi
---------dmfc
---------para
---------
d:\text1.txt'DB: ' db_name ' Instance: ' inst_name ' '-
'Snaps: ' format 999999 begin_snap ' -' format 999999 end_snap -
skip 2ORA-00900: ÎÞЧ SQL Óï¾äSQL> 我全贴上来了 是在麻烦了
你可以使用
start_snap:=statspack.snap然后把他记下来
然后你过10分钟后,你又执行次
end_snap:=statspack.snap
最后你执行报表生成的时候,输入两个值就可以了。
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Begin Snapshot Id specified: 4End Snapshot Id specified: 5
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is d:\text1.txt. To use this name,
press <return> to continue, otherwise enter an alternative.
Using the report name continue
Started spooling to E:\Program Files\PLSQL Developer\continue.lst上面我不是已经输入过了么 开始点跟结束点了和报告路劲了么 为什么还要输入