Commits

Commit history

1. Commits on Oct 1, 2013

   • A simple procedure to show open cursors

     Show description for 77b3a54
     geekcomputers

     committed
     77b3a54View commit details

     Copy full SHA for 77b3a54

     Browse repository at this point

   • Shows the current cursors open and the maximum allowed

     geekcomputers

     committed
     c13ecf2View commit details

     Copy full SHA for c13ecf2

     Browse repository at this point
2. Commits on Jun 28, 2013

   • Show user privileges

     geekcomputers

     committed
     47a4203View commit details

     Copy full SHA for 47a4203

     Browse repository at this point
3. Commits on Jun 17, 2013

   • Show the redo log switching in the database, two different ways to display the information

     geekcomputers

     committed
     cd98d73View commit details

     Copy full SHA for cd98d73

     Browse repository at this point

   • Create a procedure you can call to check the primary key for a table name passed in

     geekcomputers

     committed
     bd2f88cView commit details

     Copy full SHA for bd2f88c

     Browse repository at this point

   • Show all the free bytes in the given tablespace

     geekcomputers

     committed
     df60b38View commit details

     Copy full SHA for df60b38

     Browse repository at this point

   • how all the datafiles and there sizes for the given tablespace name

     geekcomputers

     committed
     6d79fc7View commit details

     Copy full SHA for 6d79fc7

     Browse repository at this point
4. Commits on Jun 16, 2013

   • Extracts the DDL statement for the object when the parameters are passed, Object Name and Object Type

     geekcomputers

     committed
     9b54833View commit details

     Copy full SHA for 9b54833

     Browse repository at this point

   • Creates a spool file of database files you can then use to use DBV utilit

     geekcomputers

     committed
     49d06f8View commit details

     Copy full SHA for 49d06f8

     Browse repository at this point

   • Shows the waits for dbfile_sequential_reads

     geekcomputers

     committed
     af574faView commit details

     Copy full SHA for af574fa

     Browse repository at this point

   • Shows the object causing the waits

     geekcomputers

     committed
     8f53965View commit details

     Copy full SHA for 8f53965

     Browse repository at this point

   • Gives very basic information on the database

     geekcomputers

     committed
     d85a0c5View commit details

     Copy full SHA for d85a0c5

     Browse repository at this point

   • Shows whether or not to change the setting for DB_CACHE

     geekcomputers

     committed
     72acf79View commit details

     Copy full SHA for 72acf79

     Browse repository at this point

   • Display buffer cache hit ratio

     geekcomputers

     committed
     b4824fdView commit details

     Copy full SHA for b4824fd

     Browse repository at this point

   • Shows client connections to the database

     geekcomputers

     committed
     2191c48View commit details

     Copy full SHA for 2191c48

     Browse repository at this point
5. Commits on Jun 14, 2013

   • Shows log switches in the database

     geekcomputers

     committed
     de07f2dView commit details

     Copy full SHA for de07f2d

     Browse repository at this point

   • Creates a procedure to show the largest free extent in each tablespace

     geekcomputers

     committed
     ed7e4adView commit details

     Copy full SHA for ed7e4ad

     Browse repository at this point

   • Procedure to gather a users stale statistics and create a scheduled job to run

     geekcomputers

     committed
     f4b3b4fView commit details

     Copy full SHA for f4b3b4f

     Browse repository at this point
6. Commits on Jun 11, 2013

   • Use to rebuild all the indexes on a given table

     Show description for b9af27f
     geekcomputers

     committed
     b9af27fView commit details

     Copy full SHA for b9af27f

     Browse repository at this point

   • Shows all the ACII characters

     geekcomputers

     committed
     82c5faaView commit details

     Copy full SHA for 82c5faa

     Browse repository at this point

   • Shows active rollback activity

     geekcomputers

     committed
     22fb08aView commit details

     Copy full SHA for 22fb08a

     Browse repository at this point
7. Commits on Jun 10, 2013

   • SQL to create a procedure to show events in the database

     Show description for 463f5d2
     geekcomputers

     committed
     463f5d2View commit details

     Copy full SHA for 463f5d2

     Browse repository at this point

   • SQL to show what events are set in the database

     geekcomputers

     committed
     9e7523dView commit details

     Copy full SHA for 9e7523d

     Browse repository at this point

   • Procedure with Update and email

     Show description for 0b1ebfa
     geekcomputers

     committed
     0b1ebfaView commit details

     Copy full SHA for 0b1ebfa

     Browse repository at this point
8. Commits on Jun 6, 2012

   • This will show all of the client connections to the database

     geekcomputers

     committed
     3fbe72fView commit details

     Copy full SHA for 3fbe72f

     Browse repository at this point

   • This will kill all the oracle processes associated with a given sid

     geekcomputers

     committed
     62ead4eView commit details

     Copy full SHA for 62ead4e

     Browse repository at this point

   • Shows the object causing the waits

     geekcomputers

     committed
     fbd381bView commit details

     Copy full SHA for fbd381b

     Browse repository at this point

   • Creates a test table and inserts 1000 rows

     geekcomputers

     committed
     76fdb72View commit details

     Copy full SHA for 76fdb72

     Browse repository at this point

   • Shows the client connections within the oracle database

     geekcomputers

     committed
     dacee12View commit details

     Copy full SHA for dacee12

     Browse repository at this point
9. Commits on Feb 29, 2012

   • Shows the waits for dbfile_sequential_reads

     geekcomputers

     committed
     f86a758View commit details

     Copy full SHA for f86a758

     Browse repository at this point

   • Shows active rollback segments

     geekcomputers

     committed
     aa0f81aView commit details

     Copy full SHA for aa0f81a

     Browse repository at this point

   • Two Examples to search the long text field in DBA_VIEWS

     geekcomputers

     committed
     3a53535View commit details

     Copy full SHA for 3a53535

     Browse repository at this point

   • Displays the last 5 extents at the end of the datafile

     geekcomputers

     committed
     91595fbView commit details

     Copy full SHA for 91595fb

     Browse repository at this point

   • Displays everything assocaited with a given table

     geekcomputers

     committed
     a5207c2View commit details

     Copy full SHA for a5207c2

     Browse repository at this point
10. Commits on Feb 24, 2012

    • Shows roll back segment extensions to show if they are sized correctly

      geekcomputers

      committed
      37248f3View commit details

      Copy full SHA for 37248f3

      Browse repository at this point