I am learning Oracle Grid Control.
If my server is down and I configured Grid Control to send emails to
me, I can sepecify it send it to me every 15 minute and repeat say 100
times.

So my work for the next few weeks is sorting out how to merge 2 almost
identical databases used by 2 almost identical applications into one
application with one database. These applications were developed for a
client.

I have this query:
SELECT customer_id, co.order_id, p.product_id, ol.status, p.code,
p.subproduct_id,
 FIRST_VALUE(ol.status)

I am beginning to like these analytical functions.  Especially with
10g they seem to have a lot of options.  Anyhow, I have a simple query
like this:
SELECT s.customer_id, c.signup_date, s.produst_id, s.status FROM

I am trying to get the same resultset  with an original query but one
last column less.
For example the original query is "select x,y,z from table1 where
condition1".

I am learning Oracle, my PM asked me the following question, Please
help me on this :
You are a new employee at the company and the only Oracle DBA.
You were just informed by the management that one of the Oracle DB

I am wondering if I can create a complex query in oracle that
simulates an Access crosstab.  The data is comprised of measurments
created from fish scales.  The output is based on the water type 'F' -
Fresh and 'S' - Salt and the Age of the fish, 5th and 6th characters

Oracle 11.1.0.7 has some undocumented new parameters. I was unable to
find anything on Metalink or Google. The parameters are:
cell_offload_compaction
cell_offload_parameters

Does a VARCHAR2 input parameter to a stored procedure have a max
length?  I pass a 465 byte string to a procedure receiving it as a
varchar2 and it gives some error of the string byte too small or
something.

happy crackin'!

I created a startup on database trigger
to activate the outline at startup but it doesn't work
do you know why ? (Oracle 9.2.0.4 on windows)
Thanks in advance

I am testing a 2 node RAC setup and want to try using a SAN for the
dedicated storage (instead of a dedicated local storage disk array
located within the same frame).
Are there any "gotchas" that I should be aware of when using the SAN

The patch number is: 6890831
Patch cannot be seen yet in the Metalink patch lists  (I really, really do
hate flash, with passion!) but can be downloaded if addressed by number.
Happy testing.

SELECT      sid ,event,state,
              seconds_in_wait siw,wait_time,p1text p1txt,p1,p2text
p2txt,p2,p3text p3txt,p3
  FROM        v$session_wait WHERE       sid = &sid