Home » RDBMS Server » Server Administration » Generate statspack report without perfstat account (Oracle 9.2.0.6)
Generate statspack report without perfstat account [message #576726] Thu, 07 February 2013 09:35 Go to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
Hi,

I have only select_catalog_role in my database.
Is it possible to generate statspack report without having access to perfstat account?
Re: Generate statspack report without perfstat account [message #576728 is a reply to message #576726] Thu, 07 February 2013 09:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/


>I have only select_catalog_role in my database.
>Is it possible to generate statspack report without having access to perfstat account?

why do you waste your time and our time by asking here instead of simply trying to run the report on YOUR DB?

Re: Generate statspack report without perfstat account [message #576732 is a reply to message #576726] Thu, 07 February 2013 10:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: Generate statspack report without perfstat account [message #576733 is a reply to message #576728] Thu, 07 February 2013 10:25 Go to previous messageGo to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
I run spreport.sql. I got the below errors.

SQL>select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE    9.2.0.8.0       Production
TNS for Solaris: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

SQL>select * from session_roles;

ROLE
------------------------------
CONNECT
RESOURCE
SELECT_CATALOG_ROLE
HS_ADMIN_ROLE

SQL>@?/rdbms/admin/spreport.sql

Current Instance
~~~~~~~~~~~~~~~~

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
 1554290266 QOC                 1 qoc



Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  from stats$database_instance
       *
ERROR at line 7:
ORA-00942: table or view does not exist



Using 1554290266 for database Id
Using          1 for instance number
     , stats$database_instance di
       *
ERROR at line 9:
ORA-00942: table or view does not exist




Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap:
Re: Generate statspack report without perfstat account [message #576735 is a reply to message #576733] Thu, 07 February 2013 10:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 07 February 2013 17:23
No.

Regards
Michel

Re: Generate statspack report without perfstat account [message #576808 is a reply to message #576735] Fri, 08 February 2013 01:31 Go to previous messageGo to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
Thanks Michel.

Though I have DBA role, I can't generate the report unless and untill I have select access for all PERFSTAT tables. Pls correct me if I am wrong.
Re: Generate statspack report without perfstat account [message #576809 is a reply to message #576808] Fri, 08 February 2013 01:37 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just try it.

Regards
Michel
Previous Topic: Getting wrong information through Views
Next Topic: hide url
Goto Forum:
  


Current Time: Fri Mar 29 04:51:08 CDT 2024