Oracle 9 introduced a new way to manage rollback / undo data – an Undo Tablespace. To utilize Automatic Undo Management, create a tablespace in the database of type UNDO:
Archive for February, 2008
Auto Undo Management in Oracle
Monday, February 25th, 2008Redo Log File in Oracle
Monday, February 25th, 2008The redo log file holds transaction information. Each Commit causes a flush to the log. You have multiple log files defined – one is “active” or “online”, the others are “offline”. Oracle rotates through these files as each gets full. Switching active files has overhead so the suggestion is that each file can hold roughly 30 minutes or transactions.
Using Multiple MySQL Ports in the Same Application
Monday, February 25th, 2008This is a code example of this command:
SET_DATABASE_PORT OF MYSQL TO PORT
(more…)
Issues With Oracle’s Recyclebin
Sunday, February 24th, 2008Oracle introduced since 10g a new feature the Database Recyclebin, which as a Operative System recyclebin brings the ability to restore tables (files in OS) that are dropped (deleted).
Installing MySQL in Linux CentOS/Red Hat
Sunday, February 24th, 2008Installing MySQL in Linux, is not difficult to do. This article is a step by step guide on how to do it: