I think I made a post a while back after we upgraded to 10.2.0.2. We
had horrible performance issues. Sql plans were the same and had the
same amount of I/O going on, the server just couldn't handle it. Long
story short the only solution we found after 5 weeks of going back and

Morning all,
I'm a reasonably experienced oracle developer and just starting out
with XML. My comfort zone is really around large batch applications.
My goal is to expose functionality of my back end database via web

I have a couple of hosts in GC that have thousands of open alerts and
I'd like to clear them all in bulk. Is there a way to do that? The
closest thing I've found in GC is to go to the critical alerts page and
click on "select all", then "clear alert". The problem is it only

Has anyone come up with a way to get around the lack of escalations in
Grid Control?
Thanks,

We are using oracle 9208 on linux AS 3.
Our sysadmin always shutdown our server without shutting down the
database.  I wrote a database shutdown script.
How can I make my script automatically run before the system shuts

In another thread I was reporting how a query I do with bind variables
performs worse than an equivalent query done via strings.. One person
responded that a more recent version of Oracle improves upon this. I
started a new post because I wanted to ask about that... I definitely

10.2.0.2 Ent Ed, Aix5L
I just installed xml database and was checking for invalid objects and
found two operators that are listed as invalid.
select owner, object_name, object_type from dba_objects

I have two tables "A" and "B". Table A has columns named "a" and "c",
table B has "b" and "c". Note, that "c" is in both tables! (In my real
application, both tables are more complex and have about 20 columns.)
Oracle has no "LIMIT"-condition like MySQL, so I need subselects as

Did somebody used the EMC technology called "SRDF" (SRDF/A) with oracle for
a disaster recovery site ?
Let me know. From metalink the not synchronous modes does not seem to be
supported.

What options do I have for refreshing stats when using a datapump
import ( at schema level ) ?
My current plan is to gather the stats after the import

Hello experts !
I'm looking for Oracle 8.1.6(or Oracle 8.1.7) for AIX 5L strictly for
education purposes (I'm CS student with an old RS/6000 only 32bit capable
machine trying to learn Oracle+AIX software combo stack; Oracle 9 and

After seeing our tablespaces filling up time and again, here's the
script I wrote to monitor their free space.  Works for both fixed size
and autoextensible tablespaces.
Thought I'd share.

I have an appl server farm
On top there's a webcache loadbalancer, which divides routes to the 2
webcaches of
the local IAS instances

awe_window_memory
I am using Windows 2000 Advanced Server and my database version is
Oracle 9.2.0.6 32 bit.
I have read many articles on metalink on using /3GB and  /PAE (AWE) on