-
编辑 删除
DB_WRITER_PROCESSES
DB_WRITER_PROCESSES = 2 * number of CPU cores IO快到有空置的時間, 那麼加dbwr便有作用了Multiple DBWR processes is preferred over the use of I/O slaves. I/O slaves should only be used if multiple DBWR ...
-
编辑 删除
RMAN Image Copy Incremental Updates
Oracle ICIU - Image Copy Incremental UpdatesWith this strategy ,you will never have to apple more than 24 hours of redo/archive logs ( suppose daily backup) to apply to perform. a complete recovery.T...
-
编辑 删除
installation steps on centos5
groupadd -g 115 dbagroupadd -g 116 oinstalluseradd -u 175 -g 115 -s /bin/bash -c "Oracle Software Owner" -p pass oraclepasswd oraclemkdir /u01/OraBasemkdir /u01/OraBase/OraHome1mkdir /u01/OraBase/orad...
-
编辑 删除
one test
一:SQL Tuning 类 1:列举几种表连接方式内部连接（inner join），简称内连，结果即为TA，TB两集合的交集。左部连接（left join），简称左连，A，B左部连接的结果即为TA。右部连接（right join），简称右连...
-
编辑 删除
comment
USER_COL_COMMENTSALL_COL_COMMENTSDBA_COL_COMMENTSUSER_TAB_COMMENTSALL_TAB_COMMENTSDBA_TAB_COMMENTS
-
编辑 删除
oracle job
SQL> show parameter jobNAME &nbs...
-
编辑 删除
Deprecated in Oracle Database 11g Release 2 (11.2) - raw devices
Installing data files directly on raw devices is no longer available during installation with Oracle Universal Installer or Database Configuration Assistant. You must use a file system, or use Automat...
-
编辑 删除
Normal EM user add job
The owner of the job is not registered ORA-06512: at "SYSMAN.MGMT_JOBS", line 168 ORA-06512: at "SYSMAN.MGMT_JOBS", line 86 ORA-06512: at line 1 login with sysman;execute MGMT_USER.MAKE_EM_USE...
-
编辑 删除
flashback database
SQL> select trans_id,store_id from trans where trans_id=1085; TRANS_ID STORE_ID---------- ---------- 1085 ...
-
编辑 删除
flashback table
SQL> alter table trans enable row movement; SQL> select trans_id,store_id from trans where trans_id=1085; TRANS_ID STORE_ID---------- ---------- &...
-
编辑 删除
testdata
CREATE TABLE trans( trans_id number, cust_name varchar2 (20), trans_dt date, trans_amt numbe...
-
编辑 删除
where is the hot ?
SELECT * FROM ( SELECT addr, ts#...
-
编辑 删除
GetSQL
SELECT &...
-
编辑 删除
PGA optimal onepass multipass
/* Formatted on 2010/1/8 18:34:37 (QP5 v5.114.809.3010) */SELECT NAME, VALUE, 100  ...
-
编辑 删除
EM Grid Control Agent Target Discovery
[oracle@hzsdb2 bin]$ ./agentca -helpUsage: agentca -d/-f [-nctis] -d option for rediscovery. -f opti...
-
编辑 删除
Clone ORACLE_HOME
1, Clean up OraHome1 for OraHome1.tar.gz $ORACLE_HOME/<Hostname>_<SID>$ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<Hostname>_<SID>$ORACLE_HOME/network/log/$ORACLE_HOME/network/a...
-
编辑 删除
EMGC Bug 5899294
Problem: OMS Cannot Communicate with Agent if IP Address of the Grid Agent Machine is Changed [ID 605009.1] http://forums.oracle.com/forums/thread.jspa?threadID=924925&tstart=15
-
编辑 删除
COMMIT OPTION
COMMIT WAIT: The commit does not return as successful until the redo corresponding to the commit is persisted in the online redo logs (default).COMMIT NOWAIT: The commit should return to the applica...
-
编辑 删除
reinstate database
DGMGRL> show configuration Configuration Name: DRMulti Enabled: &nbs...
-
编辑 删除
PSU 10.2.0.4.2
[oracle@hzshcnc OPatch]$ ./opatch -helpInvoking OPatch 10.2.0.4.2 [oracle@hzshcnc OPatch]$ unzip p6880880_102000_Linux-x86-64.zip [oracle@hzshcnc OPatch]$ ./opatch -helpInvoking OPatc...
