The new approach is to monitor what changed; and that as you say takes a
while to obtain.

But there could just be a gazillion Oracle instances on the box ....

Regards
Amin Adatia ([Email address protected]
KnowTech Solutions Inc. (www.knowtech.ca)
(613) 226-8378 Mobile (613) 864-8378
----- Original Message -----
From: "Chalkline Margaret M (US SSA) "
<oracledba-ezmlmshield-x44830337.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, May 03, 2007 11:15 AM
Subject: RE: Réf. : RE: time for auditing.


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