Vineet's Oracle Blog Spot
Friday, 7 June 2013
ALL_SYNONYMS EXECUTION SLOW
›
One special behavior I found in Oracle (11.2.0.3) only on Sun-Solaris platform. In 11.2. + There is a bug 13549808 which deals with im...
Wednesday, 27 March 2013
Tracing ORA Error Code At System/Session Level
›
Real Scenario: Development team ran the Job and the job failed with below error ORA-01031: insufficient privileges Logs were created f...
Shared Memory Allocation In 11.1.0.7 and 11.2.0.3
›
SHM is key feature for any software on any of the host server. Oracle is doing the same. When Oracle initiates; Shared memory segments ...
2 comments:
Monday, 25 March 2013
IMP_FULL_DATABASE role/privilege Can Be Dangerous At Times
›
Recently faced an issue where an Application developer as per one request asked to revert dml permissions from the table; they just wante...
2 comments:
Sunday, 16 October 2011
Understanding Joins
›
Understanding Joins Joins are statements that retrieve data from more than one table. A join is characterized by multiple tables...
1 comment:
‹
›
Home
View web version