Pete Finnigan's Oracle Security Forum


    
      
        Pete Finnigan's Oracle Security Forum
        (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
      

        Oracle Security >> Oracle Security >> How to get response time and rows returned
        
(Message started by: Pete Finnigan on Sep 21^st, 2005, 4:00am)

Title: How to get response time and rows returned
Post by Pete Finnigan on Sep 21^st, 2005, 4:00am

Two key statistics I need for auditing my data warehouse are the "query response time" and the "rows returned" by the query.

I am using FGA and extracting data from AUD$ and FGA_LOG$ tables. So I have the user, query and timestamp but these extra stats for the query would be valuable.

Is this possible within oracle? or do I need another product?

Title: Re: How to get response time and rows returned
Post by Pete Finnigan on Sep 22^nd, 2005, 12:29am

V$SQL contains sql_text, elapsed_time and rows_processed. You may also be able to use the module and action columns to tie the SQL back to the process.
This is a dynamic table, so you might want to structure in some batch job that copies it, eg every hour.