Skip to Content
author's profile photo Vishwanath Shastri
0
Vishwanath Shastri

How do we list , which Oracle parameters got changed Since last db restart ! ?

Posted on Sep 18, 2019 at 08:15 AM 264 Views

Say, My Colleague has changed few Oracle parameters and took a DB Restart ,

I want to know ,Which Oracle parameters got changed Since last db restart ,

How do I know ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Warren Angerstein
    Warren Angerstein
    Posted on Sep 18, 2019 at 02:26 PM
    0

    Why not just ask your colleague? Seems kind of shady not to. try the following link.

    http://www.oracle-wiki.net/startsqllistdbparamhist

    Add a comment
    10|10000 characters needed characters exceeded

    • Vishwanath Shastri
      Sep 20, 2019 at 09:49 AM

      Hello Warren,

      The link provided by you Picks the value from 2 tables which dba_hist_parameter and dba_hist_snapshot

      But in general we only have retention period of 7 days for ,

      this is same as the retention period of AWR reports ,

      Which is very less , So it will work as long as the changes were in last 7 days ,

      also the time period for collection of this info is generally 1 hour

      so lets say. some one changed a value and the changed it back to original, then we won't know

      We can increase the retention period and the collection interval but then we will need more space in the SYSAUX tablespace + this

      will cause load on the DB.

      Regards

    Comment on This Answer
  • author's profile photo SAMEER HATTIMATTUR
    SAMEER HATTIMATTUR
    Posted on Oct 08, 2019 at 08:25 AM
    0

    Hi Vishwanath,

    Please see below few options, let me know if anyone worked.

    1. If your database is daily backed up by BRTOOLS (BRBACKUP) it also backs up the initSID.ora and spfileSID.ora as a part of profile backup. Try to restore the pfile and spfile from the old backup in some other location. Compare them with current setting you will get to know which parameter was changed. I know its a long method but a way to get it.

    2. Check the DB13 Checkdb jobs output from before and after parameter change. It should give you some hints.

    Thanks,

    Sam

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.