Here is a nice trick to work with files larger than 2GB on Unix/Linux using pipe.
First case - TKPROF
When trying to execute TKPROF on a trace file larger than 2 GB I got this error:
In order to successfully execute TKPROF on this trace file you can use the mkfifo command to create named pipe as follow:
This way you'll successfully get the output file.
Second case - spool
Similar issue with spool to file larger than 2GB can be treat similarly.
Note 62427.1 - 2Gb or Not 2Gb - File limits in Oracle