||Oracle Tips by Burleson
Is the IT employee knowledgeable enough to
accomplish his or her job responsibilities with minimal assistance
from others? Is this knowledge broad across diverse aspects of the
job, such as multiple DBMS’s (Oracle, Sybase, Informix, and DB2)? Does
this knowledge extend beyond the immediate job responsibilities to
include other related IT groups and the business itself?
Knowledgeable Worker Story
The more fortunate IT managers have employed some
very talented DBAs who possessed very broad knowledge. In one
particular case, an IT employee was proficient in supporting Oracle,
Sybase, and Informix databases. His grasp of the surrounding
environments and their relationship to the database was excellent.
For example, tuning an Oracle database does not
stop at the database. There are many aspects of the OS, filesystems,
hardware, storage, network, and application code that have a large
impact on database performance. He analyzed OS memory paging and
swapping, disk I/O, the number of processors, disk striping, the
storage cache, network latency, and application code efficiency (SQL
and PL/SQL), to name a few. This extensive range of knowledge helped
to bring together the other IT support groups in resolving difficult
system performance issues and outages.
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA