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.

Goal

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


Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms