Home » RDBMS Server » Performance Tuning » can we grant SYSDBA privilege to SYSTEM user ?
can we grant SYSDBA privilege to SYSTEM user ? [message #233907] Sat, 28 April 2007 01:51 Go to next message
Messages: 17
Registered: April 2007
Location: MUMABI
Junior Member

Dear all,

I can connect as SYSTEM...but i don't have SYSDBA privilege.... but i need this privilege to generate statspack report and to check v$sysstat settings....

can we grant this SYSDBA privilege to SYSTEM...?

or is there any other alternate to check v$sysstat values and to generate the statspack at database level ?

pls clarify me...

thank you all.
Re: can we grant SYSDBA privilege to SYSTEM user ? [message #233914 is a reply to message #233907] Sat, 28 April 2007 02:30 Go to previous message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ You don't need sysdba to generate a statspack report. SYSDBA is only for database maintenance purpose (startup, shutdown...)
2/ Yes you can give sysdba to system but you should not use system (create your own dba account) and you should not give sysdba to system
3/ you can directly query on v$sysstat, you don't need to use statspack but statspack is really useful and ready.

Previous Topic: JUNIOR DBA
Next Topic: How to find out the bad sql statemets ?
Goto Forum:

Current Time: Tue Aug 22 23:28:01 CDT 2017

Total time taken to generate the page: 0.09386 seconds