Commits

Branch selector

 master

User selector

All users

All time

Commit history

Commits on Jul 18, 2020

• style: renamed README to README.md

  alikhatam

  committed
  f3af967

  Copy full SHA for f3af967

• docs: added Procedure and Examples sections to README.md

  alikhatam

  committed
  7427153

  Copy full SHA for 7427153

• docs: Created README.md

  alikhatam

  committed
  eacd7d8

  Copy full SHA for eacd7d8

Commits on Oct 1, 2013

• A simple procedure to show open cursors

  Show description for 77b3a54
  geekcomputers

  committed
  77b3a54

  Copy full SHA for 77b3a54

• Shows the current cursors open and the maximum allowed

  geekcomputers

  committed
  c13ecf2

  Copy full SHA for c13ecf2

Commits on Jun 28, 2013

• Show user privileges

  geekcomputers

  committed
  47a4203

  Copy full SHA for 47a4203

Commits on Jun 17, 2013

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

  geekcomputers

  committed
  cd98d73

  Copy full SHA for cd98d73

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

  geekcomputers

  committed
  bd2f88c

  Copy full SHA for bd2f88c

• Show all the free bytes in the given tablespace

  geekcomputers

  committed
  df60b38

  Copy full SHA for df60b38

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

  geekcomputers

  committed
  6d79fc7

  Copy full SHA for 6d79fc7

Commits on Jun 16, 2013

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

  geekcomputers

  committed
  9b54833

  Copy full SHA for 9b54833

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

  geekcomputers

  committed
  49d06f8

  Copy full SHA for 49d06f8

• Shows the waits for dbfile_sequential_reads

  geekcomputers

  committed
  af574fa

  Copy full SHA for af574fa

• Shows the object causing the waits

  geekcomputers

  committed
  8f53965

  Copy full SHA for 8f53965

• Gives very basic information on the database

  geekcomputers

  committed
  d85a0c5

  Copy full SHA for d85a0c5

• Shows whether or not to change the setting for DB_CACHE

  geekcomputers

  committed
  72acf79

  Copy full SHA for 72acf79

• Display buffer cache hit ratio

  geekcomputers

  committed
  b4824fd

  Copy full SHA for b4824fd

• Shows client connections to the database

  geekcomputers

  committed
  2191c48

  Copy full SHA for 2191c48

Commits on Jun 14, 2013

• Shows log switches in the database

  geekcomputers

  committed
  de07f2d

  Copy full SHA for de07f2d

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

  geekcomputers

  committed
  ed7e4ad

  Copy full SHA for ed7e4ad

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

  geekcomputers

  committed
  f4b3b4f

  Copy full SHA for f4b3b4f

Commits on Jun 11, 2013

• Use to rebuild all the indexes on a given table

  Show description for b9af27f
  geekcomputers

  committed
  b9af27f

  Copy full SHA for b9af27f

• Shows all the ACII characters

  geekcomputers

  committed
  82c5faa

  Copy full SHA for 82c5faa

• Shows active rollback activity

  geekcomputers

  committed
  22fb08a

  Copy full SHA for 22fb08a

Commits on Jun 10, 2013

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

  Show description for 463f5d2
  geekcomputers

  committed
  463f5d2

  Copy full SHA for 463f5d2

• SQL to show what events are set in the database

  geekcomputers

  committed
  9e7523d

  Copy full SHA for 9e7523d

• Procedure with Update and email

  Show description for 0b1ebfa
  geekcomputers

  committed
  0b1ebfa

  Copy full SHA for 0b1ebfa

Commits on Jun 6, 2012

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

  geekcomputers

  committed
  3fbe72f

  Copy full SHA for 3fbe72f

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

  geekcomputers

  committed
  62ead4e

  Copy full SHA for 62ead4e

• Shows the object causing the waits

  geekcomputers

  committed
  fbd381b

  Copy full SHA for fbd381b

• Creates a test table and inserts 1000 rows

  geekcomputers

  committed
  76fdb72

  Copy full SHA for 76fdb72

• Shows the client connections within the oracle database

  geekcomputers

  committed
  dacee12

  Copy full SHA for dacee12

Commits on Feb 29, 2012

• Shows the waits for dbfile_sequential_reads

  geekcomputers

  committed
  f86a758

  Copy full SHA for f86a758

• Shows active rollback segments

  geekcomputers

  committed
  aa0f81a

  Copy full SHA for aa0f81a

• Two Examples to search the long text field in DBA_VIEWS

  geekcomputers

  committed
  3a53535

  Copy full SHA for 3a53535