RE: OFFTOPIC - RE: Which is faster, Metalink or...

2001-03-27 Thread Richard Ji 

Me going upstream against Naigara fall.

-Original Message-
Beilstein
Sent: Tuesday, March 27, 2001 3:19 PM
To: Multiple recipients of list ORACLE-L


Water flowing uphill (that never works either)

>>> [EMAIL PROTECTED] 03/27/01 02:52PM >>>
Turtles walking through peanut butter in January?

-Original Message-
Sent: Tuesday, March 27, 2001 2:32 PM
To: Multiple recipients of list ORACLE-L



A snail going uphill through jungle vegetation? Molasses in the northernmost
region of the Siberian tundra?




  _

Do You Yahoo!?
Yahoo! Mail Personal  
Address - Get email at your own domain with Yahoo! Mail.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OFFTOPIC - RE: Which is faster, Metalink or...

2001-03-27 Thread Kevin Kostyszyn 



Metalink, hands down.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
  Tuesday, March 27, 2001 2:52 PMTo: Multiple recipients of list 
  ORACLE-LSubject: OFFTOPIC - RE: Which is faster, Metalink 
  or...
  Turtles walking through peanut butter in January?
  
-Original Message-From: Chuck Hamilton 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 27, 2001 
2:32 PMTo: Multiple recipients of list 
ORACLE-LSubject: Which is faster, Metalink 
or...
A snail going uphill through jungle vegetation? Molasses in 
the northernmost region of the Siberian tundra?


Do You Yahoo!?Yahoo! Mail 
Personal Address - Get email at your own domain with Yahoo! 
  Mail.

OFFTOPIC - RE: Which is faster, Metalink or...

2001-03-27 Thread William Beilstein 

Water flowing uphill (that never works either)

>>> [EMAIL PROTECTED] 03/27/01 02:52PM >>>
Turtles walking through peanut butter in January?

-Original Message-
Sent: Tuesday, March 27, 2001 2:32 PM
To: Multiple recipients of list ORACLE-L



A snail going uphill through jungle vegetation? Molasses in the northernmost
region of the Siberian tundra?




  _  

Do You Yahoo!?
Yahoo! Mail Personal  
Address - Get email at your own domain with Yahoo! Mail.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Which is faster, Metalink or...

2001-03-27 Thread gregory . t . norris 

Especially when it's a stampeding herd of turtles!!!

-Original Message-
Sent: Tuesday, March 27, 2001 1:52 PM
To: ORACLE-L
Cc: MohanR




Turtles walking through peanut butter in January?

-Original Message-
Sent: Tuesday, March 27, 2001 2:32 PM
To: Multiple recipients of list ORACLE-L



A snail going uphill through jungle vegetation? Molasses in the 
northernmost region of the Siberian tundra?

 

OFFTOPIC - RE: Which is faster, Metalink or...

2001-03-27 Thread Mohan, Ross 



Turtles walking through peanut butter in January?

  -Original Message-From: Chuck Hamilton 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 27, 2001 2:32 
  PMTo: Multiple recipients of list ORACLE-LSubject: Which 
  is faster, Metalink or...
  A snail going uphill through jungle vegetation? Molasses in 
  the northernmost region of the Siberian tundra?
  
  
  Do You Yahoo!?Yahoo! Mail Personal 
  Address - Get email at your own domain with Yahoo! 
Mail.

RE: Which is faster??

2001-03-27 Thread Martin Kendall 

Thanks guys.

-Original Message-
Sent: 26 March 2001 18:26
To: Multiple recipients of list ORACLE-L


Direct patch sqlldr (and insert-append) do allow
indexes - its just that you get slugged a little more
on rollback and redo...

I don't have any metrics to compare - typical usage of
either tends be to the ol'  a) drop ind, b) load, c)
redindex

hth
connor

--- Martin Kendall <[EMAIL PROTECTED]> wrote: >
I know that Direct Path of sqlldr does not allow
> Indexes
> so what is the comparative performance of this
> suggestion if
> the given Table is indexed ?
> 
> Martin
> 
> -Original Message-
> Sent: 23 March 2001 09:05
> To: Multiple recipients of list ORACLE-L
> 
> 
> If you're on 8.0 or higher, try
> 
> insert /*+ APPEND */ 
> into table
> select * from other_table;
> 
> where "table" is defined as nologging.  Then you
> won't
> hit either redo logs or rollback segments..Its the
> equivalent of a sqlldr direct load
> 
> hth
> connor
> 
> --- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
> the following scripts:
> > 
> > insert into table
> > select * from table2
> > ;
> > 
> > So if use the about bulk statement in my 
> > application, and the table2 is big, say 10
> > million records, my concern is that it's 
> > going to fail because of the possible rollback
> > segments failure. So then I have to use PL/SQL
> > to create a cursor and commit every 5 records.
> > What's the disadvantage of this?Will it be much
> > slower
> > than a bulk insert?
> > 
> > Can I do it another way: create a stored procedure
> > for this bulk insert, then pin this procedure in
> > memory, does it still have RBS problem?
> > 
> > Anyone has similar experience?
> > 
> > Thanks in Advance,
> > 
> > Chris
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail. 
> > http://personal.mail.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: CC Harvest
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at 
> http://www.oradba.freeserve.co.uk)
> 
> "Some days you're the pigeon, some days you're the
> statue"
> 
>

> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Martin Kendall
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (85

RE: Which is faster??

2001-03-26 Thread Connor McDonald 

Direct patch sqlldr (and insert-append) do allow
indexes - its just that you get slugged a little more
on rollback and redo...

I don't have any metrics to compare - typical usage of
either tends be to the ol'  a) drop ind, b) load, c)
redindex

hth
connor

--- Martin Kendall <[EMAIL PROTECTED]> wrote: >
I know that Direct Path of sqlldr does not allow
> Indexes
> so what is the comparative performance of this
> suggestion if
> the given Table is indexed ?
> 
> Martin
> 
> -Original Message-
> Sent: 23 March 2001 09:05
> To: Multiple recipients of list ORACLE-L
> 
> 
> If you're on 8.0 or higher, try
> 
> insert /*+ APPEND */ 
> into table
> select * from other_table;
> 
> where "table" is defined as nologging.  Then you
> won't
> hit either redo logs or rollback segments..Its the
> equivalent of a sqlldr direct load
> 
> hth
> connor
> 
> --- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
> the following scripts:
> > 
> > insert into table
> > select * from table2
> > ;
> > 
> > So if use the about bulk statement in my 
> > application, and the table2 is big, say 10
> > million records, my concern is that it's 
> > going to fail because of the possible rollback
> > segments failure. So then I have to use PL/SQL
> > to create a cursor and commit every 5 records.
> > What's the disadvantage of this?Will it be much
> > slower
> > than a bulk insert?
> > 
> > Can I do it another way: create a stored procedure
> > for this bulk insert, then pin this procedure in
> > memory, does it still have RBS problem?
> > 
> > Anyone has similar experience?
> > 
> > Thanks in Advance,
> > 
> > Chris
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail. 
> > http://personal.mail.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: CC Harvest
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at 
> http://www.oradba.freeserve.co.uk)
> 
> "Some days you're the pigeon, some days you're the
> statue"
> 
>

> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Martin Kendall
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---

RE: Which is faster??

2001-03-26 Thread Witold Iwaniec 

As far as I remember direct load allows to load data into indexed 
table - it "disables" indexes for the loading time and builds the 
indexes once, after the load completes. Also it prepares binary 
array corresponding to the table layout and writes directly to the 
file. Conventional load basically creates an insert statement for 
each row of data to be loaded and executes it. It also modifies 
indexes after each record has been loaded. It makes big difference 
in time, of course depending on the volume

Witold


On 26 Mar 2001, at 7:31, Martin Kendall wrote:

> I know that Direct Path of sqlldr does not allow Indexes
> so what is the comparative performance of this suggestion if
> the given Table is indexed ?
> 
> Martin
> 
> -Original Message-
> Sent: 23 March 2001 09:05
> To: Multiple recipients of list ORACLE-L
> 
> 
> If you're on 8.0 or higher, try
> 
> insert /*+ APPEND */ 
> into table
> select * from other_table;
> 
> where "table" is defined as nologging.  Then you won't
> hit either redo logs or rollback segments..Its the
> equivalent of a sqlldr direct load
> 
> hth
> connor
> 
> --- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
> the following scripts:
> > 
> > insert into table
> > select * from table2
> > ;
> > 
> > So if use the about bulk statement in my 
> > application, and the table2 is big, say 10
> > million records, my concern is that it's 
> > going to fail because of the possible rollback
> > segments failure. So then I have to use PL/SQL
> > to create a cursor and commit every 5 records.
> > What's the disadvantage of this?Will it be much
> > slower
> > than a bulk insert?
> > 
> > Can I do it another way: create a stored procedure
> > for this bulk insert, then pin this procedure in
> > memory, does it still have RBS problem?
> > 
> > Anyone has similar experience?
> > 
> > Thanks in Advance,
> > 
> > Chris
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail. 
> > http://personal.mail.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: CC Harvest
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at 
> http://www.oradba.freeserve.co.uk)
> 
> "Some days you're the pigeon, some days you're the statue"
> 
> 
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
> or your free @yahoo.ie address at http://mail.yahoo.ie
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Martin Kendall
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


==
Witold Iwaniec
Senior Software Developer
NovaLIS Technologies
[EMAIL PROTECTED] 
http://www.novalistech.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Witold Iwaniec
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

RE: Which is faster??

2001-03-26 Thread Martin Kendall 

I know that Direct Path of sqlldr does not allow Indexes
so what is the comparative performance of this suggestion if
the given Table is indexed ?

Martin

-Original Message-
Sent: 23 March 2001 09:05
To: Multiple recipients of list ORACLE-L


If you're on 8.0 or higher, try

insert /*+ APPEND */ 
into table
select * from other_table;

where "table" is defined as nologging.  Then you won't
hit either redo logs or rollback segments..Its the
equivalent of a sqlldr direct load

hth
connor

--- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
the following scripts:
> 
> insert into table
> select * from table2
> ;
> 
> So if use the about bulk statement in my 
> application, and the table2 is big, say 10
> million records, my concern is that it's 
> going to fail because of the possible rollback
> segments failure. So then I have to use PL/SQL
> to create a cursor and commit every 5 records.
> What's the disadvantage of this?Will it be much
> slower
> than a bulk insert?
> 
> Can I do it another way: create a stored procedure
> for this bulk insert, then pin this procedure in
> memory, does it still have RBS problem?
> 
> Anyone has similar experience?
> 
> Thanks in Advance,
> 
> Chris
> 
> 
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: CC Harvest
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Martin Kendall
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Which is faster??

2001-03-23 Thread Hillman, Alex 

When inserting only rowid gows into rollback segment, so 1GB will be more
then enough.

Alex Hillman

-Original Message-
From:   CC Harvest [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, March 23, 2001 12:18 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Which is faster??

Thank you all for the reply. Probbaly I need to do
more test. My concern is that whether it's ok to do
the buld insert of 9 million records(say 2.7GB) on a 1
GB RBS? I think the RBS should also be at least 3GB,
right?

Thanks,

Chris

--- Connor McDonald <[EMAIL PROTECTED]> wrote:
> If you're on 8.0 or higher, try
> 
> insert /*+ APPEND */ 
> into table
> select * from other_table;
> 
> where "table" is defined as nologging.  Then you
> won't
> hit either redo logs or rollback segments..Its the
> equivalent of a sqlldr direct load
> 
> hth
> connor
> 
> --- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
> the following scripts:
> > 
> > insert into table
> > select * from table2
> > ;
> > 
> > So if use the about bulk statement in my 
> > application, and the table2 is big, say 10
> > million records, my concern is that it's 
> > going to fail because of the possible rollback
> > segments failure. So then I have to use PL/SQL
> > to create a cursor and commit every 5 records.
> > What's the disadvantage of this?Will it be much
> > slower
> > than a bulk insert?
> > 
> > Can I do it another way: create a stored procedure
> > for this bulk insert, then pin this procedure in
> > memory, does it still have RBS problem?
> > 
> > Anyone has similar experience?
> > 
> > Thanks in Advance,
> > 
> > Chris
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail. 
> > http://personal.mail.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: CC Harvest
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at 
> http://www.oradba.freeserve.co.uk)
> 
> "Some days you're the pigeon, some days you're the
> statue"
> 
>

> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UN

Re: Which is faster??

2001-03-23 Thread CC Harvest 

Thank you all for the reply. Probbaly I need to do
more test. My concern is that whether it's ok to do
the buld insert of 9 million records(say 2.7GB) on a 1
GB RBS? I think the RBS should also be at least 3GB,
right?

Thanks,

Chris

--- Connor McDonald <[EMAIL PROTECTED]> wrote:
> If you're on 8.0 or higher, try
> 
> insert /*+ APPEND */ 
> into table
> select * from other_table;
> 
> where "table" is defined as nologging.  Then you
> won't
> hit either redo logs or rollback segments..Its the
> equivalent of a sqlldr direct load
> 
> hth
> connor
> 
> --- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
> the following scripts:
> > 
> > insert into table
> > select * from table2
> > ;
> > 
> > So if use the about bulk statement in my 
> > application, and the table2 is big, say 10
> > million records, my concern is that it's 
> > going to fail because of the possible rollback
> > segments failure. So then I have to use PL/SQL
> > to create a cursor and commit every 5 records.
> > What's the disadvantage of this?Will it be much
> > slower
> > than a bulk insert?
> > 
> > Can I do it another way: create a stored procedure
> > for this bulk insert, then pin this procedure in
> > memory, does it still have RBS problem?
> > 
> > Anyone has similar experience?
> > 
> > Thanks in Advance,
> > 
> > Chris
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail. 
> > http://personal.mail.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: CC Harvest
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at 
> http://www.oradba.freeserve.co.uk)
> 
> "Some days you're the pigeon, some days you're the
> statue"
> 
>

> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Which is faster??

2001-03-23 Thread Ron Rogers 

Chris,
 Does the destination table have to be recoverable? If not you could built the table 
with the UNRECOVERABLE clause and your problem is solved.
 In large inserts from one table to another for archive purposes, I get around the 
large RBS problem by using a procedure with a commit every 20 records. Works fine 
and I kick it off and you home.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 03/22/01 09:35PM >>>
I have the following scripts:

insert into table
select * from table2
;

So if use the about bulk statement in my 
application, and the table2 is big, say 10
million records, my concern is that it's 
going to fail because of the possible rollback
segments failure. So then I have to use PL/SQL
to create a cursor and commit every 5 records.
What's the disadvantage of this?Will it be much slower
than a bulk insert?

Can I do it another way: create a stored procedure
for this bulk insert, then pin this procedure in
memory, does it still have RBS problem?

Anyone has similar experience?

Thanks in Advance,

Chris


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/ 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: CC Harvest
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Which is faster??

2001-03-23 Thread Connor McDonald 

If you're on 8.0 or higher, try

insert /*+ APPEND */ 
into table
select * from other_table;

where "table" is defined as nologging.  Then you won't
hit either redo logs or rollback segments..Its the
equivalent of a sqlldr direct load

hth
connor

--- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
the following scripts:
> 
> insert into table
> select * from table2
> ;
> 
> So if use the about bulk statement in my 
> application, and the table2 is big, say 10
> million records, my concern is that it's 
> going to fail because of the possible rollback
> segments failure. So then I have to use PL/SQL
> to create a cursor and commit every 5 records.
> What's the disadvantage of this?Will it be much
> slower
> than a bulk insert?
> 
> Can I do it another way: create a stored procedure
> for this bulk insert, then pin this procedure in
> memory, does it still have RBS problem?
> 
> Anyone has similar experience?
> 
> Thanks in Advance,
> 
> Chris
> 
> 
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: CC Harvest
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Which is faster??

2001-03-22 Thread C.S.Venkata Subramanian 

 You can try the Bulk insert feature of Oracle. It is available from Oracle 8i 
onwards. It really reduces time.
--

On Thu, 22 Mar 2001 18:35:21  
 CC Harvest wrote:
>I have the following scripts:
>
>insert into table
>select * from table2
>;
>
>So if use the about bulk statement in my 
>application, and the table2 is big, say 10
>million records, my concern is that it's 
>going to fail because of the possible rollback
>segments failure. So then I have to use PL/SQL
>to create a cursor and commit every 5 records.
>What's the disadvantage of this?Will it be much slower
>than a bulk insert?
>
>Can I do it another way: create a stored procedure
>for this bulk insert, then pin this procedure in
>memory, does it still have RBS problem?
>
>Anyone has similar experience?
>
>Thanks in Advance,
>
>Chris
>
>
>__
>Do You Yahoo!?
>Get email at your own domain with Yahoo! Mail. 
>http://personal.mail.yahoo.com/
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: CC Harvest
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Which is faster?

2001-02-20 Thread Johan [EMAIL PROTECTED] Services 

I don't think there is any question.

A smart select statement always tends to be a better solution.

The one instance where I'd definitly prefer a procedure over a select is
when the select contains Oracle's tree-walk method (i.e. connect by prior...
start with)

Regards
JL

-Original Message-
Sent: Tuesday, February 20, 2001 12:31 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus !

I'm going to some tables with huge amount of records. There are references
between these tables. The
question is:
Does it worth creating a procedure with several small selects or is it
faster to use one select with
joins?

For example:
CUSTOMER(CUST_ID);
CONTRACT(CONTR_ID,CUST_ID);
CONTRACT_ITEM(CONTR_I_ID,CONTR_ID,PHONE_NUM_ID);
PHONE_NUMBER(PHONE_NUM_ID,PHONE_NUM);

I have the PHONE_NUM and I need the CUST_ID.

Which Faster?
SELECT CUST_ID from PHONE_NUM,CONTRACT_ITEM,CONTRACT,CUSTOMER where 
[JOINS] and
PHONE_NUM=searchedone

or In procedure or function

select phone_num_id into Variable from phone where phone_num=searchedone;
select contract_id into Variable2 from contract_item where
phone_num_id=Variable;
select cust_id into Variable from contract where contr_id=Variable2;



Thanks in advance.
Gyula

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andor Gyula
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johan Locke@i-Commerce Services
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).