OraFAQ Forum: Performance Tuning » Database options to address work load increase

Home » RDBMS Server » Performance Tuning » Database options to address work load increase

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

Database options to address work load increase [message #655992]

Mon, 19 September 2016 10:22

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
I have 2 node RAC database running on 11.2.0.4 (RedHat Linux) with the memory utilization of about 80% (we have 140GB of memory) and we are expecting the application work load to increase by 10 times. The size of the database is 5TB. What are all the options that I should be looking into to address the increase in database workload to maintain or improve the performance?
Thanks

Report message to a moderator

Re: Database options to address work load increase [message #656002 is a reply to message #655992]

Mon, 19 September 2016 13:45

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

If no limits within the database, the instance, or the server are being reached, you do not need to do anything.
If you post an AWR or statspack report, this may become clearer.

Report message to a moderator

Re: Database options to address work load increase [message #656005 is a reply to message #655992]

Mon, 19 September 2016 15:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

caprikar wrote on Mon, 19 September 2016 08:22

Hi,
I have 2 node RAC database running on 11.2.0.4 (RedHat Linux) with the memory utilization of about 80% (we have 140GB of memory)

post command & results that support the statement WRT 80% memory utilization.

Which metric at what value do you use to determine when RAM is a system bottleneck?

In addition to RAM you need to monitor CPU & disk sub-system utilization as potential bottlenecks.

Report message to a moderator

Re: Database options to address work load increase [message #656076 is a reply to message #655992]

Wed, 21 September 2016 21:45

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

caprikar wrote on Mon, 19 September 2016 15:22

Hi,
I have 2 node RAC database running on 11.2.0.4 (RedHat Linux) with the memory utilization of about 80% (we have 140GB of memory) and we are expecting the application work load to increase by 10 times.

I have got a question same to Black Swan. How do you knew the memory utilization of RAC wasted 80%? What was the metric, utility or anything did you use to measure?
And, there are many reasons made bottleneck but not only memory.

140gb physical memory per server? Is it physical or virtual?

Quote:

The size of the database is 5TB. What are all the options that I should be looking into to address the increase in database workload to maintain or improve the performance?
Thanks

As John Waston suggestion, you might upload AWR (get the snaps between busy time) here, it will take a cleaner rather than guess.

TaT.

Report message to a moderator

Re: Database options to address work load increase [message #656122 is a reply to message #655992]

Fri, 23 September 2016 08:41

bpeasland
Messages: 51
Registered: February 2015
Location: United States

Member

Quote:

we are expecting the application work load to increase by 10 times.

What exactly does that mean? Do you mean you will have ten times more users? Ten times more data coming in but the user base will stay the same? If you can quantify the statement above in more precise terms, then yo are starting in the right direction.

Cheers,
Brian

Report message to a moderator

Previous Topic:	Application is running slow time to time
Next Topic:	Do we need to sit down with custom about determining which statspack snapshot to be used as baseline

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 00:48:20 CST 2025