Nalanta

There are many ways to troubleshoot the performance Issues in oracle database. Here you can find some methods to troubleshoot performance Issues.
 Scenario 1:
  Users are complaining that Application is slow.

DBMS_CRYPTO package provides an interface to encrypt and decrypt stored data. For example, the table CUST_MASTER has three columns ACNO,NAME,BALANCE and you wish to encrypt the column NAME and BALANCE. Using the dbms_crypto.ENCRYPT functions,you can create your function to encrypt data.
Example:
Create a table CUST_MASTER .

Ever have someone perform a chmod 777 .*, chown -R *, etc… here is how to fix it without reinstalling or restoring from tape. You do need root access either locally or remotely.
Almost all packages installed on a Solaris machine have their settings kept in one file. It is /var/sadm/install/contents.
Root# cd /var/sadm/install
you will find […]

Disk mirroring in Solaris
Install the OS in one hard disk, and put the second one before turning on the Server.
Now go to the root and type format, it will list you the hard disk Number.
(i.e) c2t0d0 (Primary hard disk – with partition info) and c2t1d0 (secondary disk)
Normally the entire hard disk will be denoted as […]

SETTING UP YOUR CA
Step 1:
Go to http://www.slproweb.com/download/Win32OpenSSL-0_9_8e.exe and download openssl for windows.
Step 2:
Create directories to hold your CA keys, your server keys and, if you want to use SSL client authentication, your client keys. For the sake of argument let’s assume that these directories are called “C:/ssl/TomcatCA”, “C:/ssl/TomcatServer” and “C:/ssl/TomcatClient”.

egrep Multiple Pattern Search
=====================
Example:
========
Requirement : Find the root and oracle users informations from /etc/passwd
[root@tritya root]# egrep ‘root|oracle ‘ /etc/passwd
root:x:0:0:root:/root:/bin/bash
oracle:x:300:200:oracle:/home/oracle:/bin/bash
[root@tritya root]#

[oracle@tritya script]$ vi diskmon.sh
(copy and paste the below lines)
THERSHOLD=40 # ENTER YOUR OWN THERSHOLD LIMIT #
for MOUNT in `df -k | awk ‘{print $6}’ | grep -v Mount`
do
PERCENT=`df -h $MOUNT | grep -v Mount | awk ‘{print $5}’`
PERCVALUE=`echo $PERCENT |cut -d% -f1`
if [ $PERCVALUE -ge $THERSHOLD ]