Env: Oracle 9.2.0.6 (Linux 3AS)
TAB1 = 2.5 M rows
TAB2 = 200 rows
The two SQLs are as follows

First i have to say that i'm a newbie on oracle
I have an  server with oracle 7i on Unix.
On my develop machine  (wIndows XP) i need to install some client of
oracle to access to my server.

I have an environment with Java applications with a growing number of
connections that I'd like to determine:
1. If my PGA and session related values appropriate?
2. What are some best practices on changing the related values for PGA

This is a basic question regarding the connections while building a
connection pool on oracle 8.1.7 database on solaris 8.
1. Is there any parameter in oracle (init.ora or some where else) which
dictates the maximum no. of connections that ever can be opened from a

I know ... I know ... but this seems to be worth reporting but I would
like someone else to confirm it.
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 8 09:05:54 2006
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Does any one know how/if you can use an Oracle Stored Procedure to run
a Crystal Report?

Are there performance caveats on index access when enforcing a pk with
a non-unique index?
I see that a query that specifies a single pk value against such a
table gets an INDEX RANGE SCAN rather than an INDEX UNIQUE SCAN. But

How do I join two column in two tables were I only use the first
three characters in one of the tables?

I have read several articles on Web Services on TechNet. It is still
not clear to me:
1.    If I use Oracle9i EE on HP UNIX 11, do I have everything to deploy
web services. Many articles on web services mention about Oracle9i AS

I'd like to know what are the requirements of Oracle 8 and 10 (standard
edition one) database licensing, specifically,
1. If we had bought a 5-user license for one site but had only 3 users
at most can we install another database server on another site with 2

I have written some PLSQL packages in ORACLE. I want to know if a PLSQL
program which gives all the packages used in a package exist.
Thanks.
AK

I have a question to ask about the behaviour of the Cost Based
Optimiser in relation to Bitmap Indexes in Oracle 8i (8.1.7.4).
I have a table, which I shall call REPORT_USAGE_TABLE on this user
group. I have a column in this table named REPORT_POPULATED. This

There is a tables:
create table stat -- about 2,000,000 records and 500,000 records with
finish_date is null
(

I'm experiencing a (to me) weird problem while using the Oracle
Universal Installer:
We're installing Oracle on a AIX machine (Oracle 9.2.0.0 on  AIX 5.2)
The OUI works without problems.

There is a table with about 3,000,000 recs in a month:
create table Log (
User_id        number(12),
Date_time    date,