Category Archives: Technology

Advanced .Net Interview Questions

 What is something substantive that you’ve done to improve as a developer in your career? You’ve just been assigned to a project in a new technology how would you get started? Why singleton pattern is considered an Anti-pattern ?  What is the use of volatile keyword? The volatile keyword indicates that a field might […]
Read More »

Using the fingerprint reader to unlock Arch Linux

login to i3 window manager using i3lock using the fingerprint reader (X1-Carbon)

12 Oracle Design Consideration

Oracle Design Consideration, Index organized tables, partitioned tables, range partition, list partition, hash partition, composite partition

11 House Keeping in Oracle

House keeping in Oracle: invalid optimizer statistics, buffer gets, Disk Reads

10 Oracle Hints to the Database

Oracle SQL performance tuning. using Hints in the database query

08 Considerations while using PLSQL in programming (Oracle)

Considerations while using PLSQL in programming (Oracle)

07 Performance Improvement Consideration

Oracle Performance Improvement Consideration, union vs OR, Union all vs Union, exist vs IN

06 Index Suppression

Index Suppression in Oracle, operators, sub-strings, Arithmetic operators, Truncate , function based index

05 Simple Tuning Rules

Simple Tuning Rules for Oracle. Where vs having, table aliases

04 Explain Plan

Oracle Explain Plan, Execution Plan,