Home » RDBMS Server » Performance Tuning » Statspack without perstat user
icon4.gif  Statspack without perstat user [message #195158] Wed, 27 September 2006 04:30 Go to next message
amit_nanote
Messages: 56
Registered: July 2005
Location: Indore
Member
Hi All,
We all know that perfstat user is used to take the statistics of the database.
Can we run statspack utility with any other user and how?
Can we select schema in statspack utility?

With Regards
Amit Nanote

Report message to a moderator

Re: Statspack without perstat user [message #195238 is a reply to message #195158] Wed, 27 September 2006 09:27 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
All the tweaks are in the spcreate.sql.
But why?

Report message to a moderator

Previous Topic: how do i create bitmap index?
Next Topic: Help on First_Rows
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 05:50:55 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.