View the error code
Oerr ORA?
Log file
Archive log list;
MEMBER in the group of the log is mirroring.
Alter System Swith Logfile; Force System Log Switching
Related views: V $ logfile v $ logfile
Replace / delete log files:
1.SHUTDOWN (for faster shutdown, you can start Startup force;)
2. Scrapped the log file to the specified directory
3.Alter Database Rename file 'D: /oracle/log1c.rdo' to 'c: /oracle/log1c.rdo'
ALTER DATABASE DROP Logfile Member 'C: /oracle/log1c.rdo'
If the log is running, a log switch can be performed.
Create a table structure
With record creation table
CREATE TABLE AUDITING.TB_BALANCE_BAK AS SELECT * from Auditing.tb_balance
No record creation table
Create Table Auditing.tb_balance_bak asselect * from auditing.tb_balance where 1 = 2
View the process and kill the process
Select * from V $ session where program limited '% JDBC%'
Alter System Kill Session '12, 29260 '
Analysis Table
Analyze Table Init.TB_Balance Compute Statistics
However, it is possible that the index will no longer use the index by the index.
Alter session set optimizer_dynamic_sampling = 50
ALTER session set optimizer_index_cost_id = 50
