Javier Andrés Pérez Díaz

Información desde OTN Latinoamerica: http://www.oracle.com/technology/global/lad-es/blog/index.html

Todo sobre ORACLE 11g …

http://www.oracle.com/technology/products/database/oracle11g/index.html

Interesante herramienta: http://www.plpdf.com/

Si están realizando una instalación de Oracle Database 10gR2 sobre:
Red Hat 5 Advanced Server o sobre Oracle Enterprise Linux 5
Y les aparece el error el afortunado error: “libXp.so.6: cannot open shared object file: No such file or directory occurred”, significa que la libreria libXP esta perdida por lo cual la forma de solucionarlo es instalando el rpm:

rpm -ivh libXp-<version>

Solo detalles …

Hago referencia a este articulo que es muy bueno sacado del sitio “http://laurentschneider.com” donde se explica que la columna PASSWORD de la DBA_USERS ya no es visible en 11G:

select username,password from dba_users where username=’SCOTT’;
USERNAME PASSWORD
——– ——————————
SCOTT

select name,password from sys.user$ where name=’SCOTT’;
NAME PASSWORD
—– ——————————
SCOTT F894844C34402B67

Lo cual es muy bueno …

Sagradas herramientas para el browser, que te ayudara saber donde se están re-direccionando las paginas cuando trabajas con Oracle Application Server

HTTPHEADERS para Internet Explorer

HTTPHEADERS para Mozilla

Muchos problemas de I/O podrían tratarse con la configuración del RAID establecida, les muestro una nota de metalink en la cual Oracle aconseja ciertas configuraciones:

Note:30286.1 I/O Tuning with Different RAID Configurations

Recommendations:                                                               
In general, RAID usually impacts write operations more than read operation.
This is specially true where parity need to be calculated (RAID 3, RAID 5, etc).

Online or archived redo log files can be put on RAID 1 devices.   
You should not use RAID 5. ‘TEMP’  tablespace data files should also go on  
RAID1 instead of RAID5 as well. The reason for this is that streamed  

write performance of distributed parity (RAID5) isn’t as good as that of 
simple mirroring (RAID1).                          
 
Swap space can be used on RAID devices without affecting Oracle.   
====================================================================================

RAID  Type of RAID        Control       Database        Redo Log        Archive Log
                            File          File            File            File
====================================================================================

0     Striping             Avoid*          OK*           Avoid*           Avoid*     
————————————————————————————
1     Shadowing             OK             OK          Recommended       Recommended

————————————————————————————
0+1   Striping +            OK         Recommended       Avoid            Avoid     
      Shadowing                           (1)                                                         

————————————————————————————
3     Striping with         OK           Avoid           Avoid            Avoid     
      Static Parity                       (2)                                                                    

————————————————————————————
5     Striping with         OK           Avoid           Avoid            Avoid     

      Rotating Parity                     (2)
————————————————————————————
*   RAID 0 does not provide any protection against failures. It requires a strong backup

    strategy.
(1) RAID 0+1 is recommended for database files because this avoids hot spots and gives
    the best possible performance during a disk failure.  The disadvantage of RAID 0+1
    is that it is a costly configuration.

(2) When heavy write operation involves this datafile