win下一个单机oracle11g数据库,之前到处blob字段的数据,处理速度也很快,从昨天下午突然就慢了,数据库没有做参数的修改,数据库访问正常,工具可以正常连接,就是在上传blob字段时速度慢,能定位哪里的问题吗?
部分日志如下:
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Apr 15 14:25:29 2020
SMON: enabling cache recovery
Wed Apr 15 14:25:45 2020
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption…
Verifying 11g file header compatibility for tablespace encryption completed
Wed Apr 15 14:25:45 2020
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
Starting background process FBDA
Starting background process SMCO
Wed Apr 15 14:25:55 2020
SMCO started with pid=39, OS id=4552
Wed Apr 15 14:25:55 2020
FBDA started with pid=38, OS id=4548
Wed Apr 15 14:25:57 2020
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Apr 15 14:26:19 2020
Starting background process QMNC
Wed Apr 15 14:26:19 2020
QMNC started with pid=41, OS id=4688
Wed Apr 15 14:27:42 2020
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Apr 15 14:28:54 2020
Completed: alter database open
Wed Apr 15 14:32:50 2020
Starting background process CJQ0
Wed Apr 15 14:32:50 2020
CJQ0 started with pid=7, OS id=5672
Wed Apr 15 22:00:00 2020
Setting Resource Manager plan SCHEDULER[0x2C0B]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Wed Apr 15 22:00:19 2020
Wed Apr 15 22:00:19 2020
Logminer Bld: Lockdown Complete. DB_TXN_SCN is UnwindToSCN (LockdownSCN) is 31656651
Wed Apr 15 22:00:30 2020
Begin automatic SQL Tuning Advisor run for special tuning task “SYS_AUTO_SQL_TUNING_TASK”
Wed Apr 15 22:14:17 2020
Thread 1 advanced to log sequence 1259
Current log# 2 seq# 1259 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Wed Apr 15 23:00:31 2020
End automatic SQL Tuning Advisor run for special tuning task “SYS_AUTO_SQL_TUNING_TASK”
Thu Apr 16 02:00:00 2020
Clearing Resource Manager plan via parameter
Thu Apr 16 08:26:35 2020
Thread 1 advanced to log sequence 1260
Current log# 3 seq# 1260 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Thu Apr 16 09:26:02 2020
Thread 1 advanced to log sequence 1261
Current log# 1 seq# 1261 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
Thu Apr 16 10:09:10 2020
Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.1.0.6.0 - Production
Time: 16-4月 -2020 10:09:10
Tracing not turned on.
Tns error struct:
ns main err code: 12638
TNS-12638: 身份证明检索失败
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Thu Apr 16 10:30:27 2020
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\app\Administrator\product\11.1.0\db_1\RDBMS
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =363
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile D:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes = 3000
sessions = 3305
memory_target = 1640M
control_files = “D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL”
control_files = “D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL02.CTL”
control_files = “D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL03.CTL”
db_block_size = 8192
compatible = “11.1.0.0.0”
db_recovery_file_dest = “D:\app\Administrator\flash_recovery_area”
db_recovery_file_dest_size= 2G
undo_tablespace = “UNDOTBS1”
remote_login_passwordfile= “EXCLUSIVE”
db_domain = “”
dispatchers = “(PROTOCOL=TCP) (SERVICE=orclXDB)”
audit_file_dest = “D:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP”
audit_trail = “DB”
db_name = “orcl”
open_cursors = 50000
diagnostic_dest = “D:\APP\ADMINISTRATOR”
Thu Apr 16 10:30:38 2020
PMON started with pid=2, OS id=4208
Thu Apr 16 10:30:38 2020
VKTM started with pid=3, OS id=4792 at elevated priority
VKTM running at (20)ms precision
Thu Apr 16 10:30:38 2020
DIAG started with pid=4, OS id=4812
Thu Apr 16 10:30:38 2020
DBRM started with pid=5, OS id=4796
Thu Apr 16 10:30:38 2020
PSP0 started with pid=6, OS id=2772
Thu Apr 16 10:30:38 2020
DSKM started with pid=7, OS id=4112
Thu Apr 16 10:30:38 2020
DIA0 started with pid=8, OS id=2420
Thu Apr 16 10:30:38 2020
MMAN started with pid=7, OS id=5704
Thu Apr 16 10:30:38 2020
DBW0 started with pid=9, OS id=3056
Thu Apr 16 10:30:38 2020
DBW1 started with pid=10, OS id=1796
Thu Apr 16 10:30:38 2020
DBW2 started with pid=11, OS id=264
Thu Apr 16 10:30:38 2020
DBW3 started with pid=12, OS id=5124
Thu Apr 16 10:30:38 2020
LGWR started with pid=13, OS id=5140
Thu Apr 16 10:30:38 2020
CKPT started with pid=14, OS id=5136
Thu Apr 16 10:30:38 2020
SMON started with pid=15, OS id=3372
Thu Apr 16 10:30:39 2020
RECO started with pid=16, OS id=5920
Thu Apr 16 10:30:39 2020
MMON started with pid=17, OS id=5916
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 shared server(s) …
ORACLE_BASE from environment = D:\app\Administrator
Thu Apr 16 10:30:39 2020
alter database mount exclusive
Thu Apr 16 10:30:39 2020
MMNL started with pid=18, OS id=5072
Thu Apr 16 10:30:54 2020
Setting recovery target incarnation to 2
Thu Apr 16 10:30:59 2020
Successful mount of redo thread 1, with mount id 1565660752
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Thu Apr 16 10:31:10 2020
Beginning crash recovery of 1 threads
parallel recovery started with 16 processes
Started redo scan
Thu Apr 16 10:31:24 2020
Completed redo scan
4409 redo blocks read, 289 data blocks need recovery
Thu Apr 16 10:31:36 2020
Started redo application at
Thread 1: logseq 1261, block 10113
Thu Apr 16 10:31:47 2020
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1261 Reading mem 0
Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
Completed redo application
Thu Apr 16 10:32:11 2020
Completed crash recovery at
Thread 1: logseq 1261, block 14522, scn 31738566
289 data blocks read, 289 data blocks written, 4409 redo blocks read
Thu Apr 16 10:32:24 2020
Thread 1 advanced to log sequence 1262
Thread 1 opened at log sequence 1262
Current log# 2 seq# 1262 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Thu Apr 16 10:32:31 2020
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Apr 16 10:32:31 2020
SMON: enabling cache recovery
Thu Apr 16 10:32:54 2020
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption…
Verifying 11g file header compatibility for tablespace encryption completed
Thu Apr 16 10:32:54 2020
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
Thu Apr 16 10:33:07 2020
Starting background process FBDA
Starting background process SMCO
Thu Apr 16 10:33:07 2020
SMCO started with pid=39, OS id=4876
Thu Apr 16 10:33:07 2020
FBDA started with pid=38, OS id=5892
replication_dependency_tracking turned off (no async multimaster replication found)
Thu Apr 16 10:33:27 2020
Starting background process QMNC
Thu Apr 16 10:33:27 2020
QMNC started with pid=41, OS id=3560
Thu Apr 16 10:34:46 2020
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Apr 16 10:36:38 2020
Completed: alter database open
Thu Apr 16 10:40:47 2020
Starting background process CJQ0
Thu Apr 16 10:40:47 2020
CJQ0 started with pid=31, OS id=4964
