As the subject says, just curious how many people out there have
passwords on their listeners?
Some external group auditing us for SOX is saying that its a best
practice but in my 8 years as a DBA i've never seen it.

  I am trying to optimize a query and Using PL/SQL developer for
looking at explain plan. Looking at default goal of Optimizer ( All
Rows ) is not the most effective way. So I change optimizer goal as
First Rows and the query is now using indexes - Good. However how do i

I have a question about flashback. For some reason it doesn't work?!
Here is what I do:
show parameter undo_retention;
NAME                                 TYPE        VALUE

Do you think Oracle Database 10g R2 for Linux x86 is ready production
use yet?
I am planning to deploy it on RHEL4 soon.
Should I wait for the first patchset instead?

I'm looking for guideline or syntx to rename an Oracle failsafe cluster
detail, including the virtual name and ip address. I can do it via
Oracle FS Manager, but I'm just wondering whether I can script this at
fscmd.

I need to stored some japanese character in a WEISO8859P15 database.
But I prefer no migrate the SB character set to a MB character set.
Is it possible to store the asian character in CLOB in a SB database ?
tyia

Hi Experts,
I want to know how to properly set composite limit for assigning to a
profile. Oracle docs says:
"

Any suggestion on a good PL/SQL reference book? Thanks.

Any one have any idea whats wrong with this code? Other than the fact
its a bit messy...
IF in_location_array.count > 1 THEN
sql_contains_str := 'contains('||in_location_array(1)||',

Hi Experts,
I have oracle 9.2.0.6 on Solaris 8. My listener log file has grown to
15 mb. I needto recycle the listener but not sure of its steps:
Are they as follows:

I just installed Oracle 9.0.1 on SUSE 9.
I started the listener.
How do I log in to the database?  I am trying this:
sqlplus /nologin

Anyone have any reservations or concerns about using NAS (Network Attached
Storage) for Oracle redo logs in a high volume OLTP environment?

I am receiving an ORA-00932: inconsistent datatypes: expected CLOB -
got CHAR
My spool select, is this:
WHENEVER SQLERROR EXIT SQL.SQLCODE

Is ORA-01555 something you cannot get rid at all(most of the
books/articles I read mentioned only how to REDUCE its occurrence)?  If
yes, what, as programmers, should we do in our code to handle it?

 I have a problem with COMPRESSION.
Basically, I have upgrade from 8.1.7.4(solaris ) to
10g (solaris 64bit).
And then I have a problem when I try to select from one of my