Hi, 10g on Redhat. I am reading the following. I want to limit the number of
sessions a user can have. The Oracle documentations say this is the way you
do it:
create profile proftest limit cpu_per_session 100 sessions_per_user 1

I was wondering if the following setup was possible:
- Primary Development server on box A
- Primary Test server on box A
- Primary Production server on box B

Does someone know *when* the engine decides to (or what makes
Oracle choose to) add a session in its 'long operations' views,
i.e. to add a 'long ops' SID into V$SESSION_LONGOPS ? What kind
of calculations is it based upon ?

How Dare Could America Industrial Property Office Be In Conspiracy With
Jungang International Patent Office To Make An Extravagant
International Crime ?
Currently a Korean party now holds the American patent 4919933, the

I'm having a little trouble understanding the EXISTS operator.  Why do
the following SQL statements return a different number of records:
SELECT t.id, lt.id
FROM table t, link_table lt

Hello world,
(how) can I monitor the sequence of SQL commands of a session? I'm not
interested in statistics but in the exact sequence of commands. Can
this be done with Oracle commands? (I'v found sth. to do this in

I have a stored procedure that takes a blob as an input parameter.  I
check to see if the parameter is null by using    CURSOR passCur IS
     SELECT NVL(PASSWORD, 'P@ssw0rd')
FROM DUAL;

What's wrong with this code? I want to be able to replace instances of the
ampersand character with the string "AND" but this code seems to go into an
end less loop and updates nothing.  The query in the cursor works on its own
so there must be something I'm missing with the loop ...

Where can I find Oracle EE 8.1.7 dla Sun Solaris (SPARC)? I tried on
Oracle.com but found nothing.
Regards, Greg.

I have a simple question - If I have 2 tables, 1 small and 1 large,
what are the implications of the table order if I'm using a hash join?
Does it matter? Oracle has got to create the hash keys on both join
columns anyway. What about if the large table is too large to fit the

I'll have to set up some sort of connection from an Oracle 9.2 (Windows
- server) to an Sql Server (also Windows - server) in order to read
data from the Sql Server.
I'd planned on using 'Gerneric Connectivity', but - AFAIK - this

Altough i have set filesystemio_options=setall and mount the file
system by using forcedirectio , truss output of oracle processes shows
that files are opened by using o_dsync:
open("/data/oradata/spssdata01.dbf", O_RDWR|O_DSYNC) = 13

We're doing some basic research on how corporate customers evaluate
Intel/AMD servers. What we're trying to figure out is if vendor
characteristics (service, reliability, etc) are more important than
system characteristics (feeds & speeds) to real world customers. . We

I´m new to Oracle and have a problem when i try to create a trigger.
Is it possible to reference the values that should be inserted?
If yes, how is it possible?
Here is my code:

Using Oracle 9iR2
I have this problem whereby I want to read from 10 tables that have FK
and the data is always changing.  Therefore I use the option SET
TRANSACTION READ ONLY.  Works fine.  But now I want to read these 10