Interested to Buy Any Domain ? << Click Here >> for more details...
What are the database administrators utilities avaliable ?
- 2 Answers
- 3709 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
SQL * DBA - This allows DBA to monitor and control an ORACLE
database.
SQL * Loader - It loads data from standard operating
system files (Flat files) into ORACLE database tables.
Export (EXP) and Import (imp) utilities allow you to move
existing data in ORACLE format to and from ORACLE database.
55. What are the minimum parameters should exist in the
parameter file (init.ora) ?
DB NAME - Must set to a text string of no more than 8
characters and it will be stored inside the datafiles,
redo log files and control files and control file while
database creation.
DB_DOMAIN - It is string that specifies the network
domain where the database is created. The global
database name is identified by setting these parameters
(DB_NAME & DB_DOMAIN)
CONTORL FILES - List of control filenames of the database.
If name is not mentioned then default name will be used.
DB_BLOCK_BUFFERS - To determine the no of buffers in the
buffer cache in SGA.
PROCESSES - To determine number of operating system
processes that can be connected to ORACLE concurrently.
The value should be 5 (background process) and
additional 1 for each user.
ROLLBACK_SEGMENTS - List of rollback segments an ORACLE
instance acquires at database startup.
Also optionally
LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and
LICENSE_MAX_USERS.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shailendra kumar
So many database utilities are avalibale
1. SQLPLUS
2. RMAN
3. TKPROF
4. SQLLODAR
5. EXP,IMP AND EXPDP,IMPDP
6. EXPLAN PLAN
7. LSNRCTL
etc.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can we specify the Archived log file name format and destination ?
what is the step for rmanbackup?
What is Statement Auditing ?
what is snapshot log ?
When will the data in the snapshot log be used ?
What are the options available to refresh snapshots ?
what is different between view and sequence?
What are roles ? How can we implement roles ?
How can you Enforce Refrencial Integrity in snapshots ?
What are the responsibilities of a Database Administrator ?
What are the minimum parameters should exist in the parameter file (init.ora) ?
What are the benefits of distributed options in databases ?
Oracle General 
