Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_DLL.ANALYZE_OBJECT
DBMS_DLL.ANALYZE_OBJECT [message #220061] Sun, 18 February 2007 06:56 Go to next message
Splinter2010
Messages: 20
Registered: July 2006
Location: EGYPT
Junior Member

How can i display the data which i create with the DBMS_DLL.ANALYZE_OBJECT ??
thax
Re: DBMS_DLL.ANALYZE_OBJECT [message #220077 is a reply to message #220061] Sun, 18 February 2007 12:19 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
by using SELECT
Re: DBMS_DLL.ANALYZE_OBJECT [message #220082 is a reply to message #220061] Sun, 18 February 2007 13:33 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
1. Starting with Oracle 8i you are NOT supposed to use either
ANALYZE TABLE/INDEX or DBMS_DDL.ANALYZE_OBJECT (use DBMS_STATS instead).
2. Look at DBA/ALL/USER_TABLES (INDEXES).

HTH.
Previous Topic: pl/sql question
Next Topic: Help needed using REF CURSOR
Goto Forum:
  


Current Time: Sun Dec 04 06:28:17 CST 2016

Total time taken to generate the page: 0.11243 seconds