sys.aud$ - auditing user activities?

Hello All, Do any of you have suggestions for a good way to monitor sysdba user activities on the sys.aud$ table? Or, in terms of logging everything, what would be the keypoints to log scrub on? Any suggestions would be wonderful. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

FW: sys.aud$ - auditing user activities?

-Original Message- From: Dana Mueller Sent: Monday, November 18, 2002 11:45 AM To: '[EMAIL PROTECTED]' Subject: sys.aud$ - auditing user activities? Hello All, Do any of you have suggestions for a good way to monitor sysdba user activities on the sys.aud

Updated Question (sorry for the spam)

Is there a way to log the sysdba account accessing sys.aud table? In my reading, I have not found a solution to this yet. Thanks Again, Dana Mueller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: sys.aud$ - auditing user activities? - follow up

Tim - Thanks for the well worded response. Very, very helpful. So my next question: Are there any 3rd party applications available to do what Oracle won't? -Original Message- Sent: Monday, November 18, 2002 4:29 PM To: Multiple recipients of list ORACLE-L SYSDBA activities are not

RE: sys.aud$ - auditing user activities? - follow up

Tim / All. I figured it out. Basically assign users SYSDBA privies and track accordingly. -Original Message- Sent: Monday, November 18, 2002 7:44 PM To: Multiple recipients of list ORACLE-L please be a little more specific? what exactly is it that oracle won't do? - Original

tnslistener brute force trigger?

missing something? thanks in advance. dana mueller guardent, inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Problem with database link

You could try setting GLOBAL_NAMES to FALSE in your init.ora file. By default, it's set to TRUE. Once I set mine to FALSE, I was able to create public database links easily. - Dana --- Michal Zaschke [EMAIL PROTECTED] wrote: AFAIK, parameter DB_DOMAIN is what appends to the database link

Rollback seg for an entire session, not just per transaction? Implicit commits in PL/SQL?

ever do an implicit commit inside a PL/SQL procedure or is a commit performed only with the commit command or when exiting a procedure? Thanks very much. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http

RE: Script to reverse engineer all objects in a schema to DDL?

-software.com/ - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services

Re: New born DBA

the royalties are a generous percentage of list price (versus net). I've heard co-authors of technical books receive as little as USD (or should that be USC) 25 cents a book when royalties are paid. Thanks. - Dana __ Do You Yahoo!? Get email at your

Re: Oracle Books on Audio Tapes

d download to an MP3 player. That's probably your best choice, though an expensive one. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L

DBA job market in Australia and Asia?

a person go about finding these jobs? Any companies hiring around Boston that would send Oracle DBAs on overseas assignments? Thanks very much. - Dana __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http

STATSPACK or equivalent for 8.0.X databases?

? Any good tuning data gathering freeware out there (with statspack-like functionality) for use with 8.0.X databases? Thanks very much. - Dana __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com

confused about # of extents per segment performance issue

n confused about coalescing as well; anyone know of a good whitepaper or article on coalescing/fragmentation for Oracle 8 and beyond? Thanks. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail

Re: Tuning, RAID5, and fragmentation and DBWR

the number of database writer processes on a system with nothing but RAID5 space? Looks like there's a bit of slowdown on checkpoints. Thanks. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com

Tuning, RAID5, and fragmentation

stomer has several Oracle databases on systems with nothing else but RAID5 storage for everything. Thanks very much. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official OR

bstat/estat like setting a specific window of time for V$SYSSTAT?

Would it be correct to say that using bstat/estat is like querying V$SYSSTAT but setting the activity to a specified window of time versus instance startup to time of a query to V$SYSSTAT? Thanks. - Dana __ Do You Yahoo!? Get personalized

Diff. between FIRST_ROWS and INDEX hint - is there any?

shouldn't be in the optimizer? (or a placeholder for future innovation)? Thanks very much. - Dana __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/ -- Please see the official ORACLE-L