Home » RDBMS Server » Performance Tuning » Oracle 9i sga advisory view
Oracle 9i sga advisory view [message #389396] Sun, 01 March 2009 20:16 Go to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
hello all,

When querying this view in regards to the v$sga_shared_pool advisory , i get results but not sure how to interpret the ESTD_LC_TIME_SAVED column ?
It's a time in seconds benchmark to what? and is it in thousands of seconds ?

EST_SIZE FACTOR ESTD_LC_SIZE ESTD_LC_TIME_SAVED HITS

160 0.5 162 215103 43148850
192 0.6 193 215285 43173155
224 0.7 224 215391 43188435
256 0.8 255 215470 43200068

Thanks

[Updated on: Sun, 01 March 2009 20:19]

Report message to a moderator

Re: Oracle 9i sga advisory view [message #389397 is a reply to message #389396] Sun, 01 March 2009 20:22 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>It's a time in seconds benchmark to what?
Size of the SGA.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

[Updated on: Sun, 01 March 2009 20:31]

Report message to a moderator

Re: Oracle 9i sga advisory view [message #389413 is a reply to message #389396] Sun, 01 March 2009 23:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Format your ouput accordingly to OraFAQ Forum Guide, "How to format your post?" section. Align the columns.

Regards
Michel

[Updated on: Sun, 01 March 2009 23:23]

Report message to a moderator

Re: Oracle 9i sga advisory view [message #389521 is a reply to message #389396] Mon, 02 March 2009 07:43 Go to previous messageGo to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
Thank you for your reply. I am not clear exactly if the seconds are in thousands or is there a decimal somewhere ?

EST_SIZE FACTOR ESTD_LC_SIZE ESTD_LC_TIME_SAVED HITS

160 0.5 162 215103 43148850
192 0.6 193 215285 43173155
224 0.7 224 215391 43188435
256 0.8 255 215470 43200068

I just wanted to know if it's ~59 hrs.
Re: Oracle 9i sga advisory view [message #389523 is a reply to message #389521] Mon, 02 March 2009 07:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 02 March 2009 06:19
Format your ouput accordingly to OraFAQ Forum Guide, "How to format your post?" section. Align the columns.

Regards
Michel


Re: Oracle 9i sga advisory view [message #389525 is a reply to message #389521] Mon, 02 March 2009 08:02 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Documentation - it's not just there to look good on the bookshelf.

The time is in seconds, and the column represents the esimated total saving in parse time since the database started.
Previous Topic: Understanding Explain Plan
Next Topic: Package Tuning (merged 4)
Goto Forum:
  


Current Time: Fri Dec 02 18:39:55 CST 2016

Total time taken to generate the page: 0.13822 seconds