Hey, another cool feature is v$garbage_bin or whatever it's called, so you can undo stuff like a drop table.
Not to mention the patch management stuff, which could be rather cool.
Mogens
Ryan wrote:
did oracle provide you with documentation on these tools or just the 10g database and you had to find it all yourself? ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 5:39 PM
ADDM (pronouned "Adam") is - as I wrote a minute ago - Statspack++ - for what it's worth. Of course you can't tell a damned thing about performance problems from system-data. Unless there's only one and the same user on the system in the observation internval.
Active Session History (ASH), however, is a different story. Here they collect (down to every second) data about each session and what it spent its time doing. That's 10046 stuff being sampled in memory structures and stored in the repository in the SYSAUX tablespace. Very cool. Gaja will talk about it at our Database Forum - probably the day after he stars in "BAARF. The Musical".
Jesse, Rich wrote:
Sweet!
"Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.'"
<sarcasm>No more SQL tuning! No more STATSPACK! No more OEM/DBMS jobs! Wait a minute...no more DBA? Uh-oh.</sarcasm>
"I'm sorry Dave. I can't close the pod bay instance."
Rich
Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-----Original Message----- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: 10g
Correct. You can follow his announcement on www.Oracle.com at 2PM PDT.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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).
