From oracle-l-bounce@freelists.org Fri Sep 9 17:02:59 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j89M2xlf014077 for ; Fri, 9 Sep 2005 17:02:59 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j89M2uIP014061 for ; Fri, 9 Sep 2005 17:02:57 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8E6321E96D4; Fri, 9 Sep 2005 17:02:49 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30669-03; Fri, 9 Sep 2005 17:02:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D933B1E99DE; Fri, 9 Sep 2005 17:02:48 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=RVJlQBfbssNRo41IDIzPkLIXFKAFHDs3d+kLZEUV7DRnO0G9By34Q85u/Hq+4KjUOractEdvaD+BntVkSaRvU5vg/t+qdqGxdnxQEq6tVvz9TCtP/t1wRwPb0IqtBPGzzml7Lp+Wxc6uLl13rYnDtGqFP/0ukLLaOSe0gfeWWWM= Message-ID: <910046b405090915004de3cf89@mail.gmail.com> Date: Fri, 9 Sep 2005 18:00:57 -0400 From: Paul Drake To: ldk2005@gmail.com Subject: Re: Where does STATSPACK save its reports generated with spreport Cc: Oracle-L@freelists.org In-Reply-To: <871b07a70509091417481cba8f@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7202_10167825.1126303257402" References: <871b07a7050908071617de1e90@mail.gmail.com> <871b07a70509091417481cba8f@mail.gmail.com> X-archive-position: 25251 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: bdbafh@gmail.com Precedence: normal Reply-To: bdbafh@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.3 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_7202_10167825.1126303257402 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 9/9/05, Larry Kelly wrote: >=20 > Thanks for all the clues. Here is what I found out.=20 >=20 > This instance of Oracle is on Window 2003 server. Remote access is via a= =20 > terminal server, with load balancing. The statspack report files were sav= ed=20 > to the default directory, which in this case was 'My Documents', for the= =20 > current user. The files are physically stored on whichever terminal serve= r=20 > the TS manager routed my user account to for that session. So my reports= =20 > were scattered over several TS servers. To make matters worse, the SA=20 > assigned me a different login and profile, ( for reasond I won't bore you= =20 > with here :)). Consequently, all my previously generated reports disappea= red=20 > and wouldn't show up when I did a 'Search' of the harddrive. Makes you lo= ng=20 > for the good 'o' days, when all you had was a shell account into a 'nix'= =20 > box. Niall's comment about being able to specify a path with the alternat= ive=20 > file name helped me verify that the reports were actually being generated= .=20 >=20 > On 9/8/05, Larry Kelly wrote:=20 > >=20 > >=20 > > What does spreport.sql save the statspack report? I cannot find it=20 > > anywhere??=20 > > Statspack is installed on my Oracle 8i system. After creating a few=20 > > snapshots, I ran spreport from sqlplus*. After it conpleted, a search f= or=20 > > the report filename returned nothing. Any help here would be greatly=20 > > appreciated. > >=20 > > Thanks, again. > > --=20 > > Best Regards, > > -Larry > > "Work, work, work...there is no satisfactory alternative." > > --- E.Taft Benson=20 >=20 >=20 Larry, I have some good news for you. Someone did a quick writeup of the tweaks necessary to get Cygwin OpenSSH= =20 running on w2k3 server as a service. It was a slam dunk to get working on= =20 w2k server - but the default security policy for w2k3 server resulted in a= =20 few changes being required for the service to accept connections=20 successfully (Fanfare!). http://www.hunt-family.net/cygsshpka.html So get the SA to install Cygwin, fire up the sshd and your favorite ssh=20 client and login like its a *nix box. Enjoy. Paul ------=_Part_7202_10167825.1126303257402 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 9/9/05, Larry Kelly <ldk2005@gmail.com> wrote:
Thanks for all the clues.  Here is what I found out. 

This instance of Oracle is on Window 2003 server.  Remote access is via a terminal server, with load balancing. The statspack report files were saved to the default directory, which in this case was 'My Documents', for the current user. The files are physically stored on  whichever terminal server the TS manager routed my user account to for that session.  So my reports were scattered over several TS servers. To make matters worse,  the SA assigned me a different login and profile, ( for reasond I won't bore you with here :)).  Consequently, all my previously generated reports disappeared and wouldn't show up when I did a 'Search' of the harddrive.  Makes you long for the good 'o' days, when all you had was a shell account into a 'nix' box.  Niall's comment about being able to specify a path with the alternative file name helped me verify that the reports were actually being generated.

On 9/8/05, La= rry Kelly < ldk2005@gmail.com> wrote:

What does spreport.sql save the statspack report?= I cannot find it anywhere??
Statspack is installed on my Oracle 8i system.  After creating a few snapshots, I ran spreport from sqlplus*. After it conpleted, a search for the report filename returned nothing. Any help here would be gre= atly appreciated.
Thanks, again.
--
Best Regards,-Larry
"Work, work, work...there is no satisfactory alternative.&= quot;
           =  --- E.Taft Benson

Larry,

I have some good news for you.
Someone did a quick writeup of the tweaks necessary to get Cygwin OpenSSH running on w2k3 server as a service. It was a slam dunk to get working on w2k server - but the default security policy for w2k3 server resulted in a few changes being required for the service to accept connections successfully (Fanfare!).

http://www.hunt-famil= y.net/cygsshpka.html

So get the SA to install Cygwin, fire up the sshd and your favorite ssh cli= ent and login like its a *nix box.

Enjoy.

Paul

 

------=_Part_7202_10167825.1126303257402-- -- http://www.freelists.org/webpage/oracle-l