Top Certifications in all Fields - A Complete Guide
RedHat Linux: http://career-assessments.blogspot.com/2008/01/red-hat-linux-certification-progr
am_26.html
PMP: http://career-assessments.blogspot.com/2008/02/pmp-project-management-profession
al.html
Oracle: http://career-assessments ...

How can I extend the timeout for the SQLPLUS sql commands entry ?

I'm trying to write a stored procedure which will compare two tables
dynamically and will display the difference. The input parameter are
two table names and columnames(optional)
I get the column names from all_tab_cols table and dynamically form a

hi all i have done oracle 10g database cource but i just want
to know what is the difference regarding performence,management of a
database in oracle 10g R2 because when i was learning it ,at that time
oracle database R2 was not released or may be we used to learn on

Factory-Reconditioned Dyson DC07 Upright Vacuum, Steel/Yellow
Price:$500.00
Image: http://bestdeallocator.info/image.php?id=B0001MAAWK
Best deal: http://bestdeallocator.info/index.php?id=B0001MAAWK

Oracle 10.2.0.3 on solaris, running a select query on a test machine
takes one second, execution
plan shows that index range scan is used. On the production node same
statement takes more than

10.2.0.3 64 bit Standard on SLES 10 two node RAC
Hi All,
Does anyone know if it is possible to reverse engineer the SQL_TEXT
for a given SQL_ID?  We had large waits yesterday afternoon on 'enq:

For case of statistics there is made a copy from a database some time
ago. I produced a SQL- Statement, that worked fine on the actual
database, but when I use the same statement on the other DB I got an
Oracle Error 600, followed by some values (the 1st is 733).

I am using 10g.
I have an audit trail stored procedure to create. There is a customer
table. Then customer_audit table. Customer and Customer_audit tables
are identical. Each time a record is changed, a copy of the old record

I have oracle 10g and 11g online on linux.
But after 1 month when I do shutdown immediate command, it took a
long loooong time wait just like it freezed.
Is there anyone have the same experience?

Oracle kills free support blog and Twitter account
http://blogs.zdnet.com/Howlett/?p=1761

Where are looking for a tool which will show the relationships between
a table and all its related objects such as triggers, views,
procedures, etc.
We already have TOAD which shoes these relationships in a tabular form

In a 10g database, I am looking for all ways to list references
to a specific data string in any table of a specific schema, assuming
that the fields are all VARCHAR2.
For example, suppose that there is a schema named OLYMPICS.

What is the directory where oracle asmlib disks are created under
solaris?
On linux, the directory is "/dev/oracleasm/disks".
I need to know the equivalent directory in solaris.

Has anyone used some of the Oracle FGA?  We're needing to enable some
auditing.  I'm having trouble getting it to work.  Reading all the
documentation on this is taking a while as there are so many options.
We're running 10g R2 Enterprise on CentOS.  We want to basically audit