| Error Using STATPACK [message #173239] |
Sat, 20 May 2006 13:24  |
it_me24
Messages: 167
Registered: March 2006
Location: delhi
|
Senior Member |
|
|
Dear All,
I am trying to use statpack to monitor the database perfomanace .....but when i try to run the script SPCREATE.SQL.
the script is getting executed,& it is asking perfstat password & temp tablespace after giving the password & temporary tablespace the session is getting closed.
when i try to connect then with perfstat/password i am getting connected. but when i try to run the script STATPACK.SNAP I GET AN ERROR
pls-00201 identifier statpack.snap must be declered.
I also tried to execute the scripts(spcusr.sql /spctab.sql /spcpkg.sql) one by one.
SPCUSR.SQL [getting executed]
[getting executed]
& when i try to execute SPCPKG.SQL it gives me an error
ora-00942 Table or View Does not exist
plz help me what to do
|
|
|
|
| Re: Error Using STATPACK [message #173240 is a reply to message #173239] |
Sat, 20 May 2006 13:51  |
krystian.zieja
Messages: 12
Registered: May 2006
Location: Poland
|
Junior Member |
|
|
I would advice you to recreate statspack:
as sys:
drop user perfstat cascade;
@ $ORACLE_HOME/rdbms/admin/spcreate.sql
after this will suceed
conn perfstat/pass
exec statspack.snap
Post if you get any errors
Best Regards
Krystian Zieja / mob
|
|
|
|
| Re: Error Using STATPACK [message #173497 is a reply to message #173239] |
Mon, 22 May 2006 13:31 |
it_me24
Messages: 167
Registered: March 2006
Location: delhi
|
Senior Member |
|
|
I tried
drop user perfstat cascade;
& again I tried to recreate statspack:
as sys:
drop user perfstat cascade;
@ $ORACLE_HOME/rdbms/admin/spcreate.sql
But still i am getting same.
plz help
thanks in Advance
|
|
|
|
| Re: Error Using STATPACK [message #173589 is a reply to message #173497] |
Tue, 23 May 2006 05:11 |
oradba16
Messages: 54
Registered: September 2005
|
Member |
|
|
hi,
i think u hav not installed properly.so
connect / as sysdba
run the script @$ORACLE_HOME/rdbms/admin/spdrop.sql
this will de-install the statspack
you
>define default_tablespace='tools'
>define temporary_tablespace='temp'
>define perfstat_password='my_perfstat_password'
>@$ORACLE_HOME/rdbms/admin/spcreate.sql
>connect perfstat/perfstat
>execute statspack.snap
>alter system set time_statistics=true; after instance startup or set before instance startup at initialization parameter file
i hope these will help you.... try this.....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
