OraFAQ Forum: Performance Tuning » Check v$sqlarea for shared cursors

Home » RDBMS Server » Performance Tuning » Check v$sqlarea for shared cursors

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Check v$sqlarea for shared cursors [message #199777]

Thu, 26 October 2006 03:26

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

Report message to a moderator

Re: Check v$sqlarea for shared cursors [message #199781 is a reply to message #199777]

Thu, 26 October 2006 03:37

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

Report message to a moderator

Re: Check v$sqlarea for shared cursors [message #199795 is a reply to message #199777]

Thu, 26 October 2006 03:59

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??

Report message to a moderator

Re: Check v$sqlarea for shared cursors [message #199798 is a reply to message #199795]

Thu, 26 October 2006 04:12

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

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

version is 9.2

Report message to a moderator

Re: Check v$sqlarea for shared cursors [message #199935 is a reply to message #199777]

Fri, 27 October 2006 00:58

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

Hi,

Please reply. it is urgent.

Thanks
reena

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 18:03:56 CDT 2024