oracle用户.profile
AUTHSTATE=compat
export PS1=['$PWD']#
export HOME=/enip/oracle
PATH=/enip/oracle/app/oracle/product/11.1.0/db_1/bin:/usr/java5_64/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/enip/oracle/bin:/usr/bin/X11:/sbin:.
export PATH
export TZ=BEIST-8
export LANG=en_US
LOCPATH=/usr/lib/nls/loc
LC__FASTMSG=true
ODMDIR=/etc/objrepos
LOGIN=oracle
export ORACLE_BASE=/enip/oracle/app/oracle
export ORACLE_HOME=/enip/oracle/app/oracle/product/11.1.0/db_1/
export ORACLE_SID=oracle
export ORA_NLS33=/enip/oracle/app/oracle/product/11.1.0/db_1//nls/data
export DISPLAY=10.132.42.115:0.0
export MAIL=/var/spool/mail/oracle
export NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
export LD_LIBRARY_PATH=/enip/oracle/app/oracle/product/11.1.0/db_1//lib32:/enip/oracle/app/oracle/product/11.1.0/db_1//lib:/usr/lib:/usr/local/lib
export LIBPATH=/enip/oracle/app/oracle/product/11.1.0/db_1/lib:/enip/oracle/app/oracle/product/11.1.0/db_1/lib32:/usr/lib:/usr/local/lib
相关文档：
windows上存在32bit的限制，如AIX、HP UNIX 等有明确的64BIT OS and ORACLE的版本，32bit oracle可以装在64bit os 上，64 bit oracle不能装在32 bit OS上
oracle是64bit or 32 bit,32bit 通常 SGA有 1.7G 的限制(某些OS的处理或者WINDOWS上有特定设定可以支持到2G以上甚至达到3.7G
如何查出前台正在发出的sql语句:
sele ......
1、在oracle的sys-sysdba下登陆
写一个java source程序链接sqlserver2005：
create or replace and compile java source named test as
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class excutesql1
{
public static String entry ......
MySQL Data Type
Oracle Data Type
BIGINT
NUMBER(19, 0)
BIT
RAW
BLOB
BLOB, RAW
CHAR
CHAR
DATE
DATE
DATETIME
DATE
DECIMAL
FLOAT (24)
DOUBLE
FLOAT (24)
DOUBLE PRECISION
FLOAT (24)
ENUM
VARCHAR2
FLOAT
FLOAT
INT
NUMBER(10, 0)
INTEGER
NUMBER(10, 0)
LONGBLOB
BLOB, RAW
LONGTEX ......
【51CTO.com独家特稿】面对惊慌的客户和广泛质疑的媒体，Oracle官方最近终于出榜安民，那便是一个以“SUN CUSTOMERS ,Oracle Plans To：”为大标题的广告。直译过来便过来可知道，Oracle将要加大SPARC和Solaris的投入了，而大老板埃里森也向IBM硬件下了战书，声称Oracle将最终赢得这场竞争……
&n ......
