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 […]
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 ———————————— […]
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 […]
Adityanath's Oracle Blog 