If the remote host is not accessible, the problem may be on
the client side. Verify that other clients are able to access the host on which the database resides.
If they can, the problem is isolated to the client. If they cannot, the problem lies on the server
side, and the server, its listener processes, and its database instances should be checked.
CHAPTER
16
Managing Large Databases
543
544 Oracle Database 11g DBA Handbook
n Chapter 6, we talked about bigfile tablespaces and how they not only allow the
total size of the database to be much larger than in previous versions of Oracle, but
also ease administration by moving the maintenance point from the datafile to the
tablespace.
In Chapter 4, I presented an overview of Automatic Storage Management (ASM) and how it
can ease administration, enhance performance, and improve availability. The DBA can add one
or more disk volumes to a rapidly growing VLDB (Very Large Database) without bringing down
the instance.
In this chapter, we??™ll revisit many of these database features, but with an emphasis on how
they can be leveraged in a VLDB environment. Although these features surely provide benefits in
all Oracle installations, they are especially useful in databases whose most heavily used resource
is the amount of disk space allocated. First, we??™ll review the concepts behind bigfile tablespaces
and delve more deeply into how they are constructed using a new ROWID format.
Pages:
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813