Oracle Interview questions for Implementation/Maintenence
Hello list, 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
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 additional virtual CPU. As far as the O/S is concern, it looks like there are _two_ CPUs. What does this mean to your software licensing? Microsoft says that it is one CPU. What does Oracle say? Well, it depends on who you speak to and what day of the week it is. Seriously, you will need to get some confirmation in writing from your account manager the next time you purchase Oracle S/w for Intel's Xeon ta tony _ / |Tony Jambu, Database&Web Consultant /_ _/_ __ / |Wizard Consulting Pty Ltd /(_)/ )(_/ \_/(///(/_)/_( |IOUG's Select Asia-Pacific Tech. Editor \___/ |EMAIL: TJambu @ wizard.cx (REMOVE Spaces from email ) |PHONE: +61-419-TJAMBU(852628) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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 both primary on SAN, standby db files on the itnernal storage of standby machine any thoughts ? TIA Rahul
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 admin. is uncomparable with network admin. in the ISP setting, the network Engineer is almost everything of ISP. So, I think if I change my carrer path to this way , which I can control the system from the application layer(Oracle) and OS layer (Solaris, *nix) I will get myself more value when I move the company. Further suggest I would appreciate. Patrick -Original Message- Sent: Thursday, March 20, 2003 20:24 To: Multiple recipients of list ORACLE-L Pat Not to be impolite, but what makes you think this is the next logical career move for you? Before you become a DBA it is good if you have a lot of other computer experience, such as development or system administration. You really need to understand how large computer systems work and how all the various pieces fit together. One step you can take is to work on Oracle Certification. This will not make you a DBA, when you don't have experience, this work will show your serious intent to learn to a prospective employer. Get a job at a site that uses Oracle, using whatever background you have. If you are a developer, get a job as a developer. If you are a system administrator, get a job as an administrator. Most of us gradually learned more and more about Oracle before getting a DBA job. I was a developer that began supporting Oracle for development activities, gradually learning DBA skills in a non-production environment. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 19, 2003 10:09 PM To: Multiple recipients of list ORACLE-L Anyone please suggest me if non-experience but knowledge DBA cannot get job, how they become experience DBA until they can get job. Thanks Pat. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sangbutsarakum, Patai INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sangbutsarakum, Patai INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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. We had fgac (or rls - row level security - as it was often called on our project) enabled and the execution plan includes the effects of the access control. You could grab a query executed by a different user and ask for an explain plan under your own schema and get a different result. This made tuning difficult since the access control could do all sorts of things to queries, and it is easy to ignore when you don't see it on screen. I guess at the end of the day it's important to remember that the optimisor's job is to choose the best execution path for a given query at a given moment in time. A lot of people get concerned when execution plans change, and whilst this is sometimes with good reason it is also Oracle simply changing to a better approach. If the plan changes and the query takes forever to run, but if the plan changes and performance is still fine then you typically don't have a problem. Regards, Mark. "Kevin Toepke" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> racle.com> cc: Sent by: Subject: RE: Explain Plan vs Actual Execution Plan [EMAIL PROTECTED] 22/03/2003 05:29 Please respond to ORACLE-L Yes, local statistics are the partition specific statitics. Global stats are on the partitioned object as a whole. Global stats are vitally important when you are accessing more than one partition. If you are accessing > 1 partition and you do not have global stats, then the optimizer will use the default statistics. Very bad. Kevin -Original Message- Brad Sent: Friday, March 21, 2003 12:19 PM To: Multiple recipients of list ORACLE-L Please exlain the difference between local and global statistics. Is this statisitics on a partition? Brad Odland -Original Message- Sent: Thursday, March 20, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Brad, you're absolutely correct. Explain plan is what is intended, but isn't what always happens. It probably is most of the time, but not always. I recently had a circumstance in which a long running job (the explain plan of) was telling me it was reading from a big partitioned table and using the index that it should have been using, but a 10046 trace showed reads from a different index and no reads from the index identified by explain plan. A full analyze compute (using dbms_stats) later, this job works fine. I suspect in my case the problem was with statistics. The job was originally set up by the developer to add data each night, then analyze the current partition. The last time global stats were gathered on this table was last October. I suspect that over time with data loads and updates the data distribution, etc. got skewed as compared to the global stats, so the optimizer didn't have enough valid information to make a good choice. This query was reading data from 5 or 6 partitions of a 54 partition table. That's important information because a couple of weeks ago I was reading the "Oracle 8i Designing and Tuning for Performance" document and came across this statement: "Unless the query predicate narrows the query to a single partition, the optimizer uses the global statistics. Because most queries are not likely to be this restrictive, it is most important to have accurate global statistics." Pretty interesting to think about. It's gather stats global and local from now on for me. >
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 name is incorrectly specified SQL> ORA-12162: TNS:service name is incorrectly specifiedSQL>Database "" warm started. Can't find init file for Database "dbserver".Database "dbserver" NOT started. could anybody help me to solve it. Thank you Regards, Pomin
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 Para: Multiple recipients of list ORACLE-L Asunto: Problems installing Developer on XP I am trying to install Developer 6i on a Pentium 4 Xeon The Oracle Universal Intaller has a problem and tries to send error report to Microsfot. I checked Metalink and the workaround was to search for symcjit.dll in the install directories and rename to symcjit.old ... did this. Also the solution was to replace JInitiator 1.1.7 with JInitiator 1.1.8. I checked and when I installed Oracle 9i on this machine the 1.1.8 was installed and I do not have the 1.1.7 under c:\programs\oracle\jre Any other ideas on what to do ??? Thanks - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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 calls to complete. Normally the message is: Sun Mar 16 00:04:06 2003 Shutting down instance (immediate) Sun Mar 16 00:05:11 2003 ALTER DATABASE CLOSE NORMAL Our immediate suspicion is that someone has implemented an application this last week that connects to the database in a more active manner than we've experienced before. Does anyone have any idea what I should look for (aside from asking each developer: "What did you do last week?". Since 3 systems have been affected, we are wondering if a process using a database link could cause a problem like this. Any ideas appreciated. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] Dennis, check out if you had any active oracle jobs at the moment of shutdown. Sometimes they may be the cause of hang. -- Kind regards, Edward Shevtsov -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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 ORACLE-L 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 commit/rollback prior to shutdown 4. Look for which processes are still alive during the shutdown, use lsof to trace them back to the client app OR select a list of sessions and their respective processes prior to shutdown 5. Forget about shutdown immediate, use shutdown abort. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sun, 23 Mar 2003, 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 calls to complete. > > Normally the message is: > > Sun Mar 16 00:04:06 2003 > Shutting down instance (immediate) > Sun Mar 16 00:05:11 2003 > ALTER DATABASE CLOSE NORMAL > > Our immediate suspicion is that someone has implemented an application this > last week that connects to the database in a more active manner than we've > experienced before. Does anyone have any idea what I should look for (aside > from asking each developer: "What did you do last week?". Since 3 systems > have been affected, we are wondering if a process using a database link > could cause a problem like this. Any ideas appreciated. > > > > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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 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 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 > commit/rollback prior to > shutdown > > 4. Look for which processes are still alive during > the shutdown, use > lsof to trace them back to the client app OR select > a list of sessions > and their respective processes prior to shutdown > > 5. Forget about shutdown immediate, use shutdown > abort. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Sun, 23 Mar 2003, 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 calls to complete. > > > > Normally the message is: > > > > Sun Mar 16 00:04:06 2003 > > Shutting down instance (immediate) > > Sun Mar 16 00:05:11 2003 > > ALTER DATABASE CLOSE NORMAL > > > > Our immediate suspicion is that someone has > implemented an application this > > last week that connects to the database in a more > active manner than we've > > experienced before. Does anyone have any idea what > I should look for (aside > > from asking each developer: "What did you do last > week?". Since 3 systems > > have been affected, we are wondering if a process > using a database link > > could cause a problem like this. Any ideas > appreciated. > > > > > > > > Dennis Williams > > DBA, 40%OCP, 100% DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > San Diego, California-- Mailing list and > web hosting services > > > - > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (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). > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Jeremiah Wilton > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (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). > = __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Toepke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, in
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 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 > commit/rollback prior to > shutdown > > 4. Look for which processes are still alive during > the shutdown, use > lsof to trace them back to the client app OR select > a list of sessions > and their respective processes prior to shutdown > > 5. Forget about shutdown immediate, use shutdown > abort. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Sun, 23 Mar 2003, 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 calls to complete. > > > > Normally the message is: > > > > Sun Mar 16 00:04:06 2003 > > Shutting down instance (immediate) > > Sun Mar 16 00:05:11 2003 > > ALTER DATABASE CLOSE NORMAL > > > > Our immediate suspicion is that someone has > implemented an application this > > last week that connects to the database in a more > active manner than we've > > experienced before. Does anyone have any idea what > I should look for (aside > > from asking each developer: "What did you do last > week?". Since 3 systems > > have been affected, we are wondering if a process > using a database link > > could cause a problem like this. Any ideas > appreciated. > > > > > > > > Dennis Williams > > DBA, 40%OCP, 100% DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > San Diego, California-- Mailing list and > web hosting services > > > - > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (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). > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Jeremiah Wilton > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (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). > = __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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 commit/rollback prior to shutdown 4. Look for which processes are still alive during the shutdown, use lsof to trace them back to the client app OR select a list of sessions and their respective processes prior to shutdown 5. Forget about shutdown immediate, use shutdown abort. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sun, 23 Mar 2003, 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 calls to complete. > > Normally the message is: > > Sun Mar 16 00:04:06 2003 > Shutting down instance (immediate) > Sun Mar 16 00:05:11 2003 > ALTER DATABASE CLOSE NORMAL > > Our immediate suspicion is that someone has implemented an application this > last week that connects to the database in a more active manner than we've > experienced before. Does anyone have any idea what I should look for (aside > from asking each developer: "What did you do last week?". Since 3 systems > have been affected, we are wondering if a process using a database link > could cause a problem like this. Any ideas appreciated. > > > > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Shutdown Immediate hangs
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 calls to complete. Normally the message is: Sun Mar 16 00:04:06 2003 Shutting down instance (immediate) Sun Mar 16 00:05:11 2003 ALTER DATABASE CLOSE NORMAL Our immediate suspicion is that someone has implemented an application this last week that connects to the database in a more active manner than we've experienced before. Does anyone have any idea what I should look for (aside from asking each developer: "What did you do last week?". Since 3 systems have been affected, we are wondering if a process using a database link could cause a problem like this. Any ideas appreciated. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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 longer and meanwhile my available space window kept shrinking. I wrote scripts to help, but there are always decisions involved. Since switching to autoextend, we've experienced only a couple of incidents where something ran the disk out of space, and these turned out to be easier to deal with than the out of tablespace calls from the users. We use big RAID sets, so it is a matter of checking a couple of RAID sets vs. checking hundreds of tablespaces. There is also the advantage of less wasted space. If you leave enough free space in each tablespace to accommodate the largest next extent, that adds up. With LMT and autoextend, there is zero free space on most of these tablespaces. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, March 22, 2003 5:49 PM To: Multiple recipients of list ORACLE-L AUTOEXTEND can be abused for sure, but it can also be a big time saver. Say you want to load 100 gigabytes of data, and you have 5 disks to spread it out on. You opt for 5 files of 4 gig each on each disk. That gives you 20 files to create in your tablespace. Creating 100 gig of datafiles takes awhile. If you start each file out as 500m with a next size of 500m and a max of 4g, you can defer the time spent creating the files to load time, rather than waiting around for 100g of files to be created before you start loading. Still takes the same amount of time, but you get to go home earlier. :) Jared On Friday 21 March 2003 18:23, Jacques Kilchoer wrote: > Well, my first suggestion would be to buy a software package from a > reputable software company that lets you predict object growth and an > estimate of when your tablespace will be full. Contact me for more details. > > :) > > But seriously, you can write a report that shows the number of extents and > the amount of freespace in each tablespace, and review the report > periodically (say once a week). Which is what I did back in my production > DBA days. I imagine you could have a database procedure that checks the > free space in a tablespace and sends you an e-mail, or even pages you if > you have e-mail forwarded to a pager. > Setting the datafiles to autoextend just pushes the problem back to the OS > level - how do you know when your disks will be full? > > > -Original Message- > > From: Ryan [mailto:[EMAIL PROTECTED] > > > > so for normal business you should not use autoextend? You > > should monitor it > > yourself? What are some tips for monitoring the database to > > see if you need > > to extend your tablespace manually? Do you use DBMS_ALERT and > > read the v$ > > views and then broadcast a message if you need to extend a tablespace? Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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 hasn't changed, but you've just looked more closely since the upgrade? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, March 23, 2003 2:09 AM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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 quite tell from your question). Niall > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Tom Schruefer > Sent: 14 March 2003 22:59 > To: Multiple recipients of list ORACLE-L > Subject: Server Recommendations > > > I have a question, I have to make a decision on the purchase > of a new web server for a multiteir Oracle based system. So > here are my two remaining options, all other things remaining > equal, on a system which has 100% dynamically generated web pages. > > > 1. A server with one 2ghz CPU. > > or > > 2. A server with two 1ghz CPU. > > > Which will provide more power? > > > A little more food for though. Would a server with a 1ghz > CPU and 512mb RAM be adequate for a Oracle backed web site, > which the pages are all 100% dynamic? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tom Schruefer > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).