Oracle DBA

Sunday 14 February 2016

Subscribe to: Posts (Atom)

▼ 2016 (1)
- ▼ February (1)
  -  (adsbygoogle = window.adsby...

Script to moving objects from one tablespace to another tablespace

Script to moving objects from one tablespace to another tablespace There are many occasions where we will move segments from one table...
DIFFERENTIAL & CUMULATIVE INCREMENTAL BACKUP

DIFFERENTIAL & CUMULATIVE INCREMENTAL BACKUP The only difference between a level 0 incremental backup and a full backup is that a fu...
(no title)
Cloning oracle database from one server to another existing database in linux

This is the fast and easiest method to clone the oracle database from one server to another existing database server in Linux environment. ...
The below query used to check the current database size

set lines 300 select round(sum(used.bytes)/1024/1024/1024) || ' GB' "Database Size", round(sum(used.bytes)/1024/1024/102...
SCAN IN ORACLE RAC 11G

Single Client Access Name (SCAN) Oracle RAC 11g release 2 introduces the Single Client Access Name (SCAN), which provides a single name f...
Identifying Your Oracle Database Software Release

Oracle Database continues to evolve and can require maintenance, Oracle periodically produces new releases. Not all customers...

Simple theme. Powered by Blogger.