Запуск и управление инстанцией в СУБД ORACLE

Цель работы:

Ознакомиться с последовательностью шагов администратора БД для запуска и остановки экземпляра Oracle в нужном режиме в различных ситуациях.

1. Запустите базу данных в режиме MOUNT так, чтобы к ней имел доступ только один экземпляр.

 SQLWKS> startup nomount

2. Работа с представлениями словаря данных V$SGA and V$PARAMETER.

а) Обратитесь к представлению V$SGA. Какую информацию оно содержит? Значения каких параметров инициализации определяют его содержимое?

 SQLWKS> select from V$SGA

     2>

select from V$SGA

       *

ORA-00936: missing expression

SQLWKS> select * from V$SGA

     2>

NAME                 VALUE    

-------------------- ----------

Fixed Size                35748

Variable Size           7052044

Database Buffers         409600

Redo Buffers               8192

4 rows selected.

  Б) Обратитесь к представлению V$PARAMETER. Какую информацию оно содержит? Есть ли другой способ получения этой информации?

 SQLWKS> select * from V$PARAMETER

     2>

NUM        NAME                                                             TYPE       VALUE                                                                            ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ DESCRIPTION                                                    

---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------- ----- --------- ---------- ----- ----------------------------------------------------------------

         7 processes                                                                 3 50                                                                               FALSE     FALSE FALSE     FALSE      FALSE user processes                                                 

         8 sessions                                                                  3 60                                                                               FALSE     FALSE FALSE     FALSE      FALSE user and system sessions                                       

         9 timed_statistics                                                          1 FALSE                                                                            TRUE      TRUE  IMMEDIATE FALSE      FALSE maintain internal timing statistics                             

        11 resource_limit                                                            1 FALSE                                                                            TRUE      FALSE FALSE     FALSE      FALSE master switch for resource limit                               

        12 license_max_sessions                                                      3 0                                                                                TRUE      FALSE FALSE     FALSE      FALSE maximum number of non-system user sessions allowed             

        13 license_sessions_warning                                                  3 0                                                                                TRUE      FALSE FALSE     FALSE      FALSE warning level for number of non-system user sessions           

        16 cpu_count                                                                 3 1                                                                                FALSE     FALSE FALSE     FALSE      FALSE number of cpu's for this instance                              

        18 event                                                                     2                                                                                  TRUE      FALSE FALSE     FALSE      FALSE debug event control - default null string                      

        19 shared_pool_size                                                          3 6500000                                                                          FALSE     FALSE FALSE     FALSE      FALSE size in bytes of shared pool                                   

        20 shared_pool_reserved_size                                                 3 0                                                                                TRUE      FALSE FALSE     FALSE      FALSE size in bytes of reserved area of shared pool                  

        21 shared_pool_reserved_min_alloc                                            3 5000                                                                             TRUE      FALSE FALSE     FALSE      FALSE minimum allocation size in bytes for reserved area of shared poo

        22 pre_page_sga                                                              1 FALSE                                                                            TRUE      FALSE FALSE     FALSE      FALSE pre-page sga for process                                       

        31 enqueue_resources                                                         3 155                                                                              FALSE     FALSE FALSE     FALSE      FALSE resources for enqueues