OraFAQ Forum: Performance Tuning » I have one problem with snapshot date

Home » RDBMS Server » Performance Tuning » I have one problem with snapshot date

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I have one problem with snapshot date [message #269693]

Mon, 24 September 2007 02:20

trantuananh24hg
Messages: 744
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!

Attachment: 24_09_2007.snap
(Size: 72.89KB, Downloaded 1137 times)

Report message to a moderator

Re: I have one problem with snapshot date [message #269855 is a reply to message #269693]

Mon, 24 September 2007 20:58

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

Report message to a moderator

Previous Topic:	Index rebuild
Next Topic:	AWR REPORT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 01 03:29:32 CDT 2024