lob

Query to Display the Concurrent Program’s which has are modified at XML Data_Defination_level or LOB’level

Introduction:   This query is used to fetch the list of  concurrent program names which are having the changes at XML Publisher level (Data_Definition or Template Level) which also includes…

Read More

Tablespace Level Fragmentation — Defragmentation/Shrink A Big Tablespace In Oracle

The most efficient/effective way to defrag/shrink a big tablespace in oracle is to migrate the tables/indexes to new tablespaces. Here below are the steps: Step 1. find tablespace “BMW” whether…

Read More