...and Oracle answers for all | by Orlando Olguín Olvera

Popular pages

• Restarting MMON process | ...and Oracle answers for all

  When I tried to do a simple change to a database parameter, I found an anormal or non-typical error, the ORA-00453 indicating that the MMON process was "dead". Here is a small set of steps to restart ...

• Index | ...and Oracle answers for all

  Database Automatic memory management Bulk ASM disks’ creation with Linux Changing the AUD$ table to another tablespace Database version How to change the Undo tablespace? How to delete a database Inva...

• Useful scripts for a DBA | ...and Oracle answers for all

  After sometime, I was in a little debate between publish or not, my useful scripts that I personally use to query important information from the database and instance. Now I post these scripts and hop...

• Installing examples and HR schema | ...and Oracle answers for all

  When you install the RDBMS, if you choose to create the database, you can choose the installation of the Oracle examples. Here I'll show you how to install the Oracle examples if you choose to install...

• ASM | ...and Oracle answers for all

  Posts about ASM written by Orlando Olguín Olvera

• Automatic memory management | ...and Oracle answers for all

  Starting with the Oracle database 11g version, there is an useful and Oracle recommended option to manage automatically the memory. When you modify some parameters of the instance, it can be implement...