Oracle Select slow between 85 and 95 columns

[Bonus83]

Hi,

I am using an Oracle 10g and have a problem when selecting a specified amount of columns. I have a Table called customer and want to read the ID (primary key, indexed aso.)
This happens only in the application and with sqltalk. Not with sqlplus or toad.
So I assume this has something to do with TD or with any setting within the runtime.

The problem occurs when selecting 86-95 columns from this table. The select lasts over 8 seconds. If i use more or less columns the selects returns within 0.03 seconds. To exclude any problems with clobs, long strings aso. I used the same column 90 times.

The select looks like:
SELECT customer_id, customer_id, customer_id, customer_id, customer_id, customer_id ... (90 times)
FROM Customer
WHERE Customer_id = 1;

If I use the customer_id 85 times in my SELECT its fast. If I use it 96 times ist fast. If I use any amount from 86 to 95 its slow.

So my Question is if there is any setting which leads to this sorcery? And why the hell it occors between 86 and 95 and not after 85 at all.

Thank you in advance.

[ianrudge]

Can't answer why it would do that but I wondered why you would need to do that?

[Bonus83]

Can't answer why it would do that but I wondered why you would need to do that?

You wonder why I have to select 90 columns out of a table?

[ianrudge]

Not 90 columns just 90 of the same columns.