There is no V$ view or X$ table that contains this information. The only solution that occurs to me is to dump the savepoints to the process trace file with
alter session set events 'immediate trace name savepoints';
and then use UTL_FILE to read and parse the trace file information. Here is an
example of what you might get:
SAVEPOINT FOR CURRENT PROCESS
------------------------------
flag: 0x3
name: S3
dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082
status: VALID, next: 3822f60
name: S2
dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046
status: VALID, next: 37f63ec
name: S1
dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602
status: VALID, next: 0
This process has three savepoints named S1, S2 and S3 respectively.
Does anybody know if and how can I get a list of active savepoints for the current session? I need a native way, not solutions based on additional application-level housekeeping. Some query on the V$ tables/views would be the kind of answer I'm looking for.