ASM and OMF TEMP files
Hi to all,
I have a bit of problem with my TEMP tablespace.
I currently have a clustered database using ASM/OMF file structure.
one of the DBA's managing the database created a datafile (not using OMF) and has now created a physical file on disk. It was whilst I was away and at the time they needed to add more temp space urgently. All is forgiven.
My problem is trying to manage this TEMP tablespace. I am not sure how to resolve it and just wanted to check what I should do.
Here is the current setup of TEMP:
Name|| Directory|| Size (MB)|| Used (MB)|| Auto Extend|| What needs to be achieved;||
temp.269.684959461|| +ASMDB/Proddb/tempfile/|| 0.00|| 0.00|| No|| ------> I need to remove this||
temp01.dbf|| +ASMDB/Proddb/tempfile/|| 7,860.00 || 38.00 || Yes|| ------> I need to remove this||
temp.269.782738817|| +ASMDB/Proddb/tempfile/|| 100.00|| 0.00|| Yes|| ------> This will stay in place. -----> This has been newly created to try and resolve the problem.||
My environment:
OS - RHEL 5.7
Oracle DB - 11.1.0.7
Filesystem - ASM/OMF
Thanks to all that reply. Any advise is gratefully received.
Edited by: JayGee on May 8, 2012 3:38 AM