Sunday, May 15, 2016

In-Database Row Archiving

In-Database Row Archiving

In-database archiving is a feature provided by Oracle in 12c which allow to archive rows withing a table. It is done by making those rows invisible. Application will not be able to get those data from the table, they will compressed and kept secure. It will be accessed only when we set session parameter.

So, with this feature you don't have to purge the data, but same time it will not impact the application performance. We can compressed these archived data to reduce backup time. We can make the update deferred so that the application upgrades time can be minimized.

To manage in-database archiving for a table, you must enable ROW ARCHIVAL for the table, manipulate the ORA_ARCHIVE_STATE hidden column of the table, and specify either ACTIVE or ALL for the ROW ARCHIVAL VISIBILITY session parameter.

1. Connect to the database
2. Create the table.
Create table order_arch as select order_id, amount from order where rownum <= 4;

3. Enable row archival on the table.
alter table order_arch row archival;

4. Set the archival visibility to ALL for the session. This will allow this session to view all rows, archived or not.
alter session set row archival visibility = all;

5. Issue the same query as before, but now you should see all 4 rows.
select order_id, amount, ora_archive_state from order_arch;

6. Set the archival visibility to ACTIVE for the session. This will allow this session to view only active (unarchived) rows.

alter session set row archival visibility = active;

What are the new features of Oracle 12C.

What are the new features of Oracle 12C.

As per my view, below are the main new features of the Oracle Database 12c.

1. Pluggable Database
2. Reduction Policy
3. Top N Query and Fetch and offset Replacement to Rownum
4. Adaptive Query Optimization and Online Stats Gathering
5. Restore a Table Easily through RMAN
6. Some Datatype Size has been increased (Varchar2, NBarchar2, Raw Data)
7. Multiple indexes on single column.
8. Temporary Undo Feature
9. In database Archiving

Thursday, May 5, 2016

Free stock trading.

I've been using Robinhood to trade stocks for free. Check it out on the App Store! http://share.robinhood.com/koushim

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...