Recent posts

Oracle Database Session Control: RESOURCE_LIMIT, CONNECT_TIME, and IDLE_TIME

Oracle Database Session Control: RESOURCE_LIMIT, CONNECT_TIME, and IDLE_TIME Overview Or…

Read more

Query to Show Parameter Change History with Time

Query to Show Parameter Change History with Time SELECT      p1.snap_id,     TO_CHAR(s.be…

Read more

How to Drop Corrupted Undo Tablespace Segments in Oracle

How to Drop Corrupted Undo Tablespace Segments in Oracle If undo segments in the undo tab…

Read more

Steps to Change UNDO Tablespace in Oracle Database

Steps to Change UNDO Tablespace in Oracle Database Step 1: Connect to the Database sqlpl…

Read more

Exporting Data from a Physical Standby Database Using Data Pump

Exporting Data from a Physical Standby Database Using Data Pump A physical standby databa…

Read more

Gathering Statistics in Oracle – Detailed Guide with Examples

Gathering Statistics in Oracle – Detailed Guide with Examples 1. What are Oracle Statisti…

Read more