10g and CLOB

[Christo Kutrovsky]

I am playing arround with a 10g database.

When I query a table with CLOB columns, i get the following error:

"A query with LOB's requires OCI8 mode, but OCI7 mode is used."

I am using the 9i client software. I don't have "FORCE OCI7" checked.

Is that a PL/SQL developer problem, or an oracle problem ? Same happens with "GOLDEN32".

I was wondering if you have found a work arround or solution internally ?

 

[Marco Kalter]

I will upload a 5.1.5 pre-release later today that fixes this problem, and will post a notification here.

 

[Marco Kalter]

It's already up. This pre-release will officially be made available by the end of this week.

 

[oraclelover]

I work at a big company where all purchases have to go through purcurment(spelling??). We just got 20 licenses for PL/SQL Developer.
Where do you get your id and password from to download from the registered section? Also how do you know to go to that link, did that info get mailed and we the developers are not getting everything that shipped from our precurment department? As of now we have the box and manual and cd with cd key. But no username and password. Any help would be great. If I have to I will go through the our precurment department. That process will take more then a few days and more likely more than a week. If I can pass that up and get the info another way that would be nice. Can I email or call with my serial number or license key?

 

[Marco Kalter]

I will send you all necessary information by e-mail.

 

[Christo Kutrovsky]

Hey it's the end of the week. I don't see the new 5.1.5 is it dellayed ?

Just curious

 

[Christo Kutrovsky]

I have been running with 5.1.5 and clobs run just fine under 10g, only one little problem.

When I connect to a remote database (high latency, internet link) retrieving lines which have CLOBS is very slow. I takes about half a second per line, as opposed to very fast before.

maybe this has something to do with arrays and clobs ? I have not yet had a chance to diagnose the packets been exchanged, will do during working day tomorow.

I was just wondering if you had noticed this ?

 

[Marco Kalter]

We have not noticed any speed difference with CLOB's, though we haven't got any slow networks here. Are you also using the 10g client?

 

[Christo Kutrovsky]

No, the 9i client to a 9i database.

If you connect from home, via a VPN to work, and use PL/SQL developer on your home PC, you sould see the difference.

P.S.
I will try to diagnose more the client, and provide you with some info.

 

[Christo Kutrovsky]

I think the reason is because you are probably not using arrays fetches when fetching with clobs.

What happens is, when I have a clob it does:
- fetch row
- confirm row fetched, request next
- fetch row
...

as opposed when a clob is not present:
- fetch 100 rows
...

Extremly slow via high-latency links. I think many people use PL/SQL Developer over low bandwith, high latency links (like 2 Mbit, 100 ms). You should really try it via such a link, and see how slow are certain things. Like, opening the index columns of a table with many rows and many indexes. Sometimes it takes 30 seconds...

 

[Marco Kalter]

We'll check it out.

 

[Deman]

I do find the slowness on querying the BLOB/CLOB table after I upgrade to 5.1.6 version
Is there any follow-up on this topic?

 

[Marco Kalter]

We have not been able to find any LOB related performance issues.