I've been reading about the difference between connections and sessions
on Kyte's site and this group.  It's a bit rough for me, so I got a few
questions.  I'm also having a hard time figuring out how it could be
applied to auditing when the OS user uses an app to do database work,

Does anyone know a way to create a corrupt block or blocks in an Oracle
tablespace ?
I want to checkout the DBMS_REPAIR package for real.
I'm running 10G on Windows XP.

I'm having trouble believing this is true.
With an export or import, I can use a parfile and hide my password
either with the parfile or with a shell re-direct like
echo password | exp userid=system  or something.

Good day,
We have 3-node Oracle 9.2.0.5 RAC database on AIX 5.2.
We're seeing enqueue wait events in our database.  Here is a Statspack
output (elapsed time of about 5 minutes):

I hope some expert can halp me with this.
An old 8.1 server crashed and no backup was avaialble.
I managed to salvage from the hard disk the oracle directories,
and specifically the oradata directory. Since I had to set up an

I want daily report in Excel format.and this excel file should be
mailed to client.I want autoamtic process for that just like cron job.
I am using Oracle 9i on Linux

We are upgrading to Oracle 10g.  According to the docs, we are to run a
SQL script named:  utl1012i.sql.
When I do that, it aborts with the following error:
ORA-25153: "Temporary Tablespace Empty"

We are upgrading to Oracle 10g.  According to the docs, we are to run a
SQL script named:  utl1012i.sql.
When I do that, it aborts with the following error:
ORA-25153: "Temporary Tablespace Empty"

The Supreme Progneer:
'Progneer' basically I invented and drived from "Programmer & Engineer"
Some remember Him as God, remember Him as Bhugwan, some remember Him as
Jahova, Some remember Him as Allah SWT but I remember Him as The The

Dear DBA,
You are cordially invited to test and review our windows native and
100% pure Java Oracle 10g Monitoring & Security Application (Xg).
Xg is  the Ultimate Visual Real Time Oracle Monitoring Tool. As the

Hy,
i have a problem with a function table. This function have a loop on a
cursor, and create a "recordset". It work fine with the first 2 record,
on the 3rd it send me ORA-06540 error.

Guys:
     In MS SQL server, there is a utility called Profiler which can be
used monitoring real time SQL traffic between the client and SQL server
so we know what kind of sql statements has been executed against the

--_NextPart_00009763-0000083A-0CE5CA12-D297
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
There is a great job board located at the employment section of

During 10g database install on Solaris 9 SPARC station, the DBCA seems
to hang and eventually returns the following error message:
Enterprise Manager configuration failed due to the following error -
Error starting Database Control.  Refer to log file at

I am running 10g on solaris 5.9.
I am doing some testing on my own test instance.
One thing I don't understand is I can't get the RECYCLE-BIN working.
I try to "test" drop a table and I look at the recycle-bin,