Oracle 9i Database Administration in 10 Minutes
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Chapter 8: Oracle Enterprise Manger -A SQL-Less DB Mgmt Software
As explained before, connect to the database as SYSDBA when asked to
provide login, password and privilege level. There is no need to specify
the login and password as its would be the externally authenticated
OSDBA or OSOPER account. Once you get connected to the Oracle database
you would be able to expand the tree on the left pane of OEM window.
Expand the “Storage” item; you will see “Tablespaces”. When you select
the Tablespaces item, on the right pane you will see the list of all the
Tablespaces along with associated data files and related information.
Figure 68: No need to remember SQL statements. Most of
the time right-click solves the problem and popped up menu provides you
the command you were looking for.
________________________________________
Chapter 8: Oracle Enterprise Manger -A SQL-Less DB Mgmt Software
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Share with others: