Can anybody tell me about the parameters which effects the
performance of CPU utilization .
How these parameters should be configured for different type of
applications to reduce the cpu utilization and decrease the memory

I'm using Oracle 8i on Solaris box. I have a list of values which
will be passed to oracle "where in" clause.
for example, if id list = 1, 5, 80, 13, 4
This list will be passed to query where in clause:

trace file from 10046 level 8:
9.2.0.5:
select /*+index_combine(a)*/ count(*)
from

I am debugging a problem with an application failing to
connect to the DBMS (or rather fail to obtain a connection
from a JDBC driver), because the DBMS fails to insert to
the SYS.LOG_TRAIL table. The HOST column is 20-chars max,

Why does the queries which uses join have a lower data rate than simple
count(*) statement?
The db version is 9.2.0.5 , the disk array is raid 10 , emc , fiber
channel via 1hba. (100mb. per second read is possible)

is there any possibility to reference a record field in PL/SQL code, not
hard-coding it name
e.g.
i`ve got a ':new' record in a trigger and an array of varchar2 ` s -

I am trying to verify something I was told and need some help.   The
proposed application requires that Oracle databases be installed at
several geographically distributed sites.  Each of these installations
will have some tables that are for local use only, and other tables

In oracle portal, how users can update their profiles, I can see only
administrators has this feature, not for developers?
Can anyone tell me how to do this?
Any help is highly appreciable.

Is it possible to find and delete archive logs that are 3 days old
using PL/Sql? Could you, please refer me to an online document?
Thanks,
Eugene

I would like to play around with importing an export from 8i (nt 4)
into 10g (2003). I need to make sure that all the forms 6i form stuff
will work (somehow) properly in 10g before I can switch the users over.
I suspect it will take me quite some time to iron all that out.

If I have a Table X in Schema A with 1000 rows spilt between 3
companies (company_id 1,2,3).
I then create a view called Y in Schema B which is a Read Only View of
table X but only for rows where company_id = 3.

Does exist PGP library to use in PL/SQL code (PL/SQL package, java stored
procedures or java library loaded in Oracle)?
thx,
   M.

I would like to have your comments on this strange behaviour.
Oracle Server used : 8.1.7.0.0 on a ALPHA (VMS) server.
A table and an index are defined like this :
CREATE TABLE POINTAGE (

We are using Oracle 8.1.7.
I have a table of adresses where there will be several rows for each person.
Each row has a column 'isCurrent', and when the value of this column =1 it
means that this is the address where the person stays right now.

Do you want to break into the fast moving computer industry or do you
simply want to move to a job with more benefits and better security?
Well, FindJobEasy.com is the solution to all your employment woes. With
this simple, yet powerful website, you will be able to access more