Category: interesting advanced dba articles

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.

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.

generate xml from table using dbms_xmlgen – for the new oracle dba

you are a new oracle dba and you would like to know how an xml can be generated from a table data using oracle packages like dbms_xmlgen.

sqlnet interoperability matrix- for the new oracle dba

you are a new oracle dba and you know that oracle sqlnet is the component that is present in the oracle client as well as the oracle server.when oracle client wants to communicate with the oracle server then the sqlnet component of the oracle client communicates with the sqlnet component of the oracle server. Below is the supported versions matrix from oracle metalink.

how oracle manages uncommitted changes during instance crash – reference article for new oracle dba

oracle behaviour during instance crash with uncommitted changes – for the new oracle dba

performance problem with unindexed foreign keys – reference article for the new oracle dba

performance problem with unindexed foreign keys – reference article for the new oracle dba

more info about finding out swap space used by the oracle instance – for the new oracle dba

how to find out swap space usage – reference article for the new oracle dba

How to Troubleshoot ORA-30926 Errors – reference article for the new oracle dba

how to troubleshoot merge statement errors and ora-30926 errors – reference article for the new oracle dba

advanced reference article about oracle UTL_FILE package – for the new oracle dba

advanced reference article about UTL_FILE package – for the new oracle dba

How to create oracle wallets in 10g – for the new oracle dba

brief overview of oracle wallet creation commands and steps – for the new oracle dba