Describe 首頁/2020-11-28 here.
OCP DAY 3
parameter
SQL> desc v$parameter Name Null? Type ----------------------------------------------------------------------------------------------------------------- -------- ---------------------------------------------------------------------------- NUM NUMBER NAME VARCHAR2(80) TYPE NUMBER VALUE VARCHAR2(4000) DISPLAY_VALUE VARCHAR2(4000) DEFAULT_VALUE VARCHAR2(255) ISDEFAULT VARCHAR2(9) ISSES_MODIFIABLE VARCHAR2(5) ISSYS_MODIFIABLE VARCHAR2(9) ISPDB_MODIFIABLE VARCHAR2(5) ISINSTANCE_MODIFIABLE VARCHAR2(5) ISMODIFIED VARCHAR2(10) ISADJUSTED VARCHAR2(5) ISDEPRECATED VARCHAR2(5) ISBASIC VARCHAR2(5) DESCRIPTION VARCHAR2(255) UPDATE_COMMENT VARCHAR2(255) HASH NUMBER CON_ID NUMBER 1 select name,value,ISINSTANCE_MODIFIABLE from v$parameter 2* fetch next 20 rows only SQL> / NAME VALUE ISINSTANCE ------------------------------ -------------------- ---------- lock_name_space FALSE processes 300 FALSE sessions 472 TRUE timed_statistics TRUE TRUE timed_os_statistics 0 TRUE resource_limit TRUE TRUE license_max_sessions 0 TRUE license_sessions_warning 0 TRUE long_module_action TRUE TRUE standby_db_preserve_states NONE FALSE instance_abort_delay_time 0 TRUE NAME VALUE ISINSTANCE ------------------------------ -------------------- ---------- cpu_count 4 TRUE instance_groups FALSE event FALSE sga_max_size 570425344 FALSE use_large_pages TRUE FALSE pre_page_sga TRUE FALSE shared_memory_address 0 FALSE hi_shared_memory_address 0 FALSE lock_sga FALSE FALSE 20 rows selected. 1 select name,value,ISINSTANCE_MODIFIABLE from v$parameter where ISINSTANCE_MODIFIABLE='TRUE' 2* fetch next 5 rows only SQL> / NAME VALUE ISINSTANCE ------------------------------ -------------------- ---------- sessions 472 TRUE timed_statistics TRUE TRUE timed_os_statistics 0 TRUE resource_limit TRUE TRUE license_max_sessions 0 TRUE
SQL> show parameter db_writer_processes; NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ db_writer_processes integer 1 SQL> alter system set db_writer_processes=4 scope=spfile; System altered. SQL> show parameter db_writer_processes; NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ db_writer_processes integer 1 SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 570422456 bytes Fixed Size 8660152 bytes Variable Size 322961408 bytes Database Buffers 230686720 bytes Redo Buffers 8114176 bytes Database mounted. Database opened. SQL> show parameter db_writer_processes; NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ db_writer_processes integer 4
SQL> show parameter log_archive_max_processes; NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ log_archive_max_processes integer 4 SQL> alter system set log_archive_max_processes=6; System altered. SQL> show parameter log_archive_max_processes; NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ log_archive_max_processes integer 6
rollback
EM Express
https:/IP:5600/em SQL> exec dbms_xdb_config.sethttpsport(5600); PL/SQL procedure successfully completed.
session kill
select sid,serial#,USERNAME from v$session where username is not null
SQL> column USERNAME FORMAT a20
SQL> /
SID SERIAL# USERNAME
---------- ---------- --------------------
3 22826 SYS
10 15679 SYS
258 58337 SYS
SQL> select sid,serial#,USERNAME from v$session where username is not null;
SID SERIAL# USERNAME
---------- ---------- --------------------
3 22826 SYS
10 15679 SYS
20 10980 SCOTT
137 63223 SCOTT
SQL> alter system kill session '20,10980' immediate;
System altered.
SQL> select sid,serial#,USERNAME from v$session where username is not null;
SID SERIAL# USERNAME
---------- ---------- --------------------
3 22826 SYS
10 15679 SYS
137 63223 SCOTT