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

History Table

steph0h Newbie
Currently Being Moderated


I'm quite new to Oracle Advanced Queueing and I was just browsing the manuals (11G). In the prformance and scalabiltiy manual 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!




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