Several years ago I was in a 9i new features class and thought I
remembered hearing about a feature that would let you test a query over
and over, forcing it think that that none of the blocks were in memory
when they query started. Is there such a feature, and if so, can someone

I am running oracle 8.1.7.4 (32 bits oracle) on solaris 5.9 OS.
I am trying to use RMAN script (this script work in other machine,
it has been doing backup every day in other production machine,which is
working).

i am trying to determine no of chars in a long field.
googled around, adapted some code, put it in a function and it works
beautifully:
function MYLEN (idx varchar2) return number

I have a dbms job to run.
The job is to be set up so that it runs on January 31st at 1:00am
every year until the server fails....
DBMS_JOB.SUBMIT(v_JobNum,       -- Return of job number

I have an oracle instance with one database. I am about to add a
database. It has completely different purpose than the first one. I am
not sure what would be best, to add a new instance or have the new
database in a new schema in the old instance. With one instance I save

Hi , every body
I have written a query
--------------------   QUERY------------------------------
select count(*) from newtable where order_tm > TO_DATE('19-SEP-05' ,

The following has been bothering us for some time now:
After you install Failsafe on a Windows 2003 Cluster,
no other user than the one installing Failsafe is able
to install new software, search for files/Folders via

TESTKINGS! TESTKINGS!  TESTKINGS!  TESTKINGS!  TESTKINGS!  TESTKINGS!
WANNA PASS THAT TEST?  DONT MESS AROUND WITH OTHER MATERIALS, GET THE
*REAL* QUESTIONS AND MUCH MORE.  PASS THE TEST THE FIRST TIME AND DONT
GO BROKE GETTING THERE.  YOU CANT BEAT THIS DEAL.  YOU GET 349 TESTKING

I have a question about db_block_size.
OS - Win 2003
D/b - Oracle 9.2
We have a reporting d/base with block size of 8192K.

If I have an existing 9iR2 database and want to install HTMLDB from 10g,
is it just a case of installing the pl/sql packages into the appropriate
schema and then creating a new DAD or are there different versions of
the HTTP listener and/or mod_plsql which are required?

We're running 10g on HPUX and was wondering whether the is a required
licence for EM.
We are currently licensed per processor (24 CPU superdome).
I realise this is a bit of a stupid question, but some of my colleagues

Can someone point me to one...
Overwhelmed by all these features I don't seem to need.. can't find a
way to do it..
Got as far as creating a diagram file, but can't seem to find how to

am stuck with an application which uses
1. VB6,TCP/IP FOR CLIENT
2. VB6,TCP/IP,ADO FOR SERVER SIDE
3. ORACLE 9I FOR DATABASE.

We use a lot of packages in the database. There are a lot of dependency
among packages in  our database. Sometimes, when developers push a new
version of a core package (changed its spec), it will invalid some
other packages. We constantly have customers activities that need call

I have to generate a schema delta between two 9i databases, and I'd be
interested in your opinions about which tools to use. I know that TOAD
and TOYS have some functionality in this area but I only have the
freeware versions so the functionality is either restricted or missing