temm
asked on
Oracle datafile inactive?
Hello,
Before two days i expanded a tablespace creating a new datafile. I used the enterprise manager console.
The problem is that this datafile is indicated as online but no data is written to it. Instead the temporary tablespace is begin using. It's increasing with a huge performance impact.
All of the datafiles permisions are -rw-r--r- and the new datafile has -rw-rw---
Can i change the attributes from the datafile? Do i have to shutdown the database first?
We are using 10g on RedHat Enterprise 4.4
Thank you.
Teo
Before two days i expanded a tablespace creating a new datafile. I used the enterprise manager console.
The problem is that this datafile is indicated as online but no data is written to it. Instead the temporary tablespace is begin using. It's increasing with a huge performance impact.
All of the datafiles permisions are -rw-r--r- and the new datafile has -rw-rw---
Can i change the attributes from the datafile? Do i have to shutdown the database first?
We are using 10g on RedHat Enterprise 4.4
Thank you.
Teo
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Well this is a tablespace where some indexes are stored. There are a few tables also. I did some test inserting records into a test table but i don't see the size of the actual data change from the enterprise manager.
Is there a way to see excatly the amount of bytes in a datafile e.g. from dba_data_files?
Is there a way to see excatly the amount of bytes in a datafile e.g. from dba_data_files?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Teo