Create tablespace extremely slow
Hello Guys ..
Microsoft Windows x64 (64-bit)
DB version : 11.1.0.6
CREATE SMALLFILE TABLESPACE TEST DATAFILE 'E:\oradata\sipdb\TEST.DBF' SIZE 64M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE 2038M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO DEFAULT NOCOMPRESS;
A command like this might take 90-150 minutes to complete
10046 tracing shows that most of the wait time is spent on idle wait event "SQL*Net message from client"
* The error is raised when connected to the DB server directly using bequeath connection (/ as sysdba), same behavior when tried via Toad
* DCD is not enabled
* Bouncing the server didn't help
* Creating a file directly on the server works fine
Microsoft Windows x64 (64-bit)
DB version : 11.1.0.6
CREATE SMALLFILE TABLESPACE TEST DATAFILE 'E:\oradata\sipdb\TEST.DBF' SIZE 64M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE 2038M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO DEFAULT NOCOMPRESS;
A command like this might take 90-150 minutes to complete
10046 tracing shows that most of the wait time is spent on idle wait event "SQL*Net message from client"
* The error is raised when connected to the DB server directly using bequeath connection (/ as sysdba), same behavior when tried via Toad
* DCD is not enabled
* Bouncing the server didn't help
* Creating a file directly on the server works fine
0