Re: Restrictions in the OTN downloadable version of 9i?

It looks to me as though the network can be eliminated then.

Two other things that strike me are

1. that it is possible that some swapping is going on . If you can try reducing the large and java pools (say to 56m each). Swapping the sga out to disk will kill performance.
2. That you have sqlnet set to use NT authentication in the sqlnet.ora on the client app.

The other 'obvious' thing to check is that the tables are analyzed and the db is running in CBO mode.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
<peter.peltonen_at_iki.fi> wrote in message
news:afvu25$gn0$1_at_oravannahka.helsinki.fi...


> Niall Litchfield <niall.litchfield_at_dial.pipex.com> wrote:

> > Obviously win2k must be a better os than linux <runs off laughing

> > hysterically>

>

> Well, when it turned out that our app is working fine against Win2k

> running 8i I kinda blushed :) I'd been so proud with my nice little linux

> installation running Oracle... Oh well.

>

> I'm going to install Oracle on some other linux machine in the near future

> to see what happens...

>

>

> > Seriously if the app performs badly against only one database/machine

> > especially if you can replicate the problems with the demo db then I'd

be


> > tempted to look at the initialisation parameters of the db on linux (and

the


> > kernel parms as well) and also the network connections between the

machines.


>

> Great. Here is some info. If you need more, just ask.

>

> The network is quite simple: It is a private network (192.168.0.0). All

> hosts are connected to a 100M HP's switch by ethernet. The machine has

> Intels's NIC:

>

> From dmesg:

> --<snip>--

> eepro100.c:v1.09j-t 9/29/99 Donald Becker

> http://cesdis.gsfc.nasa.gov/linux/drivers/eepro100.html

> eepro100.c: $Revision: 1.36 $ 2000/11/17 Modified by Andrey V. Savochkin

> <saw_at_saw.sw.com.sg> and others

> PCI: Found IRQ 11 for device 01:08.0

> eth0: Intel Corporation 82801BA(M) Ethernet, 00:03:47:13:E5:53, IRQ 11.

>   Board assembly 000000-000, Physical connectors present: RJ45

>   Primary interface chip i82555 PHY #1.

>   General self-test: passed.

>   Serial sub-system self-test: passed.

>   Internal registers self-test: passed.

>   ROM checksum self-test: passed (0x04f4518b).

> --</snip>--

>

> ifconfig reports of no errors. Transferring files via ftp happens as fast

> as in any other machine on the network.

>

>

> My /etc/sysctl.conf:

> --<snip>--

> # Disables packet forwarding

> net.ipv4.ip_forward = 0

> # Enables source route verification

> net.ipv4.conf.default.rp_filter = 1

> # Disables the magic-sysrq key

> kernel.sysrq = 0

>

> # 320M

> kernel.shmmax = 335544320

>

> kernel.sem = 250 32000 100 128

> kernel.msgmni = 128

> --</snip>--

>

> My /opt/oracle91/product/9.0.1/dbs/inittest.ora:

> --<snip>--

>

############################################################################
##


> # Copyright (c) 1991, 2001 by Oracle Corporation

>

############################################################################
##


>

> ###########################################

> # Cache and I/O

> ###########################################

> db_block_size=8192

> db_cache_size=67108864

>

> ###########################################

> # Cursors and Library Cache

> ###########################################

> open_cursors=300

>

> ###########################################

> # Diagnostics and Statistics

> ###########################################

> background_dump_dest=/opt/oracle/admin/test/bdump

> core_dump_dest=/opt/oracle/admin/test/cdump

> timed_statistics=TRUE

> user_dump_dest=/opt/oracle/admin/test/udump

>

> ###########################################

> # Distributed, Replication and Snapshot

> ###########################################

> db_domain=fivetec.dev

> remote_login_passwordfile=EXCLUSIVE

>

> ###########################################

> # File Configuration

> ###########################################

> control_files=("/opt/oracle/oradata/test/control01.ctl",

> "/opt/oracle/oradata/te

> st/control02.ctl", "/opt/oracle/oradata/test/control03.ctl")

>

> ###########################################

> # MTS

> ###########################################

> dispatchers="(PROTOCOL=TCP)(SER=MODOSE)",

> "(PROTOCOL=TCP)(PRE=oracle.aurora.serv

> er.GiopServer)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"

>

> ###########################################

> # Miscellaneous

> ###########################################

> compatible=9.0.0

> db_name=test

>

> ###########################################

> # Network Registration

> ###########################################

> instance_name=test

>

> ###########################################

> # Pools

> ###########################################

> java_pool_size=117440512

> large_pool_size=1048576

> shared_pool_size=117440512

>

> ###########################################

> # Processes and Sessions

> ###########################################

> processes=150

>

> ###########################################

> # Redo Log and Recovery

> ###########################################

> fast_start_mttr_target=300

>

> ###########################################

> # Resource Manager

> ###########################################

> resource_manager_plan=SYSTEM_PLAN

>

> ###########################################

> # Sort, Hash Joins, Bitmap Indexes

> ###########################################

> sort_area_size=524288

>

> ###########################################

> # System Managed Undo and Rollback Segments

> ###########################################

> undo_management=AUTO

> undo_tablespace=UNDOTBS

>

> # added by peter

> license_sessions_warning=140

> --</snip>--

>

> Regards,

> Peter

>