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 -> Save query and statistics automatic

Save query and statistics automatic

From: Steve Robin <ocmaman_at_gmail.com>
Date: 10 Feb 2007 06:26:10 -0800
Message-ID: <1171117570.915975.252330@p10g2000cwp.googlegroups.com> 





Hi All,


Is it possible to store, query with username, who is executing it,
with osuser, with time taken by that query plus number rows processes.
Actually I want to store each query with right literals not bind
variable, which are store in v$sqlarea(including query executes twice
with two different stats), which is executed by user between 8 PM to 9
PM in a table. Is it possible to store it with details.
Please help.
Received on Sat Feb 10 2007 - 08:26:10 CST












Original text of this message













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