How to allocate actual tempfile size in OS
I have created a temporary tablespace with a tempfile with 5GB size, but the tempfiles in OS level is not allocate the size as per I specify, the space is only allocated when the time tempfile is been access.
How can i pre-allocate the space in the OS for temporary datafile?
Great Thanks for any advise given.
Best regards