Sridhar kasukurthi

Latest posts by Sridhar kasukurthi

• Troubleshooting Materialized View (MV)

  Troubleshooting Materialized View (MV) Problems in PeopleSoft Reporting. Step1 - Notification: Email will notify PeopleSoft DBA team on Materialized View issue: Sample Email to PeopleSoft DBA's: Materialized Views Refreshes Out of Date as of Thu Sep 10 03:22:03 EDT 2009 on psrptprd SQL> select Name,...

  Posted on 2 September 2013 | 12:23 pm

  Read post

• Granting Access to run AWR/ADDM reports to a non priv user

  In our environment many developers like/need(has knowledge) to look at the awr report to analyze and tune their problamatic queries and also understand the load details and wait events the database is facing. They request for privileges to run AWR/ADDM reports. So see below simple steps we do to ach...

  Posted on 1 July 2013 | 9:37 pm

  Read post

• Enable Archivelog Mode in a RAC database

  Hi All. Its been a long time since I posted so thought i'd better start again :-)This is a pretty trivial thing but I always forget the syntax hence thought i'd post it for the benefit of others and myself1. Change the cluster database parameter so the database can be mounted in exclusive mode which...

  Posted on 1 July 2013 | 9:14 pm

  Read post