Home » RDBMS Server » Performance Tuning » Check v$sqlarea for shared cursors
Check v$sqlarea for shared cursors [message #199777] Thu, 26 October 2006 03:26 Go to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Hi,

How can we check in v$sqlarea whether existing cursor is being used or not. Please mention the columns to look on . Please help with examples.

Thanks
Reena
Re: Check v$sqlarea for shared cursors [message #199781 is a reply to message #199777] Thu, 26 October 2006 03:37 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

LITERAL_HASH_VALUE NUMBER Hash value of the literals which are replaced with system-generated bind variables and are to be matched, when CURSOR_SHARING is used. This is not the hash value for the SQL statement. If CURSOR_SHARING is not used, then the value is 0. 

Oracle Version : 10.2

Re: Check v$sqlarea for shared cursors [message #199795 is a reply to message #199777] Thu, 26 October 2006 03:59 Go to previous messageGo to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
what does the value in columns version_count and parse_calls of view v$sqlarea signify??when would it change??
Re: Check v$sqlarea for shared cursors [message #199798 is a reply to message #199795] Thu, 26 October 2006 04:12 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Can You plz. post Oracle Version ?
10.2
http://download-
west.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2129.htm

10.1
http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10755/dynviews_2112.htm

thanx

[Updated on: Thu, 26 October 2006 04:15]

Report message to a moderator

Re: Check v$sqlarea for shared cursors [message #199799 is a reply to message #199777] Thu, 26 October 2006 04:15 Go to previous messageGo to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
version is 9.2
Re: Check v$sqlarea for shared cursors [message #199935 is a reply to message #199777] Fri, 27 October 2006 00:58 Go to previous message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Hi,

Please reply. it is urgent.

Thanks
reena
Previous Topic: setting trace file name created using sql trace
Next Topic: Reorganization of data/ Eliminate database fragmentation (export, drop and re-import tables)
Goto Forum:
  


Current Time: Thu Dec 08 05:58:05 CST 2016

Total time taken to generate the page: 0.09410 seconds