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: Ryan 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).