title: Oracle drop user check
body: <p>DB: Oracle11gR2</p>
  
  <p>OS: Linux</p>
  
  <p>I want to drop USER1 Oracle user which is already locked for few weeks now.</p>
  
  <p>I can run <code>"drop user USER1 cascade;"</code> to drop user but before dropping want to confirm nobody else is using or used objects after user was locked.</p>
  
  <ol>
  <li>How to verify in Oracle that nobody is accessing or have accessed USER1 objects in last month or so?</li>
  <li>Is there a db query/view available which we can use to make sure it's safe to run DROP command?</li>
  </ol>
  
  <p>Thanks</p>