hi friends, my undotablespace datafile size is increased much.
it is 2.7 GB. I was suggested to decrease the size up to 400 or
500 mb etc..
how to resize this datafile. If I use alter database data file....
resize.. it is give 'it is beyond the used space' error.
Can u give best solution for this.
does this size effects performance??
should i resize it compulsary?