Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Preferences: Code Editor: Printing: Add File Path and Date to Print Header?

MillicentCathySep 24 2013

Is there a way to add file full path and date to the print file header for a SQL Worksheet when printing from the Code Editor?  So, for example, if my SQL worksheet is called MySQL.sql and is saved to C:\Myfiles\SQL_Code\, I'd like to print the full path 'C:\Myfiles\SQL_Code\MySQL.sql' and today's date as part of the print header along with the page numbers at the top of the code.   I see a Java preview in the Preferences: Code Editor: Printing window that mentions a "Today" date but I don't know Java and that is an uneditable preview.  I have checked the "Print File Header" check box.  Is the file header definition stored somewhere in a configuration file and/or is there a way to modify/customize the default file header?  

I am a new user to SQL Nav. version 3.2.20.09 Build-MAIN  09.87. I could do this in SQL Navigator but can't figure it out in SQLDeveloper. Thank you.

-Cathy

Comments

Greybird-Oracle

Since the OOME is in RandomAccessFile.writeBytes0(Native Method), the system must overall must be low on memory. In other words, the OOME doesn't seem to be due to lack of Java heap space and therefore something else (another process?) is filling memory.

However, just in case the error is misleading, you should ensure that your heap size is around 2X the size of the JE cache. You didn't say what heap size you're using.

--mark

nitroamos

Thanks, Greybird-Oracle.

Here's the memory read out when the exception occurred:

memory: 403 free, 870 max, 870 total

for freeMemory, maxMemory, totalMemory respectively.

So I think my heap is sufficiently large... I haven't found a way to track native memory usage/availability.

How is it possible that my process would be competing for memory with another process?

Are you implying that lowering my je cache size might help?

Greybird-Oracle

It seems that RandomAccessFile.writeBytes0(Native Method) is allocating memory *outside* the Java heap, and there isn't memory available there. So something else on your machine is using this memory. In this case the JE cache size is not relevant, since it only impacts what is used inside the Java heap.

You could try reducing your heap size or look at what else is running on the machine and how much memory is available. To start with, look at your heap size relative to the total RAM.

--mark

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 22 2013
Added on Sep 24 2013
0 comments
218 views