CPU monthly consumption per user

From: Daniel Pinol <dpinol_at_cesca.es>
Date: 1997/12/10
Message-ID: <348E58A0.3BCDD82D@cesca.es>#1/1

Hi,

        I'd need ANY way to count how much CPU each of the users of my database has spent over a month. I've thought about 3 ways, but none is satisfying:         

-SQL TRACE: I could parse the generated files, but they are too big and
represent too much overhead.

-AUDIT: It cannot count CPU usage.
-v$sesstat: Since the SIDs are reused, I cannot count the consumption
by user.

	Thanks a lot.
	I'd appreciate an email to dpinol_at_cesca.es

-----------------------------------------------------------------------

 Daniel Piñol
 Scientific Promotion
 CESCA - Centre de Supercomputacio de Catalunya

 Edifici Nexus                                  Phone:  (34)(3) 2056464
 Gran Capita, 2-4                               Fax:    (34)(3) 2056979
 08034 Barcelona, SPAIN                         e-mail: dpinol_at_cesca.es
-----------------------------------------------------------------------

Received on Wed Dec 10 1997 - 00:00:00 CST