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

       240 background_dump_dest                                                      2 %RDBMS73%\trace                                                                  FALSE     FALSE FALSE     FALSE      FALSE Detached process dump directory                                

       241 user_dump_dest                                                            2 %RDBMS73%\trace                                                                  FALSE     FALSE FALSE     FALSE      FALSE User process dump directory                                    

       242 max_dump_file_size                                                        3 10240                                                                            FALSE     FALSE FALSE     FALSE      FALSE Maximum size (blocks) of dump file                             

       245 oracle_trace_enable                                                       1 FALSE                                                                            TRUE      FALSE FALSE     FALSE      FALSE Oracle TRACE instance wide enable/disable                      

       246 oracle_trace_facility_path                                                2 %OTRACE73%\ADMIN\FDF\                                                            TRUE      FALSE FALSE     FALSE      FALSE Oracle TRACE facility path                                     

       247 oracle_trace_collection_path                                              2 %OTRACE73%\ADMIN\CDF\                                                            TRUE      FALSE FALSE     FALSE      FALSE Oracle TRACE collection path                                   

       248 oracle_trace_facility_name                                                2 oracled                                                                          TRUE      FALSE FALSE     FALSE      FALSE Oracle TRACE default facility name                             

       249 oracle_trace_collection_name                                              2 oracled                                                                          TRUE      FALSE FALSE     FALSE      FALSE Oracle TRACE default collection name                           

       250 oracle_trace_collection_size                                              3 5242880                                                                          TRUE      FALSE FALSE     FALSE      FALSE Oracle TRACE collection file max. size                         

156 rows selected.

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

SQLWKS> select * from DBA_USERS

     2>

USERNAME                       USER_ID    PASSWORD                       DEFAULT_TABLESPACE             TEMPORARY_TABLESPACE           CREATED   PROFILE                      

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

SYS                                     0 D4C5016086B2DC6A               SYSTEM                         SYSTEM                         08-MAR-97 DEFAULT                      

SYSTEM                                  5 D4DF7931AB130E37               USER_DATA                      TEMPORARY_DATA                 08-MAR-97 DEFAULT                      

DBSNMP                                  9 E066D214D5421CCC               SYSTEM                         SYSTEM                         08-MAR-97 DEFAULT                      

SCOTT                                  10 F894844C34402B67               USER_DATA                      TEMPORARY_DATA                 08-MAR-97 DEFAULT                      

4 rows selected.

 3. Откройте базу данных. Снова обратитесь к представлению DBA_USERS.

SQLWKS> startup force open

ORACLE instance started.

Total System Global Area       7505584 bytes

Fixed Size                       35748 bytes

Variable Size                  7052044 bytes

Database Buffers                409600 bytes