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 -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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$ 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 -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 logged to the SYS.AUD$ table, even in Oracle9i with the AUDIT_SYS_OPERATIONS parameter set to TRUE. SYSDBA operations are always logged to the OS audit trail, including access/modifications to the SYS.AUD$ table... The reason that these records are only logged to the audit trail (previous to Oracle9i, only connections as SYSDBA were logged) is because that is the only way to protect the audit records review and (especially!) alteration from people with SYSDBA privilege. Someone with SYSDBA could alway muck with the contents of the SYS.AUD$ table, but they would not necessarily have OS permissions to alter the audit records sent to the OS. ...which is why the command CONNECT INTERNAL went away with Oracle9i, to remove the last necessity for DBAs to be members of the OSDBA and OSOPER groups in the OS. Now, with 9i and CONNECT ... AS SYSDBA commands, you can lock down the OS account and account-group that owns the Oracle software away from those with SYSDBA privileges, thus protecting the software distribution files, log files, trace files, and audit files from casual modification, if desired... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 18, 2002 12:46 PM 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 -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 18, 2002 7:58 PM 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 logged to the SYS.AUD$ table, even in Oracle9i with the AUDIT_SYS_OPERATIONS parameter set to TRUE. SYSDBA operations are always logged to the OS audit trail, including access/modifications to the SYS.AUD$ table... The reason that these records are only logged to the audit trail (previous to Oracle9i, only connections as SYSDBA were logged) is because that is the only way to protect the audit records review and (especially!) alteration from people with SYSDBA privilege. Someone with SYSDBA could alway muck with the contents of the SYS.AUD$ table, but they would not necessarily have OS permissions to alter the audit records sent to the OS. ..which is why the command CONNECT INTERNAL went away with Oracle9i, to remove the last necessity for DBAs to be members of the OSDBA and OSOPER groups in the OS. Now, with 9i and CONNECT ... AS SYSDBA commands, you can lock down the OS account and account-group that owns the Oracle software away from those with SYSDBA privileges, thus protecting the software distribution files, log files, trace files, and audit files from casual modification, if desired... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 18, 2002 12:46 PM 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 -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--
tnslistener brute force trigger?
all, i have been attempting to find a solution to set a trigger / alarm mechanism on the listener for brute-force attempts. we're trying to get something useful logged so we can forward it to an ISD system or what not. ideas? i have done a bit of research and found nothing useful so far. am i 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 list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 name (which must be DB_NAME of your remote database). SQLWKS show parameter db_domain NAME TYPEVALUE -- --- -- db_domain string WORLD Helmut Daiminger wrote: Hi there! I'm having a problem with database links here. I am on my SPEEDY database and want to create a link that points to another database called SAM. create database link SAM connect to user identified by pasword using 'SAM'; Then I try and issue that statement: select view_name from user_views@SAM * ERROR at line 2: ORA-02085: database link SAM.VIVONET.COM connects to SAM Where does our domain name appendix (vivonet.com) come from I looked in all the possible config files (e.g. sqlnet.ora etc.) and couldn't find anything. In both databases the init.ora parameter is set to global_names = true. Any idea? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] __ 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-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rollback seg for an entire session, not just per transaction? Implicit commits in PL/SQL?
A colleague wants to do a large load using multiple PL/SQL programs; she typically (has the DBA) turns off all rollback segments except for SYSTEM and one large rollback segment. Some questions: Will the rollback segment called SYSTEM in the SYSTEM tablespace never be used for user session transactions? Is there any way to specify which rollback segment to use for an entire session versus per transaction? I'm not sure if her PL/SQL code performs implicit commits so I'm not sure doing one commit + set transaction before executing the procedure(s) will have the desired effect. Will Oracle 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://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script to reverse engineer all objects in a schema to DDL?
There are other programs such as SQL Navigator, DB Artisan, EZSQL are available but requires you to purchase a copy. SQL Programmer from Sylvain-Faust, another commercial product, will do this as well; at least on a per-object basis. It's a terrific tool all around: http://www.sfi-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-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: New born DBA
shameless plug get the book _Oracle DBA 101_ it has not only that kind of list, but lots and lots of other good stuff. and you can always ask one of the authors questions right here on the list.;-) /shameless plug did i do good rachel?;-) Question for the authors here (offline responses ok): with book-writing for technical issues, are these usually work-for-hire affairs or royalty-based? I ask as a DBA who does a small amount of (travel-related) freelance writing on the side. With the relatively higher price tag of technical books but lower number of sales, e.g.: SELECT count(*) from BOOK_SALES where SUBJECT = 'DATABASE ADMINISTRATION'; SELECT count(*) from BOOK_SALES where SUBJECT = 'PERSONAL FINANCE'; Which works out better for technical authors? Work-for-hire (flat one-time fee, publisher purchases the copyright) or royalties? My guess is work-for-hire unless 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 own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Books on Audio Tapes
--- Apps Sol [EMAIL PROTECTED] wrote: Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK I doubt it. From what I understand, audio books are primarily made from best-selling fiction. What non-fiction audio books exist are probably limited to stuff with the broadest general appeal (best-sellers). I've personally never heard of technical books on tape/audio CD. However, you might be able to make your own, rather tediously, if you receive a PDF version along with a "dead tree" technical book. 1. Copy-paste the text from the PDF to your word processor of choice. 2. Use text-to-speech software to creave WAV files 3. Burn to CD. Or, you may want to purchase some Oracle Computer-Based-Training CDROMs and burn the audio tracks to an audio CD(if they're in a standard audio format or a format you could convert to WAVs) - or convert and 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 FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBA job market in Australia and Asia?
What's the job market like for Oracle DBAs in Australia (Queensland and NSW)? Is demand being satisfied mostly with local talent? I've heard that's the case for much of the IT market there. Would it be difficult for an American Oracle DBA to secure a work visa in Australia or Asia? Any demand for English-speaking Oracle DBAs in Asia? I've heard English-speaking techs are in high-demand over in Asia, but where specifically and doing what specifically I don't know (possibly technical training conducted in English, or English for programmers/engineers/techs; or technical writing). How would 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://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
STATSPACK or equivalent for 8.0.X databases?
Will statspack ever be available, in a supported version, for Oracle 8.0.X? We'll be upgrading the machine I'm concerned about to 8.1.X eventually (next six months or so); But for now, I'd like to have access to a more sophisticated tuning-data gathering tool than bstat/estat. I find it appalling that bstat/estat can't collect, compare, and contrast multiple sets of tuning data over time; that it can't calculate db buffer cache hit ratios, etc. We've purchased Spotlight on Oracle from Quest; But come to find out (someone else did the research and made the purchase recommendation before I became involved), Spotlight is merely a real-time monitor and can't save tuning data. I thought about writing something to retrieve data from the Spotlight tables, or modifying bstat/estat to make it do what I want, but statspack seems to do everything I want - and who wants to reinvent the wheel? 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/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
confused about # of extents per segment performance issue
Apparently, it's a widely held myth that a large # of extents (let's say "BETWEEN 5 AND 1000") per table segment is bad for performance. Yet the same sources who label the belief mistaken persist in pushing for fitting all of a table in the INITIAL extent. And that confuses the heck out of me. What gives? Is it that fetching a new extent on the fly, the act of obtaining a new extent, creates too much overhead? And finis, no more concern beyond this? If you approached a database for the first time and it already contained a segment with 500 extents, would that segment's number of extents not be a performance concern unless you expected it to continue grabbing new extents? Let's say it would never have a new insert, update, or delete. Would there be any performance value in crushing the segment down to fit in one extent? What's the definitive answer on this? I remain 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.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana mn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tuning, RAID5, and fragmentation and DBWR
Thanks Dave, Don, and Patrice. It's hardware RAID, a Compaq GS140 machine, and Oracle on VMS [not my choice of OS/hardware]. Limited to one large RAID5 volume. I'd like to make the most of what's there, because for political reasons nothing else will change. Does it make any sense to increase 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/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana mn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Tuning, RAID5, and fragmentation
Presuming a DBA is forced to use RAID5, what elements of tuning become irrelevant? (in the sense that if you're stuck with RAID5, warts and all, then trying to tune X, Y, and Z would be a waste of time / ineffective). Load balancing files would be one thing.. no way to put indexes and tables on different disks (ditto redo log file members, etc) with one massive RAID5 volume. What about fragmentation and coalescing? Are these still a concern for tablespaces located on RAID5 volumes? Has anyone written an article about Oracle and "living with RAID5"? I'm finding that a customer 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 ORACLE-L FAQ: http://www.orafaq.com -- Author: dana mn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana mn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Diff. between FIRST_ROWS and INDEX hint - is there any?
Is there any difference between the FIRST_ROWS hint (which is said to "generally force the use of indexes" - Niemiec) and the use of the INDEX hint (without specifying a particular index)? Is something else going on behind the scenes with FIRST_ROWS or is this gratuitous bloat that 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 FAQ: http://www.orafaq.com -- Author: dana mn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).