Oracle 11g new security feature for authentication restriction
Oracle 11g new security feature called Authentication Attempts Restriction Oracle tool
Category: database services
Undocumented Oracle Utility-dbhome
Hi Friends, Today we are going to discuss one another undocumented Oracle utility called DBHOME. Yes I think you understood usage of utility as per it’s name. Usage of dbhome: For checking $ORACLE_HOME environment variable. This utility is very useful for getting location of Oracle home. We can use dbhome utility instead of “echo” command […]
DB2 and Oracle Server Comparison
Hi friends, Two biggest RDBMS from brand leaders. DB2 is product of IBM and Oracle Database server is from Oracle. How to make compare both because both found equally in most of features. Yes. But we found some difference between DB2 and Oracle Server. Wonderful article has bee published on our site. It is very […]
Tuning of gc current block 3-way wait in RAC Oracle Database
Hi Friends, What is the gc current block 3-way wait or gc current block 2-way wait event. Following article is explaining the more detail of gc current block 3-way wait secret with performance tuning of wait event in RAC Oracle Database. So many times oracle rac database wait event gc current block 3-way wait logs […]
Oracle DBA Scripts- PGA management and pga_aggregate_target
Hi Friends, Here you can find out some useful and important Oracle DBA scripts for managing and administrating Database very easily. Oracle DBA Scripts-1: How to check hidden PGA parameter setting from Oracle hidden parameters. Following scripts are very useful to get hidden pga parameters. Kindly execute with SYSDBA privilege. select a.ksppinm name, b.ksppstvl value […]
ORA-01045: user SCOTT lacks CREATE SESSION privilege
Hi Friends, This is general error getting from Oracle 10g database. It calls as ORA-01045 that lacking of create session privilege. Reason of ORA-01045: From Oracle 10g, connect role doesn’t contain create session privilege. Solution of ORA-01045: If you granted connect role to any user and database was upgraded then you should need to give […]
