Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help : X$KSPPI Oracle 8.1.7.2 STATSPACK

RE: Help : X$KSPPI Oracle 8.1.7.2 STATSPACK

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Thu, 03 Oct 2002 05:33:24 -0800
Message-ID: <F001.004DF2D4.20021003053324@fatcity.com>


If you are running the statspack script as SYS, and still getting these errors, then it appears that catalog.sql (and may be catproc.sql) was not run (as sys) on this new database.

-----Original Message-----
Sent: Thursday, October 03, 2002 3:58 AM To: Multiple recipients of list ORACLE-L

This errors I got,
I did the same installation on an other server same 8.1.72 and never I got any errors with statspack.
Why those objects does'nt exists ?
How can fix this problem ?
thanks

grant select on V$FILESTATXS      to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V$TEMPSTATXS      to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V$SQLXS           to PERFSTAT

*

ERROR at line 1:
ORA-01720: grant option does not exist for 'SYS.V_$SQL'

Grant succeeded.

grant select on V_$PARAMETER      to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$SYSTEM_PARAMETER to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$DATABASE       to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$INSTANCE       to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$LIBRARYCACHE to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$LATCH          to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$LATCH_MISSES to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$LATCH_CHILDREN to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$LATCH_PARENT to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$ROLLSTAT       to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$ROWCACHE       to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SGA            to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$BUFFER_POOL to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$SGASTAT        to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$SYSTEM_EVENT to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$SESSION        to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$SESSION_EVENT to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$SYSSTAT        to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$WAITSTAT       to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SQLAREA        to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SQL            to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SQLTEXT        to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SESSTAT        to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

grant select on V_$BUFFER_POOL_STATISTICS to PERFSTAT

*

ERROR at line 1:
ORA-00942: table or view does not exist

	-----Message d'origine-----
	De:	Deshpande, Kirti [mailto:kirti.deshpande_at_verizon.com]
	Date:	mercredi 2 octobre 2002 20:33
	:	Multiple recipients of list ORACLE-L
	Objet:	RE: Help : X$KSPPI Oracle 8.1.7.2  STATSPACK

	That's an Oracle internal table that is created during the database
creation
	time. 

	What is the exact error you are receiving?

	BTW, Do you use APT scripts by Steve Adams? 

	- Kirti


	-----Original Message-----
	Sent: Wednesday, October 02, 2002 12:39 PM
	To: Multiple recipients of list ORACLE-L


	How to create this view X$KSPPI ?

	I am trying to install statspack, and it missing this view. ! ! !
	Regards
	-- 
	Please see the official ORACLE-L FAQ: http://www.orafaq.com
	-- 
	Author: Bernard, Gilbert
	  INET: Gilbert.Bernard_at_caissedesdepots.fr

	Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
	San Diego, California        -- Mailing list and web hosting
services         
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L
	(or the name of mailing list you want to be removed from).  You may
	also send the HELP command for other information (like subscribing).
	-- 
	Please see the official ORACLE-L FAQ: http://www.orafaq.com
	-- 
	Author: Deshpande, Kirti
	  INET: kirti.deshpande_at_verizon.com

	Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
	San Diego, California        -- Mailing list and web hosting
services         
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L
	(or the name of mailing list you want to be removed from).  You may
	also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bernard, Gilbert
  INET: Gilbert.Bernard_at_caissedesdepots.fr

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Oct 03 2002 - 08:33:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US