-
编辑 删除
Oracle 11G Virtual Columns
Virtual ColumnsVirtualcolumns are defined by evaluating an expression the results of which become themetadata of the columns for tables. Virtual columns can be defined at tablecreation or modification time.Virtualcolumns enable application developers to define computations andtransfor...
-
编辑 删除
Oracle 11G EM建立
ogg<*dt2*/home/oracle>$emca -repos createSTARTED EMCA at Aug 20, 2013 10:50:25 AMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle. All rights reserved.Enter the following information:Database SID: whispcListener port number: 1526Password for ...
-
编辑 删除
Oracle 11G 统计信息Task
Managing Automated Database Maintenance TasksCase 1:在DBCA安裝時如果沒有勾選自動收集統計信息，則oracle不會自動收集查詢AUTOTASK_STATUS為 DISABLEDselect * fromDBA_AUTOTASK_WINDOW_CLIENTS 且查詢為空select * fromDBA_AUTOTASK_TASK ...
-
编辑 删除
Interval Partition table 11G
Interval PartitioningInterval partitioning is an extension of range partitioning whichinstructs the database to automatically create partitions of a specifiedinterval when data inserted into the table exceeds all of the existing rangepartitions. You must specify at least one range partition...
-
编辑 删除
db_block_checksum和db_block_checking
物理一致性：硬件故障檢查，不關心內容正確與否。Checksum邏輯一致性：內容檢查，比checksum複雜的多。如：檢查記錄是否被不存在的事務鎖定、記錄和索引是否對應，檢查內容比物理一致性要多 db_block_checksum : 通過對數據塊校驗和 物理一致性檢查9i,10G中TRUE 啟用，默認參數：1、SGA數據...
-
编辑 删除
Oracle active dataguard ORA-01555
Bug 10018789 Spin in kgllock / DBhang with high library cache lock waits on ADG This note gives abrief overview of bug 10018789. The content was last updated on: 03-SEP-2013 Click here for details of each of the sections below.Affects:...
-
编辑 删除
Timeout (30000 milliseconds) waiting for the OracleService service to connect.
問題：Services.msc 中Oracle服務啟動時報錯無法開啟 環境：Oracle 11.2.0.3 Microsoft Windows 2003(32-bit)Server : 虛擬平台(公司自主研发的VM很卡)現象：启动报错：Event Type: ErrorEvent Source: ServiceControl ManagerEve...
-
编辑 删除
Oracle standby ORA-00600:[3020] ORA-10567
現象Oracle Database 11g Enterprise Edition Release11.2.0.1.0 - 64bit ProductionRed Hat Enterprise Linux Server release 5.3(Tikanga) 64bit 在主庫執行將文件從4G改小為2G后ALTERDATABASEDATAFILE'/data/orcl/undotbs04.dbf'RESIZE2000M; Standby DB中SELEC...
-
编辑 删除
Redo Transport Compression in a Data Guard Environment (文档 ID 729551.1)
ID 729551.1)转到底部In this DocumentPurpose Details Enabling Data Guard Redo Transport Compression ...
-
编辑 删除
tempfile报错重建 ORA-01187 ORA-01110
ORA-01187: 無法自檔案 201 讀取資料, 因為檔案未通過驗證測試ORA-01110: 資料檔 201:'/data/dmsdb/temp01.dbf' select * fromdba_temp_filesORA-01187: 無法自檔案 201 讀取資料, 因為檔案未通過驗證測試ORA-01110: 資料檔 201:'/data/dmsdb/temp01.dbf' ...
-
编辑 删除
Oracle database/Tablespace logging&nologging 优先关系
Database : force logging所有操作都有redolog Tablespace force loggingTablesapce所屬table操作都有redo log Tablespace loggingtablespace下對象的建立默認為：loggingTable設置nologging/logging覆蓋tablespace級別的設置Table設置nologging 則為nologgingTable...
-
编辑 删除
DBA_TAB_PARTITIONS中 high_value栏位long型转varchar2
CREATE OR REPLACE function SMES_C.long_2_varchar (p_table_owner in DBA_TAB_PARTITIONS.table_owner%type,p_table_name in DBA_TAB_PARTITIONS.table_name%type,p_partition_name in DBA_TAB_PARTITIONS.partition_name%type) return varchar2asl_high_value LONG;begin&...
-
编辑 删除
DBCA建库报错 ORA-13516 / ORA-06512
DBCA fails in the middle of database creation withORA-13516 / ORA-06512 (文档 ID 1929718.1) In this Document Symptoms Cause SolutionApplies to:Oracle Database - StandardEdition - Version 11.2.0.2 t...
-
编辑 删除
Oracle 11G RAC OS开启后集群组件开启但DB依然是关闭
OS開啟后其他集群件自動開啟但DB依然是關閉的：ora.gc.db 1 OFFLINE OFFLINE &nb...
-
编辑 删除
Oracle 反向索引 where index_column like '%xxx'
Oracle 反向索引 where index_column like '%xxx' create table objectsas select * from dba_objects;createindexobj_idx on objects(OBJECT_NAME)reverse;createindexobj_idx_reverse on objects(reverse(OBJECT_NAME));reverse index使用：select* from objectswherereverse(object_name)LIKEreverse('%OL$')或select* fro...
-
编辑 删除
ora-600 [rwoirw: check ret val] with count distinct and order by
點檢DB看到web程式引發 ORA-00600[rwoirw:check ret val]Mon Mar 02 09:32:062015 ORA-00600: 内部错误代码, 参数: [rwoirw: check ret val]問題SQL：SELECTSUM(MD01)MD01,SUM(MD02)MD02,SUM(MD03)MD03,SUM(MD04)MD04,SUM(MD05)MD05,SUM(MD06)MD06,SUM(MD07)MD07,SUM(MD08A)MD08A...
-
编辑 删除
Rman-10038: Database Session For Channel D1 Terminated Unexpectedly
ID 399395.1)转到底部In this DocumentSymptomsSolutionApp...
-
编辑 删除
Oracle Table and tablespace Compress
Compressed TablespacesYou can specifythat all tables created in a tablespace are compressed by default. You specifythe type of table compression using the DEFAULT keyword, followed by one of thecompression type clauses used when creating a table.The following statementindicates that al...
-
编辑 删除
Oracle Index Key Compression索引压缩
Index KeyCompressionOracle Database can use key compression to compressportions of the primary key column values in a B-treeindex or an index-organized table. Key compression can greatly reduce the spaceconsumed by the index.In general, index keys have two pieces, a groupingpiece and ...
-
编辑 删除
Oracle 11G RAC CTSS服務
CTSS(ClusterTime Synchronization Server Daemon)GRID 自己提供的時間同步服務如果所有節點上已經部署NTP服務，CTSS以Observer mode 運行，這種模式下CTSS只會在集群alert.log中記錄時間不一致信息，但不會去調整如不是所有幾點上部署NTP，CTSS以Active mode運行，并和主節點同步。分為兩種方式：1> 當節點加...
