Most of process time of ETL Jobs is due to simple minus queries against
partitioned tables like this
SELECT DISTINCT x
FROM A

When looking at db code, I find the word 'shape' used a lot, for example, in
java there is a method 'getHostVarShape'.  However, it is not in the oracle
glossary anywhere.
I was wondering what the precise definition of 'shape' is?

we have a distributed system which is based on a Oracle Database 10g,  and I
have read that rollback is supported by Oracle DB, but  now we want to
realize a "part"-rollback in this system, so only part of the transactions
should be  reversed. For example, in the last 10 minutes ...

Does anyone know what the space requirements for the ASM (10gR2)
instance are?
That is, software, its own data files but not the drives it manages for
the data database.

we have a small Oracle 9.2.0.6-database with about 100 tables and about
1-10 million records per table. Some queries runs a long time and
because of this I ran the following found in google:
connect sys/iwadissys as sysdba

Are any of you using Oracle 10g's ASM on a production system and if so
what are you finding to be the pros and cons?
To me it looks like a software based SAN for Oracle files.  I have
systems that already have a high speed physical SAN and I am not

I've created a database and, for some reason, I'm having problems with my
PUBLIC SYNONYMS.
I can person an insert statement on a table using the SYSTEM account on a
different schema using the synonym but if I try to TRUNCATE I get an error

I'm trying to install this SQL Developer on our AIX box.  It says I
need to have JDK 5.0 installed.  However, I cannot find a link to
download JDK 5.0 for AIX anywhere.......
Can anyone help please?

I would really like to learn knowledge so that I could become a web
application developer to work in e-commerce industry and/or become a
database
administrator -- in other words -- an IT professional. Could somebody

Does anyone know if I can stream from a 10g db running on Solaris to a 10g
database running Linux?  Has anyone had experience streaming to a 10g RAC?
In the end I am looking for options to migrate from my current Solaris db
platform to Linux.

I'd really appreciate some help with a PL/SQL problem in 9i. This
routine compiles fine, and seems to update the column as intended (the
DBMS_OUTPUT command shows me a UID for each row), but after the commit
I find that the column is blank (which is what it was before the

I am new to Oracle. I need to install the latest patch kit for an
Oracle 9i db we still have running.
I can find on the ORacle site a pdf doc stating that there was a pk in
Jan 2006 but I can't find a download link to it.

is there a v$something or DBA_foobar view somewhere allowing to know
easily if a tablespace is in "autoextend" mode or not ?
thx a lot,
best regards,

Hi Faculties,
 I am working as a developer DBA. I need to document the Oracle DBs i
ll be developing in terms of the functionality and schema. An ER
diagram is needed to depict the schema(s) and relationships among the

Folks,
I did oracle RAC about 2years back that time, I had used the following
- Solaris 8
- Sun cluster 3.1