Author: admin

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.

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.

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.

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

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

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

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

transportable tablespaces – knowledge article for the new oracle dba

you are a new oracle dba and you would like to know about transportable tablespace limitations , transporting tablespaces between platforms with different endian format etc

administer database trigger privilege – knowledge article for the new oracle dba

you are a new oracle dba and you would like to know why a DBA role can bypass  logon triggers that fail where as  normal sessions are prevented  from logging into the database.

what is UGA- knowledge article for the new oracle dba

you are a new oracle dba and you would like to know what UGA is and from where memory is allocated to the UGA.