Thanks for the question, Roman.
Asked: January 10, 2019 - 10:08 am UTC
Last updated: January 21, 2019 - 12:12 pm UTC
Version: 11.2
Viewed 1000+ times
You Asked
Hi TOM,
How to profile with DBMS_HPROF into memory (RAM)?
For example, into BLOB, that will be stored in memory (RAM, PGA).
The problem is that I need to save result only if a procedure running more than 1 minute. Most of the time there is no need to write result on disk.
and Connor said...
The profiler captures its data to the file system initially.
It only loads the database tables after an ANALYZE call.
So the overhead should be pretty small anyway - you would simply not call analyze unless your proc ran for more than 60 seconds.
If that is still an overhead, then create a ram-based file system at the OS level, and then make that your target directory for DBMS_HPROF data collection.
But the biggest benefits will be simply avoiding the ANALYZE call unless you really need it.
Is this answer out of date? If it is, please let us know via a Comment