You can increase SORT_AREA_SIZE upto 1Mbytes.
Larger values than this have not improved performance significantly.
- Original Message -----
From: Allan Nelson <anelson_at_houston.rr.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Wednesday, November 08, 2000 6:20 AM
Subject: Re: ORDER BY ..
> Make sure your sorts are in memory.
>
> Allan
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, November 07, 2000 9:25 AM
>
>
> >
> >
> >
> > i want my 'order by' transaction to be quick...very quick ...
> > what oracle parameter should i increase or decrease ???
> >
> > Thanks a lot .
> >
> >
> >
> >
> >
> >
> >
> >
> > "bunyamin karadeniz" <bunyamink_at_havelsan.com.tr> on 07/11/2000 02:55:22
AM
> >
> > Please respond to ORACLE-L_at_fatcity.com
> >
> >
> >
> >
> >
> >
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> >
> > cc: (bcc: Marcos Vera/M&S Consultores/51)
> >
> >
> >
> > Subject: Re: Query to select only the duplicate records from
> > a table?
> >
> >
> >
> >
> >
> >
> >
> >
> > SELECT interested_columns
> > FROM table_name a
> > WHERE rowid >(SELECT min(rowid)
> > FROM table_name b
> > WHERE b.pk_column = a.pk_column ) ;
> >
> > *pk_coloumn is the primary key column the table.
> > if you want to delete the duplicate rows, just change the select to
DELETE
> >
> > ****** if you want to leave only one row of the duplicated rows,For ex:
> you
> > have 3 duplicated rows and want to delete 2 of them and leave only one,
> The
> > only possibility as I understand is first selecting the duplicate rows
> with
> > DISTINCT and then insert into another table and then delete duplicated
> rows
> > from the base table and select from second table and insert into base
> > table.******
> >
> >
> > **********************************************
> > Bunyamin K. Karadeniz
> > Enformasyon Teknolojileri Dir.
> > Veri Tabani Grubu tel : 2873565/1681
> > HAVELSAN
> > **********************************************
> >
> > > -----Original Message-----
> > > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > Date: Monday, November 06, 2000 2:38 PM
> > >
> > >
> > > >Hello Lists,
> > > >
> > > >Can any body help me in writing a query which will
> > > >list only the duplicate records from a table?
> > > >
> > > >Any help would be highly appreciated.
> > > >
> > > >TIA,
> > > >Muru
> > > >
> > > >__________________________________________________
> > > >Do You Yahoo!?
> > > >Thousands of Stores. Millions of Products. All in one Place.
> > > >http://shopping.yahoo.com/
> > > >--
> > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > >--
> > > >Author: Murugesan Balakrishnan
> > > > INET: mail_oracle_at_yahoo.com
> > > >
> > > >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: ListGuru_at_fatcity.com (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: Jim Walski
> > > INET: jwalski3_at_classicplan.com
> > >
> > > 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: ListGuru_at_fatcity.com (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: bunyamin karadeniz
> > INET: bunyamink_at_havelsan.com.tr
> >
> > 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: ListGuru_at_fatcity.com (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:
> > INET: Marcos.Vera_at_msconsultores.com.pe
> >
> > 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: ListGuru_at_fatcity.com (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: Allan Nelson
> INET: anelson_at_houston.rr.com
>
> 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: ListGuru_at_fatcity.com (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).
Received on Wed Nov 08 2000 - 00:27:09 CST
