Avatar of GurcanK
GurcanK
 asked on

How to write to a LOB column with high performance in Oracle?

Dear Experts,

We have a large table with a BLOB field. A scheduled software is writing data to that BLOB field daily. (Everyday single record is written to the table) The size of Data is about 8 GB. How can we achieve fast writes to BLOB field, is it possible to write parallel to single BLOB field ?

BR
Oracle Database

Avatar of undefined
Last Comment
GurcanK

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
GurcanK

ASKER
We create a record (row) everyday in the table. The table has a BLOB field, there is no append to an existing BLOB field of a row.
slightwv (䄆 Netminder)

Is the row you are inserting 8 Gig or the entire tablesize is 8 Gig?
GurcanK

ASKER
Just the row (its BLOB field) is about 8 GB.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
slightwv (䄆 Netminder)

I still to not understand:
One row is 8 Gig or all rows total up to be 8 Gig?

In other words are you inserting one 8 Gig row every day?
GurcanK

ASKER
Yes, we are inserting one 8 GB row everyday.
SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
GurcanK

ASKER
These are good questions, I will talk to our software engineer who wrote the program.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.