Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

15 February 2021

Oracle LGWR is not running at highest priority

The Oracle database does automatically increase the priority on Solaris if you run
the database version 11.2.0.4 or later. On older versions this does not happen.


If you are on Oracle 12.1.0.2 it could be because of Bug
27092821 - IN 12C CRITICAL DATABASE PROCESSES ARE NOT RUNNING WITH HIGHER PRIORITIES IN FSS
It is fixed in 12.1.0.2.99


If you run the Oracle database in a Solaris Zone, make sure you have 'proc_priocntl' set in limitpriv in your zonecfg. This is required to allow the change of the priority inside the zone.


Ideally the ora_lwgr_x process should run in the FX class with prio 60.
This can be verified using

ps -efcZ | grep lgwr




30 May 2020

Oracle Database on Solaris ZFS done right

ZFS is the default filesystem on Oracle Solaris. It is
very easy to use with the two commands zpool and zfs.

Disk management
Expand existing LUNs or add additional LUNs if you
need more space. Since Solaris 11.4 you can remove LUNs if you
want to shrink your pool.

Features
No need for filesystem checks, because of the copy-on-write
implementation. You can create snapshots and clones,
use encryption and compression. Transfer data to other
systems using send/receive or sharing.
Move the pools using export/import to other systems.

ZFS builds the base for the Solaris BootEnvironment (beadm)
where you are able to update to and boot from different Solaris 11
Updates.

ZFS is my preferred filesystem and volume manager, but
is everything perfect? No. You need to carefully configure
ZFS to avoid and work around fragmentation.


Oracle Database

You can run Oracle Database very well on ZFS and profit
from snapshots, cloning and other features. Especially
for larger databases (many TB) with lots of data changes
you should setup carefully.

Following a few Best Practices based on own experiences
and Recommendations by Oracle:

- data pool with log device / 8KB recordsize for data / logbias=latency
- redo pool with log device / 1MB recordsize / logbias=latency
- archive pool / 1MB recordsize

Add multiple LUNs for striping. Use SSDs for highest performance.
If you are using SAN increase zfs:zfs_vdev_max_pending and ssd:ssd_max_throttle to 20.
Limit the ZFS Cache (zfs:zfs_arc_max)
Make sure there is around 20% free space on the zpools.
Use a Server with 'enough' Memory.

After many years of using ZFS it always hurts, if I have
to use other more complicated filesystem ....


Links

Pool Creation Practices for an Oracle Database (Solaris 11.4 ZFS Guide)

Configuring Oracle ZFS for an Oracle Database Whitepaper (2014)

Oracle DB erfolgreich betreiben auf SPARC/LDoms/Solaris/ZFS     (German Presentation)


30 October 2017

Events about SPARC and Oracle Solaris in Nov & Dec 2017

A) Webcast 3rd Thursday Tech Talk: Solaris Continuous Innovation: Modernize without the Risk

16. November 2017
Speaker: Scott Lynn


B) DOAG Konferenz und Ausstellung - Yearly Conference, Nuremberg (Germany)

21 - 24 November 2017
Speakers: Thomas Nau, Joost Pronk, Jan Brosowski, Manfred Drozd, Christophe Brune, Malthe Griesel, Elke Freymann, Michael Färber, Marcel Hofstetter


C) Oracle Power of Solaris Sponsored by Fujitsu, Rome (Italy)

28. November 2017


D) Oracle SPARC / Solaris Users Group Summit, Solna (Sweden)

1. December 2017
Speakers: Bill Nesheim, Martin De Jong, Wissam Moussa, Sergey Kalmykov, Niclas Fredsberg, Juha Hellman


E) UKOUG Tech 17 - Yearly Conference, Birmingham (UK)

4-6 December 2017
Speakers: Stefan Hinker, Marcel Hofstetter



F) Oracle Systems Summit 2017 - Mit Sicherheit in die Zukunft!

28.11. München, Germany
Speaker: Thomas Herrguth, Ralf Zenses, Detlef Drewanz, Jörg Meiners, Jan Brosowski

5.12. Köln, Germany
Speaker: Thomas Herrguth, Ralf Zenses, Detlef Drewanz, Jörg Meiners, Jan Brosowski

6.12. Frankfurt, Germany
Speaker: Thomas Herrguth, Ralf Zenses, Detlef Drewanz, Jörg Meiners, Jan Brosowski

14.12. Zürich, Switzerland
Speaker: Stefano Amato, Ralf Zenses, Detlef Drewanz, Jörg Meiners, Jan Brosowski, Marcel Hofstetter