Home » SQL & PL/SQL » Client Tools » How to find the List of Queries from the History used before a Day (Oracle 11g Database, MS Win Xp, Oracle Sql Developer)
icon9.gif  How to find the List of Queries from the History used before a Day [message #625562] Fri, 10 October 2014 04:18 Go to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Hi,

I have a Complicated issue, well i am using Oracle SQL Developer,
yesterday i was querying some SQL Select Statements for some tables,
and i didnt shutdown my system and went to home after locking my
system so that i can work today from the same queries.

Unfortunately my system got restarted without my knowledge,
and when i tried to open sql history i found no history of
the queries i typed yesterday and it shows some 15 days old queries
only.

well i like to know how recover the sql_text i typed yesterday is
there any queries or methods.

pls help...

[Updated on: Fri, 10 October 2014 04:19]

Report message to a moderator

Re: How to find the List of Queries from the History used before a Day [message #625582 is a reply to message #625562] Fri, 10 October 2014 10:58 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
If you remember something about the SQL, and if the shared pool is not yet flushed, you can look into v$sql for sql_fulltext.
Re: How to find the List of Queries from the History used before a Day [message #625583 is a reply to message #625582] Fri, 10 October 2014 11:33 Go to previous messageGo to next message
BlackSwan
Messages: 25859
Registered: January 2009
Location: SoCal
Senior Member
Lalit Kumar B wrote on Fri, 10 October 2014 08:58
If you remember something about the SQL, and if the shared pool is not yet flushed, you can look into v$sql for sql_fulltext.



Does not the SGA start empty after a system restart? It will contain NOTHING from before the system restart.
Re: How to find the List of Queries from the History used before a Day [message #625584 is a reply to message #625583] Fri, 10 October 2014 11:53 Go to previous message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I think he is talking about SQL Developer statements history not database one.

Previous Topic: Garbled foreign text in Oracle SQL Developer
Next Topic: sqlplus script end of file
Goto Forum:
  


Current Time: Sun Feb 25 12:40:47 CST 2018

Total time taken to generate the page: 0.01736 seconds