This is going to be a more of screen shot driven document where I will be upgrading Oracle 11.2.0.3.0 database to 12.1.0.1.0 You can view the document for the upgrade prepared by me Oracle 11.2.0.3.0 to 12.1.0.1.0 Thanks….
Call for papers – AIOUG-NIC Tech Meet..
We are opening the slots for speakers for our September month’s technical meet-up and off – course for the coming months as well. If you have any topic/work experience/finding related to any Oracle technology If you are interested in presenting, please send us your presentation’s title, a short abstract(not more than 10 lines) and your… Continue reading Call for papers – AIOUG-NIC Tech Meet..
My Presentation:Data Guard : Your’s Database Life Insurance
I presented at 4th Tech event of AIOUG-NIC. My talks were about Oracle’s Data Guard and how it acts as a Life Insurance to your Database. My Presentation can be viewed/downloaded from Data Guard – Database’s Life Insurance Thanks
My Presentation: An Approach to SQL Tuning : Part -1
With AIOUG-NIC entering into 6th month and 6th meet being organized in Chandigarh at Hotel RIO, technical talks are also getting more matured in the form of content and details with Nikhil Kumar speaking on RAC’s heart CACHE FUSION, Aman Sharma doing a deep dive into the Oracle’s Beast Exadata and Karan talking about Oracle APPS…… Continue reading My Presentation: An Approach to SQL Tuning : Part -1
My Presentation: Flashback – The Oracle’s Time Machine
I presented on the various features of Flashback in Oracle database at 3rd Tech event of AIOUG-NIC. My presentation can be viewed at or downloaded from Flashback. Thanks
My Presentation: Oracle 12c New Features..
I got my first opportunity to present something in public at the 1st Tech meet of AIOUG-NIC tech event and it was a discussion on Oracle 12c New Features… You can check my presentation at Oracle 12c New Features
AIOUG – North India Chapter … Journey has already begin….
What actually started a very informal talk with my friend Oracle ACE Mr. Aman Sharma, turned up into reality so quickly in the month of March 2014, when we decide to hold technical session on Oracle and related technologies in Chandigarh, India. Soon, we saw our dream getting fulfilled of holding such talks in our… Continue reading AIOUG – North India Chapter … Journey has already begin….
Moving Database from one ASM group to Another
In this blog, I am going to demonstrate how to move database from one location to another within ASM. This situation arises for me because I have renamed one database and now wanted to move it to location in ASM matching database name. Database was renamed (Using NID utility) from “BR91DMO” to “BRDMO”. Now we… Continue reading Moving Database from one ASM group to Another
Snapshot Standby database
What is Snapshot Standby database (from Oracle Docs): A snapshot standby database is a fully updatable standby database that is created by converting a physical standby database into a snapshot standby database. A snapshot standby database receives and archives, but does not apply, redo data from a primary database. Redo data received from the primary… Continue reading Snapshot Standby database
SGA Current Resize Operations
[code]</pre> 21:41:18 SYSTEM/bitst/BITST>set lines 10000 21:41:29 SYSTEM/bitst/BITST>column current_size format 999999 21:41:29 SYSTEM/bitst/BITST>column min_size format 9999999 21:41:29 SYSTEM/bitst/BITST>column max_size format 9999999 21:41:29 SYSTEM/bitst/BITST> 21:41:29 SYSTEM/bitst/BITST>select component,current_size/(1024*1024*1024) current_size ,min_size/(1 024*1024*1024) min_size ,max_size/(1024*1024*1024) max_size from v$sga_dynamic_components 21:41:29 2 / COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE —————————————————————- ———— ——– ——– shared pool 3 3 3 large pool 0 0 0 java… Continue reading SGA Current Resize Operations