Good joke Amin. HeHe

Seriously this would all depend on how and different parts are being used. You could audit for three weeks but if it is not the right window, you would miss the heaviest once a month use from the engineers, or the accounts or the trainers. Figure out the windows of heaviest use and audit that since it will tax your system the most.

-----Original Message-----
From: Amin Adatia [mailto:oracledba-ezmlmshield-x78913636.[Email address protected]
Sent: Thursday, May 03, 2007 10:09 AM
To: LazyDBA Discussion
Subject: Re: Réf. : RE: time for auditing.

Ask your Boss -- How long is a string?

Regards
Amin Adatia ([Email address protected]
KnowTech Solutions Inc. (www.knowtech.ca)
(613) 226-8378 Mobile (613) 864-8378
----- Original Message -----
From: "David NGUYEN "
<oracledba-ezmlmshield-x5446624.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, May 03, 2007 10:49 AM
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
>
>
>



---------------------------------------------------------------------
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