Oracle database management scripts
Oracle database management scripts- Check how large size of the database col “Database Size” format a20 col “Free space” format a20 col “Used space” format a20 select round(sum(used.bytes) / 1024… Read more »
Category: Oracle
RAC srvctl and crsctl useful commands
RAC SRVCTL and CRSCTL useful commands- Below are some of the commands which we have used regularly in our RAC system. There are many more RAC commands for 11gR2/12c Clusterware… Read more »
Convert physical standby database to snapshot standby database
Convert Physical Standby Database to Snapshot standby Database The difference between a read-only standby and a snapshot standby is that the snapshot standby is fully update-able. It was possible in… Read more »
What is datapump in oracle
What is datapump in oracle Data Pump: Data pump is a utility provided by Oracle to export data and/or structure from a database into a binary file called as dump… Read more »
How to check tablespace size in oracle database
How to check tablespace size in oracle database set linesize 150 set pagesize 5000 col owner for a15 col segment_name for a30 col segment_type for a20 col TABLESPACE_NAME for a30… Read more »
Check user status in oracle database
Check user status in oracle database Here with the use of below scripts you can check the status of particular user whether is open/locked or expired , you can check… Read more »
check sql session detail in oracle database
Check sql session detail in oracle database SET LINESIZE 190 COLUMN spid FORMAT A10 COLUMN username FORMAT A15 COLUMN program FORMAT A65 SELECT s.inst_id, s.sid,s.serial#, p.spid, s.username, s.program FROM… Read more »
How to check datapump job status
How to check Export/Import data pump job status Monitor export/Import with the data pump views – The main view to monitor Export/Import jobs are dba_datapump_jobs and dba_datapump_sessions. set line 190… Read more »
How To Resolve Database Blocking In Oracle
How To Resolve Database Blocking In Oracle Database blocking is a situation where the statement run by one user locks a record or set of records and another statement run… Read more »
How to change RAC database NoarchiveLog Mod to Archivelog mode
How to change RAC database NoarchiveLog Mod to Archivelog mode Login to one of the nodes (i.e. linux Node1) and disable the cluster instance parameter by setting cluster_database to FALSE… Read more »