oracle questionaire [message #460841] |
Tue, 15 June 2010 03:47 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vjgreat
Messages: 1 Registered: June 2010
|
Junior Member |
|
|
Hi All,
I am new to this forum. Great to join this group.
I have been asked to prepare a questionaire for a customer. for example,
What Version of Oracle database and edition? And no of databases?
Whether ASM used, if so number of disk groups?
What is the database size?
What is the SGA size?
What is the PGA size?
No of application schemas?
Is it uses raw disk file?
so anyone has a template which has basic oracle questions to be probed to a customer?
Regards,
Hari
|
|
|
Re: oracle questionaire [message #460845 is a reply to message #460841] |
Tue, 15 June 2010 03:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
I doubt anyone has such a template, sounds like you've got the start of one anyway.
I'm really not sure what sort of customer you plan on asking these questions, customers shouldn't care about such things, software vendors on the other hand should.
|
|
|
Re: oracle questionaire [message #461598 is a reply to message #460845] |
Sat, 19 June 2010 10:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
jack124
Messages: 1 Registered: June 2010 Location: India
|
Junior Member |
|
|
Determining the PGA size is a critical part of Oracle RAM tuning. Each PGA RAM region is allocated for every dedicated connection, and the size is determined as follows:
* OS Overhead - "Program Global Area (PGA):OS Overhead" We reserve 2 meg for Windows and 1 meg for UNIX.
* Sort_area_size parameter value - " Program Global Area (PGA): Sort_area_size" This RAM is used for data row sorting inside the PGA.
* Hash_area_size parameter value - " Program Global Area (PGA) :Hash_area_size " This RAM defaults to 1.5 times sort_area_size and is used for performing hash joins of Oracle tables.
|
|
|