12c database has introduced a pretty nifty Security feature which allows you to check last login time for non-sys user. e.g If I connect to scott user as below, it…
This is a interesting feature for Oracle DBA's. Till now there has been no way of limiting total PGA being used by oracle instance. _pga_max_size (hidden parameter) could be used to…
The first problem reported by my EM 12c is an ORA-7445 error. After checking the alert log following is the exact message: Sun Feb 19 12:09:41 2012 Errors in file…
Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that it cannot copy jobs which have arguments. Need to copy jobs can arise due…
In Oracle database 11g, a new feature/enhancement has potential of bringing down the application due to multiple sessions hitting database with wrong password. As per Bug 7715339 - Logon failures…
I had installed a 11.2.0.2 RAC setup few days back with incorrect timezone. It had to be PDT but I installed with UTC. Starting/stopping clusteware with correct timezone didn't solve…