RE: strange behavior - DBMS_FEATURE_USAGE

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Wed, 26 Oct 2005 18:58:27 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E05BD604B@ecogenemld50.Org.Collegeboard.local>

Is a 10g thing...interesting.

http://www.psoug.org/reference/builtin_packages.html
http://www.psoug.org/reference/dbms_feature_usage.html
http://www.psoug.org/reference/dbms_feature_usage_rpt.html

Oracle Built-in Packages Version 10.1

Common Name
Usage Registration & Monitoring
Usage Registration Internal: Undocumented Usage Report

Owner
SYS Package Name

DBMS_FEATURE_USAGE
DBMS_FEATURE_USAGE_INTERNAL
DBMS_FEATURE_USAGE_REPORT

Last Modified
14-Sep-2005
-
14-Sep-2005

SELECT name, description FROM dba_feature_usage_statistics;

[oracle_at_www admin]$ more /u01/oracle/product/10.1.0/rdbms/admin/prvtfus.plb CREATE OR REPLACE PACKAGE BODY dbms_feature_usage wrapped a000000
1
...

[oracle_at_www admin]$ more /u01/oracle/product/10.1.0/rdbms/admin/dbmsfus.sql Rem
Rem $Header: dbmsfus.sql 25-apr-2003.18:49:06 aime Exp $ Rem
Rem dbmsfus.sql
Rem
Rem Copyright (c) 2002, 2003, Oracle Corporation. All rights reserved. Rem
Rem NAME

Rem      dbmsfus.sql - User Interface for the DB Feature
Rem                    Usage PL/SQL interfaces

Rem
Rem DESCRIPTION
Rem Implements the dbms_feature_usage package specification. ...

Input arguments:
feature_name - name of feature
install_check_method - how to check if the feature is installed.
currently support the values:
DBU_INST_ALWAYS_INSTALLED, DBU_INST_OBJECT
install_check_logic - logic used to check feature installation.
if method is DBU_INST_ALWAYS_INSTALLED,
this argument will take the NULL value.

Chris Marquez
Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of Paul Drake Sent: Wed 10/26/2005 6:03 PM
To: oracle list
Subject: strange behavior - DBMS_FEATURE_USAGE_INTERNAL

After a database had been cloned, I noticed that one tempfile had not been added.
As a result of the missing tempfile, numerous trace files were produced in the usual location.

ACTION NAME:(Auto-DBFUS Action) 2005-10-23 05:59:30.422
MODULE NAME:(MMON_SLAVE) 2005-10-23 05:59:30.422
SERVICE NAME:(SYS$BACKGROUND) 2005-10-23 05:59:30.422
SESSION ID:(145.8195) 2005-10-23 05:59:30.422 *********START PLSQL RUNTIME DUMP************ ***Got internal error Exception caught in pfrrun() while running PLSQL*** ***Got ORA-25153 while running PLSQL*** PACKAGE BODY SYS.DBMS_FEATURE_USAGE_INTERNAL:

***********END PLSQL RUNTIME DUMP************
*** KEWUXS - encountered error: (ORA-25153: Temporary Tablespace is Empty
)
*** KEWFADS: Error=13515 encountered by Auto DBFUS slave.

I'm not saying that its a good idea to have such a database with the sys account assigned to a temporary tablespace that is empty ... as that might be a violation of the digital millenium copyright act.

I just found it funny that they couldn't write their snooper code to work without a sort segment. :)

-bdbafh

--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 26 2005 - 18:00:53 CDT

RE: strange behavior - DBMS_FEATURE_USAGE_INTERNAL