Home » RDBMS Server » Enterprise Manager » vp$dba$
vp$dba$ [message #128142] Fri, 15 July 2005 06:36 Go to next message
vadik77
Messages: 3
Registered: July 2005
Junior Member
Platform HP-UX 11.11
Database Version 9.2.0.5.0
DBSNMP for HPUX: Version 9.2.0.5.0 - Production

Problem: VP$DBA tables not being purged and my repository is growing to fast.
What is to be done?
Re: vp$dba$ [message #133379 is a reply to message #128142] Thu, 18 August 2005 15:30 Go to previous messageGo to next message
mirage
Messages: 4
Registered: July 2005
Junior Member
i don't know that there is a table named vp$dba$! or idont understand.

but you ask V$DBFILE , V$DBLINK , V$DB_CACHE_ADVICE V$DB_OBJECT_CACHE , V$DB_PIPES or others. these are i remember now beginning with db.

and if the problem is that growing cache, query V$CACHE table and also V$DB_CACHE_ADVICE.


good luck,
mirage
Re: vp$dba$ [message #133461 is a reply to message #133379] Fri, 19 August 2005 03:23 Go to previous message
vadik77
Messages: 3
Registered: July 2005
Junior Member
Please read about my problem on
http://www.metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=BUG&p_id=2718199

But now I know the right answer.

Check Metalink for the patch that is referenced below.
Capacity Planner must be patched on the workstation or the problem will reoccur.
==============================
Patch Name: DP_920_2718199
Patch Version: not versioned; see patch date
Can Apply Patch To: Diagnostics Pack 9.2.0.1.0
Date: January 6, 2003
Previous Topic: Add / Remove Program
Next Topic: ORacle 9i OEMC unable to logon - please help
Goto Forum:
  


Current Time: Wed May 18 02:39:14 CDT 2022