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
oracle view data error
Moderators: chulett, rschirm, roy
oracle view data error
D.N .MURTHY
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.