Breakdown of Oracle SGA into Solaris Locality Groups
Muhammad Anwar
October 14, 2013
Goal: for a given process, find out how the SGA was allocated in different locality groups on a system running Solaris operating system. C...
Results for
Permanent link to this entry
Solaris lgroups, CT optimization, Data Pump, Recompilation of Objects
Muhammad Anwar
July 30, 2013
1. [Re]compiling all objects in a schema exec DBMS_UTILITY.compile_schema(schema => 'SCHEMA'); To recompile only the invalid...
Enabling 2 GB Large Pages on Solaris 10
Muhammad Anwar
August 03, 2012
Few facts: - 8 KB is the default page size on Solaris 10 and 11 as of this writing - both hardware and software must have support for 2...
Revert the entire database to a previously saved state - Oracle 11g
Muhammad Anwar
August 27, 2011
Error recovery, historical reporting, trend analysis, data forensics and fraud detection are just some of the business problems that can be...
Subscribe to:
Posts
(
Atom
)