Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books
SQL Server Books
Oracle Software
image
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
  Phone
  252-431-0050
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

    Privacy Policy

  

 

Click here for larger image

  Oracle 11g DBA
Reference Poster


Don Burleson, Mike Ault, John Garmany

ISBN 0-9744486-9-9 
Retail Price $12.95 /  £7.95 

Only $12.95      

 

Get the Oracle Tuning Pack
Six for $79.95 - A $150.00 value
Oracle Performance Troubleshooting $27.95
Oracle Replication $27.95
Oracle Wait Event Tuning $27.95
Oracle Disk I/O Tuning $27.95
Oracle 10g DBA Reference Poster $8.95
Oracle Silver Bullets $27.95

 

 
Get the Easy Oracle Pack
Six books for $59.95 - A $118.00 value
Easy Oracle Jumpstart $27.95
Easy Oracle PHP $27.95
Oracle DBA Made Simple (eBook) $19.95
Easy Oracle SQL $16.95
Oracle 10g DBA Reference Poster $8.95
Easy Oracle PL/SQL Programming $16.95

 


Mike Ault, Don Burleson and John Garmany are recognized among best-selling Oracle Authors in the world with over 50 Oracle books. For the first time ever, Burleson, Ault and Garmany combine their talents in this exceptional Oracle11g poster. This poster focuses on the most important DBA views to the underlying tables in the Oracle 11g data dictionary.

This annotated Oracle data dictionary poster only displays the most important DBA dictionary views, the important data columns and the relationships between the DBA views. It's a great cheat-sheet for writing customized Oracle dictionary scripts.

Especially useful are the Automated Workload Repository (AWR) and Active Session History (ASH) DBA views. The most useful feature of this Oracle dictionary reference is the inclusion of the relationships between the views. This allows the Oracle DBA to quickly see the table join keys required for writing complex data dictionary queries.

 

 
Key Features

* Assists the Senior Oracle DBA in writing complex dictionary queries

* Include entities and relation information for all important DBA views

* Includes details on the Automated Workload Repository (AWR)

* Include DBA views for the Active Session History (ASH)

* Allows the senior Oracle DBA to create sophisticated predictive modeling scripts

WARNING - This poster is not suitable for beginners.  It is designed for senior Oracle DBAs and required knowledge of Oracle data dictionary internal structures.

This poster is indispensable for every senior Oracle professional who requires an intelligent quick-reference Oracle poster for the 11g data dictionary. 

 

About the Authors:

Mike Ault

Mike Ault has five Oracle Masters Certificates.  Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.

 


Donald Burleson

Donald K. Burleson is one of the world’s top Oracle Database experts with more than 20 years of full-time DBA experience.  He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems.  

A former Adjunct Professor, Don Burleson has written 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Rampant TechPress. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.

 

Free Oracle Tips

HTML Text

John Garmany

 

John Garmany is a Senior Oracle DBA with Burleson Consulting.  A graduate of West Point, an Airborne Ranger and a retired Lt. Colonel with 20+ years of IT experience. John is an OCP Certified Oracle DBA with a Master Degree in Information Systems, a Graduate Certificate in Software Engineering, and a BS degree (Electrical Engineering) from West Point.  A respected Oracle expert and author, John serves as a writer for Oracle Internals, DBAZine and SearchOracle and SELECT Magazine.  John is also the author of four bestselling Oracle books by Rampant TechPress, Oracle Press and CRC Press and hosts a popular Oracle Application Server Newsletter.

   

Oracle poster Contents:

 

dba_clu_columns, dba_clusters, dba_col_privs, dba_cons_columns, dba_constraints, dba_data_files, dba_extents, dba_external_tables, dba_free_space, dba_free_space_coalesced, dba_high_water_mark_statistics, dba_hist_active_sess_history, dba_hist_bg_event_summary, dba_hist_buffer_pool_stat, dba_hist_db_cache_advice, dba_hist_enqueue_stat, dba_hist_evcmetric_history, dba_hist_event_name, dba_hist_filemetric_history, dba_hist_filestatxs, dba_hist_latch, dba_hist_latch_children, dba_hist_latch_misses_summary, dba_hist_latch_parent, dba_hist_metric_name, dba_hist_pga_target_advice, dba_hist_pgastat, dba_hist_seg_stat, dba_hist_sga, dba_hist_sgastat, dba_hist_shared_pool_advice, dba_hist_sql_plan, dba_hist_sql_summary, dba_hist_sql_workarea_hstgrm, dba_hist_sqlstat, dba_hist_sqltext, dba_hist_sys_time_model, dba_hist_sysmetric_history, dba_hist_sysmetric_summary, dba_hist_sysstat, dba_hist_system_event, dba_hist_waitclassmet_history, dba_hist_waitstat, dba_ind_columns, dba_ind_partitions, dba_ind_subpartitions, dba_indexes, dba_join_ind_columns, dba_lmt_free_space, dba_lmt_used_extents, dba_lobs, dba_objects, dba_segments, dba_tab_col_statistics, dba_tab_columns, dba_tab_histograms, dba_tab_partitions, dba_tables, dba_tablespace_groups, dba_tablespaces, dba_triggers, dba_undo_extents
 

 

 

Errata and Enhancements

Key to box color codes on poster:

  • Grey- Top level reference views that contain names, snapshot dates and times, etc
     

  • White – Main reference level views that contain data such as individual waits, enqueues, SQL and objects
     

  • Blue – Drill down or detail views for expanded data for the White level views.

 

   

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation.
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks