Share your RMAN knowhow!!

From: Robert Freeman <>
Date: Fri, 21 Aug 2009 12:35:59 -0700 (PDT)
Message-ID: <>

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 G. Freeman
Oracle ACE
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: 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! :-)

From: Fuad Arshad <>
Cc: ORACLE-L <> 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 <> To:
Cc: ORACLE-L <> 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 <> wrote:

>>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.



   ,timestamp logon
   ,logoff_time logoff
   , os_username

from dba_audit_session
order by timestamp

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Fri Aug 21 2009 - 14:35:59 CDT

Original text of this message