Search results for query: *

Well, that gonna be A LOT of queries, and I have big concerns about performance since it't performance that is the primary goal of my current project. Almost every query will be using NVL. Each will retrieve thousands of rows, and there a hundreds of clients running those queries...

Hi How can I make NULLs come first in query output? Oracle puts'em to the end of the list, I need right opposite. I don't want to use NVL since it will affect performance. Neither I can use DESC since I need regular sorting order for non-NULLs. Any ideas? Thanks a lot Dmitri Issanov

Hi, Janos We've switched to Oracle 8.1.7, now it works fine. As far as I remember out problem was insufficient SESSIONS init parameter value, we had a high number of recursive sessions and it run out of limit. I'm not sure though, it was half a year ago :) Hope this helped Regards Dmitri

You probably have misspelled error message: Unable to allocate 8192 bytes of shared memory("large object","unknown object","sort subheap","sort key") instead of Unable to allocate 8192 bytes of shared memory("large POOL","unknown...

Hi I have troubles putting Oracle MTS (Multi-Thread server mode) to work with MS Transaction Server. I run Oracle 8.1.6 on Solaris 7, Oracle Services for MTS 8.1.6.1 (patched). When Oracle runs in dedicated mode, thins go fine. Once I set it to shared server mode, all distributed transactions...

Will failed transaction show up in trace file or just errors like SQL parsing error, etc?

Thanks, it helps!

Hi I have an application working with Oracle database, and I don't have access to source code. Some transactions fail but this app doesn't generate any logs. How can I trace errors occuring while executing SQL statements, session initialization, etc? All I need is to get ORA error number and...