Several commands required to understand the Oracle Physical System

Several commands required to understand the Oracle physical system 1. display the parameters related to the rollback segment ChenZw> show parameter undo name type value =---------------- undo_management string AUTOundo_retention integer 900undo_tablespace string UNDOTBS1 2. Display SGA related parameter ChenZw> show parameter sga name type value -------------------------------------- ----------- ---------- lock_sga boolean FALSEpre_page_sga boolean FALSEsga_max_size big Integer 512Msga_target big integer 0 3. display the Shared Pool parameters ChenZw> show parameter shared_pool name type value ------------- ------------ shared_pool_reserved_size big integer large integer 132 M 4. display the data buffer pool size ChenZw> show parameter db_cache_size; name type value ------------------------------------ ----------- --------- db_cache_size big integer 0 5. Display logs Buffer-related parameters: ChenZw> show parameter log_buffer name type value ------------- ---------- log_buffer integer 5653504 6. Command for modifying database parameter settings: ChenZw> alter system set sga_target = 200 m scope = memory; the system has been changed. Used time: 00: 00: 00.16 7. display the Instance NAME of the current database ChenZw> show parameter instance_name name type value ------------- instance_name string orcl 8. view the current archived log mode 21:34:54 ChenZw> archive log list database log Mode archive mode: Enable automatic archiving end point USE_DB_RECOVERY_FILE_DEST oldest online log sequence 229 next archive log sequence 231 current log sequence 231 9. The command to start and stop the database ChenZw> shutdown immediate database has been disabled. The database has been detached. The ORACLE routine has been disabled. ChenZw> startup nomountORA-32004: the obsolete and/or deprecated parameter (s) specifiedORACLE routine has been started. Total System Global Area 535662592 bytesFixed Size 1334380 bytesVariable Size 339739540 bytesDatabase Buffers 188743680 bytesRedo Buffers 5844992 bytesChenZw> alter database mount; the database has been changed. ChenZw> alter database open; the database has been changed. 10. view the parameter view of the database ChenZw> select * from v $ parameter; 11. view the database's control file ChenZw> show parameter control name type value ----------- using control_file_record_keep_time integer 7control_files string D: \ ORACLE \ ORADATA \ ORCL \ CONTROL 01.CTL, D: \ ORACLE \ ORADATA \ ORCL \ CONTROL02.CTL, D: \ ORACLE \ orad ata \ ORCL \ CONTROL03.CTLcontrol _ management_pack_access string DIAGNOSTIC + TUNING 12, see the database file ChenZw> column file_name format a40ChenZw> select file_name from dba_data_files; FILE_NAME----------------------------------------D: \ ORACLE \ ORADATA \ ORCL \ USERS01.DBFD: \ ORACLE \ ORADATA \ ORCL \ connector: \ ORACLE \ ORADATA \ ORCL \ SYSAUX01.DBFD: \ ORACLE \ ORADATA \ ORCL \ SYSTEM01.DBFE: \ GXSIDB \ DATAE: \ GXSIDB \ RMAN_TS.DBF six rows have been selected. 13. view the Database Log File ChenZw> column member format a40ChenZw> select group #, member from v $ logfile; GROUP # MEMBER ------------ ---------------------------------------- 3 D: \ ORACLE \ ORADATA \ ORCL \ REDO03.LOG 2 D: \ ORACLE \ ORADATA \ ORCL \ REDO02.LOG 1 D: \ ORACLE \ ORADATA \ ORCL \ REDO01.LOG 3 rows have been selected. 14. view the database archive file ChenZw> show parameter recovery name type value ------------------------------------ ----------- ---------------------------- db_recovery_file_dest string e: \ gxsiDB \ DATABASE_BACKUPdb_recovery_file_dest_size big integer 4Grecovery_parallelism integer 0 15. view the database's alarm Log File ChenZw> show parameter dump name type value = ------------------------------------------------------------------------- ---- Background_core_dump string partialbackground_dump_dest string d: \ oracle \ diag \ rdbms \ orcl \ tracecore_dump_dest string d: \ oracle \ diag \ rdbms \ orcl \ empty string unlimitedshadow_core_dump string noneuser_dump_dest string d: \ oracle \ diag \ rdbms \ orcl \ trace 16. view the command status C: \> lsnrctl status LSNRCTL for 32-bit Windows: Version 11.1.0.6.0-Production on-2013 0 Copyright (c) 1991,200 7, Oracle. all rights reserved. connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1523) the listener status ---------------------- alias LISTENER version TNSLSNR for 32-bit Windows: version 11.1.0.6.0-Production start date: 06-7 months-2013 10:21:21 normal running time: 0 days 11 hours 45 minutes 41 seconds tracking level off security ON: Local OS AuthenticationSNMP OFF listener parameter file D: \ oracle \ product \ 11.1.0 \ db_1 \ network \ admin \ listener. ora listener day Log File d: \ oracle \ diag \ tnslsnr \ Supermos \ listener \ alert \ log. xml listener endpoint overview... (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (PIPENAME = \\. \ pipe \ EXTPROC1523ipc) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = Supermos) (PORT = 1523) Service abstract .. the Service "ORCLXDB" contains one routine. Routine "orcl", status READY, contains 1 handler of this service... service "ORCL_XPT" contains 1 routine. Routine "orcl", status READY, contains one handler of this service... service "orcl" contains one routine. Routine "orcl", status READY, contains 1 handler of this service... command Execution successful 17. start and stop listening command C :\> lsnrctl stop C :\> lsnrctl start author Chen Ziwen (keen on PM \ ORACLE \ JAVA, etc., welcome to exchange) ziwen # 163.com deduction: 4 0 9 0 2 0 1 0 0 18, clear the sharing pool of the current system ChenZw> alter system flush shared_pool; the system has changed.