Sunday, December 4, 2011

Check Memory Usage

prstat -s cpu -a -n 8

http://developers.sun.com/solaris/articles/prstat.html

Wednesday, November 2, 2011

Clean Up Oracle DB Space

Free up oracle db space by delete below log:-
/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
using this command :
cat /dev/null > /oracle/oracle/product/10.2.0/db_1/network/log/listener.log
This log was more than 4GB of size. Emptying this file is harmless as it only contains the connection log to the DB.

Monday, October 24, 2011

Check Disk Size

df -h

Saturday, June 18, 2011

Oracle DB Test Client

public class Test{
public static void main(String[] args) {
try {
Connection con=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:database_name",
"username",
"password");
Statement s=con.createStatement();
s.execute("
INSERT INTO EMP VALUES
('1', 'William')
");
s.close();
con.close();
} catch(Exception e){e.printStackTrace();}
}
}

Tuesday, April 12, 2011

View IP Domain Name

#cat /etc/hosts

Friday, March 25, 2011

Add Shortcut Key

1. Edit /export/home/user1/.profile
2. Add "alias m1='cd /export/home/user1/jboss-eap-4.3/jboss-as/server/product_prod'"
3. Close putty and logon again