oracle view data error

dr.murthy · Post by **dr.murthy** » Thu Jan 22, 2009 2:36 am

hi all,
when i view the data from oracle coi stage i got a error message some thing like,i used an user defiened sql query.

The open files limit is 100; raising to 65536.
**VIEWDATA ROW LIMITER HIT**

any suggestions

ray.wurlod · Post by **ray.wurlod** » Thu Jan 22, 2009 2:50 am

Your user-defined SQL is generating a large number of messages.

Try it independently of DataStage, for example using sqlplus. What happens then?

swarnkar · Post by **swarnkar** » Thu Jan 22, 2009 3:01 am

Hi Ray,

I am just curious about "Open File limit" in the message.

Is it pertaining to "ulimit" parameter on Unix box or MFILE/TFILE at Datastage environment ?

ray.wurlod · Post by **ray.wurlod** » Thu Jan 22, 2009 3:19 pm

No, I think that's just a default table of file handles within the code. The message is informational only.

It's definitely not related to T30FILE (which is only about dynamic hashed files) and it's almost certainly not related to MFILE (which is for the server engine rather than the parallel engine). And I doubt that any UNIX system has ulimit set to only 100.