I was thinking on working on this media failure scenario.
Lets suppose i have taken the Backup of my Control file. After backup i
add a Tablespace. Then i delete my control file simulating media
failure. Can i recover my database from the backup of the control file

My understanding is that the cost value for "SELECT STATEMENT" at the
top of the plan indicates what the optimizer estimates to be the total
cost for the entire statement.
If this is true then how do I interpret plans that show low cost for

Howdy,
Which file systems/volume managers are folks using with their Oracle RAC
10G Solaris installations? We are currently debating deploying ASM+RAW
or Veritas clustered VM/FS. Any know issues with either of these

I have a database in archivelog mode. After making a consistent backup
with RMAN, I deleted all archived log files. New RMAN complaints that
it cannot find the archived logs when I do a 'backup archivelog all'.
How do I tell RMAN not to care about those archived logs? I think I can

Sorry guys but I am totally ignorant on oracle matters.
I need some guidance in how and what is needed to connect directly to an
oracle 7.3.2.3.2 database on a OpenVMS operating system with a database
application developed on a Windows XP PC using DB2K.

Sorry guys but I am totally ignorant on oracle matters.
I need some guidance in how and what is needed to connect directly to an
oracle 7.3.2.3.2 database on a OpenVMS operating system with a database
application developed on a Windows XP PC using DB2K.

I use analytic function to calculate running sum, but I found the
result is strange.
SQL> SELECT DEPTNO ,ENAME ,SAL
 2   ,SUM(SAL) OVER (

Any suggestions for keeping non-DBAs from browsing through the alert log in
order to "help" the DBAs?
Thanks.

I have taken over some PL/SQL code which is deeply indented.
Some lines have 10-12 tabs before code appears on them. I want
to minimise this. I don't even mind introducing an
"indent_help_exception" for this purpsoe.

Oracle is a widely used Database server for most of the applications.
But, it looks like, directory basesd servers are the clear choices when
it comes to Distributed architecture systems. In that case, I would
like to know what exactly are the things that Oracle misses to provide

I've worked as a programmer and a bit in network admin, but now I'm trying
to learn DBA responsibilities. I've installed 9i on a test machine running
XP Pro SP2 (unfortunately, this box doesn't have enough firepower to support
10g).

Hopefully a simple question.  I have Oracle 8.1.7 installed on my IBM
AIX 5.2 server.  The server only has 1 GB  of RAM and a 2G paging space
(I'm thinking that is not enough memory).  Anyway, I was wondering
about the size of the SGA. On this one server I have a test database

I'm upgrading my database server hardware this weekend. On the new
server, I've created a standby database and
logs are being copied over and applied right away on the standby. I've
scheduled a planned downtime

could You pls help me with one select?
I can't find how to get select of all groups for specific user with specify
are following roles Defoult or not for example:
Role1 Default