OraFAQ Forum: Unix » Performance Bottle neck in Solaris

Home » Infrastructure » Unix » Performance Bottle neck in Solaris (5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Performance Bottle neck in Solaris [message #635774]

Wed, 08 April 2015 05:15

karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI

Member

Same application program runs fast in one server and slow in another server. both are solaris server.

I checked the /etc/system in both server and I find the below values

In Slow Server:

set shmsys:shminfo_shmmax=141073000
set shmsys:shminfo_shmseg=1024
set shmsys:shminfo_shmmni=4104

set semsys:seminfo_semmap=4104
set semsys:seminfo_semmni=4096
set semsys:seminfo_semmnu=800
set semsys:seminfo_semmsl=500
set semsys:seminfo_semopm=800
set semsys:seminfo_semume=1024

The above variables are not set in Fast server.

Let me know whether anything need to be changed in the above values to increase the system performance?

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635775 is a reply to message #635774]

Wed, 08 April 2015 05:29

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Is your problem related to Oracle in anyway?

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635777 is a reply to message #635775]

Wed, 08 April 2015 06:07

karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI

Member

Yes. For both application database is Oracle.

Note that DB is copied to slow running server. So DB & Appln configuration are same.

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635778 is a reply to message #635777]

Wed, 08 April 2015 06:38

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

But the problem is on the database server or on the application server?

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635786 is a reply to message #635778]

Wed, 08 April 2015 08:44

karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI

Member

Both are in the same server. ie. Both Appln & DB are in the same server.

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635787 is a reply to message #635778]

Wed, 08 April 2015 08:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What clues are contain in statspack or AWR reports?

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635790 is a reply to message #635787]

Wed, 08 April 2015 10:31

karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI

Member

Only this I found in AWR

Recommendation 2: Host Configuration
   Estimated benefit is 5.06 active sessions, 46.92% of total activity.
   --------------------------------------------------------------------
   Action
      Investigate the possibility of improving the performance of I/O to the
      online redo log files.
   Rationale
      The average size of writes to the online redo log files was 10 K and the
      average time per write was 7 milliseconds.
   Rationale
      The total I/O throughput on redo log files was 0 K per second for reads
      and 947 K per second for writes.
   Rationale
      The redo log I/O throughput was divided as follows: 0% by RMAN and
      recovery, 100% by Log Writer, 0% by Archiver, 0% by Streams AQ and 0% by
      all other activity.

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635791 is a reply to message #635790]

Wed, 08 April 2015 11:08

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is not AWR this ADDM; just follow what it says but most of the time it is completely irrelevant.

[Updated on: Wed, 08 April 2015 11:09]

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635793 is a reply to message #635791]

Thu, 09 April 2015 02:18

karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI

Member

How to increase the performance of I/O to the online redo log files based on the above details. What parameters I need to check and change?

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635794 is a reply to message #635793]

Thu, 09 April 2015 02:20

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Buy faster disks, for instance.
But you choose the wrong way.
Ignore ADDM and take AWR report(s) for the pertinent period.

[Updated on: Thu, 09 April 2015 02:21]

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635823 is a reply to message #635793]

Thu, 09 April 2015 08:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

karthik4u wrote on Thu, 09 April 2015 00:18

How to increase the performance of I/O to the online redo log files based on the above details. What parameters I need to check and change?

I bet that if you succeed in making REDO faster that users will still complain about slow database response.

REDO only impacts DML.
Most applications do 10 SELECT for every DML.
REDO has ZERO impact on SELECT performance.

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635826 is a reply to message #635823]

Thu, 09 April 2015 09:31

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

+1

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635827 is a reply to message #635823]

Thu, 09 April 2015 09:51

karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI

Member

Correct.. REDO only impacts DML.

Here all SELECTs are tuned and working with good performance. Only DML activities are taking time.
How to increase performance of REDO log activity? What are the parameters I need to Check?

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635828 is a reply to message #635827]

Thu, 09 April 2015 09:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/mv/msg/84315/433888/#msg_433888

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635829 is a reply to message #635827]

Thu, 09 April 2015 10:43

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

No, DML impacts redo. You need to tune your queries first - BlackSwan has given you a useful link. I'd start with that if I were you. If you want to experiment with redo log sizes and locations, Managing the Redo Logs.

Report message to a moderator

Re: Performance Bottle neck in Solaris [message #635830 is a reply to message #635829]

Thu, 09 April 2015 12:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

https://docs.oracle.com/apps/search/search.jsp?q=lgwr&category=database&product=e50529-01

LGWR writes all redo entries that have been copied into the buffer since the last time it wrote.
There really is little or nothing to "tune" regarding REDO logfiles.
You can place the REDO files on faster disk drives.
You can place the REDO file on disks that are dedicated to just LGWR operations.
If DML is "slow", it is more likely the slowness is NOT due to REDO but due to the actual DML operation itself.

Report message to a moderator

Previous Topic:	Table is full
Next Topic:	zfs file system

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 27 17:41:03 CDT 2023