Link to home
Start Free TrialLog in
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
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GurcanK
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.
Is the row you are inserting 8 Gig or the entire tablesize is 8 Gig?
Avatar of GurcanK

ASKER

Just the row (its BLOB field) is about 8 GB.
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?
Avatar of GurcanK

ASKER

Yes, we are inserting one 8 GB row everyday.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GurcanK

ASKER

These are good questions, I will talk to our software engineer who wrote the program.