Hello list,
is it possible to create a 11gr1 rac database on grid 11gr2? i thought
it is possible but i get errors while trying it. dbca fails while
trying to start the instance:

When you issue and ALTER TABLE command and put a table into the KEEP
pool, how can you get a list of table that have been put into the keep
pool?  Is there come X$ view?  I cannot find a v$ view.
Also, will these tables automatically reload into the KEEP pool on

One of the Oracle 10gR1 Production Server faced few memory problems.
Few details that i got regarding this problem are as follows :
It seems like the server process private memory seems to have
exhausted.

So I recently ran down a really weird problem we were having on one of
our production 10.2.0.4 servers.
To make a long story short, recently during the RMAN backup window,
the database would go into a "locked" state and all transactions would

I have a table T1.
I have 5 partitions in that table, say : PART1, PART2, PART3, PART4,
PART5.
I need to take individual row count for these 5 partitions present in

I have a table with transactions of customers. There are about 20
transactions per month for a customer, I need to store history of 24
months. There is about 1 500 000 customers. Average length of row is
300 bytes.

I've been asked to investigate how to best build an Oracle DB that
will be able to handle the insertion of 500 million rows every 8 hour
work day.  The data will be batch inserted via sql loader every few
seconds, into two main tables, distributed about 8:1.  Each table is

In DB2 you can do something like the following:
SELECT *
FROM MYTABLE
WITH UR;

I've got an application being put together with cake/php.  It's
pretty nice, but their data pager does this:
   SELECT COUNT(*) AS COUNT
   FROM foo f

My scripts looks like this .. when i execute this script its says file
does not exist even though file is present physically and if the file
does not present in the file system then the output is null.
I am wrong somewhere .. ??

we use Oracle 10.2.0.4 on Windows 32 Bit platform and run sometimes into
ORA-4030 problems.
Current memory settings are :
sga_max_size : 1504M

We're on 10g.  We're playing with the Keep Pool.  If the Keep Pool is
meant to keep frequently used blocks/tables in cache, well, if they we
frequently used, wouldn't they be in the cache anyhow??
So, what is the purpose of the Keep Pool??

The "ALTER SESSION SET CURRENT_SCHEMA" used to only influence the name
resolution. In version 10.2, it also influences the owner of the newly
created objects:
Connected to:

10 Reasons Why YOU Should Join Us
The Most Proven Leisure Internet Business.
Business that earns you more money every day.
Thanks to the power of the Internet.

Do you know of any newsgroups where I might ask about performance related
questions. .
Database Version
============