Home » RDBMS Server » Performance Tuning » Related To STATSPACK
Related To STATSPACK [message #325861] Mon, 09 June 2008 04:51 Go to next message
raj_roshan_009
Messages: 29
Registered: May 2008
Junior Member
Hi all,

I am using oracle 9i on window platform.

i want to execute STATSPACK using command as:

SQL>@D:\ORACLE\ORA93\RDBMS\ADMIN\spcreate.sql

then it give me error as "sp2-0640:NOT CONNECTED"

I am attaching spctab.txt file that is produced during
execution of the "spcreate.sql" .

i don't know why my connection going lost during table creation of STATSPACK.

Please help me.
Thanks in advance.
Roshan.
  • Attachment: spctab.txt
    (Size: 3.73KB, Downloaded 278 times)
Re: Related To STATSPACK [message #325872 is a reply to message #325861] Mon, 09 June 2008 05:18 Go to previous message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First connect, then execute the script.

Regards
Michel
Previous Topic: Scheduled jobs
Next Topic: BITMAP INDEX
Goto Forum:
  


Current Time: Thu Dec 08 04:22:03 CST 2016

Total time taken to generate the page: 0.29151 seconds