Extend the RECALL history duration

[Ramesh Selvam]

Dear Team,

I am using PLSQL Developer 11.0.3 which has recall statement Ctll+E duration for just 3 days.

Usually any our oracle implementation goes for 6 to 12 months.

Kindly guide me how to extend the duration so that I can see all my sql queries ran from starting of my project.

Also if that is not possible.Request you to share any other option to save my sql windows automatically on daily basis.

Thanks,
Ramesh Selvam

 

[Marco Kalter]

You can control the number of statements that can be recalled through Tools > Preferences > Tools / Recall Statement. By default this is 200.

There is no maximum duration. Statements will be stored indefinitely. The oldest statement is replaced by a newly executed statement when the maximum number of statements is reached.

 

[fctb]

The "Maximum size(statements)" has a limit of 1000 statements. Can you please change (increase) this limit?

Regards

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Srikanth Reddy]

Hi Marco,

Is this added in version 13, if not, any tentative version that will receive this update.

Regards,
Sri

 

[Marco Kalter]

The maximum recall buffer size has been increased from 1,000 to 10,000.