OraFAQ Forum: Performance Tuning » oracle performance metrics

Home » RDBMS Server » Performance Tuning » oracle performance metrics (11g)

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

oracle performance metrics [message #621792]

Mon, 18 August 2014 07:28

andrewscharles89
Messages: 25
Registered: July 2014

Junior Member

how to save output of planx.sql to a table?

Report message to a moderator

Re: oracle performance metrics [message #621794 is a reply to message #621792]

Mon, 18 August 2014 07:43

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is "planx.sql"?

Report message to a moderator

Re: oracle performance metrics [message #621800 is a reply to message #621794]

Mon, 18 August 2014 08:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

what does "how to save output of planx.sql to a table" have to do with "oracle performance metrics"?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Report message to a moderator

Re: oracle performance metrics [message #621805 is a reply to message #621800]

Mon, 18 August 2014 09:27

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

There seems to be an underground script developed called planx.sql claiming to be lightweight, not sure based on what metrics. I never heard of it officially, just saw few people with their take on this subject, an example here http://carlos-sierra.net/2013/10/09/yasts-yet-another-sql-tuning-script-planx-sql/

@OP, could you elaborate what exactly you are trying to do.

Report message to a moderator

Re: oracle performance metrics [message #621807 is a reply to message #621805]

Mon, 18 August 2014 10:02

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, I suspected this was this on (which is no more available on the web, afaik) but I preferred to ask OP instead of guessing.

Report message to a moderator

Re: oracle performance metrics [message #621809 is a reply to message #621807]

Mon, 18 August 2014 10:07

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Yes, I couldn't find anything else related to the subject on web. I found it via linkedin as Carlos shared it.

And regarding OP telling us about it, I wonder if he even cares to feedback, based on his previous posts. So, I posted what I found.

Report message to a moderator

Previous Topic:	view slowness..
Next Topic:	Regarding sql id

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 17:51:58 CST 2025