10g
select * from V$SYSTEM_WAIT_CLASS order by TIME_WAITED desc;
WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS     TOTAL_WAITS TIME_WAITED
------------- ----------- -------------- ----------- -----------

I am trying to apply Oracle database patch 9.2.0.8 on top of our
9.2.0.5 .
I have created response file and tried intallaing. But it gives the
following error.

I have a database running Oracle 9i that from 2 days seems to have
troubles in performance.
Ho can i see which users have more activity in queries or in resources
consumpion?

I am trying to set up Oracle 10i on mye desktop computer running
Windows XP. Everything works flawlessly on this computer as far as I
can tell. I can use SQL*Plus and webbased configuration to connect to
the database e.t.c. But I also want to use my laptop running Windows

I have a question about  sqlnet.ora file security on a host running
Linux. As far as I know the only way without additional
options( Database Vault) to forbid connect as sysdba without password
on the database host  is to add an entry in $ORACLE_HOME/network/admin/

How can I write an oracle function that can return a set of rows? this
is what I am doing now. It doesnt work.
create or replace FN_ABCD
(

Is it possible to installed drivers on a Windows 2003 x64 server to
connect to Oracle 9.0.2.6
Is a client available for 9.2.0.6 and windows2003x64
or

One of the developers  had written a function such that it returns a
string value as either "True" or "False", which was again used in a
sql context with a decode statement wrapped around it to do something
else.

I would like to know 2 things regarding oracle.
1)Does Oracle PL/SQL now support the returning of a recordset to the
business tier by just using a single 'SELECT ColNameList FROM
tablename', or still I have to use  the cumbersome method of declaring

I am learning and would need your help.
I'm able to create a simple SQL in the oracle view.
Select Home
AS

I am just wondering how can i get df output in table column html
format.
Rgds,
AB

     We are involved in migration of data from DB2 to Oracle.
We are facing some problem while loading some french data to
oracle table's using sql loader.
Table (tb_test) structure:

We have an oralce 9i that from 2 weeks seems to have troubles in
performace. Seems that oracle don't want use indexes for 2 of our
largest tables and many sql queries access in full table scan. what's
happening?

I was close to giving up hope of seeing this patchset but it's
available now ( I think it came out August 13th 2007 ).
Hoping to see the 10.2.0.4 patchset for that environment come out "a
whole lot closer" to the release date for 10.2.0.4 on other platforms

is there a way to propagate two columns with a CASE WHEN
statement in a SELECT. What I tried and I think it shows
what I want to do is:
SELECT