Have a 10g database on Solaris.
Need to connect with an ordinary unix user ie not oracle.
can connect with
sqlplus username/password

I'm on 10gR2 on AIX with ASM. have DB_FILE_MULTIBLOCK_READ_COUNT=16 in
spfile. but still see different block size for "db file scattered
read" ranging from 2 to 16. Can someone explain why its ranging from
2-16? Shouldn't DBRC always be followed if it's set in SPFILE?

We are trying to upgrade our database  from Oracle 9i to 10g.
We have a CHAR(30) column in a table.
When we perform string comparisons using '='  operator (Eg.....where
col = 'XYZ' )  the trailing spaces are ignored, which is perfectly

I created two database but I have some problem :
1.How I can startup two data base or one of them ?
2.After create second database the listener  is point on first data
base ,How I can start listener for second database  ?

I have a query which is this:
SELECT cnt || ':' || t_id cnt_t_id
FROM (SELECT COUNT(*) cnt, t_id
     FROM zc_body zb, zc_type zt

I wanna add a default value which from a user defined function.But
oracle raise an error.
Could I do that? if I could, how?
Thanks a lot

We are running OEM 8i on a WINDOWS 2000 box .
When we click on file/add database to tree, nothing happens.
It used to work.
Is there some log we can look at ?

I am having some serious problems with my create data procedure. After
the CREATE DATABASE statement i run the catalog.sql and catproc.sql
scripts. During the catproc script it after a while encounters a massive
amounts of errors ending up in a fatal error whihc terminates the

how can I find out when the last synchronization of the context index
was done? I'm using the ctxsys.ctx_ddl.sync_index package.
In dba_objects I can see the creation date of the context index, but
not the last usage of the ctxsys.ctx_ddl package.

Oracle 9i 9.2.0.1.0,
Windows XP Pro
In playing around with the 9i on my desktop I've come across something which
has me a bit baffled.

Is this a safe operation? According to the docs, it should be. Any
contraindications?
(Oracle 10.2.0.3 on SUSE Linux)
Thank you. Kind regards, Y.

Have a tablespace to repair - its a new database so dataloss no
problem.
The guy who created it originally is "not available"
I get this error:

I have Oracle Sales too, but if you could let your light shine on what
the following line from the Named User Plus license means/implies, it
is appreciated (http://www.oracle.com/corporate/pricing/eplext.pdf).
"Automated batching of data from computer to computer is permitted."

I'm trying to update a materialized view:
EXECUTE DBMS_MVIEW.REFRESH('NED_PRODUCT_CARD_MV', 'C');
This commands hangs for a very long time (no idea if it'll ever
complete). Hm, reminds me of the halting problem.

I'm running under 10.2 database on AIX5.3L
I have disk group ASM_DATA which has 100 SAN equi-sized (256GB) disks/
luns. with MBRC of 16 & Block size of 16K , When I read a table of
10GB via FTS, what should be my I/O size/lun ? Should my I/O size be