Pular para o conteúdo principal

Postagens

Mostrando postagens de setembro, 2011

Setup Oracle 11gR2 on linux - Oracle Validated

First Configure public Yum Repository: http://public-yum.oracle.com/ Run oracle-validated: [root@localhost yum.repos.d]# yum install oracle-validated Loading "security" plugin Setting up Install Process Parsing package install arguments Resolving Dependencies --> Running transaction check ---> Package oracle-validated.x86_64 0:1.1.0-14.el5 set to be updated filelists.xml.gz          100% |=========================| 3.1 kB    00:00 filelists.xml.gz          100% |=========================| 2.9 MB    00:10 filelists.xml.gz          100% |=========================| 2.7 MB    00:15 filelists.xml.gz          100% |=========================| 3.2 MB    00:18 filelists.xml.gz          100% |=========================| 2.6 MB    00:14 filelists.xml.gz          100% |=========================| 3.2 MB    00:18 filelists.xml.gz          100% |=========================| 3.0 MB    00:14 filelists.xml.gz          100% |=========================| 2.9 MB    00:14 file

Calculate the Size of an RMAN Backup Piece

DATAFILE_BLOCKS The number of data blocks in the datafile BLOCKS The number of data blocks written to the backup BLOCK_SIZE The size of the data blocks in bytes So BLOCKS * BLOCK_SIZE will give the number of bytes written for this particular datafile and hence the size of the backup piece may be calculated. SQL> select bs_key, sum(blocks*block_size) from rc_backup_datafile group by bs_key; If you do not use catalog (controlfile): SQL>select bs_key, sum(blocks*block_size) from v$backup_datafile group by bs_key;

How to disable automatic statistics collection in 11g

BEGIN  DBMS_AUTO_TASK_ADMIN.DISABLE(  client_name => 'auto optimizer stats collection',  operation => NULL,  window_name => NULL);  END;  / to verify: SQL> select client_name,status from Dba_Autotask_Client;  CLIENT_NAME                        STATUS ---------------------------------- -------- auto optimizer stats collection    DISABLED auto space advisor                 ENABLED sql tuning advisor                 ENABLED

How to Apply an 11i Patch When adpatch is Already Running

1. Using the adctrl utility, shutdown the workers. a. adctrl b. Select option 3 "Tell worker to shutdown/quit" 2. Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema a. sqlplus applsys/ b. create table fnd_Install_processes_back as select * from fnd_Install_processes; c. The 2 tables should have the same number of records. select count(*) from fnd_Install_processes_back; select count(*) from fnd_Install_processes; 3. Backup the AD_DEFERRED_JOBS table. a. sqlplus applsys/ b. create table AD_DEFERRED_JOBS_backas select * from AD_DEFERRED_JOBS; c. The 2 tables should have the same number of records. select count(*) from AD_DEFERRED_JOBS_back; select count(*) from AD_DEFERRED_JOBS; 4. Backup the .rf9 files located in $APPL_TOP/admin//restart directory. At this point, the adpatch session should have ended and the cursor should be back at the Unix prompt. a. cd $APPL_TOP/admin/ b. mv restart restart_back c. mkdir restart 5. Drop the F