View Single Post
  #3 (permalink)  
Old 12-18-02, 15:45
billm billm is offline
Drunkard
 
Join Date: Nov 2002
Location: Desk, slightly south of keyboard
Posts: 697
Hi,

I just took a quick look in the docs and found the following procedures in DBMS_STATS....

CREATE_STAT_TABLE Procedure Creates a table with name stattab in ownname's schema which is capable of holding statistics.

EXPORT_COLUMN_STATS ProcedureRetrieves statistics for a particular column and stores them in the user stat table identified by stattab.

EXPORT_INDEX_STATS Procedure Retrieves statistics for a particular index and stores them in the user stat table identified by stattab.

EXPORT_TABLE_STATS Procedure

I couldn't post all of the relevant stuff here, but you can search the Oracle docs on oracle.com

The document I found this in is
Oracle8i Supplied PL/SQL Packages Reference
Release 2 (8.1.6)
Part Number A76936-01

It doesn't answer your question but hope it atleast points you in the right direction.

Regards
Bill
Reply With Quote