I started Enterprice Manager Console and connected to oracle 9.2.0.4. and
found one session consuming 80% process time.
i didn't found latter data about this process :
Username

Is there a way to lock table for select.
I.E. Something a bit stronger than
LOCK TABLE MY_TABLE IN EXCLUSIVE MODE;
Tried this and on a separate sqlplus session I could do

I need to count the number record in two tables with duplicate check,
so I have:
Table a - X
         Y

I am getting amazing results from these queries. Only thing I am
changin just from table to one table. Basically I would like
to get total quantity by forecast date wise. If I use SUM(CF.FRCST_QTY)
the results are correct by date wise. If  I use

Dominant Ad Creator 2.3.2
http://www.soft30.com/softdown-154-9127.htm
Dominant Ad Creator allows anyone to create full-blown, professional
looking auction ads in a matter of minutes! The ads you create are

Thanks, Ranko.

I think I have far too much documentation to this simple audit and
still isnt working....Im doing a simple test.  Version 9.2.0 .
audit_trail = DB . Restarted the instance.
Ran as sysdba

I'm using OEM 10G to schedule a backup with my username which has
sysdba privileges.  The backup fails with the message:  Unable to
perform the backup because the database is closed.  I know the database
is up and running because I can log into it.  Any ideas why this isn't

I'm sorry if this has been discussed earlier but surprisingly I couldn't
find much information regarding this issue.
We've been using BMC SQL-BackTrack for years. We're in the process of
replacing our Sun Solaris 2.6 server running 8i by two smaller Sun

Can someone explain to me what's going on here? I recently queried my
RMAN catalog and found a lot of old backups, much older than the
configured retention period of 30 days. I run a "delete obsolete" once a
week so I was surprised to find things well over a year old on the

We'd like to finally start rman.
We have a number of not very large databases (up to 100G) running on
multiple hosts (3-6).
We'd like to buy a server and attach storage to it for backups only.

I have a table in my database which has a date column...I need to pick
up a resultset based on a where clause, identify the latest record
based on the date column and then go ahead and pick up other values of
the latest record. Here is the rough structure of the query..How could

is possible to a precise time start a job or something about for create
a TXT (.csv) file in a specific folder all from oracle?
Tnks Alen

I'm having trouble with a routine to get all rows from a remote table
using  a cursor and a DBLink.
The cursor is defined like:
CURSOR param IS SELECT * FROM table@dblink

Ciò che vi sto per raccontare è veramente eccezionale. Non è una
truffa: esiste la possibilità di arricchirsi con un semplicissimo
scambio di messaggi via rete! E' un metodo divertente e onesto per fare
un sacco di soldi: Rasmus Lino è un ragazzo danese che ha incassato in