Capacity Planner and OEM

From: Cyril Thankappan <cyril_thank_at_rediffmail.com>
Date: 15 Jan 2001 18:41:16 -0000
Message-Id: <10742.126703@fatcity.com>

  Hello listers

 I need some urgent help on
 Capacity Planner of OEM..

 Now the documentation says that we
 can 'project' 'estimate' requirements using  capacity planner

 But despite my best attempts
 I keep getting a chart with the present  'readings' only

 Can someone please help me to get
 the 'extrapolation' part right?

 Thanks a lot

---

Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com

---

 From: "Ferris, Shawn" <Shawn.Ferris_at_twtelecom.com>  Date: Mon, 15 Jan 2001 11:47:16 -0700
 Subject: RE: Name of controlfile trace

>
> I recall reading somewhere that there may be a way to
> determine the name of the trace file when a control
> file trace backup is created with the command:
>
> alter database backup controlfile to trace noresetlogs;

This is platform specefic. The following sql is for sun. (sid_ora_#.trc - Linux is ora_#.trc) Just change the format of the result for your platform. The query should be the same.

select

      a.value ||
        '/' ||
      lower(d.name) ||
        '_ora_' ||
      b.spid ||
        '.trc' as file_name
    from
      v$parameter a,
      v$process b,
      v$session c,
      v$database d
    where
          a.name='user_dump_dest'
      and b.addr=c.paddr
      and c.type='USER'
      and c.audsid=userenv('SESSIONID')

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom  

---

 From: "Viraj Luthra" <viraj999_at_lycos.com>  Date: Tue, 16 Jan 2001 04:49:13 +1000
 Subject: Oracle Enterprise Manager, Diagnostic Pack - on NT 4.0 and Oracle 8i Received on Mon Jan 15 2001 - 12:41:16 CST