executions=0 in V$sqlarea

Do you run Uniface by any chance ?
This 'opens' a table by parsing, but not executing, a 'select * from table_name;' statement when a client connects with the application.

Regards,
Norman.

PS. I think Uniface 7205 *does* actually execute the statement but it shouldn't :o(

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------

-----Original Message-----

From: ydias_at_hotmail.com (dias) [mailto:ydias_at_hotmail.com] Posted At: Friday, November 23, 2001 4:43 PM Posted To: server
Conversation: executions=0 in V$sqlarea
Subject: executions=0 in V$sqlarea

Hi,

In v$sqlarea, there is some sql orders with : - executions = 0
- parse_calls > 0

Can someone explain why parsing without executing ?

Thanks Received on Mon Nov 26 2001 - 07:55:41 CST