I work primarily in SQL Server and have run across a situatiion in
Oracle that's troubling me....
I have a query that contains a where clause with 2 restrictions.  Both
these fields are in a composite index of 3 fields.  If I add the third

I want to implement a general logging framework for our development
team at our site, currently studying several samples and initiatives
around log4j, java.util.logging and log4plsql.
What I like to log in every invocation of a stored procedure is the

Oracle RDBMS 11.1.0.6 maintains XML version of alert_$ORACLE_SID.log,
in addition to the ASCII one. Some of you might remember that log files
are inclined to grow. To prevent endless growth which would fill up my
disk space, I use logadm on Solaris and logrotate on Linux. I can do

Due to a change in roles, I no longer have access to our Oracle dev/test
labs.
I remember OTN used to have a subscription program where you got personal
use software and media for a relatively low cost. I can't find it anymore.

How to investigate in advance if a bigger blocksize on an index
tablespace will benefit performance?
Thanks for pointers
H.

hi all, i want to Show total purchases by supplier in 2006.
and i want to nclude only those suppliers from whom we made purchases
of more than 2,000,000 during the first 6 months of 2006.
so i did the following:

Has anyone come across the error ORA-03237. I am trying to upgrade an
application and while it is modifying the schema by adding a new
column of type NCLOB it stops and throws this error:
ORA-03237: Initial Extent of specified size cannot be allocated to

I'm writing a simple update statement in Ora 9.2 and am scratching my
head as to why the following syntax is wrong:
------------------------------------------------------------------------------------------------------------
update CITI_CIRCUIT_LBCODE A

hi all. i want to Produce  total sales per month per indicated
region.
The total should include only sales of products with more than
4,000,000 total sales.

Poll:  How fast is YOUR database in rows per second, on a full bore
table scan???
This is for those who like Tom Kyte's work, and empirically get their
metrics.

Have 9i on RedHat 3.8 and if I carry out a dbors stop it hangs.
[root@carbon init.d]# ./dbora stop
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jan 10 11:29:34 2008
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

I have started to test Oracle 11g.
I have scripts in place that read the alert log already.
The log goes into a new location in 11g.
Has anyone found a way to put the log back in its original position?

I've installed Oracle Express Edition on a Windows 2000 Advanced Server SP4.
The installation work fine but when I try to open http://127.0.0.1:8080/apex 
I get the following error: cannot find server.
What can I do?

1)  What are the real bytes per value (RAM) associated with each
element of a Varray of NUMBER? (Of INTEGER, of PLS_INTEGER, of
VARCHAR2(20) etc).We are using arrays with more than 1 million
elements and often get PGA usage in the gigabytes.

I have the following problem concerning memory of Oracle 9iR2 processs
on a RHEL 4 Linux box: I have observed that the 24G RAM memory on the
Oracle box is pretty full most of the time (c. 98%) and since the box
is used to host Oracle processes only it comes as no surprise that