Hi ALL,
11gR2
OL6
is there problem with our disk i/o subsystem?
Lately it seems the performance of our database is so slow
I tried to create a new tablespace and it takes too long which should be less that a minute before.
create tablespace data01 datafile '/home/oracle/app/oracle/oradata/oracledb/data01.dbf' size 1G autoextend on;
Sun May 21 03:52:30 2017
Thread 1 advanced to log sequence 306280 (LGWR switch)
Current log# 7 seq# 306280 mem# 0: /home/oracle/app/oracle/oradata/oracledb/redo7.log
Does creating a tablespace generates redo?
Please help how to check if we have problem in I/O.
Kind regards,
jc