processes, free mem

2001-08-26 Thread Tatireddy, Shrinivas (MED, Keane)
Hi lists where can i find the 1)maximum number of processes that have connected at one time to the database. 2)the database free memory...lowest available since startup. If anybody have ideas about the above, kly reply. thanx in advance srinivas -- Please see the official ORACLE-L FAQ:

FYI - another good Oracle list

2001-08-26 Thread Andrey Bronfin
Write to [EMAIL PROTECTED] and, in the text of your message (not the subject line), write: SUBSCRIBE ORACLE-L DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED]

RE: aix tools

2001-08-26 Thread Nirmal Kumar Muthu Kumaran
thank you -Original Message- From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]] Sent: Saturday, August 25, 2001 10:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: aix tools It means Tools for AIX (IBM's UNIX version). Not related to any of the Oracle Tools.

RE: FYI - another good Oracle list

2001-08-26 Thread Tatireddy, Shrinivas (MED, Keane)
earlier there was another list [EMAIL PROTECTED] -Original Message- Sent: Sunday, August 26, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Write to [EMAIL PROTECTED] and, in the text of your message (not the subject line), write: SUBSCRIBE ORACLE-L DBAndrey * 03-9254520 *

one file being relinked in wrong ORACLE_HOME

2001-08-26 Thread Doug C
We have 2 Oracle Homes, one of which was upgraded to 8.1.7.1 on Jul 25th. The other Oracle Home is just vanilla 8.1.7. We did a relink all on the 8.1.7 last night which completed successfully. There are no problems being reported by anybody. We checked the entire environment before the relink and

What is the fastest way to drop tablespace ? - urgent please

2001-08-26 Thread Andrey Bronfin
Dear gurus ! What is the fastest way to drop tablespace , please ? I issued drop tablespace including contents command and it runs for some 5 hours already . The tablespace has 6 datafiles totalling ~ 13GB space. While trying to look why does it take too long , i discovered that there is a

RE: OT - File System to Disk Mapping

2001-08-26 Thread Kimberly Smith
HA, the SA's here commonly stop by my desk to see if I have anything for them to do. They feel that they are my minion. Have them well trained. Just took one of them into the DBA team actually. Really though, it makes your job so much easier to have a good relationship with your SA's cause

Re: OPS on LINUX

2001-08-26 Thread Oliver Artelt
Hi, I think it works only with 817 oli [EMAIL PROTECTED] wrote: Hi, 1) I have set up a cluster of INTEL machines on INTEL PIII using LINUX Redhat 6.2 . 2) I have installed Oracle 8.1.6 on LINUX redhat 6.2 . The database is on raw devices. 3) When I try to install OPS option , I

RE: [Fwd: an OPS question - tnsnames]

2001-08-26 Thread Andrey Bronfin
Hi Paul ! Thanks a lot for your reply . This is a production DB and can not be upgraded right now. DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, August 23, 2001 8:06 PM To: Multiple recipients of list ORACLE-L Hi. I would highly

Re: What is the fastest way to drop tablespace ? - urgent please

2001-08-26 Thread Deepak Thapliyal
since u wanna drop this anyways .. why not simply offline immediate the tblspc and then drop it? deepak --- Andrey Bronfin [EMAIL PROTECTED] wrote: Dear gurus ! What is the fastest way to drop tablespace , please ? I issued drop tablespace including contents command and it runs for

RE: OT - File System to Disk Mapping

2001-08-26 Thread Rachel Carmichael
I ply my SAs with chocolate and candy. Works like a charm :) From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT - File System to Disk Mapping Date: Sun, 26 Aug 2001 09:50:19 -0800 HA, the SA's here

Controlling transactions when JDBC connection closed?

2001-08-26 Thread Arn Klammer
We're reusing a set of Java classes from an old application in a new application. The old application used a PC database; the new one is using Oracle. It appears that the PC database implicitly rolled back transactions if a connection to the database was closed. However, with Oracle, is

Re: How to interpret Alert.Log Trace files...

2001-08-26 Thread C.S.Venkata Subramanian
You must log a TAR with Oracle support. Pls refer to DocID 146580.1 in metalink. This doc tells you what is Ora-00600 errors and what to do when it occurs. HTH Venkat -- On Fri, 24 Aug 2001 10:52:36 Denmark Weatherburne wrote: Hi DBA's I'm currently monitoring the Oracle SIDALRT.LOG and