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…
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…
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…
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…
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…
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…
- 1
- 2
- 3
- 4
- …
- 8
- Go to the next page