I want to install Oracle 9i EE on Suse 10.0.
Any experienced people about this? Cookbook maybe?
Thanks in advance!
Best regards!

Very odd that the word shape is used so much in the db world but the vendors
do not use it and it is not in the glossary of any oracle document.  One
person said 'shape' can't be defined.  Like I said, very strange that a word
that can't be defined is used so much in oracle app ...

I have a database, which is backed up (as yet) in the user managed way,
resulting in having a couple of datafiles and an increasing amount of archived
log files.
Question: is the *undo tablespace (file)* also necessary for a a restore of the

I am starting to think that we will require a patch for our Oracle
databases (all versions, all platforms) to deal with the change of the
start date and end date of the daylight period (longer period of DST).
I can't quite convince myself that we would need a patch to deal with

All,
I can not work out the proper syntax to extract the hour from a date
column in my table.
Examples I have found select from DUAL, but I want it from a user table

I have the following query, which returns dates, but those dates
contain leading zeros for the DD part, even though I'm using the
fill_mode FM, i.e. FMDD
SELECT

I am new to oracle and would like to know if oracle server 9 and 10
come with any utilities to get a table view / form with cursor
capablilties. A tool such as Informix's isql and dbaccess gives you a
simple menu drivin program in an xterm window. You can generate table

We got this error second time now. All we do it bring d/b up and it
works fine.
I've looked in .TRC file and found following:
-------------------------------------------------------------------------

We use DBMS_TRACE, but currently I am finding few limitations for the
same, please le us know if there is way out.
DBMS_TRACE shows output in SYS.PLSQL_TRACE_EVENTS table and it helps me
to know

From the PL/SQL packages doc:

Users complain about a recent drop in response times. I did a statspack
report. Would someone take a peek and see if there is something unusual in
it?
Snaps were made about an hour apart. During that hour i used one of the

running 9.2.0.5 on AIX5 with compatible parameter set to 8.1.7 and
using DMT.
Everything I've read so far was that dbms_stats was the best thing next
to sliced bread. I just read in a manual though that it doesn't update

Oracle 9i or 10g.
I have a question about how pl/sql program accessed in the shared pool
memory.  Let's say I have two schema owners (S1 and S2), and each of
them has it's own procedure ProcXYZ.  S1.ProcXYZ and S2.ProcXYZ are the

Following query is talking high CPU, using Oracle9i on windows:
SELECT t1.cessation_date, t1.commence_date, t1.confirm_date, t1.alias,
      t1.birth_date, t1.emp_card_one, t1.employee_id,
t1.employee_name,

I have this records:
AAAA
AAAA
AAAA