chapter 9 Flashcards
it is a Java-based tool used to create Oracle Databases.
Oracle Database Configuration Assistant
Using this, Oracle manages the file placement and naming automatically
Configure Automatic Storage Mangement
- research and marketing data
- state or federal tax payments
- professional licensing
Data Warehouse
- Store checkout register system
- Automatic teller machine transaction
Transaction processing
Retail billing system
General Purpose
this user owns all base tables and user-accessible view of the data distionary
SYS
this user is used to create additional tables and views that display administrative information, and internal tables and views used by various Oracle option and tools
System
this user represents the Enterprise Manager super admin account. This EM admin can create and modify other EM admin accounts as well as admin the database instance itself
Sysman
this user is used by EM to monitor the databse
DBSNMP
are admin privileges to perform high-level admin
SYSOPER
can do SYSOPER plus can look at user data.
SYSDBA
5 operations only can be performed by SYSDBA
- startup a database
- shutdown a database
- backup a database
- recover a database
- create a database
it is the most common type of storage configuration for many Oracle databases
File system storage
are disks that are not managed by the underlying OS
Raw Devices
It is the foundation of the new automated disk-based recovery feature
Oracle flash recovery
Performs a shutdown abort then restart
startup force
open to only restricted session privilege
startup restrict
increase the database availability state
alter database[mount|open]
wait till all users are disconnected
shutdown
wait till all active transactions are completed
shutdown transactional
- roll back uncommitted transactions
- disconnect all clients immediately
shutdown immediate
- terminate current sql statement statements, no roll back
- disconnect all clients immediately
- requires instance recovery in next startup
shutdown abort
it contains chronological summary of startup. shutdown, alter activities
alert log
how to find location of alert log diags trace and alert
sql> select name, value from v$diag_info
- initialization parameter files that reads and writes by instance
spfile (spfileSID.ora or spfile.ora)
- reads only by instance
- can be created from an spfile
pfile (initSID.ora)
how many initializaiton parameters
285
to change parameter
sql> alter system set
to view parameter
sql> show parameter
initialization parameters view are located in?
oracle_home/dbs
how many data dictionary views about the database and its objects
1600
how many dynamic performance views
480
- data dictionary views that shows information on all tables
DBA_
an user’s own tables and tables with granted access
ALL_
tables owned by individual user
User_
it shows information about the initialization parameters that are currently in effect
V$PARAMETER
it shows the contents of the spfile used to start the instance
V$SPPARAMETER
-this starts the instance without mounting the database
startup nomount
this performs all the work of the startup nomount option but also attaches and interacts with the database structures.
startup mount
this is the default startup mode if no mode is specified on the startup comman line.
startup open
you can use this when you are experiencing trouble starting the database in normal fashion
startup force
this option starts up the database and places it in open mode but gives access only to users who have the restricted sessions privilege
startup restrict
note1:
Database_block_size cannot be changed from 8K
global database name
ORACLE SID
Initialization parameter
- memory
- size
- character set
- connection mode
contain database definition information, actual datafile and redo log file
seed template
custom defined database definition
nonseed template
database metadata
data dictionary views and dynamic performance views
provide information about database and its object
data dictionary views
- virtual tables that record the current database activity and status
- fixed views
- v_$ or v$
dynamic performance views
hierarchy parameter files
- spfile$ORACLE_SID.ora
- spfile.ora
- init$ORALCE_SID.ora