My company has the need to manage data for multiple customers. High
volume concurrent read and write access will be required to these
databases, so I'm trying to determine what hardware scenario is best
to support this requirement. Each database will be approx 0.5Tb in

I posted this about a week ago and am still having issues trying to
improve this query.
This is a nasty query here which I'm hoping to make smaller by using
some joins.  I got help from here before, so while I'm trying to do

I have a REAL nasty query here which I'm hoping to make smaller by
using some joins.  I got help from here before, so while I'm trying to
do it, I was hoping some others can look at it also.
Thank you,

I try to tansport a tablespace from AIX to Windows (10.2.0.3)
convert with RAMN is OK
When I import metadata to the windows database I get the error below
Can you help me ?

Systel is an IT Solutions organization, which offers a variety of
products and services to premium customers globally. With its
relentless focus on customer satisfaction, acquisition of the best DNA
and robust processes, the company has moved from strength to strength

I have three table with the following structure
DomainTechDetails(DomainID,DomainName, ....)
Domains(DomainID, CustomerID, ...)
Customers(CustomerID, CustomerName, .... )

Let me first describe the tables I'm working with:
table1 with these columns:
user_id cat_id more_data even_more_data
table

Hi folks, Go and get a copy of Secure Auditor which is a unified
digital risk management solution and provides 30 tools in 1 package.
It performs scan and audit on your windows based machine so that you
will be able to identify the weakest link in your network. It helps in

I have a question about oracle10g. How can I get the bind variables?
Here is a description of the situation:
1. A java process starts a stored procedure via jdbc.
2. The procedure has a number of bind variables as input.

referring to this section:
http://www.oracle.com/technology/obe/11gr1_db/manage/dbconsole/dbcontrol.htm#t1t5
on the Schema tab - upper right section "Users & Privileges" is
missing

We have an application that stores operational data as a single master
table and a set of child tables. Based on the class of data, a
different child table gets joined in e.g.
master inner_join pets -> gives us pet data

We have discovered in the alert.log some ora-00600 in our Oracle
Database 10g (10.2.0.3.0) on Windows 2003 Server. The database is
running, but the error is generating a big amount of dump files.
In the dump files, we found the following information:

For DB2, I can use 'db2ilist' to list all created instance in the
server.
Is there any way in oracle to check and display all created instances
in the server even though they are not started?

I installed oracle and created ASM disk group 'DATA' with some raw
devices in linux. Since it is a test environment, I uninstall all
oracle software and reinstall them.
I am now running OUI and stop at 'Configure Automatic Storage

I find that many spfile and pfile coexist in one system. How do I know
which one is used by the DBA to startup the database?
If the database is started, I can type "show parameter spfile" to
check the location of spfile. But it show nothing if pfile is used.