Adityanath's Oracle Blog

My thoughts on Oracle

  • About Me
By Adityanath Dewoolkar on May 30, 2014 • ( 16 Comments )

Generating multiple AWR reports using single command

AWR reports are very essential part of performance tuning in Oracle databases. Many a times we require multiple copies of AWR reports so that we can compare it with each other. Traditional method of generating AWR reports (@?/rdbms/admin/awrrpt.sql) just generate single report at a time. Also generating AWR reports for […]

By Adityanath Dewoolkar on May 30, 2014 • ( 12 Comments )

Recreating undo tablespace in oracle database

Many a time situation comes, when undo tablespace becomes very big in size and due to space crunch , we need to recreate undo tablespace with appropriate size & drop old one. This post provides u simple steps to perform this activity.   SQL> SHOW PARAMETER UNDO NAME TYPE VALUE ———————————— […]

By Adityanath Dewoolkar on May 29, 2014 • ( 1 Comment )

Script to calculate exact free space in a tablespace considering maxsize clause

Many a times we receive false alerts for low free space on the oracle tablespaces, as our traditional tablespace monitoring scripts does not consider maxsize clause while calculating free space in the tablespace. Please find below the tablespace monitoring script – which gives you exact free space in tablespace:   WITH […]

‹ Newer 1 2 3 4 5 6 7 8 9 10

About ME

Blog Stats

  • 372,154 hits

Join 322 other followers

Categories

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
Website Powered by WordPress.com. |
  • Follow Following
    • Adityanath's Oracle Blog
    • Join 322 other followers
    • Already have a WordPress.com account? Log in now.
    • Adityanath's Oracle Blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar