SET WRAP OFFSET LINESIZE 100
TIMED_STATISTICS = TRUEALTER System SET TIMED_STATISTICS = FALSE Scope = Memory; / SPFILE / BOTH
Dynamic parameters and static parameters v $ system_parameterisses_modifiable is session modifiable alter session set ... issys_modifiable is system modifiable alter system set ...
Create spfile from pfile; create spfile = 'd: /oracle/ora90/Database/spfile.ora' from pfile;
By default, create file directory show parameter db_create
Alter System Set DB_CREATE_FILE_DEST = 'D: / Oracle / ORADB'; CREATE TABLESPACE TEST1;
9IDrop TableSpace Test1Including Contents and DataFiles;
Startup [Nomount | Mount | Open] Pfile = RestRict Recovery Force
Alter Database DB01 Mount; Alter Database DB01 Open Read Only
Alter System Enable Restricted Session;
Alter Database DataFile 8 Offline; / Online;
Recovery 1.redo logs buy to it should change the roll back uncommitted change to roll back uncommitted change
altr file Background trace files written to a background process error trace file background_dump_destUser trace files is disabled by default user_dump_destA user trace file is produced by the user processconnected to the Oracle server through the server process.
Enabling or disabling User Tracing1 Session level using the Alter session command: alter session set sql_trace = true2 Session level by executing DBMS procedure: dbms_system.SET_SQL_TRACE_IN_SESSION3 Instance level by setting the initialization parameter: SQL_TRACE = true
