Recently we have had a lot of active sessions after a powerfailer of
network components.
To solve this, i know of these optins :
kill all "hanging sessions"  ( time consuming and you have to stop the

Dear experts,
I've recently started working in an environment with
both 10G, and 9i.
All of the Window clients had Oracle 9i on it, and

I'm trying to select the first part of a string (before charachter
'-'). An example of the string is '123456-03' and the result should be
'123456'. This is perfectly done by the following code:
SELECT SUBSTR(RESOURCESTRING,1,INSTR(RESOURCESTRING , '-')-1)

Hi all. I had a customer report that the query below
scans the table. Can that be true, that Oracle doesn't
realize during construction of the query plan that
the search argument will never be satisfied?

I want to write some java-code (CREATE OR REPLACE AND RESOLVE JAVA SOURCE
NAMED...)
where I want to return an image as blob.
For doing that I have to initialize the blob in the java-code -correct?

We have application that changes every year, but we have old version
running and being used as well.
The changes are mostly data changes, and database structure and
procedures are in general the same.

I'm going to be learning all about Oracle databases in my last year at
university, even though the courses start in September/October time I would
like to get a head start as I want to work with Oracle databases as a career
path when I graduate.

Hi all. I am a developer using the Microsoft products and have
developed using Visual Interdev, Studio.Net 2003 (ASP and ASP.Net) etc.
and always used SQl 2K as the backend. I have a strong hold over
development and its SDLC. Now i want to switch over from Microsoft to

Lets say I had to find the products for which we had a total of $500 or more
in sales.  I need to see the following information:
·        product number
·        total sales (in dollars)

Can anyone recommend me a good book or online documentation regarding Perl
and Oracle (10g) ?
Thanks

I am running a single Oracle 9i instance on Red Hat Linux. I need to
add a second instance to the same box. Is it preferable to:-
1. Create a new user to own the second instance and share the same
ORACLE_HOME as the first instance.

Hi, I have two computers.
I have just downloaded Oracle 10.2 XE for Debian x86 and installed it.
I can connect to the database instance using SQLPlus and everything is
working.

Oracle 9.2.0.5
Table 1 - Calendar with following columns
country_id
load_date

I've noticed that in order to join V$SORT_USAGE and V$TEMPFILE
I have to add 200 or 1000 to the value of the file number in the
latter (depending on the version).
In Metalink note

hi people,
           I have the following performance issue, when i run query
and look out for the statistics i get the following. which i have
enclosed below. i am using oracle8.1.7 in solaris OS.