Hello everyone!! We are working on the 11g Edition of our RMAN book. If you have read previous editions of the book, you know that we have some chapters specific to the MML interfaces to RMAN such as Veritas NetBackup. I need some authors to go through the existing chapters on Veritas NetBackup and EMC Networker and update them for us. I also need someone who would be interested on doing a chapter on Oracle Secure Backup. While we don't pay for these chapters, you will get your name mentioned in the acknowledgments of the book and saying that you wrote a chapter in a book looks pretty cool on a resume!! If you would be interested, please let me know in a private email. Please DO NOT reply to this thread or to the group as a whole. Thanks in advance! Robert Robert G. Freeman Oracle ACE Author: Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press) Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press) Other various titles out of print now... Blog: http://robertgfreeman.blogspot.com The LDS Church is looking for DBA's. You do have to be a Church member in good standing. A lot of kind people write me, concerned I may be breaking the law by saying you have to be a Church member. It's legal I promise! :-) http://pages.sssnet.com/messndal/church/parachurch.pdf ________________________________ From: Fuad Arshad <fuadar@xxxxxxxxx> To: jkstill@xxxxxxxxx Cc: ORACLE-L <oracle-l@xxxxxxxxxxxxx> Sent: Friday, August 21, 2009 12:23:06 PM Subject: Re: User count at a point in time So from a debugging standpoint it is something we have to create and not something already enabled or collected right . Just making sure that my assumption here is the correct one . I'm trying to debug an issue that happened in the past and while is see oracle is collect history of v$resource_limit i cant find any clear way to correlate the v$resource_limit data to actual logons at a point in time. ________________________________ From: Jared Still <jkstill@xxxxxxxxx> To: fuadar@xxxxxxxxx Cc: ORACLE-L <oracle-l@xxxxxxxxxxxxx> Sent: Friday, August 21, 2009 1:01:38 PM Subject: Re: User count at a point in time On Fri, Aug 21, 2009 at 10:31 AM, Fuad Arshad <fuadar@xxxxxxxxx> wrote: > >List >>I'm trying to figure out someone that potientially can be basic >>I know awr and ash contain data about users that were connected I'm trying to >>find a way to tell at a point in time how many users were connected >>I.e abc had 500 sessions >>Def has 600 sessions >>Basically looking to match the users the caused my process resource limit to >>exceed .this is more of debugging exercise > You can do that with auditing by enabling session auditing. select username ,timestamp logon ,logoff_time logoff , os_username ,terminal ,action_name ,returncode from dba_audit_session order by timestamp / Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist