- 博客(79)
- 收藏
- 关注
转载 DB_WRITER_PROCESSES
DB_WRITER_PROCESSES = 2 * number of CPU cores IO快到有空置的時間, 那麼加dbwr便有作用了Multiple DBWR processes is preferred over ...
2010-07-30 14:01:27 277
转载 RMAN Image Copy Incremental Updates
Oracle ICIU - Image Copy Incremental UpdatesWith this strategy ,you will never have to apple more than 24 hours ...
2010-07-28 16:20:13 152
转载 iSCSI?
More devices, lower performance request , higher bandwidth (10Gb) ,then more advantage ! ...
2010-07-27 08:58:31 106
转载 installation steps on centos5
groupadd -g 115 dbagroupadd -g 116 oinstalluseradd -u 175 -g 115 -s /bin/bash -c "Oracle Software Owner" -p pass o...
2010-07-01 16:53:33 96
转载 one test
一:SQL Tuning 类1:列举几种表连接方式内部连接(inner join),简称内连,结果即为TA,TB两集合的交集。左部连接(left join),简称左连,A,B左部连接的结果即为TA。右部连接...
2010-07-01 16:47:13 149
转载 comment
USER_COL_COMMENTSALL_COL_COMMENTSDBA_COL_COMMENTSUSER_TAB_COMMENTSALL_TAB_COMMENTSDBA_TAB_COMMENTS ...
2010-05-10 15:39:26 95
转载 oracle job
SQL> show parameter jobNAME TYPE VALUE--------------------------------...
2010-01-29 13:55:34 67
转载 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 Ins...
2010-01-20 11:12:50 60
转载 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"...
2010-01-19 12:45:25 119
转载 flashback database
SQL> select trans_id,store_id from trans where trans_id=1085; TRANS_ID STORE_ID---------- ---------...
2010-01-18 20:53:02 78
转载 flashback table
SQL> alter table trans enable row movement; SQL> select trans_id,store_id from trans where trans_id=1...
2010-01-18 20:39:48 67
转载 testdata
CREATE TABLE trans( trans_id number, cust_name varchar2 (20), trans_dt date, trans_amt number (1...
2010-01-18 19:35:56 130
转载 PGA optimal onepass multipass
/* Formatted on 2010/1/8 18:34:37 (QP5 v5.114.809.3010) */SELECT NAME, VALUE, 100 * (VAL...
2010-01-08 18:36:49 137
转载 EM Grid Control Agent Target Discovery
[oracle@hzsdb2 bin]$ ./agentca -helpUsage: agentca -d/-f [-nctis] -d option for rediscovery....
2009-12-07 10:44:56 85
转载 Clone ORACLE_HOME
1, Clean up OraHome1 for OraHome1.tar.gz $ORACLE_HOME/_$ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole__$ORACLE_...
2009-12-07 09:19:15 86
转载 ncompress-4.2.4-44.rhel4.x86_64
Cloning of an Oracle Home via Grid Control fails with "/usr/bin/compress: Command not found." [ID 566370.1]ncompre...
2009-12-04 22:09:02 112
转载 EMGC Bug 5899294
Problem: OMS Cannot Communicate with Agent if IP Address of the Grid Agent Machine is Changed [ID 605009.1]ht...
2009-12-03 18:26:40 72
转载 COMMIT OPTION
COMMIT WAIT: The commit does not return as successful until the redo corresponding to the commit is persisted in...
2009-12-01 20:58:00 123
转载 reinstate database
DGMGRL> show configuration Configuration Name: DRMulti Enabled: YES ...
2009-11-30 19:44:03 169
转载 PSU 10.2.0.4.2
[oracle@hzshcnc OPatch]$ ./opatch -helpInvoking OPatch 10.2.0.4.2[oracle@hzshcnc OPatch]$ unzip p6880880_...
2009-11-27 17:54:54 98
转载 oracle patch category
Oracle Interim patches: A patch that is applied in between patchset releases with the Opatch utility. Interim ...
2009-11-24 18:15:46 64
转载 convert database
SQL> set serveroutput onSQL> declare 2 retcode boolean; 3 begin 4 retcode := dbms...
2009-11-23 20:21:31 82
转载 DG- log type and database role
Pri WEB> SELECT DEST_ID,VALID_TYPE,VALID_ROLE,VALID_NOW FROM V$ARCHIVE_DEST; DEST_ID VALID_TYPE V...
2009-11-13 19:16:32 86
转载 RAC Parallel Compute Parameter
INSTANCE_GROUPS is a Real Application Clusters parameter that you can specify only in parallel mode. Used in con...
2009-10-26 15:50:24 71
转载 Orion
# ./orion_linux_x86 -run simpleORION: ORacle IO Numbers -- Version 11.1.0.7.0Test will take approximately 9 ...
2009-10-22 11:57:33 78
转载 Standby is performing log apply
Performing Redo ApplySQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY; PROCESS STATUS--------...
2009-10-22 10:58:10 84
转载 10g sga_target ? < sga_max
在11g 中,这个SGA_TARGET 只能设置是等于SGA_MAX_SIZE 的大小了,设置比它小,oracle 会自动帮你调整,设置比它大,那还是出错。现在可以自己想想,oracle 对SGA_TARGET 的大小处理在往正...
2009-10-21 16:53:19 53
转载 HA parameters
DB_BLOCK_CHECKINGOracle checks a block by going through the data in the block, making sure it is logically se...
2009-10-13 21:22:52 57
转载 Is there a server running on localhost:3306?
set password for @ = old_password(''); ...
2009-10-13 17:53:39 102
转载 RAC Tips
# oifcfg getifeth0 10.224.188.0 global publiceth2 192.168.0.0 global cluster_interconnect # ocrdump -h...
2009-10-06 19:25:43 56
转载 srvctl -h
srvctl [-V]srvctl add database -d -o [-m ] [-p ] [-A /netmask] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY...
2009-10-06 14:45:14 73
转载 srvctl service
# srvctl status service -d webdbService hzwebtaf is running on instance(s) webdb2, webdb1 # srvctl config s...
2009-10-06 14:36:51 114
转载 Customizing How Oracle Clusterware Manages Oracle RAC Databases
To prevent Oracle Clusterware from restarting your Oracle RAC database when you restart your system, or to avoid r...
2009-10-04 18:36:33 61
转载 CRS diagwait
This setting increases the time for failed nodes to flush final trace files, which helps to debug the cause of a n...
2009-09-27 13:01:40 69
转载 Extend nodes Tips
The following sections provide a summary of the command line procedures for deployments of RAC in grid environme...
2009-09-21 13:46:26 58
转载 TAF
HZWEBTAF = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.224.183.142)(PORT = 1522)) (ADDRESS =...
2009-09-16 21:48:10 71
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人