전체 글 (662) 썸네일형 리스트형 43 - [Oracle 19C] Enable DDL logging SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> alter session set container=orclpdb; Session altered. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 ORCLPDB READ WRITE NO SQL> show con_name CON_NAME ------------------------------ ORCLPDB SQL> show parameter ddl; NAME TYPE VALUE -----------------------.. 42 - [Oracle 19C] (ADR)Trace files • Trace files contain: Error information (contact Oracle Support Services if internal error occurs) Information that can provide guidance for tuning applications or an instance • Each server and background process can write to an associated trace file. • Trace file names for background processes are named after their processes. Exception: Trace files generated by job queue processes • Oracle Dat.. 41 - [Oracle 19C] View alert log using ADRCI [oracle@test Desktop]$ adrci ADRCI: Release 19.0.0.0.0 - Production on Thu Nov 23 16:23:17 2023 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> show alert Choose the home from which to view the alert log: 1: diag/rdbms/orcl/orcl 2: diag/clients/user_oracle/host_1461729758_110 3: diag/tnslsnr/test/listener Q: to quit Please select o.. 40 - [Oracle 19C] Automatic Diagnostic Repository (ADR) Typical installations will have the ADR_BASE set to the ORACLE_BASE [oracle@test ~]$ echo $ORACLE_BASE /u01/app/oracle • You can make sure from parameter diagnostic_dest • The ADR home path is "/u01/app/oracle/diag/rdbms/orcl/orcl" SQL> show parameter diagnostic_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ diagnostic_dest string /u01/app/or.. 39 - [Oracle 19C] CONTAINER clause in alter system ISSES_MODIFIABLE is false that means you cannot change it in the session, but you can change it. ISSYS_MODIFIABLE(system modifiable) is immediate. This means that I can change the value in the memory level. FALSE: You can only change the value with a static parameter using scope=spfile. In other words, the change will take effect from the next restart of the database. IMMEDIATE: If you change th.. 38 - [Oracle 19C] Default scope in alter system Alter system set parameter=value - If a server parameter file was used to start up the database, then BOTH is the default. Alter system set parameter=value same as Alter system set parameter=value scope=both - If a parameter file was used to start up the database, then MEMORY is the default, as well as the only scope you can specify. Alter system set parameter=value same as Alter system set para.. 37 - [Oracle 19C] To alter system example(both) SQL> alter system set max_idle_time=20 scope=both; System altered. SQL> select value from v$parameter where name='max_idle_time'; VALUE -------------------------------------------------------------------------------- 20 SQL> alter system reset max_idle_time scope=both; System altered. SQL> select value from v$parameter where name='max_idle_time'; VALUE -------------------------------------------.. 36 - [Oracle 19C] To alter system example(spfile) SQL> alter system set max_idle_time=50 scope=spfile; System altered. SQL> show parameter max_idle_time NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ max_idle_time integer 0 SQL> SQL> SQL> select value from v$system_parameter where name='max_idle_time'; VALUE -------------------------------------------------------------------------------- 0 SQL> S.. 이전 1 ··· 23 24 25 26 27 28 29 ··· 83 다음
