Home » RDBMS Server » Performance Tuning » oracle performance metrics (11g)
oracle performance metrics [message #621792] Mon, 18 August 2014 07:28 Go to next message
andrewscharles89
Messages: 25
Registered: July 2014
Junior Member
how to save output of planx.sql to a table?
Re: oracle performance metrics [message #621794 is a reply to message #621792] Mon, 18 August 2014 07:43 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is "planx.sql"?

Re: oracle performance metrics [message #621800 is a reply to message #621794] Mon, 18 August 2014 08:27 Go to previous messageGo to next message
BlackSwan
Messages: 25856
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/
Re: oracle performance metrics [message #621805 is a reply to message #621800] Mon, 18 August 2014 09:27 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
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.
Re: oracle performance metrics [message #621807 is a reply to message #621805] Mon, 18 August 2014 10:02 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: oracle performance metrics [message #621809 is a reply to message #621807] Mon, 18 August 2014 10:07 Go to previous message
Lalit Kumar B
Messages: 3123
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.
Previous Topic: view slowness..
Next Topic: Regarding sql id
Goto Forum:
  


Current Time: Tue Feb 20 20:31:49 CST 2018

Total time taken to generate the page: 0.09625 seconds