Home » RDBMS Server » Performance Tuning » I have one problem with snapshot date
I have one problem with snapshot date [message #269693] Mon, 24 September 2007 02:20 Go to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Dear all!

I executed spreport.sql at 09/21/2007, and this snapshot is attached following my topic.
Today, I execute again, however, it is not true date - 09/24/2207.

How do I resolve this problem?

Thank in advance!
Re: I have one problem with snapshot date [message #269855 is a reply to message #269693] Mon, 24 September 2007 20:58 Go to previous message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello trantuananh24hg,



Your statspack report concerns snap ids 1 e 2 as follows:

STATSPACK report for

Database    DB Id    Instance     Inst Num Startup Time    Release     RAC
~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
          1713206530 neo                 1 21-Sep-07 07:48 10.2.0.1.0  NO

Host  Name:   TTUD-SRV01       Num CPUs:    2        Phys Memory (MB):    1,023
~~~~

Snapshot       Snap Id     Snap Time      Sessions Curs/Sess Comment
~~~~~~~~    ---------- ------------------ -------- --------- -------------------
Begin Snap:          1 21-Sep-07 09:29:57       38       5.9
  End Snap:          2 21-Sep-07 09:30:08       38       5.8
   Elapsed:                0.18 (mins)

Regards,


mson77
Previous Topic: Index rebuild
Next Topic: AWR REPORT
Goto Forum:
  


Current Time: Fri Dec 09 15:53:40 CST 2016

Total time taken to generate the page: 0.13099 seconds