Scope Oracle Database 10g
1)
Roles/Privileges
2)
ORAPWD
3)
Remote_login_passwordfile
4)
Considerations before creating the database
5)
Specifying Database time zone and time zone file
6)
Specifying force logging mode
7)
Database Block Size
8)
Managing SGA
9)
Specifing the method of Undo Space Management
10)
Specifying the max number of process
11)
Setting COMPATIBLE
12)
Setting the license parameter
13)
Exporting Server Parameter file
14)
Backing up the server parameter file
15)
Error and Recovery for the server parameter file
16)
Viewing parameter settings
17)
Defining Application Services for Oracle
Database 10g
18)
Enabling Transparent Data Encryption
19)
Creating a secure external password store
20)
Restricting access to an open database
21)
Quiescing a database
22)
Suspending and Resuming a database
23)
Dedicated server processes
24)
Shared server processes
25)
Intialization parameter for shared server
26)
Oracle database background processes
27)
Managing Processes for Parallel SQL Execution
28)
Managing Processes for External Procedures
29)
Terminating Sessions
30)
Monitoring the operation of your database
31)
Backup control files
32)
Manage the size of control files
33)
Handling errors during create controlfile
34)
Backing up control files
35)
Redo log contents
36)
How Oracle database writes to the Redo Log
37)
Verifying Blocks in Redo log files
38)
Clearing a redo log files
39)
Viewing Redo log information
40)
Performing Manual Archiving
41)
Adjusting the number of archiver processes
42)
Understanding archive destination status
43)
Normal transmission mode
44)
Standby transmission mode
45)
Controlling trace outout generated by the
archivelog process
46)
Viewing information about the archive redo log
47)
Bigfile tablespaces
48)
Multiple Temporary Tablespaces : Using
Tablespace Groups
49)
Specifying non standard block sizes for
tablespaces
50)
Controlling the writing of redo records
51)
Creating a read-only tablespace on a WORM Device
52)
Delaying the opening of datafiles in Read-Only
Tablespace
53)
Monitoring the Occupants of SYSAUX Tablespace
54)
Moving Occupants Out of or Into SYSAUX
Tablespace
55)
Controlling the size of the SYSAUX Tablespace
56)
Diagnosing and repairing Locally Mananged
Tablespace Problems
57)
Migrating the SYSTEM Tablespace to a locally
Managed Tablespace
58)
Transporting tablespace between database
59)
Viewing tablespace information
60)
File Transfer and DBMS_SCHEDULER Package
61)
Advanced File transfer Mechanisms
62)
Mapping file to Physical Devices
63)
Sizing the Undo Tablespace
64)
Managing Undo Tablespaces
65)
Viewing Information about undo
66)
What are Oracle Managed files
67)
Behavior of Oracle-Managed Files
68)
Scenarios for Using Oracle-Managed Files
69)
Administering an ASM Instance
70)
Administering ASM Disk groups
71)
Using ASM In the databse
72)
Accessing ASM with the XML DB Virtual Folder
73)
Viewing information about ASM
74)
Truncate Table and Cluster
75)
Enabling and Disabling Triggers
76)
Managing Integrity Constraints
77)
Managing Object Dependencies
78)
Managing Object Name resolution
79)
Switching to a different schema
80)
Displaying information about schema objects
81)
Managing Space in Data Blocks
82)
Managing Storage Parameters
83)
Managing Resumable Space allocation
84)
Reclaiming Wasted Space
85)
Understanding Space Usage of Datatypes
86)
Displaying Information about space usage of
schema objects
87)
Capacity Planning for Database Objects
88)
Guidelines for Managing Tables
89)
Parallelizing table creation
90)
Loading Tables
91)
Automatically collecting statistics on Tables
92)
Redefining Tables Online
93)
Auditing Table changes using flashback
transaction query
94)
Recovering tables using the flashback table
features
95)
Using flashback drop and Managing the recycle
bin
96)
Managing IOT
97)
Managing External Tables
98)
Viewing information about tables
99)
Guidelines for Managing Indexes
100)
Monitoring Space Use of Indexes
101)
Viewing Index Information
102)
Partitioning
Methods
103)
Marinating Partitioned Tables
104)
Guidelines for Managing Clusters
105)
Managing hash clusters
106)
Managing views,sequences and synonyms
107)
Using DBMS_REPAIR to repair data block
corruption
108)
Managing Automatic System Tasks Using the
Maintenance Window
109)
Using Database Resource Manager
110)
Moving from DBMS_JOB to DBMS_SACHEDULER
111)
SCHEDULER CONCEPTS
112)
Distributed database concepts
113)
Database Link
114)
Transaction Processing in a distributed system
115)
Managing a distributed databases
116)
Distributed transaction concepts
117)
Managing Distributed Transactions
No comments:
Post a Comment