What is the tool to monitor all sql executed say last a couple of hours?
I have looked at TopSQL but this doesn't produce what i wanted.
Thanks in advance.

Apparently I am missing a step in the process of working with nested
tables, so I am wondering if anyone can help me out.  All examples I
look at look the same as mine, so Im not sure what the problem is.
Here is the setup:

Is there anyway to know how many days have passed between two dates?  I
have a table with a date (day application was submitted) I need to
compare that with today's date and see if a week (7 days) have gone by
since then.

In a very large scale production environment, typically how many
session might you see open on an Oracle instance at any one time?  I
know it's probably highly variable, but what's the most you have seen
it?

How can i log all queries sent to Oracle 10g ?
Thanks a lot
Francois

At the moment I am working towards an Oracle server through Microsoft
SQL Server Reporting Services and I've been stuck with an "ORA-12704:
character set mismatch" error for a while now. What I'm trying to do is
to run a query using multi value parameters from Reporting Services to

I have just spent the weekend moving Oracle7 and Oracle8 instances to a new
server.
The company I support as DBA, still use these versions as :-
choose from

Hi: everybody
just say hello to you guys. of course I need some help from your
suggesstion, I am a oracle DB developer, recently join a project, one
query I am currently working with is to join 9 tables together, the

this might be a stupid question, but anyway, I have to ask before doing
anything wrong.
I have no tables or sequences or anything else in my tablespace.
I dropped everything.

I am trying to check if  a primary key already exists in a table
(Oracle 9i) having a few millions of records. Which is the best way to
check that and avoid duplicate inserts?
Thank you.

I'm experiencing "db file sequential/scattered waits" problems on a
8.1.7 database on a Windows server. I'm pretty new to Oracle
Administration (and to DB Administration too), however it seems altering
the number of "freelists" on specific tables and indexes could help.

I'm very sorry if this has been hashed here several times before.  I
honestly have been searching the web and newsgroups for hours today for
answers.
I'm somewhat new to SQL (about 8 short months under my belt) and my

I have an excel file containg a data set which I want to link to a
table in oracle. Normally I would just create a table and load the data
from excel. In this case I can't do that because I don't have  create
permission on the database. Is there a way to work around this? I'm

Hello Fellow Oracle Users,
Is there a way to report possible Oracle bugs
to Oracle without having an Oracle license?
I am testing the free evaluation download

We have an Oracle database (enterprise edition) installed in our IT
department. It's just running as a back-end storage system and the IT
department do nothing else than making sure that it's backed up. So
we hold no in-depth knowledge about the capabilities of the database.