ORACLE DBA SURVIVAL KIT

Real-time Oracle DBA SQL queries packed as an Survival Kit. Oracle Database Administrators are welcome for knowledge sharing and discussions.

Welcome to Maari Consulting

Oracle DBA Survival Kit

DEMO E-Book Available for Download below :

  • Right Click and use "Save link as..." to download a restricted version of the E-Book kit to know the touch and feel of the full version...Only Few pages are visible and also copy protected. Buy the full version for complete use. 
  • Only Pages 1, 2, 9, 10, 11, 21, 23 are available for viewing only in this DEMO version. Copy/Print options are blocked.
  • You will get an error message for all other pages stating that the Page is Locked.
  • Right Click below Download Link and use "Save link as" (Demo Book below is a Executable application)

BE A SPARTAN IN DATABASE ADMINISTRATION 

To Buy fully registered Version read below details :

  • Your Own Script Base Ready to Use.
  • Contents Below. Check the above "Sample Queries" page for few of the commands from this E-Book. 
  • This E-Book includes almost everything that is on High Demand for Oracle Database Administrators (Level1/Level2 Support). 
  • You get almost everything you need as a DBA. This Kit is designed mainly for L1/L2 DBA to Survive in their current Work.
  • This book includes 113 Most demanded Topics with More than 1000s of Commands which includes Sql Queries/Os Commands/Installation & Upgrade Guides with Screenshots.  
  • All are examples only. It may not solve the issue in all cases but most cases.

To DOWNLOAD Full Version use the below Link :

(You Need to Buy a Registration Key to Activate the book).

Maari Consulting Oracle DBA Survival Kit-V1.exe

Important Instructions

  • Use the below BUY NOW Button to buy this E-Book.
  • Upon Purchase, you will receive a email link & in the Explorer screen to download the fully functional E-Book with a Registration Key to Unlock it.
  • This E-Book is Hardware Locked. It means, this E-Book and Registration Key can work on only one computer where the book is downloaded and registered.
  • Please always download and Register this E-Book in the main computer where you actually perform your DBA Activities for ease of use.
  • We are giving away a additional free license on demand from buyers. So you get 2 licenses for $15.
  • If you want to use this E-Book in more than two computers, then you need to buy this E-Book for the additional computers.
  • If the Computer crashes, you can contact "support@maariconsulting.com" to again register in the new computer for free of cost.
  • Please save a copy of the downloaded E-Book kit for backup purpose in-case restore is required. Contact the above email address in-case of questions and clarifications.
  • Please read the Prerequisites and Terms of Service before buying this E-Book. 
  • Complete Contents of the E-Book is available below the Buy Now button.
Credit Cards / Paypal - (Click BUY NOW button for Instant Delivery)

Buy Now      

Buy to Be & Survive in your DBA Role

  • We Give a additional FREE LICENSE on Request from buyer for every purchase!!!. You can use this additional license to use the E-Book in your personal laptop/Desktop as a backup copy!!!.
  • So two licenses for $15 (Additional license can be created when you mail us @ "support@maariconsulting.com" on demand)

Oracle DBA Survival Guide E-Book Kit Version - 1 (CONTENTS) 

PAGES

  1. Home - Maari Consulting Oracle DBA Survival Kit Ver1
  2. Contents - Page wise

     

Database/Instance Information

  1. Getting Complete Database Information
  2. Identifying Database size
  3. Instance Up-time
  4. Finding Oracle server bit (32 or 64bit)
  5. Identifying NLS Parameters
  6. Finding Instance id-Host name-Instance name in RAC

     

All types of Tablespace Maintenance and issues

  1. Normal Tablespace Maintenance Scripts Complete
  2. Undo Tablespace Scripts
  3. Temp Tablespace Scripts
  4. Resolving Segments in Tablespace approaching Max Extents
  5. Resolving Segments unable to extend in Tablespace
  6. Tablespace Growth (When files are added)
  7. Single query to resolve Small Problematic Segments
  8. Resolving Max extents reached for LOB segment
  9. Rollback segment Management & shrinking

     

Analyzing Oracle Sessions Complete

  1. Session Details shell script
  2. Setting the NLS DATE FORMAT TO Display accurate DATE with Mins hours and seconds
  3. ASH scripts CPU util
  4. Active and Inactive Sessions sqls
  5. sid.sql Script to pull out complete Sessiondetails
  6. Session information Adhoc Queries
  7. Session Info from PID
  8. Session Info from SID
  9. Session details ConcurrentReq Complete
  10. Checking what is the Last SQL of a Session
  11. Long Running Sessions Monitoring
  12. Identifying Active transaction thru SID
  13. Checking for active transactions of a session using SID
  14. Checking rollback & Undo segment info used for a session using SID
  15. Checking Timing Details of SID and event waiting for
  16. Identifying Sever Machine and Client Machine names of a session
  17. Obtaining Session details Query
  18. Date & Time of database users & file

     

Various Locking/Blocking issues

  1. Different Lock Modes with explanation
  2. Identifying Blocking sessions Complete
  3. Troubleshooting Library Cache Lock Pin Loadlock wait events
  4. Locked Objects Complete
  5. Killing a Session

     

Various Wait events Analysis

  1. Identifying the Wait event of a session thru SID
  2. Wait events Analysis Complete
  3. Sessions Ordered by Wait Events
  4. Buffer Busy Wait Monitoring and Troubleshooting
  5. DB File Scattered read Monitoring and Troubleshooting
  6. Latch Free Sessions Monitoring

     

