Platform: Oracle 9.2 on Solaris 5.9
Recently started getting problems on a dev db of maxing out
'processes.' Made the decision to enable shared server, so added
'dispatchers' init parm, fiddled with shared pool and large pool

I need to query (read, write, drop table, ecc..) an Oracle DB from a
handheld device (pocket pc 2002) using an internet connection.
How can i do it?
I have Oracle 9.2 Enterprise edition, installed on my webserver pc.

Using Oracle 9.2.0.4.0, Solaris 9.
After reading as much as I can about histograms, I feel I'm still
confused regarding histograms on columns that contain many more
distinct values than the 255 bucket limit imposed by Oracle (referred

My solution to calculating the number of business days using Oracle 8i
is to create a table with holidays and run some kind of calculation
like so:
select count(*)

I am being told by my supplier that if my application works okay on a two
nodes Oracle RAC database there is no problem scaling up - to over ten
nodes.  Is that true?  Are there no contention issues that will appear as
the cluster grows beyond two nodes?

I'm having problems with SQL*Loader.
This is the top of my control file.
LOAD DATA
INFILE mydata.dat "str X'7C7C'"

Current State:
Currently we have a system that inserts records directly into a
staging table directly after any of several tables are inserted,
updated or deleted to/from. This is done by invoking the update

I am trying to build a system where I can full-text index documents with
UTF8 or UTF16 data using Oracle Text. I am doing the filtering in a
third-party component outside the database, so the I dont need filtering in
Oracle, but only indexing.

Oracle Database 10g Release 10.1.0.2.0 - Production
Operating System: Windows Server 2003
table definition on the remote db (db2: Database server = DB2 OS/390
6.1.2)

I have a strange behaviour with REF in Oracle. I have a table
organization with a ref . If I do a DEREF on it, I can view the data. If
I try to get the object in a procedure, and I get an End of file
communication channel.

I have complete Oracle 10g stack 10.1.2.0 installed on RHAS 3
i have webcache sitting infront, IM and SSO on one server, PORTAL, BI
installed on the other server. Both Portal and BI installed on
different homes.

I was taking cold backup of my database by simply copying and archiving
the dbf files when I noticed that TEMP01.DBF has grown upto 8 GB.
For now, I've two queries:
- How can I determine the operation that caused this file to grow?

Is the "replace" command supported by the anchient SQL Plus version
3.3.4.0.1?

To get  the database version  use
select * from v$version
But how can I identify the client version?
Is there a way on database side or does I have to use an API function which

Hi, list,
did somebody experienced that behaviour?
(there are no concurrent sessions)
mmm@APPL> select count(*) from t_noc;