How to add space to a Tablespace in oracle?

Tweet STEP 1: Identify the current Tablespace usage. SQL> set lines 250 SELECT a.tablespace_name, ROUND(a.totsize/1024/1024,0) “Tot Size (MB)”, ROUND(NVL(b.used,0)/1024/1024,0) “Used … more →


What is a Checkpoint ?

Tweet A checkpoint is the act of flushing modified, cached database blocks from SGA Buffer Cache to disk (DB Datafiles) … more →


What is Oracle SCN?

Tweet System Change Number (SCN)? The SCN is a stamp that defines a committed version of a database at a … more →


Oracle invalid objects in the schema

Tweet Operations such as upgrades, patches or DDL changes can invalidate schema objects. These invalid objects can be manually recompiled … more →


What is Spfile and pfile ? How to create spfile from pfile and vice-versa?

Tweet   Spfile refers to Server Parameter file(spfile$ORACLE_SID.ora). Server parameter files are binary files that exist only on the server … more →


monitoring

Oracle Enterprise Manager 13c !! Whats new ?

Tweet Oracle just announced the release of Oracle Enterprise Manager 13c with * Superior Enterprise-Grade Management * Integrated Cloud Stack … more →


RMAN

What is RMAN ?

Tweet RMAN (Recovery Manager) is a Oracle Utility used as a backup and recovery manager for Oracle databases (from Oracle┬árelease … more →


REDO_resize

What is Redo?

Tweet What is Redo Log? Redo log consists of two or more preallocated files that store all changes made to … more →


BKUP

What is Backup and its types ?

Tweet What is Backup ? A backup is a copy of data from your database that can be used to … more →


ora_history_cover