Cloning Database and Oracle Homes Complete

  1. 14 Steps for CLONING USING RMAN Recovery with any storage Manager backups
  2. Cloning Using RMAN Incomplete Recovery for Disk Backups and Using automated shell script
  3. How to CLONE ORACLE HOME (Both RAC and Non RAC)
  4. Cloning Oracle Home Manually

     

Restore/Recovery Using RMAN Various Scenarios

  1. POINT IN TIME PRODUCTION RESTORE RECOVERY Using RMAN Backups
  2. Recovering a Nonsystem datafile which is Missing and not available in the RMAN Backup
  3. Recovering Loss of all Controlfiles situation
  4. Recovering Loss of System Datafile
  5. Recovering Loss of Undo Datafile
  6. Restoring a Corrupted Non System datafile using RMAN Backups
  7. Restoring a Corrupted Non System Tablespace using RMAN Without shutting down the database

     

Managing RMAN Backups

  1. Oracle 10g New RMAN backup and recovery V$VIEWS
  2. Deleting backed up Old Archivelogs using RMAN
  3. RMAN Backups monitoring sqls
  4. RMAN Backups overall progress Status
  5. Managing RMAN Disk Backups
  6. Using DBV utility

     

Export/Import

  1. Zipping and Exporting a table using GZIP option on the fly with mknod
  2. Realtime EXPDP & IMPDP DATAPUMP Export Import Commands.htm

     

Various Versions Installations/Upgrades and Creating DB using DBCA (With Screen shots)

  1. Oracle 11g R2 Installation and DB creation using DBCA
  2. Oracle 11106 DB installation 11107 Upgrade and DB Creation using DBCA
  3. 10201 Installation 10204 Upgrade & DB creation using DBCA

     

Oracle 11i Apps CRs and other commands helpful

  1. Oracle 11i Apps Concurrent requests Complete
  2. Analyzing Oracle apps 11i f60webmx FORMS spinning process
  3. GatherSchemaStatitics_complete

     

Oracle background trace/log/dump files maintenance standalone script

  1. Oracle background trace & log files maintenance Standalone Script

     

OS Commands Very useful for DBAs and Files Management

  1. Finding OS Version and Bit
  2. Kilobytes-Megabytes-Gigabytes Convention
  3. To Check whether Sendmail is Enabled in a Unix Box
  4. OS Process count
  5. Unix commands Filesystem & codetree Management Complete
  6. Unix OS Diagnostic commands for DBAs
  7. Analyzing DiskIO Queries
  8. Unix Command to identify High DISK IO
  9. Finding client process if not listed in v$process
  10. Identifying CPU count in a Unix box
  11. Identifying RAM Size in a Unix Box
  12. AIX TOP Command Alternatives
  13. SCP Command Examples
  14. TAR Command Examples

     

ASM Important Commands for Monitoring

  1. ASM Most usefull commands

     

Dataguard Important Commands for Monitoring

  1. Dataguard Standby database & MRP immediate queries

     

Troubleshooting Performance issues

  1. In environments using Outlines, Creating a New Stored outline to fix plan instability.
  2. Finding Optimizer Statistics details & re-gathering Statistics
  3. Bind Peeking Hidden Parameter
  4. Generating Run time execution plan

     

Tracing and TKPROF

  1. Tracing a Session OR Process using ORADEBUG SQLTRACE & DBMS_MONITOR
  2. TKPROF with explain plan

DBA_JOBS

  1. Dba_Jobs Process Scripts

     

Database Objects

  1. Getting the Source code of a package using DBMS_METADATA_GETDDL Package
  2. Identifying Object details from dba_objects
  3. Identifying Oracle Schema size
  4. OBJECTS modified with LAST DDL time on a specific date
  5. Finding LOB Segment size

     

Invalid Objects

  1. Invalid objects Scripts

     

Parallel Processing Sessions Analysis

  1. Parallel Query Process Scripts

     

Table Defragmentation Analysis and Resolution

  1. Query to Identify table fragmentation Complete
  2. Table Defrag and Index rebuild using MOVE Command Examples

     

Archivelog Generation Rate and Block Changes Monitoring

  1. Redo Archive logs generation per Hour & Day basis_complete
  2. High redo & block changes

     

SQL Commands related to SGA Memory

  1. How to find out pga and uga usage
  2. Sessions Consuming High PGA Memory
  3. SGA Memory advisory queries
  4. Who is using session UGA memory

     

Index Information

  1. Index information dba_ind_col
  2. To check indexed columns

     

DB Links

  1. Verifying details about DB-LINKS in DB

     

Various v$views and 10g New features for beginners

  1. Important 10g New Features TITLES ONLY
  2. v$views and descriptions
Please read below Prerequisites and Terms of Service notice before buying this product. Click below button to BUY this E-Book.


Buy Now


AddThis Social Bookmark Button

VISITORS

Recent Videos

No recent videos

Recent Forum Posts

No recent posts

Testimonials

  • "Hi Rajesh, Thanks for the prompt response. Yes its working now after disabling firewall. And going through the contents of your E-Book seems like almost all the things neede..."
    Vishnu
    ORACLE DBA (Sathyam)
  • "I would like to say something about your dba Kit; Honestly, I thought before reading your kit that I am proud of what I know about oracle but now I am proud of your very impo..."
    Mokhtar
    Telecoms Billing System DBA Administrator (Mauritania- Africa)