I am writing a tool to repeatly display the v$system_event information
(the changed value), I try to display it every 5 seconds, but the query
need to run 2-3 seconds, v$system_event have only about 400 rows.
When I access v$SQL, it's faster than the v$system_event.

I am planning to setup [ for testing purpose ] RAC on my desktop on
normal/default
segate harddrive of 40 gb.
I am using RHEL 3.0. I want to know

I am getting the following message during installation of forms 6i on
windows 2000 professional and windows XP professional and the
installation process hault.
looking forward to an advice/

If I want to log into Oracle Management Console using "launch oracle
management server" I get an "access denied"-error. I haven`t changed
password of user SYSDBA. If I access the Console via "standalone" I can
connect to my database with SYSDBA\CHANGE_ON_INSTALL.

Have a Forms 6i application with patch 13 running against a 9.2.0.1.0
database stored on same machine in different home.
However when i run the application any sql statement at all return
ORA-01422. If I run the same statement as the same user from SQL*PLUS

A newbie's question. How oracle add an index on nested table. F.g.
Table Student:
   sid  sname  classes_registed{class_id, class_name}
   01   marry  {{c1, classA}, {c2,classB},{c3,classC}}

We are investigating pinning packages in the shared pool.  I don't
think I can use the DBMS_SHARED_POOL.SIZES procedure to give me sizes
of all our packages.  Is there another way to do this?

Greetings All, can you tell me if Oracle's Partitioning Option is extra
licencing for: 9i and/or 10g?
Thanks, TFD

I installed 10.2 on Win2003.
I want to open Enterprice Manager, but don't know how.
What do I enter in : http://<host_name>:5500/em (<- example)???
Thanks,

I have been tasked with creating a Ora 9.2 db and loading some data
from a spreadsheet. Not quite sure how to do this. Well install db no
problem.
Currentlt the data looks like this:

I have the following join query running on SQL and ORACLE identical
database/tables with the same indexes.  However, in SQL this query runs
in 10 seconds and in ORACLE it gets timed out after three minutes.  Any
idea in making it work in ORACLE is much appreciated.

Hello everybody!!
 We have a SELECT running over our database. We only need several
registers of a table of 800.000 values. In the SELECT when we put in
comments the ORDER BY T.START_TIME DESC line, the instruction is

I'm trying to set up an Oracle client on a Citrix-based terminal server
environment.
My environment:
- Citrix Metaframe XPe FP3 SP4 on Windows 2000 advanced server SP4

If I pin a package, modify it & re-compile, what is the status of the
pinned package?  Does it become unkept automatically?

I want to use a collection (a nested table in this case) in my
pl/sql-program.
I have to execute the following steps (for many times during a
session):