Home » Infrastructure » Windows » Plz help me
Plz help me [message #223939] Mon, 12 March 2007 05:52 Go to next message
hungplnbidv
Messages: 3
Registered: March 2007
Junior Member
I have installed the Oracle8.1.7 DB on PC (Intel PIV 3.0Ghz,512MBRAM, OS Win2003SP1). Everything's good but the client connected to this DB with very low speed. So, please show me how to fix this problem ! Many Thanks.
P/S: I could'nt start listener in DOS by using LSNRCTL START command. Here's my init file:
#====INIT.ORA====================================================
#
# Copyright (c) 1991, 2000 by Oracle Corporation
#
##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you customize
# your RDBMS installation for your site. Important system parameters
# are discussed, and example settings given.
#
# Some parameter settings are generic to any size installation.
# For parameters that require different values in different size
# installations, three scenarios have been provided: SMALL, MEDIUM
# and LARGE. Any parameter that needs to be tuned according to
# installation size will have three settings, each one commented
# according to installation size.
#
# Use the following table to approximate the SGA size needed for the
# three scenarious provided in this file:
#
# -------Installation/Database Size------
# SMALL MEDIUM LARGE
# Block 2K 4500K 6800K 17000K
# Size 4K 5500K 8800K 21000K
#
# To set up a database that multiple instances will be using, place
# all instance-specific parameters in one file, and then have all
# of these files point to a master file using the IFILE command.
# This way, when you change a public
# parameter, it will automatically change on all instances. This is
# necessary, since all instances must run with the same value for many
# parameters. For example, if you choose to use private rollback segments,
# these must be specified in different files, but since all gc_*
# parameters must be the same on all instances, they should be in one file.
#
# INSTRUCTIONS: Edit this file and the other INIT files it calls for
# your site, either by using the values provided here or by providing
# your own. Then place an IFILE= line into each instance-specific
# INIT file that points at this file.
#
# NOTE: Parameter values suggested in this file are based on conservative
# estimates for computer memory availability. You should adjust values upward
# for modern machines.
#
###############################################################################

db_name = "ibps"

instance_name = ibps

service_names = ibps

db_files = 1024

control_files = ("C:\Oracle\oradata\ibps\control01.ctl", "C:\Oracle\oradata\ibps\control02.ctl", "C:\Oracle\oradata\ibps\control03.ctl")

open_cursors = 300
max_enabled_roles = 30
db_file_multiblock_read_count = 8

db_block_buffers = 2935

shared_pool_size = 8348467

large_pool_size = 31457280
java_pool_size = 0

log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800

processes = 150

parallel_max_servers = 5

log_buffer = 32768

#audit_trail = true # if you want auditing
#timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5M each

# Uncommenting the line below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true
# log_archive_dest_1 = "location=C:\Oracle\oradata\ibps\archive"
# log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
#rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6, RBS7, RBS8, RBS9, RBS10, RBS11, RBS12, RBS13, RBS14 )

# Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = true

# Uncomment the following line if you wish to enable the Oracle Trace product
# to trace server activity. This enables scheduling of server collections
# from the Oracle Enterprise Manager Console.
# Also, if the oracle_trace_collection_name parameter is non-null,
# every session will write to the named collection, as well as enabling you
# to schedule future collections from the console.
# oracle_trace_enable = true

oracle_trace_collection_name = ""
# define directories to store trace and alert files
background_dump_dest = C:\Oracle\admin\ibps\bdump
#Uncomment this parameter to enable resource management for your database.
#The SYSTEM_PLAN is provided by default with the database.
#Change the plan name if you have created your own resource plan.# resource_manager_plan = system_plan
user_dump_dest = C:\Oracle\admin\ibps\udump

db_block_size = 8192

remote_login_passwordfile = exclusive

os_authent_prefix = ""

distributed_transactions = 500
mts_dispatchers = "(protocol=TCP)"

compatible = 8.0.5
sort_area_size = 65536
sort_area_retained_size = 65536


#====INIT.ORA====================================================
Re: Plz help me [message #224031 is a reply to message #223939] Mon, 12 March 2007 13:02 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
That's most probably because you have allotted very less memory to oracle..see your parameter:
shared_pool_size = 8348467

can you make it something like 80 mb and check...(just add one zero to the make this number 83484670)

also post the output of show sga command..
Re: Plz help me [message #224110 is a reply to message #224031] Tue, 13 March 2007 02:24 Go to previous messageGo to next message
hungplnbidv
Messages: 3
Registered: March 2007
Junior Member
Thanks for your advise! I've changed shared_pool_size parameter as your advise.
The results of show sga command are:
==>before
SQL> show sga ;

Total System Global Area 67967004 bytes
Fixed Size 75804 bytes
Variable Size 43769856 bytes
Database Buffers 24043520 bytes
Redo Buffers 77824 bytes

===>and now (after change)
SQL> show sga;

Total System Global Area 143501340 bytes
Fixed Size 75804 bytes
Variable Size 119304192 bytes
Database Buffers 24043520 bytes
Redo Buffers 77824 bytes


If any parameters must change for better perfomance of database, please give me a advise !

[Updated on: Tue, 13 March 2007 02:42]

Report message to a moderator

Re: Plz help me [message #224120 is a reply to message #224110] Tue, 13 March 2007 02:54 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
If any parameters must change for better perfomance of database, please give me a advise !

It is not ROT you should generate statspack report and post here or analyze yourself and findout bottleneck instead of assumption.


go through below link
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1513005503967


hope this helps


regards
Taj
Re: Plz help me [message #224128 is a reply to message #224120] Tue, 13 March 2007 03:28 Go to previous messageGo to next message
hungplnbidv
Messages: 3
Registered: March 2007
Junior Member
Thanks for your advise ! It's a very useful link.

[Updated on: Tue, 13 March 2007 03:29]

Report message to a moderator

Re: Plz help me [message #224136 is a reply to message #224128] Tue, 13 March 2007 04:03 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Thank You !!!


regards
Taj
Previous Topic: oracle installation reg
Next Topic: ORA-12560: TNS:protocol adapter error
Goto Forum:
  


Current Time: Sat Dec 03 05:37:29 CST 2016

Total time taken to generate the page: 0.09538 seconds