database precautionary checks
From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Thu, 22 Oct 2015 11:09:38 -0700
Message-ID: <CAKsxbLrGFJ+Eu-xjvA1F8VQcRc7xz=opRENyqaDQuSxDafTpbg_at_mail.gmail.com>
I was wondering if any of you have certain jobs running to check database safety from potential crashes. For example I recently add a job to run every 5 minutes to check the PGA usage of every session to make sure no one is using more than is normal. If a sessions is using more than 4gb I kill the session. We recently had some code with an infinite loop that took down the server. So I am trying to think of all the stuff I can check for ahead of time.
Is there any other jobs you have running or certain profile settings or resource manager setups. I would love to her your configurations.
Date: Thu, 22 Oct 2015 11:09:38 -0700
Message-ID: <CAKsxbLrGFJ+Eu-xjvA1F8VQcRc7xz=opRENyqaDQuSxDafTpbg_at_mail.gmail.com>
I was wondering if any of you have certain jobs running to check database safety from potential crashes. For example I recently add a job to run every 5 minutes to check the PGA usage of every session to make sure no one is using more than is normal. If a sessions is using more than 4gb I kill the session. We recently had some code with an infinite loop that took down the server. So I am trying to think of all the stuff I can check for ahead of time.
Is there any other jobs you have running or certain profile settings or resource manager setups. I would love to her your configurations.
Thanks,
Jeff
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 22 2015 - 20:09:38 CEST