Showing posts with label active queries. Show all posts
Showing posts with label active queries. Show all posts

Friday, November 13, 2009

Active queries in oracle

SELECT OSUSER,
SERIAL#,
SQL_TEXT
FROM V$SESSION, V$SQL
WHERE V$SESSION.SQL_ADDRESS = V$SQL.ADDRESS
AND V$SESSION.STATUS = 'ACTIVE';

Troubleshooting ACFS-07981: Metadata Validation Errors

  Troubleshooting ACFS-07981: Metadata Validation Errors Introduction The ACFS-07981 error indicates that an attempt to run an online file ...