vp$dba$ [message #128142] |
Fri, 15 July 2005 06:36 |
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 |
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
|
|
|
|