OraFAQ Forum: Performance Tuning » Oracle 9i sga advisory view

Home » RDBMS Server » Performance Tuning » Oracle 9i sga advisory view

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 9i sga advisory view [message #389396]

Sun, 01 March 2009 20:16

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

BlackSwan
Messages: 26766
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

Michel Cadot
Messages: 68661
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

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.

Report message to a moderator

Re: Oracle 9i sga advisory view [message #389523 is a reply to message #389521]

Mon, 02 March 2009 07:49

Michel Cadot
Messages: 68661
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

Report message to a moderator

Re: Oracle 9i sga advisory view [message #389525 is a reply to message #389521]

Mon, 02 March 2009 08:02

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.

Report message to a moderator

Previous Topic:	Understanding Explain Plan
Next Topic:	Package Tuning (merged 4)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 17 14:18:19 CDT 2024