Oracle Tuning

From: Terry Underwood <m01jra00_at_cwcom.net>
Date: Sat, 24 Apr 1999 12:47:21 +0100
Message-ID: <3721AF47.370FF315@cwcom.net>

Enclosed is a questionnaire on tuning techniques. It forms part of my dissertation so any replies would be most grateful. A full copy of the results will be sent to all respondents requesting them.

Thanks

Terry Underwood

Oracle Optimisation Pilot Questionnaire

This questionnaire forms part of the final project of a BSc. Business Information Technology degree at Southampton Institute of Higher Education.

The purpose of this questionnaire is to investigate the ways that organisations get the most from their Oracle database, the costs involved and the savings available. It also intends to investigate the different tuning methods used in industry and give a guide as to their perceived effectiveness.

Please complete the questionnaire, starting on the next page, save as a text file and send as an attachment to Terry.Underwood_at_cwcom.net All respondents will be sent via e-mail, a copy of the results of the survey and a database of tuning techniques if requested.

Any comments or criticisms regarding the questions or layout of the form would be most welcome, please add these to the body of the return e-mail message.

Thank you for your time.

Oracle Optimisation Pilot Questionnaire

IMPORTANT- THE CONTENTS OF THIS FORM ARE ABSOLUTELY CONFIDENTIAL. INFORMATION IDENTIFYING THE RESPONDENT WILL NOT BE DISCLOSED UNDER ANY CIRCUMSTANCES. Use the tab key to navigate between fields

Name ______________

Organisation ______________

Q1 Position Held (Select one)

		DBA 
            System Support
		IT Manager
            Other

Q2	Number of users serviced by the Oracle database
	
		____________

Of those users serviced by the Oracle database, approximately how many are using it constantly as part of their job, e.g. customer services (please specify).

Q3	Is your organisations database predominately tuned internally by
            employees or externally, using specialists?

		Internal
		External	
		Other

Q4	If your organisations Oracle database is tuned externally, approximately

how much a year does this cost? Leave blank if unknown.

Please include currency symbol in figure.

Q5 Traditionally, as a means of speeding up a poorly performing system, which of the following is your organisation most likely to do?
(Select one only)

		Hire tuning specialists
		Upgrade hardware
		Train staff in tuning techniques
		Nothing
		Other

If Other, please specify what means are used to speed the system up?

Q6 Are you directly responsible for, or have some involvement in the maintenance and upkeep of your database?

	Yes
	No

Q7 	Have you ever received training in tuning techniques

	Yes
	No

Q8	Have you personally ever tuned an Oracle database to improve

performance?

	Yes
	No


Q9	If so, select the tuning goals that are most appropriate to your system.

	Throughput			__				Connectivity  __	

	Fault tolerance		__				Load time	  __

	Response/service time 	__				Other		  __

If other is selected, please specify what other tuning goals are appropriate.

Q10	To your knowledge, which of the following server optimisation  
            techniques have been employed on your organisations Oracle database.

(For those selected, please number according to impact made. 1 - Very effective, 2 - Effective, 3 - No effect, 4 - slight adverse effects, 5 - severe adverse effects).

Employed Impact

Optimiser

Tuning the Private SQL and PL/SQL areas ___ ___

Tuning the shared pool ___ ___

Tuning the buffer cache ___ ___

Tuning the I/O subsystem ___ ___

Measures to reduce disk contention ___ ___

Separate Data and Indexes ___ ___

Adjusted PCTFREE/PCTUSED ___ ___

Tuning rollback segments ___ ___

Tuning redo log buffer ___ ___

Optimising archiving ___ ___

Q11 In addition to those listed above, which of the following performance enhancements have been investigated for your organization's Oracle database.

(Please indicate also, the techniques that have been used, and (For those selected, please number according to impact made. 1 - Very effective, 2 - Effective, 3 - No effect, 4 - slight adverse effects, 5 - severe adverse effects).

Investigated Rating

Amending block sizes				___			___				  
Adding clusters					___			___			  

Enabling direct write sorts			___			___				
Hash clustering					___			___			  

Further indexing					___			___	

Parallel query option				___			___			  

Parallel loading 					___			___			  



Q12	Are there any other optimisation techniques that, to your knowledge have
	Been employed to your organisation?

		__________________________________________________________________
     
		__________________________________________________________________

Thank you for completing this Questionnaire. Please save the resulting file and return e-mail. Results will be mailed to all respondents on completion of the survey and subsequent analysis. Received on Sat Apr 24 1999 - 06:47:21 CDT