my IDE has crashed while debugging a PL/SQL Procedure. After some fixes
I want to replace the procedure now, but there is a lock on the provedure
that prevent me from replacing
ORA-04021: timeout occurred while waiting to lock object PRC_AUTOVAL

i am trying to call a function inside a package. (basic operation)
I do not have the package source and it is wrapped, so i can't see the
source.
the doc only say:

I'm a java developer wanting to play a little with oracle so I DL te
lite 10g version.
JDK1.5 is installed.
The linux machine is an Ubuntu distro.

I have an ever growing discussion with a development team regarding
whether the regorg (export/import) will improve the performance of
nightly batch jobs or not.
First the history:

I have searched the comp.databases.oracle.server & tools & misc groups
with the phrase "pl/sql book" before posting this.
I already have the "Oracle Pl/SQL Programming" book by Scott Urman for
Oracle 7.3 or 8 (I can't remember the version).

Most of the examples of doing a database restore start off from a full
cold or
hot backup and then continue on with the archive logs and redo logs.
What if I happen to loose a full backup, but I still have an older full

from what I have read, i need to install oracle instant client on my linux
box and set some environ variables to get perl to talk to oracle ?
1) Engage Oracle.pm
2) Download and install instant client

We are trying to install RAC.
I have one question,  should I put archived redo logs on local drive and use
NFS to allow other nodes to access them, or should I put all the archived
redo logs of different nodes on single OCFS directory?

what's best way to get up to speed on working with the application
server? 10g
there's so much ground to cover!
reports, web portal, building applications, etc.

Can anyone help me explain what's happening here?
(Names changed to protect the innocent)
select /*+ INDEX_FFS (X INDEX) */
a,b,c from TABLE X

I have a table with filled out below data:
+------+-----+

+------+-----+

This piece of code is taking a long time. Any help will be appreicate
it.
select *
from (

Could a 10g RMAN catalog DB talk to different versions of
oracle db?
I mean, if I create a 10g RMAN catalog DB and
then when I do RMAN backup.

My eyes are starting to turn inside out.
Does anyone have a good grasp on Oracle licensing?
We currently have Oracle Enterprise 8.1.5 installed.
Is 8.1.7 considered an update or another product altogether?

Does anybody know how to predict which hash partition a value will fall
into if the hash-partitioned column is a number? I know
dbms_utility.get_hash_value works for strings, but I'm trying to find a
way with numbers.