While reading a 10.2.0.3 statspack report I was wondering why the
authors chose to compute the "Library Hit %" from the PINHITS rather
than from the GETHITS of v$librarycache.
In the report I've been reading, the lack of bind variables can be

Hi Group,
I would like connect to an Oracle DB running on HP-UX using a java
application running on Windows.
Could you pls let me know if I need to make any configuration/changes

[Oracle 9i2, Windows XP / Windows Server 2003]
I am currently trying to figure out why one of our sites has such a
horrible performance. To this end I took statspack snapshots over the
last few days from the "bad" site and from one "good" site and now I'm

I'm pretty new to Oracle and PL-SQL, I have a SQL Server/T-SQL background.
I've googled for this and found some examples, but no exact luck yet.
We're on version 9.
We have a need, in a package, to execute a Select statement using an In List

We have acquired a software package that sends alerts based on defined
thresholds and/or events.  We are working on a simple alert like when
the cache hit ratio falls below a given threshold.  The package came
with a query that uses the V$BUFFER_POOL_STATISTICS view.  We have

I have database installed on dbserver.  Dbserver is HP UNIX 11i
running Oracle 8.1.6.1.
I have Oracle client installed on three application servers
appserver1, apserver2 and  appserver3. App servers are Windows 2003

Vennela Technologies Pvt. Ltd. is a Leader in ERP Training and
Projects in India Vennela Technologies has been in Training from last
4 years. Vennela trained more than 4000 users in Oracle Applications
till date.

I need to test a procedure.  The procedure has like 15 input
parameters, and 1 output parameter.  Of the 15 input parameters, one
of them is a collection.
How can I simulate this EXECUTE statement from SQLPLUS???

Do we have any material available on "migrating applications from
non-RAC databases to RAC databases" ?
I am asked to study the readiness of "application migration from
non-RAC to RAC databses" and create analysis report. I am asked

Please let me know if you have worked on Oracle R12 Financial.
Thanks
DK

I am new to oracle and am using 10G
In Access I often used the "Like" statement to query Table 1 with a
value from table 2 like this:
SELECT tblcompany.IDcompany, tblcompany.Company, tblcompany.Pcode,

    There is a Stored procedure which has 10 parameters. All of the
parameters are of type VARCHAR2. The invoker has been given the
facility that, he/she may pass in only 3 out of the 10 parameters.
    My question is this, is it possible to determine inside the

Are there are traps to know of when using Updateable Views in Oracle?
ex.
table a, table b
upd view: select a.foo, b.bar from a,b where a.pk=b.pk;

We were running a 9i database on a Win2000 VM server which has 2
disks; More or less
an OS one and a data one. The VM server had many issues last weekend,
and