I had met a question. The oracle database will crash after about every
five days. The "pmon" had detected the DBWR was terminated suddenly. I
am very dismayed, because according to the other threads said, most of
this issue was due to the Oracle Bug.

Please let me know how to connect with the remote server in oracle as
OS User.
ex:- sqlplus /@remote_database
Regards

Do these function cause exceptions and should I always put them inside
a try block?
For example: Connection::createStatement(), Statement::setSql(),
Statement::executeQuery(), Statement::executeUpdate(),

could u help me, what is the sql command to list all existing databases
in a oracle server?

10gR2/Solaris
With the code below I load a (xml) file to CLOB
File = 1521 bytes
But "dbms_lob.getlength(l_xmlclob)" returns half of that : 760

10gR2
Is assigning NULL to Nested Table (to clear it) documented syntax ?
or should it be the_nested_table_variable.DELETE ?
DECLARE

i have resolved it
lenghtb

I am newbie to PL/SQL and have a problem of passing OUT parameters.
If I have a procedure like this:
========================
CREATE OR REPLACE PROCEDURE MYPROC (myinput IN varchar2, output1 out

My question is:
does oracle support two phase commit protocol?
and Why if no.
How if yes.

My question is:
does oracle support two phase commit protocol?
and Why if no.
How if yes.

Can someone please tell me how can I get the backup status
(completed/failed) for RMAN backup operations?
Currently I check the status using OEM but I was looking for some
database query to check the same.

If I enable tracing using the following
alter session set sql_trace = true
the trace file in being generated in user_dump_dest (Oracle Parameter)
folder and the file names are of the following format

Like for db_cache_size, we have db cache advisor and hit ratio. Do we
have any thing to java_pool_size.
Please tell me how to decide what is the good java_pool_size for the
database, because most of the application are on java in my new org.

I am working on a database system which its cpu usage at the top
waiter list in statspack outputs.
Each statspack output ( in 60 min. intervals ) show same sql statement.
( in the list of most buffer_gets )

firstly sorry my english,
how can I use variable if variable name same as table's field name?
CREATE OR REPLACE TRIGGER KULLANIC_BI BEFORE INSERT ON KULLANIC
FOR EACH ROW