In Oracle 9i on a Solaris 8 system can someone please explain what the
benefits of gathering database stats are?
I am asking in relation to using dbms_stats.gather_database_stats() .
I have heard it can make DML more efficient and add information to OEM

i am  using oracle10.2.0 version on windowsXP.i open sp file once.
i got a proble to start a database..
the following two errors are comming ..
1.ORA-01078: failure in processing system parameters

I would like to start a shell script directly from a listener
connection. The "spawn" keyword is a solution and I would like to know
if anybody has a listener.ora sample on how to do this.
Best Regards,

We recently did a database upgrade from 9.2.0.2 to 9.2.0.7 on windows.
Our Labview connects to this database using ODBC (version 9.2.0.6)
Labview retrieves a ref cursor from a function in an oracle package.
The ref cursor points to a dataset containing a number field ( with

I've got a small database on a 10g server that needs to be loaded into
8.1.7.2  - basically I've moved cities and need to finish a small but
nasty assignment.
Been advised that 10g datapump is not backwards compatible.

 They are a neophyte is of the newsgroup that of oracle, I make excuses
myself in advance payment if sara po impreciso in exposing a my problem.
I am trying from various time to install Oracle 10g PE on a computer
with windows 2k sp3 with two partitions from 10gb and 250gb the ...

All,
I've designed and implemented a phone integration system that accepts
caller information on the CTI server and then calls a stored procedure
to keep track of the caller information.  The stored procedure calls

SVRMGR> connect sys/change_on_install@orcl
ORA-01034: ORACLE not available
SVRMGR> connect sys/change_on_install
ORA-01034: ORACLE not available

We have 64 bit Hp-ux. RAM on my server is 4gb.If I set SHMMAX  to 1 Gb
and I have 3 databases on the server. What is the limit of SGA for all
the databases? Is it 1 GB for all or 1 Gb is the limit for one database?

Hi, all.
I am running 8i on AIX.
I have a listener which I've recently secured with a password.
I have shell scripts which I use to shut down the database and listener

i'm trying to convince oracle to use large pages on AIX 5.3 but haven't
suceeded so far.
i set v_pinshm=1, maxpin%=80, lgpg_regions=448 and lgpg_size=16777216
using 'vmo' and 'LOCK_SGA=true' in spfile. after rebooting and starting

visit http://www.dbnest.com/dbexperts.php?currentpage=21
Saghir Taj
MCDBA
ww.DBNest.com: The Nest Of DB Experts.

I have a dmp file created with exp on 8i.  The file was created with full=y.
I would like to imp the user accounts, including their passwords and
profiles into a 9i database.  I would like to not bring in all of the
schemas, so I would prefer to not use full=y in the import.  Is ...

Has anyone done this?
I backed up my RAC database using rman every day with full option.
When I restore / recover the database to other server (dev server,
single node), it keeps give me this error

Ok, problem here:
We copied one of our databases onto the test server.......
I asked our jr. dba (mistake there) to change the SID and get the
database up.  Apparently after changing the init.ora and directory