Skip to content

{ Author Archives }

TOP 10 – Oracle DBA – Tips for Managing Multiple Projects

You are a oracle DBA and developer working on multiple projects. These are the top 10 tips to successfully manage the expectations on you from various projects.

Tagged , , ,

Datawarehousing – Things to Consider – Reference Tables

Find out the Importance of Reference Tables in a Datawarehouse. Find out whether to implement foreign keys for the reference tables .

Tagged , , , ,

oracle statistics – what are collected – for the new oracle dba

The article explains the difference between analyze and dbms_stats packages. Both these packages can be used to gather statistics

Tagged , ,

NFS-SAN-NAS-brief storage concepts overview to the new oracle dba

you are a new oracle dba and you would like to know the storage concepts like SAN,NAS or NFS.

Tagged , , ,

oracle streams – reference article for the new oracle dba

you are a new oracle dba and you would like to know what oracle streams is.

Tagged

what is sys_context in oracle – for the new oracle dba

you are a new oracle dba and you would like to know about sys_context.

Tagged

oracle table parameters pctused and pctfree – notes for the new oracle dba

you are a new oracle dba or developer and you are creating or managing tables and would like to know what the terms pctused and pctfree are and how they impact the space in a table block

Tagged ,

tracing slow listener connections- for the new oracle dba

you are a new oracle dba and you want to find out why connecting to your database from other servers is verl slow. you want to see if the listener is the reason

Tagged , ,

ora-12547 TNS: lost contact – troubleshooting- for the new oracle dba

you are a new oracle dba and your application connection to your oracle database server failed with the ORA-12547 TNS: lost contact error

Tagged , ,

oracle sqlnet issues – tracing and troubleshooting-for the new oracle dba

you are a new oracle dba and you would like to know how to trace the client sqlnet and server sqlnet components since your application had issues connecting to your database server

Tagged , , ,