Database Administration (MOSC)

MOSC Banner

what is SYS.QT999999_BUFFER view?

edited May 15, 2024 4:18AM in Database Administration (MOSC) 3 commentsAnswered

Hi Friends,

There are serveral views under SYS schema. Any idea what are these views and are they coming from 3rd party software? If yes, what software?

QT101175_BUFFER
QT106790_BUFFER
QT12590_BUFFER
QT12617_BUFFER
QT12651_BUFFER
QT12710_BUFFER
QT12911_BUFFER
QT12949_BUFFER
QT2405155_BUFFER
QT86718_BUFFER
QT86763_BUFFER

one of the view:

SELECT "ADDR","INDX","INST_ID","OBJNO","QUEUE_ID","MSGID","CORRID","SEQUENCE_NUM","MSG_NUM","STATE","PRIORITY","EXPIRATION","ENQ_TIME","ENQ_UID","ENQ_USER_NAME","RETRY_COUNT","SENDER_NAME","SENDER_ADDRESS","SENDER_PROTOCOL","DEQUEUE_MSGID","SRCSEQUENCE_NUM","SUBSCRIBER_ID","EXCEPTIONQ_SCHEMA","EXCEPTIONQ_NAME" FROM X$BUFFER2 WHERE objno = 106790

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center