OEM under 10g is good for gathering statistics and metrics on performance. Shouldn't take more than 1/2 hour to get what you need, provided you have the tools in place and know your way around them.
Cheers,
Stephen
________________________________
From: David NGUYEN [mailto:oracledba-ezmlmshield-x5446624.[Email address protected]
Sent: Thu 5/3/2007 10:49 AM
To: LazyDBA Discussion
Subject: Réf. : RE: time for auditing.
this is a auditing for performance.
someting like tables,indexes,tablespaces,memory(sga,sort_area_size,full
scan, reload,check point,switch redo.......)
all thing to know about the performance of the instance.
i think that we need about 3 to 4 days but not sure, so i need your
opinion and suggestions.
thanks again.
david...
oracledba-ezmlmshield-x66698292.[Email address protected]
03/05/2007 16:33
Pour : [Email address protected]
cc : (ccc : David NGUYEN/E/DN/GDF/FR)
Objet : RE: time for auditing.
What kind of auditing you have enabled on your instances?
________________________________
From: David NGUYEN [mailto:oracledba-ezmlmshield-x57337141.[Email address
protected]
Sent: Thu 5/3/2007 10:33 AM
To: LazyDBA Discussion
Subject: time for auditing.
hello experts,
i was not clear
the boss asked me how long we need for auditing all database :
objects,tablespaces,memory,performance....etc....
so my question is how long do i need for a full auditing for all database(
just 1 instance) ?
the database owns : 20Go of datafiles, 300Mo of sga_max_size .
thanks in advance.
david...
----- Réacheminé par David NGUYEN/E/DN/GDF/FR le 03/05/2007 16:18 -----
oracledba-ezmlmshield-x79685155.[Email address protected]
03/05/2007 14:17
Pour : [Email address protected]
cc : (ccc : David NGUYEN/E/DN/GDF/FR)
Objet : time for audit.
hello experts,
i just want to know how long (mininum) do i need to make audit for an
instance ...?
david..
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page