RE: findtemp.sql

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Tue, 06 Jun 2000 08:56:26 -0300
Message-Id: <10520.107832@fatcity.com>

Thanks Ruth.

I also e-mailed the author, Roger Sanders, and he kindly pointed out to = me
that I am supposed to run the script while logged in as SYS, not as = myself!

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

	-----Original Message-----
	From:	Ruth Gramolini [SMTP:rgramolini_at_tax.state.vt.us]
	Sent:	Tuesday, June 06, 2000 9:42 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Re: findtemp.sql

	Here is the one I use.
	HTH
	Ruth

	b.sid,b.serial#,substr(b.username,1,8)USERNAME,b.process,

=09
substr(c.segment_name,1,8)SEGMENT_NAME,substr(b.osuser,1,7)OS_USER,subst= r(b.

	machine,1,6)M_NAME,
	substr(b.program,1,12)PROGRAM
	from v$access a, v$session b,dba_segments c
	where c.owner=3D a.owner
	and a.sid =3D b.sid
	and b.status =3D 'ACTIVE'
	and c.segment_type =3D'TEMPORARY'


	----- Original Message -----
	To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
	Sent: Monday, June 05, 2000 3:40 PM


	Hi,

	I tried this script at http://www.evdbt.com/library.htm but I keep
getting
	the same error in Oracle7 on NT - is there is a version that would
run
	properly with Oracle on NT?

	It is supposed to show who is using up space in the TEMP tablespace.

	TIA
	Patrice Boivin
	Systems Analyst (Oracle Certified DBA)

	Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
	Technology Services        | Services technologiques
	Informatics Branch         | Direction de l'informatique
	Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

	E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>

	--
	Author: Boivin, Patrice J
	  INET: BoivinP_at_mar.dfo-mpo.gc.ca

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L


	(or the name of mailing list you want to be removed from).  You may

	also send the HELP command for other information (like subscribing).


	--=20
	Author: Ruth Gramolini
	  INET: rgramolini_at_tax.state.vt.us

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L


	(or the name of mailing list you want to be removed from).  You may

Received on Tue Jun 06 2000 - 06:56:26 CDT