Hi!,
 I tuned the SGA_MAX to 3G.  Then, the database could not startup!
How can I do now!  Help!
Ming

How to get the DB activity report (like sar in UNIX), like number of
queries, history of queries, % utilization of SGA_TARGET, %
utilization of CPU, %IO, etc from within Oracle 10.
Can the info be obtained via sql queries against Oracle admin views? I

Been looking for documentation to answer this question but haven't found
any so I thought I'd ask here.
Suppose you have two sets of file name conversion strings in
db_file_name_convert for a database that you're cloning. What happens if

I know you are going to say that it all depends on the O/S, but if you
can forget that for the minute, does it matter what the CPU is when
your are compare the Intel Xeon Quads, AMD Quads and Sun SPARC chips.
Does the cache make a big difference, since you think then SPARC /

We are considering upgrading our Enterprise Edition database from
10gR2 to 11g.
My instinct tells me that its a bad idea to upgrade to the first
release of a major version.  I've been burnt in the past by upgrading

I'm running Oracle Linux and I'm trying to create raw devices from our
EMC San.
I added entries to /etc/sysconfig/rawdevices after fdisking the
emcpowerx luns:

This should be so simple, yet it is not working.  I am trying to do an
insert into a table where the values inserted are gathered from a select
from another table.  This form works:
insert into table2 (select fld1, fld2, fld3 from table1 where blah)

10.2.x on Linux ...
Is there a "neater"/more efficient way of selecting the maximum value for
a column based on the maximum value of another column.  Gods that reads
poorly, I'll try an example ...

I have a script test1.sql that has the queries that do the record
count in the tables.
When I run the script in SQLPLUS using @C:\test1.sql, I only got the
result, but I want to print the queries too so that I know which

I need to test if an entity exist in a document set. For instance, test
if there is any "Location" in a given set of 42 documents. I don't need
to retrieve the actual rows, the count or whatever, but just the existence.
Query A (get all Location in the corpus):

We are on 10.2.0.4 on Linux SLES-10 (64-bit) and we are analyzing the
IO setup of an OLAP/DWH system (about 800GB in total). We have a large
table of about 50 GB in size and it is stored in its own tablespace.
Now the question comes up whether few big (say 2 x 25GB) or many small

I have a statement that executes in SQL*Plus but not within Pro*C.
I'm guessing it has to do with where the nested select is (I know it
works from the where clause)
SELECT foo, (SELECT bar from baz where id = 1) FROM table1 WHERE ....

Is there a way to write a sqlplus batch file to "recompile all invalid
objects", or at least compile a specific object? I know the capacity
exists in TOAD but I have no idea what's going on behind the scenes...
Thanks!

10g
Here is an unusual need: some users with read access to a table must
see the data in some specific columns as gibberish, while other users
still must be able to see them as clear text. It has to work with

I am trying to develop a report to call an oracle stored procedure
contained within a package and am having major trouble in that crystal
cannot seem to determine the output ref cursor at all...  I think I
have tried just about everything!!!