Home » Infrastructure » Unix » Performance Bottle neck in Solaris (5.10)
Performance Bottle neck in Solaris [message #635774] Wed, 08 April 2015 05:15 Go to next message
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?
Re: Performance Bottle neck in Solaris [message #635775 is a reply to message #635774] Wed, 08 April 2015 05:29 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Is your problem related to Oracle in anyway?
Re: Performance Bottle neck in Solaris [message #635777 is a reply to message #635775] Wed, 08 April 2015 06:07 Go to previous messageGo to next message
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.
Re: Performance Bottle neck in Solaris [message #635778 is a reply to message #635777] Wed, 08 April 2015 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Performance Bottle neck in Solaris [message #635786 is a reply to message #635778] Wed, 08 April 2015 08:44 Go to previous messageGo to next message
karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI
Member
Both are in the same server. ie. Both Appln & DB are in the same server.
Re: Performance Bottle neck in Solaris [message #635787 is a reply to message #635778] Wed, 08 April 2015 08:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What clues are contain in statspack or AWR reports?
Re: Performance Bottle neck in Solaris [message #635790 is a reply to message #635787] Wed, 08 April 2015 10:31 Go to previous messageGo to next message
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.
Re: Performance Bottle neck in Solaris [message #635791 is a reply to message #635790] Wed, 08 April 2015 11:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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 Go to previous messageGo to next message
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?
Re: Performance Bottle neck in Solaris [message #635794 is a reply to message #635793] Thu, 09 April 2015 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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 Go to previous messageGo to next message
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.
Re: Performance Bottle neck in Solaris [message #635826 is a reply to message #635823] Thu, 09 April 2015 09:31 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
+1
Re: Performance Bottle neck in Solaris [message #635827 is a reply to message #635823] Thu, 09 April 2015 09:51 Go to previous messageGo to next message
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?
Re: Performance Bottle neck in Solaris [message #635828 is a reply to message #635827] Thu, 09 April 2015 09:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/mv/msg/84315/433888/#msg_433888
Re: Performance Bottle neck in Solaris [message #635829 is a reply to message #635827] Thu, 09 April 2015 10:43 Go to previous messageGo to next message
gazzag
Messages: 1118
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.
Re: Performance Bottle neck in Solaris [message #635830 is a reply to message #635829] Thu, 09 April 2015 12:23 Go to previous message
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.
Previous Topic: Table is full
Next Topic: zfs file system
Goto Forum:
  


Current Time: Thu Mar 28 16:59:43 CDT 2024