Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

where the compliled prepared statemnets stored?

 
narender kaasam
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
where the compliled prepared statemnets stored?
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Support for prepared statment caching is provided by DataBase, hence this prepared statement is stored in database.

for example in case of oracle, It is stored in SGA, aka SHARED_GLOBAL_AREA

Shailesh
 
narender kaasam
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thnk u very much
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic