Oracle Optimization

From: Terry Underwood <m01jra00_at_cwcom.net>
Date: Tue, 27 Apr 1999 15:32:58 +0100
Message-ID: <3725CA98.B58202D@cwcom.net>

Enclosed is a tuning questionaire aimed at DBA's. It forms part of my degree final project so any responses would be most grateful.

Regards

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 Tue Apr 27 1999 - 09:32:58 CDT