serdarturgut.blogspot.com
Serdar Turgut Oracle Blog: August 2013
http://serdarturgut.blogspot.com/2013_08_01_archive.html
Serdar Turgut Oracle Blog. BLOG of Serdar Turgut for Oracle DBA and developers. Friday, August 2, 2013. 11g Release 2 RMAN Backup Compression. With Oracle 11g Oracle Advanced Compression provides comprehensive data compression capabilities to compress all types of data, backups, and network traffic in an application transparent manner.The Oracle Advanced Compression option contains the following features:. Data Guard Network Compression. SecureFile Compression and Deduplication. Here are the results.
serdarturgut.blogspot.com
Serdar Turgut Oracle Blog: ORA-08104: this index object 136450 is being online built or rebuilt
http://serdarturgut.blogspot.com/2012/01/ora-08104-this-index-object-136450-is.html
Serdar Turgut Oracle Blog. BLOG of Serdar Turgut for Oracle DBA and developers. Tuesday, January 10, 2012. ORA-08104: this index object 136450 is being online built or rebuilt. While running an online index rebuild your session was killed so second attemp will give following error. Alter index MARDATA.COR VERGI NO HAR X2 rebuild online. Tablespace MARBASINDEX 1M storage(initial 1m next 1m) compress 2;. ERROR at line 1:. ORA-08104: this index object 136450 is being online built or rebuilt. Result boolean ;.
serdarturgut.blogspot.com
Serdar Turgut Oracle Blog: January 2012
http://serdarturgut.blogspot.com/2012_01_01_archive.html
Serdar Turgut Oracle Blog. BLOG of Serdar Turgut for Oracle DBA and developers. Tuesday, January 10, 2012. ORA-08104: this index object 136450 is being online built or rebuilt. While running an online index rebuild your session was killed so second attemp will give following error. Alter index MARDATA.COR VERGI NO HAR X2 rebuild online. Tablespace MARBASINDEX 1M storage(initial 1m next 1m) compress 2;. ERROR at line 1:. ORA-08104: this index object 136450 is being online built or rebuilt. Result boolean ;.
serdarturgut.blogspot.com
Serdar Turgut Oracle Blog: November 2011
http://serdarturgut.blogspot.com/2011_11_01_archive.html
Serdar Turgut Oracle Blog. BLOG of Serdar Turgut for Oracle DBA and developers. Thursday, November 17, 2011. How to flush a single SQL from shared pool. Use DBMS SHARED POOL.purge. Exec DBMS SHARED POOL.purge('ADRESS,HASH VALUE','C',1);. Select address,hash value, executions, loads, version count,. Invalidations, parse calls. Where sql text like 'UPDATE OTPL BASVURU KULLANICI SET ORDER ID%';. ADDRESS HASH VALUE EXECUTIONS LOADS VERSION COUNT INVALIDATIONS PARSE CALLS. Or another flush sql. How to flush a...
serdarturgut.blogspot.com
Serdar Turgut Oracle Blog: Disable or Enable all Oracle jobs
http://serdarturgut.blogspot.com/2012/07/disable-or-enable-all-oracle-jobs.html
Serdar Turgut Oracle Blog. BLOG of Serdar Turgut for Oracle DBA and developers. Tuesday, July 17, 2012. Disable or Enable all Oracle jobs. There are two kinds of jobs dbms job and dbms scheduler jobs. Alter system set job queue processes=0;. Exec dbms scheduler.set scheduler attribute('scheduler disabled','true');. Alter system set job queue processes=10;. Exec dbms scheduler.set scheduler attribute('scheduler disabled','true');. Subscribe to: Post Comments (Atom). Disable or Enable all Oracle jobs.
serdarturgut.blogspot.com
Serdar Turgut Oracle Blog: July 2012
http://serdarturgut.blogspot.com/2012_07_01_archive.html
Serdar Turgut Oracle Blog. BLOG of Serdar Turgut for Oracle DBA and developers. Tuesday, July 17, 2012. Disable or Enable all Oracle jobs. There are two kinds of jobs dbms job and dbms scheduler jobs. Alter system set job queue processes=0;. Exec dbms scheduler.set scheduler attribute('scheduler disabled','true');. Alter system set job queue processes=10;. Exec dbms scheduler.set scheduler attribute('scheduler disabled','true');. Subscribe to: Posts (Atom). Disable or Enable all Oracle jobs.
serdarturgut.blogspot.com
Serdar Turgut Oracle Blog: September 2013
http://serdarturgut.blogspot.com/2013_09_01_archive.html
Serdar Turgut Oracle Blog. BLOG of Serdar Turgut for Oracle DBA and developers. Wednesday, September 11, 2013. Quick configuration of TSM Data Protection for Oracle on an AIX. TDP for Oracle must be installed before. Policy,domain,backup copy,storage pools .etc must be defined on TSM server side. TDP for Oracle node must be registred before on server side ( e.x node name =dbgenomt e.x domain name = DM TEST ORACLE ). Ensure the SBT LIBRARY parameter is not set. Start the Oracle instances. Edit the dsm....
serdarturgut.blogspot.com
Serdar Turgut Oracle Blog: December 2010
http://serdarturgut.blogspot.com/2010_12_01_archive.html
Serdar Turgut Oracle Blog. BLOG of Serdar Turgut for Oracle DBA and developers. Thursday, December 23, 2010. Where to find MAXxxxxxx control file parameters in Data Dictionary. How to find information about the following controlfile parameters. The values of MAXLOGFILES, MAXLOGMEMBERS, MAXDATAFILES, MAXINSTANCES and MAXLOGHISTORY are set either during CREATE DATABASE, or CREATE CONTROLFILE. For parameters (exepct MAXLOGMEMBERS) can be seen from. REDO LOG', 'MAXLOGFILES',. DATAFILE', 'MAXDATAFILES',.