V$SESSION Details Changed after upgrade Database to 8.1.7.4

I have just upgraded my database at the Weekend and I have noticed that PROGRAM field in V$SESSION no longer displays the program all the time i.e. SQLPLUS and Microsoft Access in particular. I use this fields in capturing illegal log ons etc.. Anybody have an idea before I try Support.

RE: Server Recommendations

I'd agree with those who have said 'it depends', because , well it depends - on the load, the number of concurrent requests, etc etc. In general though I would suggest that the dual proc option will give you more stable, reliable performance (wether this is the web server or the db server I can't

RE: V$SESSION Details Changed after upgrade Database to 8.1.7.4

Rabbit I haven't heard this reported and I did a quick Google search and couldn't find a mention. You might check Metalink. I think that Oracle Support will probably say that what gets posted to the PROGRAM field is the responsibility of the client program. Are you certain that the behavior

RE: RE: Locally Managed Tablespaces

Jared I'm with you on this one. I switched our production tablespaces (except system) to autoextend several years ago and couldn't be happier. I used to scrupulously check the free space in tablespaces, but over the years, being a solo DBA, as more instances were added, this took longer and

Re: Shutdown Immediate hangs

1. Turn on PMON and SMON tracing for your instance and look at their trace files during shutdown 2. Look for segments of type TEMPORARY with many extents that need deallocating prior to shutdown - this will be done lazily during shutdwn immediate 3. Look for large transactions that need

Re: Shutdown Immediate hangs

Dennis, Just to add to Jeremiah's list: I have also seen the aforementioned symptom, when there were SQL*Plus sessions that are out there on the login screen with no takers. Cheers, Gaja --- Jeremiah Wilton [EMAIL PROTECTED] wrote: 1. Turn on PMON and SMON tracing for your instance and

RE: Shutdown Immediate hangs

And, if you have any job that is waiting on a DBMS_PIPE. -Original Message- Krishna Vaidyanatha Sent: Sunday, March 23, 2003 3:09 PM To: Multiple recipients of list ORACLE-L Dennis, Just to add to Jeremiah's list: I have also seen the aforementioned symptom, when there were SQL*Plus

RE: Shutdown Immediate hangs

Jeremiah, Gaja Thanks for the tips. My theory is that since 3 production instances were affected, it may be easy to find. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, March 23, 2003 11:54 AM To: Multiple recipients of list

Re: Shutdown Immediate hangs

DENNIS WILLIAMS wrote: We have been running Oracle 8.1.6 unchanged for several years. Within the past 3 days, our cold backup scripts have had a shutdown immediate hang. In the alert log the message is: Shutting down instance (immediate) Sun Mar 23 00:09:10 2003 SHUTDOWN: waiting for active

RE: Problems installing Developer on XP

Had a similar problem myself, Try adding the -nojit option for JRE in the installation script. Hope this helps. Nelson Flores Project Manager INTEC Fono : 2428374 -Mensaje original- De: Babette Turner-Underwood [mailto:[EMAIL PROTECTED] Enviado el: Sábado, 22 de Marzo de 2003 18:14

error start oracle 9.2.0 on redhat 7.3

hi all, I have a problem when start oracle 9.2.0 on redhat 7.3 the error like this : [EMAIL PROTECTED] oracle]$ dbstart SQL*Plus: Release 9.2.0.1.0 - Production on Sat Mar 22 16:32:45 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL ERROR:ORA-12162: TNS:service

RE: Explain Plan vs Actual Execution Plan

I have another suggestion (or two) as to why the execution plan may have changed: * Bind variables - these often cause grief. Of course, choosing a different execution plan may be correct behaviour based on what the histograms say. * FGAC (Fine Grained Access Control) - this caught me out once.

RE: New DBA.

Thanks, for every reply. Currently, I'm Solaris Administrator with SCSA, SCNA. I was impressed the Oracle since I was in university, Currently I'm system administrator in the ISP I'm experienced the Internet application ex. DNS, LDAP, Sendmail, etc , but for me, you know, the value of system

standby on SAN ? or use internal storage

list, i'm a bit confused on whether to put the standby DB on the SAN storage or use the internal storage of the standby host !!! config a two instances on primary server, data-files on SAN, hot standby db files on SAN too. standby instances for both primary on another machine config b

Re: Foreign Key Not Found ??

Hi Salahidin, iam using versionoracle8.1.6 and forms 6.0.12.3 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walid Alkaakati INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--

Oracle Licences Req on Intel Xeon CPU

Hi all For those that are running or intending on running Oracle on Intel's Xeon CPU, the following information may be of interest to you. The Xeon CPU has a feature called Hyper Threading with double the number of registers. This feature when turned will present to the Operating Systems an

Oracle Interview questions for Implementation/Maintenence

Hellolist, I will be attending interview on oracle..but the position is for Maintenance/Implementation of Software. Could any one of you provide me with set of questions related to maintenance/Implementation issues in oracle ? Regards, Santosh