Solved

Need a checklist for pre and post installation of Oracle 11g on Windows server 2008

Posted on 2011-03-01
4
1,168 Views
Last Modified: 2012-06-21
Hi Guys,

Currently I need a checklist as mentioned in title above. Hope you guys can share with me the installation and tuning procedures.

-titanium0203
0
Comment
Question by:titanium0203
4 Comments
 
LVL 13

Expert Comment

by:riazpk
ID: 35014371
Did you checked the Installation guide?

Oracle® Database Installation Guide
11g Release 2 (11.2) for Microsoft Windows

http://download.oracle.com/docs/cd/E11882_01/install.112/e16773/toc.htm

Are you talking about database tuning or SQL tuning?
0
 

Author Comment

by:titanium0203
ID: 35014839
riazpk,

database tuning. If possible I want to increase the sga,pga etc so that
this database will not facing any performance problems. This Database is for
transaction process and it is a stand alone server no ASM.
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 35016215
read this from oracle open world :oracle on win performance best practices

http://www.oracle.com/technetwork/topics/dotnet/tech-info/ow2010-windowsdb-performance-177304.pdf
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 125 total points
ID: 35016862
People make entire careers out of tuning Oracle.  These types of questions are really hard to answer in a forum like Experts-Exchange.  So much of it depends on your specific setup.

In a nutshell:
step1: document the existing performance issues.
step2: analyze what is causing them
step3: make changes you feel might solve these specific problems.
step4: monitor to see if those issues were resolved and no new ones were introduced
step5: repeat often

If you are licensed for the Diagnostics and/or Performance packs you can run AWR ADDM reports over time.  Starting with 11g the performance advisors are pretty good and making accurate recommendations.

0

Featured Post

Free book by J.Peter Bruzzese, Microsoft MVP

Are you using Office 365? Trying to set up email signatures but you’re struggling with transport rules and connectors? Let renowned Microsoft MVP J.Peter Bruzzese show you how in this exclusive e-book on Office 365 email signatures. Better yet, it’s free!

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
OfficeMate Freezes on login or does not load after login credentials are input.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now