Home » SQL & PL/SQL » SQL & PL/SQL » Assistance With Script for Monthly DB & EBS Sessions. (10G (10.2.0.4), 11i (11.5.10.2), Redhat AS 4.0)
Assistance With Script for Monthly DB & EBS Sessions. [message #428550] Wed, 28 October 2009 14:57 Go to next message
Kozmo
Messages: 4
Registered: February 2007
Location: New Hampshire
Junior Member

Hi folks - I was wondering if anyone could help me with a script to monitor monthly Database sessions as well as monthly EBS user sessions?

I'd like to be able to run a script at the end of the month (apps, system or sys), that shows 1. a per day breakdown of how many database logins there were and 2. how many EBS suite logins there were, the duration logged in as well as their EBS user-name.

Thanks for the help!
Re: Assistance With Script for Monthly DB & EBS Sessions. [message #428552 is a reply to message #428550] Wed, 28 October 2009 15:23 Go to previous message
BlackSwan
Messages: 24903
Registered: January 2009
Senior Member
In which schema, table, & columns does the data reside?
Previous Topic: Max Time for the Max date
Next Topic: Backup table using create statement
Goto Forum:
  


Current Time: Sun Sep 25 00:54:35 CDT 2016

Total time taken to generate the page: 0.04195 seconds