Home » RDBMS Server » Performance Tuning » statspack report (oracle 10g windows 2003 server)
statspack report [message #277612] Tue, 30 October 2007 15:08 Go to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
Hi,

when i am trying to run statspack report (oracle_home/rdbms/admin/spreport.sql) by connecting as sys user i am exiting from sql prompt. what could be the reason.could you please any one let me know the reason

Report message to a moderator

Re: statspack report [message #277613 is a reply to message #277612] Tue, 30 October 2007 15:16 Go to previous message
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You have to run it as the perfstat user.

Regards
Michel

Report message to a moderator

Previous Topic: export statistics form production to test database
Next Topic: Parallel Query yields High Consistent Gets vs Serial
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 23 20:48:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.