I'm using Oracle 10G on 64 bit Redhat Linux.
I need to perform a bulk insert:
create table table1 (
 pk1    number primary key,

Dear Gurus,
Just read this article about "Asynchronous Commit in Oracle Database
10g R2" on
http://itzkdb.blogspot.com/2005/08/asynchronous-commit-in-oracle-database.html

For some reason a few of our text indexes have blown out to about 3Gb.
I'm still investigating why. Is it possible to reduce the physical size
of the index while keeping it online? Is it even possible to reduce it's
physical size without dropping it?

thanks, rm.

I am using Oracle 10.1.0.3 on Windows 2000. I have database control on
and collecting AWR using default values.
I want to know how many sessions were connected to database every
hour/every day. My database gets rebooted every weekend.

Hello out there,
last weekend, I patched our Oracle Databases on W2k from 9.2.0.6 to
9.2.0.7.
As for now everything runs fine but one thing. On the physical standby

We had an issue on our E6900 Cluster(Solaris 9) where Oracle stopped
and started the listener after about 6 minutes of trying to ping the
database.
Opened a ticket with sun and they say we should increase the timeout

I am tring to find where to modify the default table settings in
Oracle. I have a tablespace with two tables associated with it. I want
to change the default settings for my two tables in this tablespace
without affecting the tables in other tablespaces. Where do I modify

I've been using "alter system kill session 'sid,serial';" to kill
sessions.  Now I am wondering is there a way to kill just the query of
a session/sid without killing the session/sid itself?  Or is it simply
not recommended?

Is there anything similar to avg_row_length in dba_tables, but for
indexes ?
Trying to avoid doing vsize calc on each index column.
How to estimate index space usage ?

I was reading the step by step RAC installation on Linux and have a
question on OCFS.
Q. Do I have to put all my oracle files in one mount point only? I saw
this step:

I am building a 10g server on Windows.  We expect to change the IP address
of the machine as part of implementation.  I recall that there were problems
with 9i when changing the IP address (Oracle Agent used the hostname or IP
address as part of a encryption key) and wanted to check ...

Saw a doc on Metalink that said all you had to do was reconnect and
restart the instace if an error occured after creating an spfile from a
pfile.
I checked metalink for all deprecated parameters for 9.2.0.6 and I dont

I have a problem using a trigger on a table with many field (>150).
This is the trigger :
create or replace trigger trg_tst
after insert or update on tst_table1

I'm trying to load a flat file into a table with a nested table using
Oracle 9.2
The table definition for the destination table is:
CREATE OR REPLACE TYPE grouplist AS TABLE OF VARCHAR2(100);