Saturday, June 28, 2014

Tablespace Reorganization

Tablespace Reorganization

Tablespace reorganization is a process of reorganizing the contents of a tablespace to reclaim free space from the datafiles of a tablespace. When a datafiles is resized (shrink), the size of a datafiles can only be reduced till the high water mark (last allocated extent to

Tuesday, June 24, 2014

ORA-01031 insufficient privileges - While logging in AS SYSDBA

OS Authentication is a setup whereby we can log into the oracle database as SYSDBA or SYSOPER without supplying any password because OS user (currently logged in) is already authenticated to log into the database as a privileged user. This is handy specially if you have forgotten the SYS password (another way to recover SYS password is

Sunday, June 22, 2014

Oracle IO Consumption - Throughput (IOPS) and Transfer Rate (MBPS)

Oracle Database IO Requirements (Throughput/IOPS and Transfer Rate/MBPS)

If we plan to migration an Oracle database to a new/different hardware, planning for storage is also a very important thing. It is good to find out the IO requirements of the database so that a better decision could be made while purchasing the storage. Storage speed is

Friday, June 20, 2014

Online Partition Move

As you know that Oracle partition is a database object used to partition the table’s data into multiple segments which might be stored in different tablespace for the manageability purposes. There are several partition operations that can be performed on the partitions which are called partition maintenance operations and one of them is the “partition move” which means: to move partition from one

Wednesday, June 18, 2014

Online Datafile Move or Rename

Here I am going to discuss one of my favourite new feature of Oracle 12c which has taken the down time away from the DBAs while moving or renaming a datafile online. There is no requirement of any downtime during this operation

Sunday, June 15, 2014

Oracle Segment Adviser Recommendations and Redo/Undo Generation During Segment Shrink

Since Oracle 10g, Oracle provided facility to reclaim the unused space from Tables and Indexes by using"ALTER TABLE <TABLE_NAME> SHRINK SPACE | COMPACT"  command.
Before we go through details of Oracle Segment Adviser Recommendations, it should be noted that during shrink space operation, a lot of undo and redo data is

Popular Posts - All Times