Have you issued a second "exec statspack.snap;" command ?

Hans

-----Original Message-----
From: Sriram S
[mailto:oracledba-ezmlmshield-x4276329.[Email address protected]
Sent: vrijdag 6 oktober 2006 14:06
To: LazyDBA Discussion
Subject: Statspack issues


Hi DBA's,

I have been trying to generate the statspack report unsuccessfully. I am

running oracle 9.0.1 under solaris.

The report (when executing spreport.sql) begins to generate the report,
and hangs up after a few lines. Have tried dropping and recreating the
perfstat user, increasing the undo tablespace size, sort area size,
temporary tablespace size, but in vain.

Can somebody help??

Regards,
S. Sriram


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------


Oracle LazyDBA home page