For Oracle support & training call (800) 766-1884
Free Oracle Tips

Home
Oracle Tips
Oracle Code Depot
Oracle Monitoring
Oracle Consulting
Oracle Training
Oracle News
Oracle Forum
Oracle Support





 

Free Oracle Tips

image

 
HTML Text

Free Oracle App Server Tips

image

 
HTML Text


Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle


 

   
  Oracle Tips by Burleson

Describe Object Parameters

After reading all of the reading assignments for this tutorial, prepare an executive summary that describes every storage parameter used by Oracle tables and comment on their use within the real world.  The report should include a paragraph on each of these parameters, describing the appropriate setting for each, and those parameters that should always be left to their default values. 

For full credit, you must identify those parameters that should always be left with their default values, and those parameters that are over-ridden by locally-managed tablespaces and automatic extent management. 

HINT: Remember to use Google to locate detailed information on these parameters.

- PCTFREE

- PCTUSED

- MAXTRANS

- INITTRANS

- FREELISTS

- FREELIST GROUPS

- INITIAL

- NEXT

- PCTINCREASE

- MINEXTENTS

- MAXEXTENTS

- BUFFER_POOL


For more details, see the "Easy Oracle Series" a set of books especially designed by Oracle experts to get you started fast with Oracle database technology.

  
 

 
 
 
 
Oracle performance tuning software
 
 

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

Fast-Track Oracle Support
PO Box 511
Kittrell, NC 27544


Email BC: