bulain

#java debug remote
x.debug=-Xdebug
x.noagent=-Xnoagent
x.compiler=-Djava.compiler=NONE
x.debugport=-Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=8000

bulain

1. USER_*, ALL_*, DBA_*.
2. V_$, GV_$, V$, GV$.
3. X$.

bulain

#replace in vim
[addr]s/src/dist/[option]

addr: the range
nothing	Work on current line only.
number	Work on the line whose number you give.
%	The whole file.


option: the arguments 

bulain

create tablespace demos
  logging
  datafile '<path>/demo01.dbf' 
  size 256m 
  autoextend on 
  next 64m maxsize 2048m
  extent management local;

CREATE USER demo
  IDENTIFIED BY demo

bulain

oracle server configuration
#listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC = 
      (GLOBAL_DBNAME = orcl) 
      (ORACLE_HOME = C:\oracle\product\11.2.0\dbhome_1) 
      (SID_NAME = orcl) 
    ) 
    (SID_DESC =

bulain

#change java program language
-J-Duser.language=en -J-Duser.region=CN
or
-J-Duser.language=en -J-Duser.country=CN

bulain

#for java
-agentpath:/temp/yjpagent.dll

#for jboss
-agentpath:/temp/yjpagent.dll=delay=10000

bulain

run.sh -Djboss.service.binding.set=ports-01

bulain

#windows
-Dcom.sun.management.jmxremote.port=7101
-Dcom.sun.management.jmxremote.ssl=false 
-Dcom.sun.management.jmxremote.authenticate=false

#linux
-Djava.rmi.server.hostname=192.168.0.190
-Dcom.sun.management.jmxremote
-Dcom.sun.management.jmxremote.port=7101
-Dcom.sun.management.jmxremote.authenticate=false

bulain

# run_sql.bat
sqlplus system/system@xe @test.sql

# test.sql
set echo on;
spool test.log

...your sql

spool off;