Re: Slow performance on Long Raw Datatypes, Help !

Are your rollback segments well customized ? minextents = ? nb = ? Are your datafiles on separated disks ?

Create a special RBS to do your transaction. Enough log buffers ?
Enough log files ?
Look at your alert$SID.log file.

• Jean-François LEGUILLIER *
• *
• PARTNER-SYSTEM *
• 2-4 Bd des Iles *
• 92130 Issy les Moulineaux *
• *
• Tél : 01.41.46.09.00 *
• Fax : 01.41.46.09.09 *
• email : leguillier_at_partner-system.com *
• *
• web : www.partner-system.com *

  ---

Kenny Leow wrote:
>
> Hi,
>
> Currently, I am inserting jpeg files into my table people_photo. It contains
> a member_id varchar2(7) and photo_rec Long Raw. Member_id is the primary key
> of the table people_photo.
>
> I am experiencing slow performance while inserting into the table.
> Basically, an insertion of about 200 photo takes about 5 hours. I am using
> Powerbuilder to insert the images and commit until all insertion is
> finished.
>
> Can anyone advise how can I improve the performance. I am out of my wit.
>
> Thanks a lot.
>
> Please reply to leow_at_stcs.com.sg. If you had the solution. Thanks again.
>
> Kenny
Received on Thu Oct 29 1998 - 12:06:08 CST