I have a situation where I have a materialized view/log to refresh on
commit on a fact table that is subject to archive considerations. The
fact table is partitioned by date range.
Now, the materialized view has very few rows and therefore not

There are two identical oracle 9.2 db's running identical software and
basically amount of transactions is same - still there's a huge
difference between archive log amount generated in these db's.
Logs generated from other db is something like four times more ....

I am doing maintenance on a 9i forms application that we are migrating to
10g. It mostly works without change, except for a FRM-92100 exception
that did not occur under 9i. In order to debug this, I need to better
understand how control flow actually works, e.g., the order in ...

In 10g Oracle introduced view DBA_TAB_STATISTICS. Many columns are
identical to those available
in DBA_TABLE (NUM_ROWS, LAST_ANALYZED), but there are new columns, in
particular:

How can you make min() throw no_data_found?
select min(datex) from tablex where x = 1;
With min(), I never get a no_data_found exception.

Merry Christmas
We celebrate the birth of our Lord Jesus Christ, and we remember the One who
sent His only begotten Son - our God the Father who art in Heaven.
I pray that you would experience His love for you and His presence in your

Hoping someone can explain why I am running into the issue seen
below.  I do a select count(*) from sys.aud$ and get one number, but
when I do a delete using the same where condition I get a
substantially different number of records to be deleted.

I need your help in a SQL tuning exercise:
SQL:
=======
select /*+ gather_plan_statistics index(ag,PK_AD_Y) */ count

I am currently auditing "GRANT ANY OBJECT PRIVILEGE" and "GRANT ANY
PRIVILEGE". That works well if I grant privileges of other schema
objects to others.
I would also like to audit in cases where a schema grants its objects

in a large table OUR_TABLE we have a calculated index for a persons-name
with a simple soundex function OUR_SOUNDEX in the same schema (OUR_SCHEMA)
like the table, thats different to my "select"-schema (WORK_SCHEMA):
...

how to overcome with this error???
SQL*Plus: Release 8.0.3.0.0 - Production on Tue Dec 22 20:26:57 2009
(c) Copyright 1997 Oracle Corporation.  All rights reserved.
ERROR:

I have a few doubts on creating Materialized Views (MV).
Please clarify them [ Database is : Oracle 10gR1 (Datawarehouse) ] :
1. Can we create MV with rownum as one of the column ?
for example :

I am using Oracle 11g 11.1.0.7 on HP UNIX 11.23. My database has been
running in archived log mode.
Yet when I go and look in v$archived_log, I see some archived logs
missing,

We need to recover some data from backup.  Unfortunately, the
application has a job that purges old data.  Is there a way to restore
from backup but have the jobs not run.
Thanks

Hi Friends,
I have one insteresting performance issue about 11.2.0.1. Any comments
are appreciated.
When I use A JOIN B and A JOIN C, the optimizer choose index scan on