Aquí un tip rápido para cuando te topas con el error ORA-00600: [2662], este error significa que el SCN de un bloque tiene un numero mayor al del SCN de la base de datos , esto puede significar que existe una corrupción física en tu base de datos...
Squares and Circles - Day 4...
So RAC has a pretty cool tool called Server Control or better known as srvctl, with this you can manage the services in a RAC farm, and one of the sometimes and much needed is when you have several ORACLE_HOMEs and you only need to...
Day 3 - Subway PeopleToday was a very hectic day riding the subway, but still had time to take this photo...
Se que esto no tiene mucho que ver con base de datos, pero es un tip que quiero mantener a la mano y que me ha ayudado para resolver rápidamente un problema de concatenar muchas celdas y no meterme en muchos embrollos.Vamos a decir que...
Day 2 - DuskSo yesterday was a very nice and clear day here, this is a bit of the sky we had ....
So I want to see how far I can get into a 30 day photo challenge, this will be the first for this self imposed challengeSelf Portrait...
Here is a quick tip that mainly comes from an OEM bug.In OEM you had a tuning task, and the result of this tuning tasks is advising you that if you apply a profile you go from a Full table scan to a Parallel Execution...
Uno de las grandes desventajas que tenemos como DBAs es que mucho de nuestro trabajo son a deshoras, y de igual manera requieren de scripts que toman a veces dos o tres horas en correr, asi que si son las dos de la mañana, tres...
So the other I was asked for a report regarding the backups in RMAN, so this query below helped me to give the needed details of the RMAN backups that we have.So I connected to the RMAN catalog and executed the query below, goes to...