This is a presentation I put together for a presentation to the Dallas Oracle User’s Group (DOUG) on March 24,2011.
It goes over the installation process of a Weblogic instance, the setup of a Nodemanager instance, connecting the two together, and the setup of a cluster. Additionally, it goes into Weblogic tuning tips and considerations for moving to and utilizing Weblogic with new and existing server environments and application developments.
Link to the presentation PDF
Fixed objects statistics are often overlooked in the scheme of operations in the database. Like any database object in a production environment, these objects undergo changes and need to be analyzed from time to time to ensure that the optimizer has the latest information to be able to access them effectively. The automatic statistics gathering jobs in 10g and 11g do not collect the fixed object statistics by default, but the fact that these jobs exist underscores the importance of optimizer statistics. We are going to see in this scenario that statistics on the often neglected fixed object statistics are important as well.
We will start with a typical query you would execute to find out who is accessing certain objects in the database:
select distinct owner
Our test system: Oracle 10.2.0.4.0 on Sun SPARC Solaris version 10