Home » RDBMS Server » Performance Tuning » execute to parse % - 50% (10.2.0.5.0, windows 7)
execute to parse % - 50% [message #579388] Tue, 12 March 2013 01:26 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

Here, i am little bit confuse about the percentage of the term "execute to parse %". If it's percentage would be "-ve" means, SQL statement parsing lot but executing less. May be user running reports. Here, value is 50%, what should I suggest to client? Do i tell them that performance of database is fine?

Waiting for your reply...

Regards,
Ishika
Re: execute to parse % - 50% [message #579397 is a reply to message #579388] Tue, 12 March 2013 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"execute to parse %" from what? Don't you think it depends on the tool you use?

Quote:
what should I suggest to client?


If you don't know then you are not skilled to the task that has been assigned to do, it is then better to way it and not make your job by a forum.

If you want to be this kind of work you must read Database Performance Tuning Guide.

Regards
Michel

[Updated on: Tue, 12 March 2013 01:53]

Report message to a moderator

Re: execute to parse % - 50% [message #579399 is a reply to message #579397] Tue, 12 March 2013 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition a simple search gives you this AskTom thread: execute to parse ratio.

Regards
Michel
Re: execute to parse % - 50% [message #579423 is a reply to message #579388] Tue, 12 March 2013 03:01 Go to previous messageGo to next message
John Watson
Messages: 4563
Registered: January 2010
Location: Global Village
Senior Member
I would handle this differently. You ask this:Quote:
what should I suggest to client? Do i tell them that performance of database is fine?
which is not the correct approach. No client has ever telephoned the help desk to complain that "the execute to parse ratio is bad". They complain about things like "this report is too slow" or "this screen doesn't refresh fast enough". Focus on identifying the problem, in business terms, first. Only then can you look at possible reasons.
Re: execute to parse % - 50% [message #579468 is a reply to message #579423] Tue, 12 March 2013 06:59 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear John,

The database size is small. As of now, there are no performance issue. I have give feedback on this, to client. That's why i want to about it.

Regards,
Ishika
Re: execute to parse % - 50% [message #579470 is a reply to message #579468] Tue, 12 March 2013 07:02 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If the database is small and there is no performances issue so why worry about this?
Why not worry about IO performances or CPU performances or, as a major concern, Oracle version which is no more supported?

Regards
Michel
Re: execute to parse % - 50% [message #579477 is a reply to message #579470] Tue, 12 March 2013 07:53 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

Thanks a lot to u all guys. I had gone through the links but unable to get proper answer of it. At last, i post it here to get proper answer from u all gurus but my question is wrong or way of asking is wrong so, kindly remove this post from this site.

Regards,
Ishika
Re: execute to parse % - 50% [message #579488 is a reply to message #579477] Tue, 12 March 2013 09:04 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your question is not wrong but you ask YOURSELF a question that is not pertinent for your case.
You have nothing to say to your client.

In addition, I think you didn't carefully read the links I provided as there are ALL the information you need (above all the second one). If you don't think so then explain why it does not answer your question.

Regards
Michel
Re: execute to parse % - 50% [message #579561 is a reply to message #579488] Wed, 13 March 2013 05:31 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

I read your mentioned link and come to conclusion that even if execute to parse% is 2, database performance is good. Percentage below 0 is the problem. Am I correct here?

Regards,
Ishika
Re: execute to parse % - 50% [message #579566 is a reply to message #579561] Wed, 13 March 2013 05:36 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Anyway performances are good unless there is a performances problem reported by users.

Regards
Michel
Re: execute to parse % - 50% [message #579570 is a reply to message #579561] Wed, 13 March 2013 05:43 Go to previous messageGo to next message
John Watson
Messages: 4563
Registered: January 2010
Location: Global Village
Senior Member
Ishika, I'll try again: you have missed the point!
Database performance is not GOOD or BAD according to some ratio. It is GOOD if your users find it acceptable, it is BAD if they do not find it acceptable. You said earlier that, to quote you, "As of now, there are no performance issue". Therefore, performance is GOOD. That is the only report you can give your client.

Do you understand what I'm saying? If not, you could Google "compulsive tuning disorder" which is a supposedly amusing term to describe pointless tuning activity.
Re: execute to parse % - 50% [message #579723 is a reply to message #579570] Thu, 14 March 2013 06:21 Go to previous message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Thank you Mr. michel & john. Smile
Previous Topic: Analyzing non-sequential snapshots in AWR
Next Topic: Execution Plan Changing with same SQL Profile
Goto Forum:
  


Current Time: Fri Sep 19 03:34:56 CDT 2014

Total time taken to generate the page: 0.12452 seconds