-
编辑 删除
Tracing the LSNRCTL Control Utility
Tracing the LSNRCTL Control Utility [ID 737530.1] Modified 16-DEC-2011 Type HOWTO Status PUBLISHED In this Document ...
-
编辑 删除
SQLNET.ORA
关于oracle实现ip 访问控制的资料见我的另一篇文章《sqlnet.ora 访问控制策略》相对与单节点的oracle ，11gr2 rac中，listener是配置在GRID_HOME，而不是ORACLE_HOME,所以我们要修改的sqlnet.ora文件是...
-
编辑 删除
Oracle *names
GLOBAL_DBNAME 、DB_UNIQUE_NAME、DB_NAME、SERVICE_NAME、SERVICE_NAMES之間相互關系當前環境：ORACLE_SID=ygzhou[oracle@ygzhou518]$ env |grep ORAORACLE_SID=ygzhouORACLE_BASE=/u01/app/oracleORACLE_HO...
-
编辑 删除
scan方式
可以過程v$sql_plan和v$sqltext聯合，獲得這些查詢的SQL語句，查找全表掃描的SQL語句可以參考如下語句： SQL> select sql_text from v$sqltext t,v$sql_plan p where t.hash_value = p.hash_value and p.oper...
-
编辑 删除
11g New Feature: Health monitor
11g New Feature: Health monitor [ID 466920.1] Modified 18-JUL-2010 Type BULLETIN Status PUBLISHED In this Documen...
-
编辑 删除
How to Perform a Health Check on the Database
How to Perform. a Health Check on the Database [ID 122669.1] Modified 15-NOV-2011 Type BULLETIN Status PUBLISHED Appl...
-
编辑 删除
Hard and soft parse
Instance Efficiency Percentages (Target 100%) Buffer Nowait %:100.00Redo NoWait %:100.00Buffer Hit %:99.85In-memory Sort %:100.00Library Hit %:99.92Soft Parse %:99.84Execute to Par...
-
编辑 删除
Delete Dataguard Archivelog
真實環境下的archivelog delete腳本：PrimaryDB:crontab -l00 12 * * * sh /data1/fullbackup/rman_del/rman_del.sh ------------------此時DB負載相對較...
-
编辑 删除
SQL Server ErrorLog 错误日志
默认情况下，SQL Server 保存 7 个 ErrorLog 文件，名为： http://www.cnblogs.com/blosaa/archive/2011/10/11/2206904.htmlErrorLog ErrorLog.1 ErrorLog.2 ErrorLog.3 ErrorLog.4 ErrorLog.5 E...
-
编辑 删除
Disable Automatic Statistics
How to Disable Automatic Statistics Collection in 11g [ID 1056968.1] Modified 31-MAR-2011 Type HOWTO Status PUBLISHED A...
-
编辑 删除
Oracle Group
The OSDBA group (typically, dba)You must create this group the first time you install Oracle Database software on the system. This group identifies operating system user accounts that have database a...
-
编辑 删除
Oracle Clusterware and Oracle Grid Infrastructure
Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructure [ID 1096952.1] Modified 27-OCT-2011 Type ANNOUNCEMENT ...
-
编辑 删除
SERVICE_NAME Parameter - Resolving The ORA-12514 Error [ID 77640.1]
Applies to:Oracle Net Services - Version: 8.1.7.4.0 to 11.1.0.6.0 - Release: 8.1.7 to 11.1Information in this document applies to any platform.Checked for relevance on 12-DEC-2007PurposeThe purpose o...
-
编辑 删除
Enhanced Tablespace Point-In-Time Recovery (TSPITR)
Enhanced Tablespace Point-In-Time Recovery (TSPITR) Tablespace point-in-time recovery (TSPITR) is enhanced as follows:You now have the ability to recover a dropped tablespace.TSPITR can be repea...
-
编辑 删除
局域網上傳工具
介紹一個小工具：psftp.exe http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html
-
编辑 删除
ORA-38029: object statistics are locked
SQL>ANALYZE TABLE TODAY.YGZHOU COMPUTE STATISTICS;ORA-38029:object statistics are locked要运行一个dbms包才能解开SQL>begin 2 dbms_sta...
-
编辑 删除
RAC vip問題
折騰了兩天的三節點RAC更換網卡，終于OK了！實驗環境及過程：1、模擬節點RAC02網卡eth0(PBULIC VIP)壞掉。2、添加網卡、重新配置vip；（注：所有的IP+GATEWAY均無變化）3、異常...
-
编辑 删除
11gR2 exp錯誤
http://space.itpub.net/trackback.php?code=N1mL0gUog0K4xHWUm7dUhjgOJ8A%2BUFQJ8EMKlWY
-
编辑 删除
ORA-00845 memory_target needs larger /dev/shm
ORA-00845: MEMORY_TARGET not supported on this systemWARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 314572800 byte...
-
编辑 删除
SQL Performance Analyzer
1、Testing a system change on a production system will impact the system's throughput because SQL Performance Analyzer must execute the SQL statements that you are testing. 2、
