Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Query to ID running DDL

Query to ID running DDL

From: Buck Turgidson <jc_va_at_hotmail.com>
Date: 21 Sep 2001 10:46:49 -0700
Message-ID: <f98999c8.0109210946.2daf58aa@posting.google.com> 





Is there a table against which I can query to find currently running
DDL?  I have some 3rd-party scripts that are creating massive indexes.
  However, I can't really tell which step it is on.



I tried V$SQLAREA, V$SESSION_LONGOPS, but didn't find anything usable.
 I see ALTER TABLE" statements in V$SQLAREA, but no CREATE INDEX
statements.
Received on Fri Sep 21 2001 - 12:46:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US