Data_partitioning for scale

http://java-persistence-performance.blogspot.in/2011/05/data-partitioning-scaling-database.html

http://databasewisdom.com/partit_ora1.shtml


Awesome:
http://www.shutdownabort.com/dbaqueries/Structure_Partitions.php

Oracle sql tuning

http://www.credmond.net/oracle/tuning/
http://www.myoracleguide.com/s/OracleTips.htm

How to get the list of sqls that are CPU intensive and Waiting
http://uhesse.wordpress.com/2010/07/08/performance-monitoring-active-session-history-at-work/

remove lines in a file in Linux

sed '1,10d' server.log
command to remove lines between the line numbers 1 and 10..

http://en.kioskea.net/faq/1451-sed-delete-one-or-more-lines-from-a-file

Extract rows from a file unique w.r.t column

awk '!_[$1]++' filename

Here rows are extracted w.r.t unique values from column 1.

load average description of top command in linux

http://en.wikipedia.org/wiki/Load_(computing)

Quartz cron job scheduling in properties

http://sanjaal.com/java/tag/cron-expression-quartz-schedulers/

Jmeter JDBC Configuration for oracle,sqlserver,mysql,postgresql,apachederby,ingres

http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Connection_Configuration

GEt Dbname in oracle

SQL> SELECT VALUE FROM V$PARAMETER WHERE NAME='db_name';

VALUE
--------------------------------------------------------------------------------
XXXXXXX

Oracle Connect as sysdba error..

SQL> conn / as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SQL> exit

[qysprffinwkdb01:/home/oracle](Perf)% export ORACLE_SID=xxxxxx

[qysprffinwkdb01:/home/oracle](Perf)% echo $ORACLE_SID

xxxxxx

[qysprffinwkdb01:/home/oracle](Perf)% sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.5.0 - Production on .........

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

SQL>

Jmeter starting from Command line

http://jmeter.apache.org/usermanual/get-started.html

AWk command for .csv files

http://stackoverflow.com/questions/7857090/awk-extract-specific-columns-from-delimited-file