Home » RDBMS Server » Performance Tuning » same statement reparsing again.Pl help
same statement reparsing again.Pl help [message #65997] Fri, 18 February 2005 02:45 Go to next message
BhavinShah
Messages: 105
Registered: February 2004
Senior Member
Hi frends,

I have found many same sql's parsing again and again in my sqlarea. so what should be best solution to stop reparsing a statement.If anybody can give me solution from oracle it's self rather than change in application then it will be best for me..

SELECT ctrltype_id FROM control_mst WHERE control_id = 0
SELECT ctrltype_id FROM control_mst WHERE control_id = 20
SELECT ctrltype_id FROM control_mst WHERE control_id = 4
SELECT ctrltype_id FROM control_mst WHERE control_id = 43
SELECT ctrltype_id FROM control_mst WHERE control_id = 45
SELECT ctrltype_id FROM control_mst WHERE control_id = 48
SELECT ctrltype_id FROM control_mst WHERE control_id = 50

SQL_TEXT
-----------------------------------------------------------
SELECT ctrltype_id FROM control_mst WHERE control_id = 52
SELECT ctrltype_id FROM control_mst WHERE control_id = 53
SELECT ctrltype_id FROM control_mst WHERE control_id = 56
SELECT ctrltype_id FROM control_mst WHERE control_id = 58
SELECT ctrltype_id FROM control_mst WHERE control_id = 64
SELECT ctrltype_id FROM control_mst WHERE control_id = 66
SELECT ctrltype_id FROM control_mst WHERE control_id = 71
SELECT ctrltype_id FROM control_mst WHERE control_id = 76
SELECT ctrltype_id FROM control_mst WHERE control_id = 8

Thax..

Bhavin
Re: same statement reparsing again.Pl help [message #65998 is a reply to message #65997] Fri, 18 February 2005 06:34 Go to previous message
Art Metzer
Messages: 2478
Registered: December 2002
Senior Member
Your application isn't using bind variables.

As a stopgap measure, you could research the use of CURSOR_SHARING=FORCE, but the right thing to do here is to fix your application. Use bind variables.

To detect cases where bind variables should be used, see the v$sqlarea script Tom Kyte offers here.
Previous Topic: get proc and package names
Next Topic: CBO estimates Bitmap Index retrieval at 100 times Btree cost.
Goto Forum:
  


Current Time: Sun Sep 27 21:58:26 CDT 2020