Re: Sql Trace to detect concurrency issues

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 23 Jan 2006 09:45:39 -0800
Message-ID: <1138038337.442253@jetspin.drizzle.com>

Jonathan Lewis wrote:

> You can then convert
> the SCN to a time with one of the utility packages
> (but I can't remember the name at present).

No packages required:

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 23 09:44:36 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> SELECT dbms_flashback.get_system_change_number

   2 FROM dual;

GET_SYSTEM_CHANGE_NUMBER

---

                   831050

SQL> SELECT SCN_TO_TIMESTAMP(831050)
   2 FROM dual;

SCN_TO_TIMESTAMP(831050)

---

23-JAN-06 09.44.37.000000000 AM SQL> SELECT TIMESTAMP_TO_SCN('23-JAN-06 09.44.37.000000000 AM')    2 FROM dual;

TIMESTAMP_TO_SCN('23-JAN-0609.44.37.000000000AM')

---

                                            831050

SQL>

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Mon Jan 23 2006 - 11:45:39 CST