Skip to Content
Author's profile photo James Zhang
James Zhang
October 7, 2015 Less than a 1 minute read

User specific database parameters (use_large_pages , etc) after migrating “oracle” user

Hi Folks,

Recently I am testing and verifying the problems&questions regarding migrating to “oracle” user on Oracle 12c.

We have an SAP note “1888485 – Database Parameter for 12.1.0.2” which tells us the right database parameters should be set. Please verify those
“Database Parameter Settings for Specific Platforms” database parameters carefully.

use_large_pages is the one that adjusted for oracle owner, after migrating “oracle” user, you have to adjust it from OS level as well according to SAP note 1672954.

We have met a very bad performance issue after upgrading to oracle 12c, it took us days to dig the cause in wrong way. We were getting deeper and deeper into wrong road for days (reviewing sqls, io, etc. 😕 ). Luckily we finally found this parameter use_large_pages needs to adjusted for oracle user. Keeping parameters right is the prerequisite for tuning database performance.

Best regards,
James

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.