Tags » Dba

oracle cannot compile store procedure library chache pin waiting event

cannot compile store procedure

library chache pin waiting event

use query below to identify who is using the stored procedure preventing to be modified and recompiled… 129 more words


A scientific background in my DBA experience

When I started my Doctorate of Business Administration at Grenoble Ecole de Management four years ago, about 20 years had passed since I had earned my PhD in Chemistry. 667 more words


PaaS and the ever changing role of the DBA

I’ve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list of DMVs and I’m a happy camper. 580 more words


Liberals and the complicity in casteism - Part 1

I am from a conservative Tamil Brahmin family, which has always leaned to the right (supporting BJP, RSS etc.). I  am privileged in four ways – gender (male), religion (Hindu), caste (Brahmin) and class (upper middle – class). 1,763 more words


T-SQL Tuesday #97 - My learning plan

This month’s T-SQL Tuesday is hosted by…er..yours truly. I picked a topic that usually comes up for me every December – learning goals for the next year. 910 more words


Introduction to Database Normalisation


There are two approaches in relational database design.

* TOP DOWN: From Data Modeling (eg. ER Model) to Relational Logical Model for implementation.

* BOTTOM UP: Normalization of Relations… 1,216 more words


Oracle ACE Director

I was at UKOUG Tech17 this week in my capacity at both Speaker and Tech Lead (organizing and selecting the agenda, drinks, parties, etc – although the heavy lifting is done by the @UKOUG office) 92 more words