Abstract: Described herein is a system and method for determining the status of instances and update applications to reflect the updated statuses of instances, in real-time. In an embodiment, each instance may enable a service to determine the status of an instance. A core application server may load server pool configurations including a status of an instance. The status indicates the instance is live. Core application server may read a gate definition of the instance using the service enabled on the instance. Core application server may determine that a current status of the instance is virtual, based on the gate definition of the instance. The core application may a local cache of core application server to reflect that the current status of the instance is virtual and propagate to applications executed on other instances and core application server.

Abstract: Techniques are disclosed relating to performing database defragmentation operations by autonomously rebuilding index objects stored in one or more tablespaces of a database. In various embodiments, the disclosed techniques include autonomously performing defragmentation operations for one or more tablespaces in a database in an online manner such that a server system may continue to service data access requests while performing the defragmentation operations. In one non-limiting embodiment, for example, the disclosed techniques include selecting a first tablespace to defragment based on its level of fragmentation (e.g., relative to the other tablespaces). The server system may then rebuild index objects, from the first tablespace, to a new tablespace such that the index objects are stored in the new tablespace without fragmentation.

Abstract: Techniques are disclosed relating to performing database defragmentation operations by autonomously rebuilding index objects stored in one or more tablespaces of a database. In various embodiments, the disclosed techniques include autonomously performing defragmentation operations for one or more tablespaces in a database in an online manner such that a server system may continue to service data access requests while performing the defragmentation operations. In one non-limiting embodiment, for example, the disclosed techniques include selecting a first tablespace to defragment based on its level of fragmentation (e.g., relative to the other tablespaces). The server system may then rebuild index objects, from the first tablespace, to a new tablespace such that the index objects are stored in the new tablespace without fragmentation.

Abstract: Described herein is a system and method for determining the status of instances and update applications to reflect the updated statuses of instances, in real-time. In an embodiment, each instance may enable a service to determine the status of an instance. A core application server may load server pool configurations including a status of an instance. The status indicates the instance is live. Core application server may read a gate definition of the instance using the service enabled on the instance. Core application server may determine that a current status of the instance is virtual, based on the gate definition of the instance. The core application may a local cache of core application server to reflect that the current status of the instance is virtual and propagate to applications executed on other instances and core application server.