Database Tuning (MOSC)

MOSC Banner

Setting SGA & PGA in a high volume

edited Jan 11, 2013 5:55AM in Database Tuning (MOSC) 20 commentsAnswered
 

OS Info:

 

OS Name  Microsoft(R) Windows(R) Server 2003 Enterprise x64 Edition

Version      5.2.3790 Service Pack 2 Build 3790

Other OS Description  R2

System Type              x64-based PC

 

Total Physical Memory                61,429.51 MB

Available Physical Memory           25.93 GB

Total Virtual Memory   68.51 GB

Available Virtual Memory              26.02 GB

Page File Space         10.00 GB

Intel Xenon CPU

X5650 @ 2.67GHz

 

Page File : 43364 MB Used, 26785 Available

 

Processes

 

Image Name Username Mem_Usage

oracle.exe  system     21,620,260 

 

 

DB Info:

 

BANNER

 

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

PL/SQL Release 10.2.0.1.0 - Production

CORE       10.2.0.1.0  Production

TNS for 64-bit Windows: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 - Production

  

SQL> show parameter sga

 

NAME                                 TYPE        VALUE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center