wwv_flow_data
JoshcalApr 28 2010 — edited Jun 16 2011Hello
We are using apex 3.2 and oracle db 11g. We have more apex application running.... recently we put a new apex application which used by many we users using this applicaiton for file uploading and querying data.
We have noticed recently that the wwv_flow_data has more records related to the applicaiton.. and the following statement is executing and it's taking long time to execute.. and it's building up lots database session.
DELETE FROM wwv_flow_data
WHERE flow_instance = :b1
AND item_id IN (
SELECT ID
FROM wwv_flow_page_plugs
WHERE flow_id = :b3
AND page_id = :b2
AND plug_source_type IN
('SIMPLE_CHART', 'UPDATABLE_SQL_QUERY',
'DBMSSQL_CURSOR',
'FUNCTION_RETURNING_DBMSSQL_CURSOR',
'FUNCTION_RETURNING_SQL_QUERY_CACHED',
'FUNCTION_RETURNING_SQL_QUERY', 'STRUCTURED_QUERY',
'SQL_QUERY', 'DYNAMIC_QUERY'))
and i have noticed in other applicaiton it on UPDATE wwv_flow_data taking long time..
Question is what is stored in the wwv_flow_data?
can we purge the wwv_fllow_data?
Thanks
James.