Hello fellow DBA's,
I've read a article from Burleson where he's an enthusiast about solid
state disks:
" It's important for all Oracle professionals to learn about solid-

i have an oracle database and a mysql database.
in both i have some same tables.
if data is changed or inserted on oracle site, then i want to apply the
changes on the mysql site to.

If you are attending OOW 2007 ( and why not ? ) and are already an OCP
( let's not get started on that discussion please ) then you have the
ability to ( attempt to ) register for the "FREE OCP Oracle Database
11g New Features for Administrators Exam Cram Session".

With Oracle 10g and RMAN I have a question concerning the following
operation:
alter system archive log current
Should I perform this just before or just after my RMAN backup?

How many database imports have you done?  Well, once in a while you
forget some things and need some reminders.
First, if you do a full database export, and then import into another
database, do the users have to pre-exist?

Table question
I have a table with two columns, e.g.:
FORM        COUNT SEP
Xg        2

I love "GLOBAL TEMPORARY TABLEs" (GTT). I
have been using them for awhile, and find
them to be a great tool.
We are rac'ed but I am logging into one specific

I have been looking for a software that could easily analyze the RMAN
Oracle backup logs. I need to know how long backup took, how long
validation took, how much data was backed up and any errors during
backup.

In order to keep the SOX beancounters-from-hell(Auditors) at bay I have
to provide a report for my boss that shows who logged on to which
database, from which machine, to which database, with which app, etc.
I plan on putting in a simple table that will get populated by two

I am reading Feuerstein's article in Oracle Magazine and is seems as
the PL/SQL Function Result Cache is the same as using the
deterministic keyword.
Is this the case, or am I missing something?

10.2.0.3
SQL> select sysdate from dual;
SYSDATE
-------------------

Sounds like replicating, right?
But the case is this.
We now have a single production database machine having 4 different SID's
(instances) on it. Let's say the machine is called DB.

we have been to value some types of Oracle RAC solutions in according to
which filesystem to use on SAN in cluster environment with HP-UX (or
Linux) platform.
HP says that there are this options to choose (in order of

Someone knows when Oracle will desupport 9R2 Database?
On their portal oracle site i don't find any useful information of
it...
thanks

We have an application using Oracle 9.2.0.4. We are moving our network
and servers to IPv6. Does Oracle 9i support IPv6? Will the Oracle
database run without issues in IPv6 only environment?
Thanks,