When a block comes under the HWM,I believe its formatted by
Oracle.What I want to know is that is there any bit in block dump
which does differentiate that the block is unformatted or formatted?
Secondly, is there a difference in the performance for oracle when it

I have a database 9.2.0.6, with the wait events below:
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                                     %
Total

We upgraded database from 9i to 10g at the weekend. One of the
processes (whose statement basically consists of an "create table as
select etc") is taking +7hrs and still running instead of the more
usual 30 mins. OK, I would think that this is a statistics/explain-

I believe Data Guard was a free option with Oracle 10g EE.
But is it still free for Oracle 11g ?
Matthias

I installed 10.2.0.1 on AIX6
in a directory /logi/ora/1020,
installation is OK
but i saw a /logi/ora/920 created with

Years ago, I skimmed an Oracle book at the bookstore.
I'm sure it was written by Tom Kyte.
In it, he critiqued a system that would store data in
rows, instead of simple columns!

Hi experts,
are there tools to make a fast dump of complete databases to CSV?
Without needing any additional licenses from Oracle...?
TIA Tellie

I have a pretty complicate query that produces a sales summary,
something similar to this:
customer_id sales_amount
=========== ============

Anyone who have knowledge of a application/tool to use when you want
to document all tables, columns, triggers and so on, all objects in a
database? Years ago i worked with Designer2000. But i guess and hope
that there is some lighter/smaller applications who has capabilities

After installing oracle client (10.2.0.4) even thou I can connect to
my database using SQL PLUS, on some applications I am getting the
following error. Does anyone know what to do?
Test connection failed because of an error in initializing provider.

One of our 8i server ran out of shared memory.
I am getting following error and not even able to log in for shutting
down
conn  "/ as sysdba"

All,
a bit of background: we have a stored procedure that needs to lock
several rows via SELECT ... FOR UPDATE. Currently this stored
procedure has a single VARCHAR2 argument which contains a comma

I've created the following table and view:
_____
CREATE TABLE X_EF (
 ID_EF    INTEGER      NOT NULL,

Why is it that when I run a data pump operation with PARALLEL > 1, I
only ever see one worker EXECUTING and the state for all the others is
WORK WAITING? What would cause that?
TIA

I'd like to analyze one schema's all tables and indexes every night - should
I implement a PL/SQL-procedure for this and add it to Database
Control/Scheduler Jobs ? - there seems to some "gather stats"-jobs already
but those are "smart-ones" and this one schema is vital an stats ...