Updates To F1_TSPACE_ENTRY (Doc ID 860575.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

 What is impacted by the throughput of these statements?

update F1_TSPACE_ENTRY set UPD_DTTMS = CAST(SYSTIMESTAMP AS TIMESTAMP) where TSPACE_ENTRY_ID = :1
and TSPACE_NAME = :2 and ( (not EXP_DTTMS is null and EXP_DTTMS < CAST(SYSTIMESTAMP AS
TIMESTAMP) ) or (not LEASE_EXP_DTTMS is null and LEASE_EXP_DTTMS < CAST(SYSTIMESTAMP AS
TIMESTAMP)) )


update F1_TSPACE_ENTRY set LEASE_EXP_DTTMS = :1 where TSPACE_ENTRY_ID = :2 and LESSEE_NODE = :3
and LEASE_EXP_DTTMS > CAST(SYSTIMESTAMP AS TIMESTAMP) and (EXP_DTTMS is null or EXP_DTTMS >
CAST(SYSTIMESTAMP AS TIMESTAMP)) and TSPACE_NAME = :4



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