Im trying to eliminiate full tablescans from 'top' sql querries on our
database system.  I was led to believe that full table scans on very
large tables was a big 'nono'.
However, I'm finding that running Query 1 below only takes approx. 1

Can both the original database and the copy of the original database
reside on the same box using Data Guard?

I would like to compress some Oracle tables to see how well they can
compress.  Is there some sort of a guide or rules for how well tables
can compress based on their datatypes?  I know that some of our DBA's
have managed to compress tables up to 70%.

I'm not an affluent oracle dba. I've been hammering on this for a week,
and I stll can't solve it.  I'm hoping I can find some help here.
We have a VPN to from  a local segement to a remote segment  in PA.  It
is wide open temporarily for testing the problem.  There are 2 UNIX

we are running a OMS on a Oracle 9.2.0.5 Database and 2 production servers
with Oracle 9.2.0.5
Now we must change the hardware (new ip-adress,...)
1.) Can someone tell we how to change the hardware

Do anybody have the study material or dumps for 10g upgradation or any
link to it.
Any help will be appreciated.
SAMEER

All the docs I can find at OTN say that Solaris 8 or 9 are required for
10g.  We would like to use Solaris 10 (sparc); is this something we'll
need r2 for or are others already doing it?
thanks,

AdventNet introduces ManageEngine Applications Manager 6 - an
affordable and integrated Application, Server, and System Monitoring
Tool for Enterprise IT.
This release also includes a Free Edition, with which you can manage up

I am a complete newbie to Oracle (and has started learning right now).
I just installed Oracle 9iR2 into my server machine.  What are the minimum
configuration steps I should do to setup the JDBC drivers in the client
machine?  Where to obtain the drivers?  What configuration ...

I don't have much experience in stored procedures. I'm having some trouble.
I'm creating a java program that would compute statistics from the current
schema in the Oracle DB.
Here's the main code below

Maybe it's a dumb question, but ... is it possibls to turn on archive
logging only for specific tablespaces?
thanks,
stephan

Ho to check that licensed mode has been chosen in oracle server (per user or
per procesor) during installation

Hi, in Oracle 8.1.7 there was a demo directory. In 10g the demo directory
orahome/demo exists but a lot of the old demos have gone. Possibly our DBA
did not install them but where can I download the demo for 10g. Please don't
reply www.oracle.com.

How to check in oracle database licensing mode (per user or per procesor)
Release 8.1.7.0.0

Hi, new to RMAN and have a few questions. Using Oracle 10g on AIX 5L.
My plan was to implement RMAN hot backups, full, every night. The
backups will be run to a disk staging area, which will later be backed
up to tape using TSM. If I'm doing full backups every night, what