I would like to see all sql issued by a user for a currently open
session.  Is there a way to do this?
-thank you

I have this SELECT statement in a cursor that's giving me performance
problems and am wondering if reordering the conditions in the WHERE
clause would make a difference in performance. Does it help if one
lists the most restrictive conditions first?

I have a table with 2 million rows.
I am doing the following select statement against this table.
SELECT *
              FROM TableA

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit,
Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit -
new !
Windows Liberty 64bit                                          8403

Hello everyone.  I hope someone can help me with this.  I have 3
columns called EMPLOYEE_TEST, TEST_QA and EMPLOYEE_TEST_ANSWER.
The TEST_QA table contains the following:
TEST_QA_ID | PROC_TEST_ID | TEST_QA_QUESTION | TEST_QA_CORRECT

 I've determined that Oracle's WSM can be valuable for some of our
testing and development efforts here.  But, I'm stuck trying to figure
out how to utilize this feature when running an application in a Web
Logic server using a connection pool.

Now I am successfully perform the rman backup via command line .With
regards to this now I am using forms 6i Host command to pass the
parameters to this batch file for backup purpose. I wrote the
following code on When Button Press. But on run time when I try to

Does anyone have a performance plan for doing this? any pitfalls in
doing this? Or can i just do a big select statement and run a 10046
trace on it to get a rough estimate of the workload my system can
handle?

Some one asks me what 'Bulk Connects' is, I have never heard of this term.
What's the definition of Bulk Connects?
Where it is used?
TIA

i have code
OPEN csr_CDPM for v_ExecuteSql;
LOOP
FETCH csr_CDPM INTO Cdpm_eSchedule_rec;

Can anyone please explain to me why you would need to use Nested tables and
give an example.  Also can you show the SQL to view the table and the nested
table and explain the logic of it.
Thanks in advance for your help.

I have recently undertaken a default install of 9.2 Standard Engine.
I notice that the undotbs01.dbf file just keeps on growing.
Can I limit its size somehow, and if so what are the implications?
JL

Today I read that param SORT_AREA_SIZE shouldn't be used with Oracle
9.2.0.4 anymore. Instead PGA_AGGREGATE_TARGET should be used.
My datebase was created with SORT_AREA_SIZE=5M and PGA_AGGREGTE_TARGET=24M.
My question is: How do I unset this param ?

I'm using a product which internally installs oracle 8. This product
works on Windows 2000. I'm planning to install same product on Windows
2003 and use it in compatibility mode.
Can anybody tell me whether it will work or not? Do I need to carry

I often see Oracle job openings on the web that ask for "examples of written
procedures documentation". Does anyone have any samples of this that they
would be willing to share? TIA