| same statement reparsing again.Pl help [message #65997] |
Fri, 18 February 2005 02:45  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
