The below session ( sid=62) is waiting on db_file_sequental_read event
for more than 627 seconds. When i strace the process id , i see it is
polling. Why is this session waiting for disk index read although there
is no real io in the process? What does this mean?

To make sure all enties in one column are Upper Case you can do the
following
create table test2(
lname          varchar2(10) not null,

I would like to implement the following functionality inside the
PL/SQL block. but it is not working.
--Sample image of my problem
-- implementing the serveroutput on inside pl/sql

My database is on Linux, FC3. I know it isn't supported, I am
not asking for support, I am just reporting a problem.
This is the error that I'm receiving:
Exception:oci8 error: [12154: Error while trying to retrieve text for

I have a question regarding the MERGE statment.  
Can I do a merge with no update clause?  
For example, in the merge below, when a match is found, can I  "do nothing"?
If I don't have a match, I want the insert, but if i have a match, i don't

Does anyone have the address of a website or a document that lists
which components of Fedora are needed to install Oracle 9i on. Also
does anyone have the address of a website or a document that lists the
instructions needed to install Oracle on Fedora

I would like to know what is the max sga size for 32-bit Oracle 9.2.0.6 on
Solaris...
And how reliable are the recommendations shown by scalability analysis on
EM...

Has anyone got experience of converting a system to allow it to cater
for Timezone support. What are the pitfalls, problems etc.
Am running 9.2 with Forms and Reports 6i through 9ias.
There will obviously be data migration and changes to the DATE

I have two stored procedures
ALTER PROCEDURE dbo.qryCountOne
(@inputID int)
AS SELECT COUNT(*) AS CountOne FROM  dbo.TableOne WHERE

 first of all, sorry for my english, i'm spanish.
 I'm tracing the execution of some Prepared Statements sent through
JDBC to an Oracle 9i Database. I'm using the usual tracing methods
(enabling session trace and tkprof). The issue is that the value of the

Is it possible to create and ldap entry using Oracle Directory Manager
that's an alias for an previously existing entry? If so how? I am not
looking for someone to tell me to right click an entry and select
"create like" as that creates a separate copy. What I'm looking for is

i have a distributed system. From where i have to bring all data to one
database. All most all database is in oracle 10g and winxp. Now, the only way
to transfer data is using dial-up. So, what should i do to transfer the data
in reliable ways.

I just installed Oracle 10G (10103) on RedHat AS 3.0.
After I run EMCA -r, then I try to use the Linux web brower to connect to
http://hostname:5501/em from the same server, I got the error "the
connection was refused"

If I did not install OEM, which I do not like the idea of having an
additional database to manage, can I use OEM database control?
Thanks for your help.

in my MetaLink headlines I saw today that DocID 207303.1 "Client /
Server / Interoperability Support Between Different Oracle Versions" was
updated on 05.07.2005.
There you can see interoperability support for Oracle Client Version 10.2.0.