I have a strange problem on Oracle 10g/Red Hat Enterpirse 3
One of the user's session was accessing some procedure in her own schema,
which was preventing her from recompiling it.
I tried to do "Alter system kill session 'sid, serial#', but the session

sorry if this is a newbe question
i have this query
select PAGO.*, PAGOTELEFONO.*, REVERSION.* from REVERSION,
PAGOTELEFONO, PAGO, NOTA, CAJA where 75 = CAJA.IDRECAUDADOR AND

My laptop, running XP Pro, came with Oracle client (ver 8.1.7 I think)
already installed. I can access a database on a Unix Server on the
laptop. Now I want to install Oracle Server on the same laptop.
I would like to access either the Oracle server on my laptop or

Is there a more detailed view to v$locked_object that shows you which
rows are being locked?  If I query v$sql based on the sql_address and
prev_sql_addr from v$session or query v$open_cursor I can't see the
statements holding these locks.  All I see is SELECTs.  I'm on 8.1.7.4

How can I verify if Oracle 10g running on RHEL 3 AS is running on 64
bit mode or 32 bit mode?
Also the x86-64 installation guide does not not talk about
"runInstaller" asking if the DBA wants 64 bit Oracle 10g installed or

DOes every user have the possibility to create tables in SYSTEM
tablespace ? If yes how can i prevent it ? If not what 'block such
command' (privilegdes or something like this ?) ?
Thanx

i believe with some release of Oracle there was intruduced a command
which combines insert/update of data into a table.
What we do is:
insert into ...

I'm trying to install 9iR2 on a Redhat AS3 machine and I'm getting an error
when running 'runInstaller'.  I am doing this from an X session physically
on the server; not remote.
As 'oracle' user, I get the following error:

I need to implement a business rule 'Only one current task for each
employee'.
Almost all the tasks are in 'completed' state. There may be any amount
of tasks per employee in any other states.

I would like to write a string aggregation function (that's an idea!).
Using an Oracle 9.2, I naturally tried to do that with the ODCIAggregate
interface and there were many code samples to do that. However I want to
concatenate the string values with a custom string, while all ...

We need know how to find queries that is doing full scan table.
With the next query we obtein the number of full table scans against
tables:
select  n.name, s.value

I am trying to get some tables out of SQL Server 2000 and into Oracle
9i. However I am encountering problems.
1. Many of the tables and column names in SQL server are > than 30
Characters which meansa any auto inport I do fails.

I've tried to install oracle 10g on a x86 machine with linux suse
enterprise server 9. I've followed the instructions found in
the oracle 10g installation guide for unix.
I have:

I am calling a SP from java. Now the problem is that the SP has 3
Parameters- :
2 IN  String variables
1 IN OUT variable which is a REF CURSOR

I have written an aggregation function doing some kind of "join" on
string values.  Sometimes I would like to aggregate the values in a
specific order which I can define via ORDER BY expressions. For
instance, I would like to concatenate the strings in lexicographic order.