This discussion is archived
2 Replies Latest reply: Jul 7, 2013 6:03 AM by steph0h RSS

History Table

steph0h Newbie
Currently Being Moderated

Hello,

I'm quite new to Oracle Advanced Queueing and I was just browsing the manuals (11G). In the prformance and scalabiltiy manual http://docs.oracle.com/cd/E11882_01/server.112/e11013/perform.htm#i1005693 it's stated that "With retention specified, the history table as well as the queue table can grow to be quite big". Now I'm wondering how to create a "history table". I created a queue table for testing with retention time set to infinite - but I can't figure out how to define where the retained messages are stored - in the queue table or in the history table. Any help is very much appreciated!

Thanks,

Stephan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points