ITPub博客

jdbc thin/oci模式 ,jdbc-odbc桥 连接oracle// jdbc-odbc桥(需要配置odbc数据源)    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");    conn = DriverManager.getConnection("jdbc:odbc:dsmyorcl", "scott", "tiger");// jdbc thin模式(:实例名ORACLE_SID 仅需classpath中...

首先,recover是sqlplus命令RECOVERSyntaxRECOVER {general | managed | BEGIN BACKUP | END BACKUP}where the general clause has the following syntax:[AUTOMATIC] [FROM location]{ {full_database_recovery | partial_database_recovery | LOGFILE filename}[ {TEST | ALLOW integer CORRUPTIO...

/* session 1 */session_1> select * from emp where empno = 7788;     EMPNO ENAME      JOB              MGR HIREDATE           &nb...

from:http://blog.csdn.net/tianlesoftware/article/details/5630942  ADDM(Automatic Database Diagnostic Monitor) 是植入Oracle数据库的一个自诊断引擎. ADDM 通过检查和分析AWR获取的数据来判断Oracle数据库中可能的问题. Oracle10g中推出了新的优化诊断工具：数据库自动诊断监视工具（...

from:http://blog.csdn.net/tianlesoftware/article/details/4682300Oracle 10g之前对数据库做性能检测使用statspack工具。Oracle Database 10g 提供了一个新的工具：(AWR:Automatic Workload Repository)。与 Statspack 不同，快照由一个称为 MMON 的新的后台进程及其从进程自动地每小时采集一次。为了节省...

/* drop table ,not purge */SQL> show parameter recyclebinNAME                                 TYPE     &n...

CREATE CONTROLFILE { RESETLOGS | NORESETLOGS }/* Syntax: */CREATE CONTROLFILE  [ REUSE ]  [ SET ]  DATABASE database  [ logfile_clause ]  { RESETLOGS | NORESETLOGS }  [ DATAFILE file_specification         &nb...

Spfile Pfilealter_system_set_clauselets you set or reset the value of any initialization parameter.The ability to change initialization parameter values depends on whether you have started up the database with a traditional client-side initialization parameter file (pfile) or with a ser...

/* syntax */$ wrap iname=p1.sql oname=p1.plb/* For example: */[oracle@localhost sql]$ vi p1.sqlCREATE OR REPLACE PROCEDURE "SYS"."P1" isbegin       dbms_output.put_line('okay');end;/SQL> @./sql/p1.sqlProcedure created./* method_1 */SQL> set se...

1.     ORACLE_SID=test        export ORACLE_SID        env | grep ORA2.     orapwd FILE=$ORACLE_HOME/dbs/orapwtest password=asdjkl ENTRIES=10 force=y3.     ...

参考了很多文章,做个简单总结自用,第一篇Oracle Memory Structure:(System/Shared Global Area)SGA ; (Program/Process Global Area)PGASGA: Allocated at instance startup, and is a fundamental component of an Oracle InstancePGA: Allocated when the server process or background process is created...

/* 1. 检查参数文件类型 ,如果不是spfile ,scope=memory ,要记得尽快去修改pfile */SQL> show parameter spfileNAME                              &nbsp...

SQL> create role plustrace;Role created.SQL> grant select on v_$sesstat to plustrace;Grant succeeded.SQL> grant select on v_$statname to plustrace;Grant succeeded.SQL> grant select on v_$session to plustrace;Grant succeeded.SQL> grant select on v_$sql_plan ...

# --dict 数据字典视图 dba_,gv$,v$# --v$fixed_table 基表 x$,gv$,v$select * from dict;select * from v$fixed_table;select * from v$fixed_view_definition;select NAME,LOG_MODE,OPEN_MODE from v$database; --这里OPEN_MODE才能体现read onlyselect instance_name,version,status,archiver,database_sta...

--current_scn(2 ways)select dbms_flashback.get_system_change_number ,timestamp_to_scn(sysdate) from dual;select a as scn_dec ,'0x'||lpad(ltrim(to_char(a,'xxxxxxxx')),8,'0') as scn_hex from (select dbms_flashback.get_system_change_number a from dual);--timestamp(current_timestamp,scn_to_t...

针对NLS_LANG简单写写常用环境配置:1. 简体中文windows cmdset NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK --sqlplus中文set NLS_LANG=American_America.ZHS16GBK --英文2. securecrt,Appearance-character encoding GB2312export LANG=en_US.GB2312export NLS_LANG='SIMPLIFIED CHINESE_CHINA.Z...

/*查询当前sqlplus的server process的ospid*/SQL> select pid,spid,p.pname,p.program from v$process p,v$session s where p.addr=s.paddr and s.sid=userenv('sid');       PID SPID    PNAME      PROGRAM---------- ------- -------...

  1. $ lscpu 2. $ echo -n I | od -to2 | awk 'FNR==1{ print substr($2,6,1)}'0 -- On a Big Endian system (Solaris, SPARC)1 -- On a Little Endian system (Linux, Intel)3. $ python test_endian $ cat test_endian#!/usr/bin/env pyth...

  文件系统是操作系统用于明确磁盘或分区上的文件的方法和数据结构；即在磁盘上组织文件的方法对磁盘格式化,就是创建文件系统  linux文件系统使用inode来记录文件信息,linux在创建文件系统时,确定...

查命令: which ; type 查文件: whereis 与 locate 利用数据库 ,find 扫描磁盘which 根据$PATH变量定义的目录,来查找可执行命令,并输出完整路径选项或参数：-a ：将所有由 PATH 目录中可以找到...