Could anyone suggest the minimum installation of an oracle product on a
client pc so that i may run an oracle form connecting to a database on
the server, but keeping the client as thin and cheap as possible?
Many thanks in advance

Database: Oracle 10g (10.1.0.4) on HP/UX PA Risc 64 bit.
When doing an explain plan on a sql select statement I can see the
cardinality in different steps of the plan.

One of our database experiences heavy waits on 'log file sync'.
Top waits from V$SYSTEM_EVENT are given below. 'Log file sync'
exceeds 'db file sequential read' and 'db file scattered read'.
Metalink Note 223117.1 says that they key to understanding

I have a simple question, that might not be so easy to answer.
What is the best way to migrate a Oracle 7.34 Instance to a Oracle 9.2
Oracle 7.34 is running on Window NT 4.0 and Oracle 9.2 is supposed to be
running on Windows 2000

I thought I did this once - changing a negative interger into a
positive and vice-versa.
Anyone ever do this?
TIA,

Whenever I use a DISTINCT in my query, I see the "SORT UNIQUE" getting
added to the execution plan.
"SORT UNIQUE" is increasing the cost of the query by a greater factor.
Any help in reducing the cost in using DISTINCT would be of much help.

With Oracle 10g, one case use submultiset and query for object type
equality in where cause. For example:
create or replace type oid_collection as table of number(10)
/

Is JVM a required part of Oracle 10g ? What software/features won't work
anymore if I don't install it ? Intermedia ?
Matthias

as title, please help.

I'm planning to migrate from a single instance non-ASM database to a
new 2 node RAC database using ASM.  We are running Oracle 10.1.0.4
Standard Edition on Solaris 9 on all servers.  I'm looking for
recommendations on the best way to do this.  Should I look at using the

We currently have 10.1.0.4 (Enterprise) installed on Solaris SPARC
(64-bit).  I have started to look into upgrading to 10.2.
Can I patch the existing 10.1.0.4?
Or do I need to do a brand new install of 10.2 in another Oracle home?

It may be a wrong posted here, but I really need help on this. thanks all.
Abby

I have a simple question, that might not be so easy to answer.
What is the best way to migrate a Oracle 7.34 Instance to a Oracle 9.2
Oracle 7.34 is running on Window NT 4.0 and Oracle 9.2 is supposed to be
running on Windows 2000

I'm writing a lot of code in a various apps to construct strings which
are Oracle SQL statements.
I'm wondering if there is a performance hit with the use of in() versus
equals.  I know for multiple criteria that, for example:

Advanced JPEG Compressor 4.5
http://www.soft30.com/softdown-160-12616.htm
Advanced JPEG Compressor for Windows is an invaluable and useful tool
for everyone who knows what is a digital image. This program allows you