Roles and Stored Object behaviour
Note : 1011899.6 – Roles and Creating Stored Objects / Views Note : 180028.1 – Set up a Secure Access to Application Data within a Database: DBAs, Schemas and Users.
Implementation of key based authentications
*******************************************************************************************Step by Step Implementation of key based authentications from Source A to Destination B. ******************************************************************************************* (1) At source A (1-A) Generate a Key ssh-keygen -t dsa Above command creates a public key file called : id_dsa.pub and private key called id_dsa (1-B) Cat id_dsa.pub to the destination B and save as a file called authorized_keys…
Find Command
Following command gives, all files that are modified in last 4 days. find /IOTTOARCH/*.arc -mtime -4 -exec ls -rlt {} ; Following command gives, all files that are modified before last 4 days. find /IOTTOARCH/*.arc -mtime +4 -exec ls -rlt {} ;
SAN
For Example, Db size : 461 GB. On SAN EMC FC4700
OPENING A STANDBY DATABASE IN READ-ONLY MODE
OPENING A STANDBY DATABASE IN READ-ONLY MODE ——————————————— In order to perform queries on a read-only standby database, the database needs to be able to perform on-disk sorting operations. Locally managed temporary tablespaces do not record transactions in the data dictionary. Steps to create a locally managed temporary tablespace 1. Create a temporary tablespace on…
Oracle Standby Database Library Index from Metalink
267931.1
Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds)
========================= Test case On 29-SEP-2005 ========================= Original Statement: INSERT INTO pvm SELECT * FROM pvm1; Source table : pvm1 has 2.3 million rows. If statement executes normally it will take long time to execute. So i modified following statement and 2.3 Million rows processed in Approx 30 seconds. 10:39:11 CIF@CIF:-> set feedback 1 10:39:11 CIF@CIF:->…
Read More “Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds)” »
Removing Blank lines from file using grep
grep -v “^$” filename > newfilename
Useful Solaris Commands on 28-SEP-2005
* To Print System Configuration /usr/sbin/prtconf Above command is useful to view Memory available to this system as following. /usr/sbin/prtconf | grep “Memory size” You can also use “top” command to see total RAM and swap info. * To see Available Processor Info. (Processor Info). psrinfo
nfs mount command
mount -F nfs 192.168.6.36:/cdrom/cdrom0 /mnt