Home » Other » General » Cursor sharing = exact / similar (9.2.0.1.0)
Cursor sharing = exact / similar [message #475859] Sat, 18 September 2010 05:26 Go to next message
rrana
Messages: 1
Registered: September 2010
Location: kolkata,India
Junior Member
Hi

I am using oracle 9i (9.2.0.1.0). At present cursor_sharing = exact. For improve performance I have changed cursor_sharing = similar. After change from exact to similar some sql not working.

Exam.....

SELECT FORACID,ACCT_NAME, SCHM_CODE, ACCT_OWNERSHIP,LEAST(DRWNG_POWER,SANCT_LIM)+CLEAN_ADHOC_LIM+SINGLE_TRAN_LIM+CLEAN_SINGLE_TRAN_LIM+CLR_BAL_AMT-LIEN_AMT-SYSTEM_RESERVE D_AMT+FFD_CONTRIB_TO_ACCT+USED_CLEAN_SINGLE_TRAN_LIM
FROM GBM.GBM_GAM_VIEW
WHERE ACCT_CLS_FLG <> 'Y'
AND DEL_FLG <> 'Y'
AND ENTITY_CRE_FLG = 'Y'
AND schm_type LIKE '%%'
AND SOL_ID = '0457'
AND FORACID LIKE '%04570124163008%'
ORDER BY ACCT_OWNERSHIP,FORACID;

After execute this query no output comes but when cursor_sharing = exact 1000 row fetched.

Can any one help me where is the problem?

Regards
RRANA


[Topic SPLIT by LF]

[Updated on: Sat, 18 September 2010 09:48] by Moderator

Report message to a moderator

Re: Database administration [message #475861 is a reply to message #475859] Sat, 18 September 2010 06:00 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Upgrade to (at least) 9.2.0.8 there are many and many bugs when you use cursor_sharing with anything other than exact.

Regards
Michel
Previous Topic: how to write a 'checker' script
Next Topic: Data Dictionary to Wiki
Goto Forum:
  


Current Time: Fri Mar 29 11:00:14 CDT 2024