strange behavior - DBMS_FEATURE_USAGE

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

strange behavior - DBMS_FEATURE_USAGE_INTERNAL

strange behavior - DBMS_FEATURE_USAGE_INTERNAL

2005-10-26 - By Marquez, Chris

Reply: 1 2 3 4 5

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@(protected) admin]$ more /u01/oracle/product/10.1.0/rdbms/admin/prvtfus.plb
CREATE OR REPLACE PACKAGE BODY dbms_feature_usage wrapped
a000000
1
...

[oracle@(protected) 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@(protected) 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 (See ORA-25153.ora-code.com) while running PLSQL***
PACKAGE BODY SYS.DBMS_FEATURE_USAGE_INTERNAL:

***********END PLSQL RUNTIME DUMP************
*** KEWUXS - encountered error: (ORA-25153 (See ORA-25153.ora-code.com): 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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7233.28">
<TITLE>RE: strange behavior - DBMS_FEATURE_USAGE_INTERNAL</TITLE>
</HEAD>
<BODY>

 

Is a 10g thing...interesting. 
 
<A HREF="http://www.psoug.org/reference/builtin_packages.html">http://www.psoug
.org/reference/builtin_packages.html</A> 
<A HREF="http://www.psoug.org/reference/dbms_feature_usage.html">http://www
.psoug.org/reference/dbms_feature_usage.html</A> 
<A HREF="http://www.psoug.org/reference/dbms_feature_usage_rpt.html">http://www
.psoug.org/reference/dbms_feature_usage_rpt.html</A> 
 
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@(protected) admin]$ more /u01/oracle/product/10.1.0/rdbms/admin/prvtfus.plb 
CREATE OR REPLACE PACKAGE BODY dbms_feature_usage wrapped 
a000000 
1 
... 
 
 
 
[oracle@(protected) 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@(protected) 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 (See ORA-25153.ora-code.com) while running PLSQL*** 
PACKAGE BODY SYS.DBMS_FEATURE_USAGE_INTERNAL: 
 
***********END PLSQL RUNTIME DUMP************ 
*** KEWUXS - encountered error: (ORA-25153 (See ORA-25153.ora-code.com): 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 
-- 
<A HREF="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org
/webpage/oracle-l</A> 
 
 
 



</BODY>
</HTML>