ITPub博客

Red Hat Enterprise Linux Server release 6.6(Santiago) [root@mysqlgcopt]# tar -xvfPercona-XtraBackup-2.4.6-r8ec05b7-el6-x86_64-bundle.tarpercona-xtrabackup-24-2.4.6-2.el6.x86_64.rpmpercona-xtrabackup-24-debuginfo-2.4.6-2.el6.x86_64.rpmpercona-xtrabackup-test-24-2.4.6-2.e...

How to Obtain List of Objects Compiled With 'DEBUG' Option in the Database [ID 231349.1]

Broken Jobs and the Job Queue [ID 103349.1]***Checked forrelevance on 11-Jul-2012*** NOTE:=====The discussedfunctionality is still available in Oracle 10g and Oracle 11g.However, withOracle 10gR1 the DBMS...

問題巴西時間：FriNov 16 21:00:02 2012,北京時間:週六早上7點DELL 2950 server + Oracle 9.2.0.7 / ,/u01(ORACLE_HOME,ORACLE_BASE)相關一塊硬盤RAID1 (76G) 與磁盤陣列卡 同時壞掉/data(大部份datafile,redo logfile)  RAID5 (146G) 沒有損壞 分析如果備份激活的話，需要變...

LISTAGG函數 Oracle 11.2之後推出的：字符串聚合字符串聚合就是按照分组把多行数据串联成一行，以下面的结果集为例：11.2之前有WMSYS.WM_CONCAT函數，不過是非文檔說明的 舉個列子 為實現，同一類不同行數據 在 一行中顯示出來，可以使用wmsys.wm_concat (a.FAILURE_DESC||'-'|| a...

To BottomComments (0) In this Documen...

Bug10202228  wrong result when _allow_level_without_connect_by set totrue  This note gives a brief overview of bug10202228.  The content was last updated on: 25-OCT-2011 Click here for details of each of the sections below.Affects:...

Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1]To BottomModified:08-Mar-2013Type:BULLETINStatus:PUBLISHEDPriority:1 PLATFORM_ID...

Automatic Memory ManagementStartingwith Oracle Database 11g, the Automatic Memory Management featurerequires more shared memory (/dev/shm)and file descriptors. The size of the sharedmemory must be at least the greater of the MEMORY_MAX_TARGET and MEMORY_TARGET parametersfor each Oracl...

現象：RedHat Enterprise Linux Server release 5.4 (Tikanga)OracleDatabase 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production開啟listener時報錯 TNS-12555,Linux Errorscmautosty<*scmauto*/home/oracle>$lsnrctlstartLSNRCTL forLinux: Version 11.2.0.3.0 - Production on 03...

問題：$date-RFri,10 May 2013 14:51:40 +0800$date-uFriMay 10 06:51:45 UTC 2013 CREATE TABLEGC.TEST_JOB_TIMESTAMP(  SYST      VARCHAR2(50 BYTE), CURRENT_T  VARCHAR2(50 BYTE),  TIMES &nb...

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...

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 ...

Managing Automated Database Maintenance TasksCase 1:在DBCA安裝時如果沒有勾選自動收集統計信息，則oracle不會自動收集查詢AUTOTASK_STATUS為 DISABLEDselect * fromDBA_AUTOTASK_WINDOW_CLIENTS 且查詢為空select * fromDBA_AUTOTASK_TASK ...

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...

物理一致性：硬件故障檢查，不關心內容正確與否。Checksum邏輯一致性：內容檢查，比checksum複雜的多。如：檢查記錄是否被不存在的事務鎖定、記錄和索引是否對應，檢查內容比物理一致性要多 db_block_checksum : 通過對數據塊校驗和 物理一致性檢查9i,10G中TRUE 啟用，默認參數：1、SGA數據...

 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:...

問題：Services.msc 中Oracle服務啟動時報錯無法開啟 環境：Oracle 11.2.0.3 Microsoft Windows 2003(32-bit)Server : 虛擬平台(公司自主研发的VM很卡)現象：启动报错：Event Type:      ErrorEvent Source:  ServiceControl ManagerEve...

現象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...

ID 729551.1)转到底部In this DocumentPurpose Details Enabling Data Guard Redo Transport Compression ...