Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Showing results for 
Search instead for 
Did you mean: 

SCHED_NOAGE and Oracle

Miguel Angel Aliaga
Occasional Contributor

SCHED_NOAGE and Oracle

I`m working with an OLTP environment (Oracle 9i and HP-UX 11i). I still havent´t activate the Oracle recomendation about the SCHED_NOAGE schedulling policy.

Are there any experience about Sched_noage+Oracle out there ?

Steven E. Protter
Exalted Contributor

Re: SCHED_NOAGE and Oracle

After years of working witht he environment you are asking on I can say this:

We have never had to change the default scheduler.

Now At my last shop the DBA did do the following:

Installed and ran the stats pack so the database could learn what the activity was like and optimize itself.

Ran reports regularly to look at trends and patterns to see if the performance could be improved.

I took note of that during the only real disaster I've been through in my career. While restoring the database the first few hours of activity went very slowly until we restored stats data and tablesspace and the database could take into account prior usage.

Steven E Protter
Owner of ISN Corporation
Honored Contributor

Re: SCHED_NOAGE and Oracle


also have a look at metalink note: 239127.996

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Indira Aramandla
Honored Contributor

Re: SCHED_NOAGE and Oracle

Hi Miguel Angel,

This feature is available from Oracle8i onwards.

This could be suited to online transaction processing (OLTP) environments because OLTP environments can cause competition for critical resources. Overall performance improvements of 5 to 10% for OLTP applications

The parameter is of interger type with default value=0 and it can be set dynamically using Alter Session ot Alter system.
Range of values are 154 to 255 (for HP-UX 11.0) and 178 to 255 (For HP-UX 11i)

Oracle9i Real Application Clusters Multiple instances can have different values, and you can change the values as needed.
On HP-UX IA64 platform, must be running at least the patchset level. There is a one-off patch available for on MetaLink through Patch Number 2821953.

When setting this parameter to the highest fixed priorities
hpux_sched_noage=154 (for HP/UX 11.0)
hpux_sched_noage=178 (for HP/UX 11i)

If the parameter setting is out of range, Oracle sets the parameter to a permissible value and continues with the SCHED_NOAGE policy with the new value. It also generates a message in the alert_sid.log file about the new setting. Oracle Corporation recommends that you set the parameter to the required priority level for Oracle processes.

Indira A
Never give up, Keep Trying
Eric Antunes
Honored Contributor

Re: SCHED_NOAGE and Oracle

Hi Miguel,

See also Notes 217990.1 and 218027.1 from Metalink.

PS: read also this about the forum point system:

Best Regards,

Eric Antunes

Each and every day is a good day to learn.