Price: Check with seller

No image available

Sponsored Ads

Description

Oracle PERFORMANCE TUNING




    • DATABASE PERFORMANCE TUNING CONTEXT





    • THE DATABASE INSTANCE TUNING METHODOLOGY



STATISTICS & WAIT EVENTS




    • ABOUT THE DYNAMIC PERFORMANCE VIEWS





    • EXAMINING THE STATISTICS





    • INTERPRETING THE STATISTICS



USING STATSPACK




    • INSTALL THE STATSPACK UTILITY





    • CREATE STATSPACK SNAPSHOTS





    • GENERATE STATSPACK REPORTS





    • IDENTIFY THE REPORT SECTIONS



AUTOMATIC TUNING & AWR









    • ABOUT THE MANAGEMENT & ADVISORY FRAMEWORK








    • MANAGING THE AUTOMATIC WORKLOAD REPOSITORY








    • ABOUT THE ACTIVE SESSION HISTORY (ASH)








    • AUTOMATIC DATABASE DIAGNOSTIC MONITOR








    • MANAGING SNAPSHOTS








    • CREATE_BASELINE() & DROP_BASELINE()








    • CREATE_SNAPSHOT() & DROP_SNAPSHOT_RANGE()







METRICS, ALERTS & BASELINES









    • METRICS & ALERT THRESHOLDS








    • MANAGING METRICS








    • MANAGING ALERTS








    • USE EM REAL-TIME MONITORS







TUNING MEMORY: THE SHARED POOL









    • MORE ABOUT THE SHARED POOL








    • DIAGNOSE SHARED POOL PROBLEMS








    • KEEP OBJECTS IN THE SHARED POOL







TUNING MEMORY: THE BUFFER CACHE









    • MORE ABOUT THE BUFFER CACHE








    • REMEDY PERFORMANCE ISSUES







TUNING MEMORY: AUTOMATIC SHARED MEMORY









    • AUTOMATIC SHARED MEMORY MANAGEMENT








    • USING EM & THE MEMORY ADVISORS







TUNING I/O: CHECKPOINT & REDO TUNING









    • TUNE REDO WRITING & ARCHIVING








    • MTTR ADVISOR & TUNING CHECKPOINTS








    • LOG_CHECKPOINTS_TO_ALERT








    • ADDITIONAL REDO TUNING OPTIONS







TUNING I/O: DATABASE WRITES





SPACE TUNING: PGA & TEMPORARY SPACE









    • PGA MEMORY MANAGEMENT








    • TEMPORARY SPACE MANAGEMENT







SPACE TUNING: BLOCK SPACE USAGE









    • USING THE SHRINK SPACE OPTION








    • USING THE SEGMENT ADVISOR











 

More Details

Total Views:9
Reference Id:#517893
Phone Number: 8939915577
Website URL: Click To Visit
Current Rating: /5 0 Vote

Comments

Copyright © 2017 |   All Rights Reserved |   TuffClassified |   24x7 support |   Email us: query[at]tuffclassified.com