RE: V$ views in transactions

Thanks Ryan, I have setup the job.

Regards,
Charu.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of ryan_gaffuri_at_comcast.net
Sent: Tuesday, October 12, 2004 8:58 PM
To: joshic_at_mahindrabt.com; oracle-l_at_freelists.org Cc: Charu Joshi
Subject: Re: V$ views in transactions

Typically when someone goes 'never' its an over simplification and is often wrong. The only time I say 'never' is when I talk to a non-technical person or someone without database skills, since its too much info to explain the details. Most people who say 'never' to other professionals with the same skillset typically don't know that much and when pressed do not know the details of 'why'. So there opinion is often not trustworthy. It's one of those red-herrings that sets off alarms for me. People don't include v$views in stuff like this because if you do it alot, it hurts performance. Sounds like you are including it as part of a statspack routine that runs what 3 times a day? It shouldn't be a problem.

Its not uncommon to want to capture v$data statically for later analysis. Just don't run it out of a loop or on-demand. Periodic uses are perfectly reasonable.

> Dear all,
>
> Version 9.2.0.3
> OS: Solaris 8
>
> I have written a tiny stored procedure which does a SELECT from v$sql and
> v$sql_workarea and INSERTs into local tables. The reason for doing this is
> that STATSPACK does not take snapshot of v$sql_workarea table, and I
thought
> this information would be useful to accurately calculate values for
> SORT_AREA_SIZE and HASH_AREA_SIZE.

--
http://www.freelists.org/webpage/oracle-l


*********************************************************
Disclaimer:          

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*********************************************************
Visit us at http://www.mahindrabt.com

--
http://www.freelists.org/webpage/oracle-l