Oracle 10g
for example :
there is a table named table_a,
now ,it 's 6:00AM . i want to know that table_a's status at 5:00AM.
i want to know if anyuser locked table_a at 5:00AM.
how can i know?
Printable View
Oracle 10g
for example :
there is a table named table_a,
now ,it 's 6:00AM . i want to know that table_a's status at 5:00AM.
i want to know if anyuser locked table_a at 5:00AM.
how can i know?
no, you cannot know that
You can if you have in place any piece of software writing down activity snapshots, you may want to try digging historic data on OEM or dbtop alike logs but you have to had something out there keeping that data safe for your review.