Uncategorized – Page 2

February 5, 2017April 1, 2018Uncategorized

Oracle DBA day to day activity

Tablespace size and uses set linesize 230 SELECT Total.name “TABLESPACE_NAME”, nvl(Free_space, 0) FREE_SPACE, nvl(total_space-Free_space, 0) USED_SPACE, total_space,round((nvl(free_space,0)/nvl(total_space,0)*100),2) “PCTFREE” ,round((nvl(total_space-free_space,0)/nvl(total_space,0)*100),2) “PCTUSED” FROM (select […]

February 5, 2017March 26, 2017Uncategorized

RAC BASIC

RAC 11g useful commands Check the status of the cluster [oracle@rac1 ~]$ crsctl check crs CRS-4638: Oracle High Availability Services is online […]

January 19, 2017January 19, 2017Uncategorized

Partitioned Table Purging Live Steps

create table archive.archive_tasks partition by range (TIME) (partition ARC_Pdefault values less than (to_date(’01-10-2008′, ‘DD-MM-YYYY’)) ) as select * from tasks where 1=2 […]

January 18, 2017Uncategorized

Table Partition Purging

sql> create table source_partitioned ( a number, b varchar2(1), c date) partition by range (c) ( partition p1 values less than (date […]

January 17, 2017February 14, 2017Uncategorized

Oracle Golden Gate

GoldenGate enables us to extract and replicate data across a variety of topologies as shown the diagram below as well as the […]

January 14, 2017Uncategorized

Oracle 12c New Features

Top 12 Features of Oracle 12C Summarized. Summary: The Oracle 12C means different things to different people. It all depends on which […]

January 14, 2017Uncategorized

Golden Gate

Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high […]