Is the parameter USE_SHARED_SOCKET usable and suitable in a RAC environment
for connections through a Firewall?
Or is it better to configure Shared Servers and dispatchers?
database version : 9.2.0.6

Hello.  I need to examine Oracle 8.1.7 archive redo logs, but my 8
instance is screwed up.  I got a 9.2.0.6 instance up, and I figure I'd
try to dump the contents of it on their.  (I think I saw our DBA do it
once.)

Hi, does anyone know how I can determine the terminal, osuser, program
from a session that has been created from a connection pool from jvm ?
There is obviously a route back to the terminal but v$session will show
only limited information due to the connection pooling.

I have to ask for your help for:
OCSSD : if I try to start OracleCSService from services panel I always
obtain 'Start Pending'. If I try to start the service from a cmd
session (ocssd start) I obtain 'Started' in cmd session and 'Start

I've just had to start using all of this 'inner join' stuff and I have hit
what must be a very simple problem - How do you do multiple joins in the new
syntax?
I spent 3 hours yesterday trying to work out how do:

For Oracle 9iR2.
A simple question for triggers related to DDL statement e.g. create table.
Is a new transaction always created for the DDL trigger?  I,
disappointingly, cannot find related information in Tahiti's documentation

Buffer Nowait %: 100.00
Redo NoWait %: 99.99
Buffer Hit %: 99.87
In-memory Sort %: 100.00

What is the intermediate dataset built in this statement:
----------------------------------------------------
update T1
set T1.C1 =

I've got a problem with Oracle 10g on AIX 5.3 which even Oracle support
seems unable to fix. I want to start the database automatically at
system restart, so I put the appropriate entry into /etc/inittab
(su oracle -c dbstart, for short). After reboot, however, no Oracle

What would be the recommended value for db_file_multiblock_read_count for an
OLTP database (10g) on AIX 5.2 with JFS2 (and disk devices on SAN) ?
I did some benchmarks with Oracle 8.1.7 (dfmrc set to 8,16,32 and 64) but
couldn't find any significant performance differences when ...

I have problem with starting the Net8 listener service becouse in
Start>Settings>Control panel and double-click the Services there is no any
Oracle Net8 listener service and ia don't know whay>?  Ofcourse earlier I
create the listener.ora using The Net8 Configuration Assistant so I ...

I have trying to setup a 10G RAC to 10G RAC physical standby dataguard
configuration and then put it iunder grid control as you cannot create a
physical standby RAC database in the Grid Control.
I have looked at the Oracle manuals, all the dataguard and dataguard broker

I installed 10g on my win xp machine and I run it successfully.Database is
open and I can connect and work with it using SQL*PLUS or isqlplus and...
but when I try to access it using DB control it ALWAYS says "The database
status is currently unavailable" and suggests me to do ...

We know that the syntax to create a foreign key constraint is as
follows
foreign key(foreignkeycolumn,foreignkeycolumn,...) references
foreigntable

Is it possible to implement a "PARAMETRIZED REF CURSOR" in Oracle? How?
Can I use "TYPE My_Cur(P_NAME VARCHAR2) IS REF CURSOR;" in Oracle?
Thanks in advance,
Meenu.