12c: Sqlplus Displays Last Login Time For Non – Sys Users
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…
Read Full RecipeTag: database
12c:Limiting PGA with pga_aggregate_limit
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…
Read Full Recipe
ORA-7445 core dump [kokscold()+849] from EM 12c
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…
Read Full Recipe
Copying Oracle Scheduler jobs with Arguments
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…
Read Full Recipe
11g: Multiple failed login attempt can block New Application connections
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…
Read Full Recipe
Changing CRS/Database timezone in 11.2.0.2 post install
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…
Read Full Recipe