My Oracle Support Banner

SQL Query From TSPACE_ENTRY_TY Executes 8000 Times Per Second (Doc ID 800640.1)

Last updated on JULY 15, 2010

Applies to:

Oracle Utilities Framework - Version: 2.2.0 and later   [Release: 2.2 and later ]
Information in this document applies to any platform.


Our DBA identified a query that was executing 8000 time per second and wants to know if there is a
way to reduce the frequency of this DB call.

SELECT tspace_entry_ty, created_dttms, exp_dttms, upd_sw, upd_dttms,
lessee_node, lease_exp_dttms, dest_node
FROM f1_tspace_entry
WHERE tspace_entry_id = :1 AND tspace_name = :2


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.