Re: how to find dbms_stats progress in 11g ?
From: Prem <premj_at_rediffmail.com>
Date: 29 Mar 2011 12:32:54 -0000
Message-ID: <1301396585.S.6187.58226.F.H.Tkt1bWFyIE1hZGR1cmkAUmU6IGhvdyB0byBmaW5kIGRibXNfc3RhdHMgcHJvZ3Jlc3MgaW4gMTFnID8_.f4-234-230.old.1301401972.56902_at_webmail.rediffmail.com>
Thanks Gleb , kumar & Peter
Date: 29 Mar 2011 12:32:54 -0000
Message-ID: <1301396585.S.6187.58226.F.H.Tkt1bWFyIE1hZGR1cmkAUmU6IGhvdyB0byBmaW5kIGRibXNfc3RhdHMgcHJvZ3Jlc3MgaW4gMTFnID8_.f4-234-230.old.1301401972.56902_at_webmail.rediffmail.com>
Thanks Gleb , kumar & Peter
we have not started working on 11g and so thought some new view which would give all these details would exist.
looks like we have to go with the standard session_longops and dba_indexes.
~ jp ~
On Tue, 29 Mar 2011 16:33:05 +0530 Kumar Madduri <ksmadduri_at_gmail.com> wrote
>If you get the sid, you can then get the sql_hash_value and sql_text..
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 29 2011 - 07:32:54 CDT