The Oracle DBA daily operations

1

• The Oracle DBA daily operations

Storage space Management Databases are growing at
amazing rates. You need to properly handle place
and pay particular attention to the place used by
information and database records. Also, with Fst
Restoration Area (FRA) there are back-up places
that need to be handled for their place
utilization. With Automated Section Space
Management (ASSM), the need for reorganization of
information source things has reduced. Reorgs
also use significant sources so there should be
some assessment of whether an item needs to be
restructured or not. There are on the internet
resources that should help with reorganization of
indices and platforms while they stick to the
internet, but do not execute these functions
unless it is necessary. See the area Manage
Space, later in the area, for more on this.
2
Change Management Being able to update or modify
the information source is a expertise that needs
knowledge of many places. Improvements to the
information source schema, the step-by-step
reasoning in the information source, and the
information source software must all conducted in
a handled way. Modify control techniques and
resources such as Oracles Modify Control Package
and third-party promotions will assist
you. Schedule Jobs Since Oracle Database 10g,
DBMS_SCHEDULER was presented with the present
DBMS_JOBS. It allows for projects to be planned
for a specific date and time, and to classify
projects into job sessions that can then be
prioritized. This means that sources can be
handled by job category. Of course, other local
arranging techniques such as crontab in A linux
systemunix and Unix can be used, as well as other
third-party promotions.Jobs normally consist of
any of the information source servicing projects
such as back-ups and tracking programs.
Collection the tracking and servicing
3
Network Management Oracle Social networks are an
important element of the information source that
you will need to become comfortable with. Problem
solving relationships to the information source
is similar to troubleshooting efficiency issues,
because even though the information source is up
and available, if your programs cant achieve it,
its the same as if its down and not available.
Database connection choices such as tnsnames, the
Oracle Internet Listing (OID), and the Oracle
Audience require planning to ensure that
efficiency and security specifications are met in
a way that is simple to handle. Information this
are mentioned in the Understand Database
Connections area of this area.
4
High Availability With information and
information being available 24/7, architecting
highly available techniques has dropped into the
hands of the information source manager. Choices
on the information source side consist of Real
Application Groups, Data Secure, duplication, and
fast recovery choices. There are also components
and virtualization choices to provide repetitive
and available techniques.
5
Troubleshooting Although troubleshooting may not
be what youd consider a well used region of
information base management, it is one place that
you will come across daily. You will need
resources to help you with this. My Oracle
Assistance provides technological support team
and is a significant source. Oracle aware records
and dispose of data files will also help you
significantly. Experience will be your greatest
friend here and the earlier you jump into
information source support, the quicker you will
improvement. You can join the sql training in
pune to learn the oracle course.