1. On Server 1 (192.168.1.67) ssh-keygen -t rsa cd .ssh/ scp -r id_rsa.pub root@192.168.1.68:/root/.ssh/authorized_keys 2. On Server 2 (192.168.1.68) ssh-keygen…
Tag oracle
After a memory upgrade in our RAC servers, the Cluster wasn’t coming up after a reboot. We first tried to…
prompt ************************************ prompt **** ASH OVERALL WAIT PROFILE prompt ************************************ set lines 999 SELECT MIN(sample_time) min_ash_available,sysdate-MIN(sample_time) available duration FROM v$active_session_history;…
SQL> ALTER TABLE MOVE PARTITION COMPRESS FOR QUERY LOW PARALLEL 8; SQL> ALTER TABLE MOVE PARTITION COMPRESS FOR QUERY HIGH…
http://gavinsoorma.com/2012/11/ash-and-awr-performance-tuning-scripts/
http://www.oracle-developer.net/display.php?id=206
Check for Duplicate Row using Group By function This script deletes each row in the group after the first row.…
Install and Configure Oracle Application Express Apex 5.0, 4.2.6, 4.2.x with Embedded PL/SQL Gateway
1. Download Software as Zip file from OTN http://www.oracle.com/technetwork/developer- tools/apex/downloads/index.html 2.Unzip apex_5.0_en.zip Software to ORACLE_HOME directory, it will create a…
Since it was announced in Early 2010 that Oracle GoldenGate will be the RoadMap for Replication for Oracle Database, The…
Starting Testing for In-Memory Column Store on 12.1.0.2. Will post the results for the test very soon on the blog.
There are scenarios where you cannot login to SQL*PLUS even with SYSDBA credentials to restart a hanged database. There is…
Oracle Transparent Data Encryption using Oracle Wallet If you wish to use a wallet specifically for TDE, then you must…
— Get DDL from impdp — The below command will not import the dump, but will just create a .sql…
Remove Comma Character from Column — Use the below sql query, which will remove , from the string UPDATE data_dict…
Today on one of our 10g (10.2.0.1, don’t ask !) production databases running on AIX 5.3 we saw the following…
The Exadata Smart Flash Cache is a great Performance optimizer. The contents of the flash cache can be read fro…
If you see the below alert from the Cell Nodes, then the MS process is leaking memory RS-7445 [Serv MS…
So you are an Oracle DBA and have got used to the luxury of BASH shell in nix systems. Where…
Create SSH User Equivalence Between 2 Servers Linux Lets say you have 2 servers : server1, server 2 and you…
What to do when a production database goes hanging and there is no time left and your boss is standing…
Oracle has just announced a suite of new Engineered systems. Of particular significance is the announcement of the Generation 6…
For running a single SQL Command via sqlplus on multiple servers, we have to first do a few pre-requisites 1.…
We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went…