Oracle Clusterware Management – 2 ——————————— Step 0. First of all check the version of Oracle Clusterware $crsctl query crs…
listing columns of a table
This will list the columns of a given table along with some attributes. SELECT a.attname AS “Column Name”,t.typname AS “Data…
PostgreSQL – Finding size of each table
The following query can get the size of each table in MB and also the no. of rows. SELECT relname,relpages…
Finding Blocks/Locks
As we know Blocking happens in the database as a result of LOCKS, so before we see any blocks in…
Checking Database Corruption
Just a small hidden dynamic performance view which can tell if our database is corrupted: SELECT file#, block#, blocks, corruption,corruption_type FROM V$DATABASE_BLOCK_CORRUPTION;…
How to find Database Size
Follwing query will find the Database size in MB as well as in GB. SELECT Round(Sum(BYTES)/1024/1024) “Database_Size_In_MB”,Round(Sum(BYTES)/1024/1024/1024) “Database_Size_In_GB” FROM DBA_DATA_FILES;…
Releasing space back from Database to OS
DML Operations leave fragmentation in INDEX & TABLE Segments/Extents especially when Dictionary Managed Tablespaces (DMT) are being used or Tablespaces…
Oracle Applications RDBMS Database
-Get Tablespace Information SELECT T.TABLESPACE_NAME, Round(T.TOTAL_MBYTES) AS TOTAL_MB,Round(F.FREE_MBYTES) AS FREE_MB, Round(100 – (F.FREE_MBYTES/T.TOTAL_MBYTES) * 100) AS PCT_USED FROM (SELECT TABLESPACE_NAME,…
Managing Oracle Applications through scripts
Controlling Forms/Reports/Concurrent Managers =============================== All the controlling scripts are located under COMMON_TOP\admin\scripts\DB_Host directory i.e E:\Oracle\11i\viscomn\admin\scripts\VIS_Nimra Controlling Forms Server ———————— adfrmctl.cmd…
Controlling RDBMS Database using control Scripts
Controling the RDBMS Database ————————- There are two scripts to control Database addbctl – Controling the Database server addlnctl –…