RE: Oracle.exe consuming 100%

What kind of computation do those reports contain?
Any large summing,grouping,cube etc...
If so, Query rewrite and creating Materialized Views could help

-----Original Message-----
From: Pratibha Mane [mailto:[email protected]]=20
Sent: Tuesday, April 29, 2003 00:54
To: Oracle
Subject: [oracle] Oracle.exe consuming 100%


Hi All,

We have Oracle9.0.1.x installed on a windows2000 machine with 1 GB RAM
and=20
800Mhtz P-III single CPU machine.

We have a medium sized OLTP cum OLAP system in which we are using
Discoverer=20
to view the reports. When ever i run a report on discoverer or even from

sqlprompt, oracle.exe eats up the entire cpu of the machine, its always=20
around 95-100% consupmtion by oracle.exe
I have tried increasing the shared pool , buffer cache and all other=20
parameter.. but no gains..

I am copying part of my init.ora file here for your reference...

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

# Cache and I/O
###########################################
db_block_size=3D8192
db_cache_size=3D466472960

########Added for Tunning#################

db_file_multiblock_read_count=3D8

###########################################
# Cursors and Library Cache
###########################################
open_cursors=3D300

# MTS
###########################################
dispatchers=3D"(PROTOCOL=3DTCP)(SER=3DMODOSE)",=20
"(PROTOCOL=3DTCP)(PRE=3Doracle.aurora.server.GiopServer)",=20
"(PROTOCOL=3DTCP)(PRE=3Doracle.aurora.server.SGiopServer)"

# Network Registration
###########################################
instance_name=3Dbhabha

###########################################
# Pools
###########################################
java_pool_size=3D52428800
large_pool_size=3D10485760
shared_pool_size=3D190443520

###########################################
# Processes and Sessions
###########################################
processes=3D150

###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=3D300

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
hash_area_size=3D1048576
#sort_area_size=3D1048576

###############Modified for Tunning########

sort_area_size=3D1048576
sort_area_retained_size=3D1048576
optimizer_index_caching=3D50
optimizer_index_cost_adj=3D50

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

workarea_size_policy=3Dmanual

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=3DAUTO
undo_retention=3D10800
undo_tablespace=3DUNDOTBS

######################Added for Discoverer #####
OPTIMIZER_MODE=3DCHOOSE
JOB_QUEUE_PROCESSES=3D10
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Size of my db is not more than 8-10 GB at present.

Any suggestion to tune the db or application or discoverer will be of
great=20
use.....

Regds
Himanshu / Pratibha





************************************************************
Pratibha Rohit Mane
Center for Development Of Advanced Computing,
Ganeshkhind Road , Pune University Campus, Pune-7

Ph : 020 5694000 (ext. 323)
     020 5694050
Email ID : [email protected]
           [email protected]
************************************************************
"Knowledge is power, but it is only useful if it is shared!"
************************************************************





>From: "Amir Hayat" <[email protected]>
>Reply-To: "Oracle" <[email protected]>
>To: "Oracle" <[email protected]>
>Subject: [oracle] User Management in Oracle
>Date: Thu, 24 Apr 2003 04:13:57 -0400
>
>Hello everyone,
>
>I am using Oracle 9i on W2k server. If I have to create dozen or two
dozen=20
>users, what is the best option? Do I have to create each user
separetly,=20
>assign him a role and profile or is there a short cut.
>
>If all the users have the same privileges then is it possible to create

>them in a group form.
>
>Regards,
>
>Amir
>
>_________________________________________________________________
>MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. =20
>http://join.msn.com/?page=3Dfeatures/virus
>
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or to=20
>unsubscribe send a blank email to %%email.unsub%%.


_________________________________________________________________
See the stars. Upclose!=20
http://www.sulekha.com/movies/moviepicturegalleries.asp Bollywood=20
photogallery.


---
Change your mail options at http://p2p.wrox.com/manager.asp or=20
to unsubscribe send a blank email to %%email.unsub%%.

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].