RE: Temporary files and Quick i/o

I wonder if you could do something (big sort or temporary table etc) to force the space to be allocated ie de-sparse-ing the file, and then convert the file to Quick IO ? Connor --- Khedr, Waleed [EMAIL PROTECTED] wrote: I think that the failure will not be caused by Oracle but by the

RE: Temporary files and Quick i/o

But you need new_file with specific length - let say 500M - how will you do it? Another way to do it - but may be long - is create normal tablespace (not temporary) with data files you need, then drop tablespace and then create temprary tablespace with reuse of created data files. Alex Hillman

RE: Temporary files and Quick i/o

As I mentioned in my previous email copying the file using cp after shutdwon normal will do this. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/18/01 9:35 AM I wonder if you could do something (big sort or temporary table etc) to force the space to be allocated

RE: Temporary files and Quick i/o

Steve, The tip is part of Database creation--- Why Raw datafiles?. So if my database has been running for a while and has come back with a few unable to allocate extents in the temp tabalespace. I could convert that datafile to quick io as the full space is allocated. So it is not sparse

RE: Temporary files and Quick i/o

Hi Johnson, I think I've fixed the web site to allow for this now. No, I'd say the bottom line is to use a raw tempfile. While following Waleed's idea of copying the file to make sure that it is not sparse would be safe, it is still contrary to what Veritas recommended. @ Regards, @ Steve

RE: Temporary files and Quick i/o

No you don't. Just copy the file to the new file and the new file will be created notsparse. -Original Message- Sent: Friday, May 18, 2001 10:11 AM To: Multiple recipients of list ORACLE-L But you need new_file with specific length - let say 500M - how will you do it? Another way to

RE: Temporary files and Quick i/o

I found this link: http://www.cpmc.columbia.edu:21168/techlib/qna/faxes/html/bak/bak16.htm Find this section: The Effect of Certain Commands on Sparse Files -Original Message- Sent: Friday, May 18, 2001 12:10 PM To: Multiple recipients of list ORACLE-L No you don't. Just copy the file

RE: Temporary files and Quick i/o

Hi Johnson, No, that's a datafile tablespace with temporary contents. A tempfile tablespace is inherently temporary. Check the documentation for the difference between ... CREATE TABLESPACE ... TEMPORARY and CREATE TEMPORARY TABLESPACE ... @ Regards, @ Steve Adams @

RE: Temporary files and Quick i/o

Maybe workaround is to precreate files and when creating temporary tablespaces use precreated files with reuse. Alex Hillman -Original Message- Sent: Thursday, May 17, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Hi, After reading Steve Adams' tip on making temp files

RE: Temporary files and Quick i/o

Hi Johnson, I don't believe that tempfiles can be sparse (although I may be wrong) and I am confident that datafiles cannot be. Maybe you should log a TAR with Oracle support to checkout whether tempfile can be sparse and just use datafiles until then. Anyway, can you please post the URL to the

RE: Temporary files and Quick i/o

If you create tablespace like - create temporary tablespace tablespace_name ... file_name created file will be sparse. Alex Hillman -Original Message- Sent: Thursday, May 17, 2001 6:30 PM To: Multiple recipients of list ORACLE-L Hi Johnson, I don't believe that tempfiles can be

RE: Temporary files and Quick i/o

I noticed this when I was playing with 9i. Regular tablespaces take long time to be created and temporary ones take nothing. Here is the proof: $ ls -l temp01.dbf -rw-rw-r-- 1 oracle dba 209719296 May 17 18:55 temp01.dbf $ du -k temp01.dbf 40968 temp01.dbf $ ls -l users01.dbf

RE: Temporary files and Quick i/o

After creating the temp file and shutting down the database, you can use on Solaris cp temp-file new-file and then cp new-file temp-file. After that you can convert it to quick-i/o. Regards, Waleed -Original Message- Sent: Thursday, May 17, 2001 8:06 PM To: Multiple recipients of list

RE: Temporary files and Quick i/o

Hi All, OK, you're all correct. Tempfiles can be sparse (it seems to be platform specific). Nevertheless, I'm unclear why Veritas think that is it any more of a problem for Oracle to get ENOSPC from a sparse tempfile if it is a QIO file than otherwise. Presumably Oracle would just raise ORA-7376

RE: Temporary files and Quick i/o

Hi All, Another correction. That error number has been changed to 7248 since Oracle8. I think I need a coffee! @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 18 May 2001 10:01 To: Multiple recipients of

RE: Temporary files and Quick i/o

I think that the failure will not be caused by Oracle but by the quick-io driver itself since it has to have full access to all the physical allocated blocks and also it depends on how Veritas will communicate back its failure to Oracle. Getting rid of the sparse space may be a good idea!

RE: Temporary files and Quick i/o

Steve, The only files that can be sparse are tempfiles with 8i+ See note 6224.1 ALERT: Sparse Files and Oracle (don't be fooled by the Oracle6 in the note, it includes 8i info as well). HTH, -- Anita --- Steve Adams [EMAIL PROTECTED] wrote: Hi Johnson, I don't believe that tempfiles can