Probably a dumb question here, but we're trying to understand
DBMS_STATS and all the parameters and such.  What a complicated
thing.  Too many parameters to understand the effects.
Anyhow, I read that Oracle 10g generates database stats each night.

Can anyone help me understand following:
**********
SQL> select MAX(NEXT_CHANGE#) from V$ARCHIVED_LOG;
MAX(NEXT_CHANGE#)

HI all, I'm trying to use the collect() function (mentioned in my
earlier post in this ng) but it, well, collects all values. Is there
any way of avoiding duplicates?
What I'm trying to do is this:

how does oracle do it, if it does that without buying advanced
compression?
Thanks
Suri

I'm running a simple select stmt thus:
select A.value, b.value
from A, B
where ...

A couple of weeks ago I noticed that if you tried searching this news
group via the google groups interface ... only recent stuff would come
up.
I was hoping that this was just a temporary glitch but it sure looks

I've been searching around and I'd like to know if anyone can
recommend a decent tool to generate a Database Schema Diagram from an
Oracle DB. I have an existing database that is very large and complex
so generating a visual to explain it's current tables and their

Thanks in advance for any clues! I'm trying to edit an existing stored
procedure in Oracle and need to know how to code using SUM in this
scenario:
SELECT

We need to track work items across several existing applications. Items can
start as a document on disk, can be renamed or moved, converted to a task
in an application, until they reach a certain state. The applications know
nothing about preceding or following applications and ...

A group of us in the Seattle area have established WWOUG: the Western
Washington Oracle Users Group.  Our website is at http://www.wwoug.org.
We are a grassroots organization with the goals of promoting
networking, education and collaboration in Oracle technologies in out

I'm a develper of a j2ee based web application that supports mutliple
databases (oracle obviously included).  We access oracle via their
JDBC driver.
We have several tables in our database that store time based events,

I've a request that is like:
select l1.bill_id
from file f1
  join file f2 on f1.letter_id = f2.letter_id

I have got a next problem with TNS Listener.
I have two servers in LAN. When I connect to remote server by SQL
Navigator, Oracle Enterprise Manager - all is ok.
When I connect to my local server - connection established, by TNS

In summary, I completed an import which took five days into a test
database. The import completed successfully. I then swapped UNDOTBS1
to UNDO_TEMP tablesapce so that it would be much smaller. However,
UNDOTBS1 then reported that it needed recovery :( I tried to drop

All,
I would like to know
in Oracle 10.2.0.4:
if I have below SQL: