-
编辑 删除
DBMS_STATS.PLAN
Thread 1 cannot allocate new log, sequence 4097Checkpoint not complete Current log# 1 seq# 4096 mem# 0: /data1/stream/ygzhou01/datafile/redofile/redo01.logThread 1 advanced to log sequence 4097 ...
-
编辑 删除
DBMS_STATS
–-收集資料庫資訊EXEC DBMS_STATS.GATHER_DATABASE_STATS;EXEC DBMS_STATS.GATHER_DATABASE_STATS(ESTIMATE_PERCENT => 15);–-收集SCHEMA資訊EXEC DBMS_STATS.GATHER_SCHEMA_STATS('SCOTT');EXEC DBMS_STATS.GATHE...
-
编辑 删除
archived_sp
/* FORMATTED ON 2012/04/27 15:09 (FORMATTER PLUS V4.8.8) */ --STEP1:CREATE TABLE HMD.R_WIP_TRACKING_T_TEMPCREATE TABLE hmd.r_wip_tracking_t_temp AS SELECT * FROM sfi...
-
编辑 删除
Heavy swapping
Thu Apr 19 00:00:00 2012Time drift detected. Please check VKTM trace file for more details.Time drift detected. Please check VKTM trace file for more details.Thu Apr 19 16:30:14 2012Closing scheduler ...
-
编辑 删除
Enabling Database Resident Connection Pooling
Oracle Database includes a default connection pool called SYS_DEFAULT_CONNECTION_POOL. By default, this pool is created, but not started. To enable database resident connection pooling, you must ex...
-
编辑 删除
Shutdown Timeout
Shutdown TimeoutShutdown modes that wait for users to disconnect or for transactions to complete have a limit on the amount of time that they wait. If all events blocking the shutdown do not occu...
-
编辑 删除
PasswordFile
For example, for a database instance with the SID orcldw, the password file must be named orapworcldw on Linux and PWDorcldw.ora on Windows.In an Oracle Real Application Clusters env...
-
编辑 删除
External Tables: Querying Data From Flat Files in Oracle
mkdir -p /data1/stream/ygzhou_dir 1.1、strings inputScripts.sql CREAT OR EREPLACE DIRECTORY dir_dump as '/data1/stream/ygzhou_dir';CREATE TABLE input( id INT, name V...
-
编辑 删除
Automatic Memory Management
AutomaticMemory Management Oracle's Automated MemoryManagement (AMM) features were significantly enhanced in Oracle 11g. With AMM adatabase can automatically manage both the system global are...
-
编辑 删除
MSSQLSERVER2008
Msg 468, Level 16, State 9, Line 1Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
-
编辑 删除
RM 刪除數據文件恢復操作
[oracle@ygzhou01 ygzhou01]$ rm -rf ygzhou01.dbf[oracle@ygzhou01 ygzhou01]$ ps -ef|grep dbw|grep -vgreporacle 6081 1 0Mar14 ? &nbs...
-
编辑 删除
CMMSG WHHMD DB PLAN
類別用途設備規格OS版本DB版本RAID需求可用空間邏輯磁盤數據文件分布HMD借用AGRA主DL580G5 /E7450 *4/4GB*8/72G SAS 10K*2+300G SAS 10K *5 /P400i 512MB/RPS/NC360Tlinux RedHat 5.5Ora...
-
编辑 删除
DB存儲規劃
DB 安裝需求類別用途設備規格OS版本DB版本RAID需求可用空間邏輯磁盤數據文件分布L6 SFC主DL580 G5 /Intel® Xeon® CPU E7450 @2.40GHz*24/4GB*8/72G SAS 15K*3+146G SAS 10...
-
编辑 删除
10g Release 2 Tablespace Point In Time Recovery – recover
RMAN> recover tablespace ygzhou until scn 2420448 auxiliary destination '/home/oracle/backup'; Starting recover at 15-MAR-12using channel ORA_DISK_1RMAN-05026: WARNING: presuming following set of...
-
编辑 删除
Create a trigger TO monitoring DDL
--1、CREATE TABLESPACE、USER AND GRANT ROLE TO USER-----------DROP TABLESPACE YGZHOU INCLUDING CONTENTS AND DATAFILES;CREATE TABLESPACE YGZHOU DATAFILE '/data1/stream/ygzhou01/datafile/ygzhou01.dbf' S...
-
编辑 删除
dbverify Utility
1、check datafile: https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=35512.1(1) SQL> show parameter db_block_size NAME &n...
-
编辑 删除
ORACLE數據恢復
alter Log文件：Mon Feb 28 13:25:31 2005ORACLE V8.1.6.0.0 - Production vsnsta=0vsnsql=e vsnxtr=3Windows 2000 Version 5.0 Service Pack 4, CPU type 586 ----------------------某交警系統后臺數...
-
编辑 删除
RAC禁止某个客户端登录数据库
单实例：1、以oracle用户进入$ORACLE_HOME/network/vi sqlnet.ora，添加：tcp.validnode_checking=yestcp.invited_nodes=(192.168.1.220,192.168.1.223)tcp.excluded_nodes=(192.168.1.221)解析：tcp.invited_node...
-
编辑 删除
将一个非分区表转换为分区表
根據用戶需求、將某數據表5000萬筆數據依據范圍分區方式做表結構更改，以下兩篇很好的實驗例子： 說明一下：用insert into select * from時間短；alter table archive.R_WIP_TRACKING_T exchange partition ...
-
编辑 删除
字段字符类型不匹配导致CPU占用率高
WINDOWS2003+MSSQL2005 CPUs:6*4Mem:32G cpu平均使用达40%;MEM使用25G； 分析硬件性能状态、汇总信息如下： 内存页交换较少、buffer命中率高、内存页生...
