Scribd Logo
Upload

Welcome to Scribd!

  • 161 views

    ORACLE DBA I Assignment

    Uploaded by

    Tanmoy Nandy
    This document contains questions about configuring and monitoring various Oracle database objects and components. It includes questions about checking the Oracle version and SGA size, creating a password file, getting information on the control file, tablespaces, data files, redo logs, archive logs and data dictionary. It also includes questions about resizing components like the SGA, data files, redo members and archive logs.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    ORACLE DBA I Assignment

    Uploaded by

    Tanmoy Nandy
    161 views1 page
    This document contains questions about configuring and monitoring various Oracle database objects and components. It includes questions about checking the Oracle version and SGA size, creating a password file, getting information on the control file, tablespaces, data files, redo logs, archive logs and data dictionary. It also includes questions about resizing components like the SGA, data files, redo members and archive logs.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains questions about configuring and monitoring various Oracle database objects and components. It includes questions about checking the Oracle version and SGA size, creating a password file, getting information on the control file, tablespaces, data files, redo logs, archive logs and data dictionary. It also includes questions about resizing components like the SGA, data files, redo members and archive logs.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    161 views1 page

    ORACLE DBA I Assignment

    Uploaded by

    Tanmoy Nandy
    This document contains questions about configuring and monitoring various Oracle database objects and components. It includes questions about checking the Oracle version and SGA size, creating a password file, getting information on the control file, tablespaces, data files, redo logs, archive logs and data dictionary. It also includes questions about resizing components like the SGA, data files, redo members and archive logs.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 1

    :

    ORACLE DBA I Assignment


    1. How to check oracle version Show
    2. How to check SGA size
    V$SGA
    3. Details of SGA
    4. How to change parameter value V$SGAINFO
    5. ISSESS , ISSYS……….
    V$PARAMETER
    6. Create pfile and or spfile
    7. How to check db running using pfile/spfile
    8. DB startup and shut options
    9. MAX_SIZE……..
    10. What / why / where ….. password file
    1. Controlfile information
    2. Backup of controlfile Show
    3. Multiplexing of controlfile
    4. How to update controlfile content datafile,logfile value V$controlfile
    1. info of tablespace
    2. Info of temp tablespace
    3. Info of datafile Show
    4. Resize of tablespace and or adding datafile V$tablespace
    5. How to create a permanent tablespace
    V$datafile
    6. Resize of temp tablespace
    7. Temp tyablespace group Dba_data_files
    8. Set undo retention and size
    Dba_temp_file
    9. How to calculate undo size
    1. Info of redolog
    2. Add redolog group
    3. Add redo member V$log
    4. Resize of redo member V$logfile
    1. Info of archivelog
    2. Size of archivelog
    3. Resize of archivelog
    4. Set more process for archivelog
    V$archivelog
    5. Check archivelog generate per day
    6. Multiple location set for archivelog ( local N remote location)
    1. Architecture diagram of data dictionary
    2. Create profile, attach to user and check

    You might also like