Tuning questions

From: Terry Underwood <m01jra00_at_cwcom.net>
Date: Thu, 29 Apr 1999 19:04:25 +0100
Message-ID: <37289F25.2DADCD82@cwcom.net>

Enclosed in text format is a tuing questionaire, I would be most grateful for any responses and any findings will be mailed to all senders after analysis

Regards

Terry Underwood

Southampton
Institute

Oracle Optimisation Questionnaire

This questionnaire forms part of the final project of a BSc. Business Information Technology degree at Southampton Institute of Higher Education. Apologies are made regarding the specifics of this questionnaire but all responses at whatever level will be most useful.

The purpose of this questionnaire is to investigate the ways that organisations make the most of their Oracle databases. It also intends to investigate the different tuning methods used and give a guide as to their perceived effectiveness. From these results, recommendations will be made regarding tuning policies.

Please complete the questionnaire and return using the enclosed envelope. All respondents will be sent via e-mail, a copy of the results of the survey if requested.

Thank you for your time.

Terry Underwood

Oracle Optimisation Pilot Questionnaire

IMPORTANT- THE CONTENTS OF THIS FORM ARE ABSOLUTELY CONFIDENTIAL. INFORMATION IDENTIFYING THE RESPONDENT WILL NOT BE DISCLOSED UNDER ANY CIRCUMSTANCES. Q1 Respondents Name

Q2 Organisation

Q3. E-mail address		     
				(enter if you require a copy of the results)

Q4 Position Held? (Select one).

  	DBA
	IT Manager
	Systems Support
	Other

Q5 Number of users serviced by the Oracle database? (Please specify).              

Q6 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).                       

Q7 If known, what is the average number of operations made per day on the Database?

       (Please specify).                       

Q8 Is your Oracle database tuned internally by employees, or externally using Specialists?(Select one).

	Internally
	Externally
	Not tuned
	Other

Q9 If your organisations Oracle database is tuned externally, approximately how much a year does this cost? (Please Specify or leave blank if unknown)         

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

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

Q11 If other, please specify what means are used to speed up your system?                       

Q12 Are you directly responsible for, or have some involvement in the maintenance and

         upkeep of your database? (Select one only).

                        Yes No

Q13 Have you personally ever tuned an Oracle database to improve performance?

         (Select one only).

			Yes					No	
							(If No, please go to the end of 							the questionnaire)

Q14  Have you ever received training relating specifically to tuning an Oracle database?
           (Select one only)

			Yes					No	
			




Q15	Select the tuning goal that would be most appropriate to your system?
            (Select one only).

	Throughput
	Connectivity
	Fault tolerance
	Load time
	Response/Service time
	Other	

	If other is selected, please specify what other tuning goal is appropriate.
	
     
Q16	To your knowledge, which of the following server optimisation  

techniques have been employed on your organisation's 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				___		___     

Q17	In addition to those listed previous, which of the following performance enhancements have been investigated for your organisation's 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).

                                                Investigated Rating

Amending block sizes ___ ___

Adding clusters			___				___				     
Enabling direct write sorts	___				___			     
	
Hash clustering			___				___	     

Further indexing			___				___	     

Parallel query option		___				___     

Parallel loading 			___				___     


Q18  Following your organisations last tuning session, were the improvements 
         Benchmarked? (Select one only)

		Yes					No	

Q19 If the improvements were benchmarked, what improvements were documented?              

Q20 Are there any other optimisation techniques that, to your knowledge have been employed by your organisation?              

Thank you for completing this Questionnaire. Please return to Terry.Underwood_at_cwcom.net Results will be mailed to all respondents on completion of the survey and subsequent analysis. Received on Thu Apr 29 1999 - 13:04:25 CDT