DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBAs become bulletproof!

Links

6 thoughts on “Links
  • asghar says:

    Fantastic! Thx for sharing :)

  • Recently i found your presentation ASH and AWR performance data, I enjoyed the video on youtube , and also now I can see the pdf of the presentation. Digger who you are is amazing you share the scripts for all the platforms.

    ( after 16 years worked with oracle and 11 years with sqlserver)
    My Litle suggestions to add to sqlserver scripts

    1.adam machanic Who is active (http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx)
    2. Michelle Ufford db_index_defrag (Marvelous )
    3.Brent Ozar ( Find Indexes Not used) http://sqlserverpedia.com/wiki/Find_Indexes_Not_In_Use
    4.Grant Fritchey (Scary DBA) ( https://www.simple-talk.com/sql/sql-tools/custom-metrics-for-monitoring-database-mirroring/)

    Very useful tool
    Performance Dashboard Reports (Microsoft 2005,2008,2012)
    SQLNexus (Microsfot) the reports are amazing

    Oracle
    1. tanel poder snaper ( Brilliant ) (http://tech.e2sn.com/oracle-scripts-and-tools/session-snapper)
    2. Randolf Geist’s Extended DISPLAY_CURSOR (http://oracle-randolf.blogspot.com/2011/12/extended-displaycursor-with-rowsource.html)
    3. Kerry Osborne (Thank you teacher ) create and fix sql_profile.
    4.NORBERT DEBES asm hidden parameters

    My favorite tool
    sqlplus and Mumbai

  • Hi – I am looking for a way to duplicate a database:
    - use of “set newname”, not using db_file_name_convert, etc
    - back to a point in time, when a particualr TS still had existed. TS has been dropped including contents and datafiles -> the actual controlfile does not know about it anymore.
    So generating the set newname syntax will miss the datafiles from the past if I query v$datafiles from the production database.
    I need to find a way to restore the correct controlfile to the testserver and query that one prior to duplicate the database with “set until time”…
    Hope you can understand my issue and hope you find a minute to give me a line back.
    Best regards, Andy

  • sumanth says:

    Could you please update on this.

    i found this query in your site .

    SQL> select opname “Description”, round(totalwork/60/60) “Minutes Spent”, round(time_remaining/60/60) “Minutes Left”, sid
    from v$session_longops
    where sid in (2129)
    order by time_remaining desc 2 3 4
    5 /

    Description Minutes Spent Minutes Left SID
    —————————————————————- ————- ———— ———-
    Hash Join 350 5 2129

    SQL> !date
    Wed Feb 26 15:25:18 NZDT 2014

    SQL> select opname “Description”, round(totalwork/60/60) “Minutes Spent”, round(time_remaining/60/60) “Minutes Left”, sid
    from v$session_longops
    where sid in (2129)
    order by time_remaining desc 2 3 4
    5 /

    Description Minutes Spent Minutes Left SID
    —————————————————————- ————- ———— ———-
    Hash Join 350 3 2129

    Wed Feb 26 16:22:00 NZDT 2014

    =========================

    IT SAYS ONLY 5 MIN BUT EVEN STILL AFTER 2 HOURS IT IS STILL RUNNING WHY . IS THE QUERY WRONG .

  • Cindi says:

    Hi Kellyn,

    Love your site, best wishes with your new endeavors.

    We have had OEM 12c for a while now, But we are getting ready to setup our first email alerts there for such things as the alert log errors and out of tablespace. Any recommended articles for me?

    Thanks,
    Cindi

  • dbakevlar says:

    Hi Cindi,
    Thank you, I appreciate the kind words. I would actually start with ensuring that all is set up properly in your EM12c environment and then reading through the alerting piece in this blog series I wrote a while back: http://dbakevlar.com/2013/08/em12c-enterprise-monitoring-part-i/ Oracle documentation always comes in handy: http://docs.oracle.com/cd/E24628_01/doc.121/e24473/notification.htm
    and if you have any questions, just let me know!
    Kellyn

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

  • Facebook
  • Google+
  • LinkedIn
  • Twitter