RE:connecting session to sqlarea to find the sql_text
Welcome mate , Same question I posted a month back First get the select osuser,sid from v$session; then use sid in foll. query SELECT sql_text FROM v$sqlarea WHERE (address, hash_value) IN (SELECT sql_address, sql_hash_value FROM v$session WHERE sid = sid_number) --- sam d [EMAIL PROTECTED] wrote: Date: Sun, 9 Jun 2002 20:47:31 -0700 (PDT) From: sam d [EMAIL PROTECTED] Subject: RE: Can we find SQL user To: [EMAIL PROTECTED] CC: Richard Huntley [EMAIL PROTECTED] Really appreciate it Richard, This is what I was missing wherea.sql_address=b.address(+) Thx a Lot list, Sam --- Richard Huntley [EMAIL PROTECTED] wrote: Sam, had problems sending this to the list, but thought this might help... here is what you need...enter the specific username then look at the MACHINE field: column username format a12; column osuser format a10; column machine format a20; select username,osuser,server,machine,sid,serial#,status,program, TO_CHAR(logon_time,'DD-MON- HH24:MI:SS')=20 from v$session where username =3D 'username' / -Original Message- From: sam d [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 1:18 AM To: Multiple recipients of list ORACLE-L Subject: Can we find SQL user Hi List, Suppose I have m1,m2,m3 machines, all the users sitting on these machines are using oracle 'user1' to connect to the server. As all the people are logged in with the same user name ,Can we find which user(or machine) has issued which SQL statement. Thanks Sam __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d INET: [EMAIL PROTECTED] 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: [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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d INET: [EMAIL PROTECTED] 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: [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. Urgent - Got Stuck with trigger
Try to disable the trigger first then drop it. The error is expected because the SQL in trigger will return more than one row. HTH Sanjay -Original Message- Sent: 22 July, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Hi List, My friend has foll.(Big)problem. He'was testing the following trigger n now stuck. Do not execute this trigger on ur side. CREATE OR REPLACE TRIGGER tpp before alter or create or drop on database declare uname varchar2(20); begin select osuser into uname from v$session; if uname != 'Sachin' then raise_application_error(-20002,'not allowed); end if; end; Now he can't modify/drop this trigger, He gets the follow error: ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 4 - One thing I suggested is to make sure that there is only one session on server. Is that possible ? What are the other solutions ?? (Do not execute this trigger on ur side. if u don't know the solution) Thx Regards, Sam __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d INET: [EMAIL PROTECTED] 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: [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.com -- Author: G Sanjay INET: [EMAIL PROTECTED] 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: [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. Urgent - Got Stuck with trigger
Just realized that alter table disable trigger will not work too.. Even if there is only one session on server it will return more than one row because of BG processes. Sanjay -Original Message- Sent: 22 July, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Hi List, My friend has foll.(Big)problem. He'was testing the following trigger n now stuck. Do not execute this trigger on ur side. CREATE OR REPLACE TRIGGER tpp before alter or create or drop on database declare uname varchar2(20); begin select osuser into uname from v$session; if uname != 'Sachin' then raise_application_error(-20002,'not allowed); end if; end; Now he can't modify/drop this trigger, He gets the follow error: ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 4 - One thing I suggested is to make sure that there is only one session on server. Is that possible ? What are the other solutions ?? (Do not execute this trigger on ur side. if u don't know the solution) Thx Regards, Sam __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d INET: [EMAIL PROTECTED] 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: [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.com -- Author: G Sanjay INET: [EMAIL PROTECTED] 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: [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).
download or upload.
Title: download or upload. Some terminology confusion. When you load a text file into the database, you call it download or upload? When you create a text file from your database you call it download or upload? rgds amar http://amzone.netfirms.com
Whistler Server (Windows .NET 2003), Longhorn, Foghorn,
The next server after Windows 2000 is going to be called something like: Windows .NET 2003 Product timeline roadmap-wise, it roughly approximates the server version of XP, although they appear to be quite a bit different (see below web sites). Excerpt from the email Bill Gates sent me about Trustworthy Computing last week: ... | - In addition to providing customers with tools and | resources to help them maximize the security of | Windows 2000 Server environments, we are committed | to shipping Windows .NET Server 2003 as secure by | default. We believe it's critical to provide | customers with a foundation that has been configured | to maximize security right out of the box, while | continuing to provide customers with a rich set of | integrated features and capabilities. ... For some of the best crystal ball gazing about future versions of windows: Whistler Server (originally Windows 2002 Server): http://www.winsupersite.com/faq/whistler_server.asp excerpt: ... | Windows .NET Server has also been tweaked for better | performance and reliability: Microsoft says that the | product performs up to 50 percent faster on the same | hardware as equivalent Windows 2000 Server products ... - http://www.winsupersite.com/reviews/winnetserver_beta3.asp - - Desktop stuff: http://www.winsupersite.com/faq/longhorn.asp - http://www.winsupersite.com/showcase/longhorn_preview.asp Here is the basic roadmap for Desktop windows: august/sept 2002: XP SP1 Sometime in 2003, probably for holiday shopping: XP Second Edition (aka XP Super Service Pack, SP2), code named Longhorn. Blackcomb is the Windows desktop OS after XP. XP was code named Whistler. Longhorn is a bar/saloon on the road between Blackcomb and Whistler. Gartner Report containing Windows roadmap: | This is the html version of the file: http://www.lakehurst.navy.mil/imd-lakehurst/documents/dynamic/technology/Microsofts_Detours_To_Longhorn.pdf | G o o g l e automatically | generates html versions of documents as we crawl the web. To | link to or bookmark this page, use the following url: http://www.google.com/search?q=cache:95l0m9ul1scC:www.lakehurst.navy.mi l/imd-lakehurst/documents/dynamic/technology/Microsofts_Detours_To_Long hor n.pdf+whistler+blackcomb+longhornhl=enie=UTF-8 | Google is not affiliated with the authors of this page nor | responsible for its content. These search terms have been | highlighted: whistler blackcomb longhorn - --- Page 1 GartnerEntire contents © 2001 Gartner, Inc. All rights reserved. Reproduction of this publication in any form without prior written permission is forbidden. The information contained herein has been obtained from sources believed to be reliable. Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Gartner shall have no liability for errors, omissions or inadequacies in the information contained herein or for interpretations thereof. The reader assumes sole responsibility for the selection of these materials to achieve its intended results. The opinions expressed herein are subject to change without notice. Technology, T-14-2723M. Silver Research Note16 Core Topic Hardware Platforms: Client Platforms Key Issue How will desktop and mobile clientplatforms evolve during the next five years? October 2001 Microsoft Detours to `Longhorn' on the Way to `Blackcomb' Microsoft's road map for future releases of Windows needsto be carefully understood and kept in mind by enterprises developing their OS upgrade strategies. Microsoft's original road map for Windows anticipated two releases after Windows 2000 (Whistler and Blackcomb,named after mountains in Canada). Now, in the middle of the two, is a new Windows project - Longhorn. Microsoft intended to alternate major and minor releases of its newest operating system (OS), delivering them about 18 months apart. Whistler, now known as Windows XP, was supposed to be the minor release following Windows 2000 and Blackcomb themajor release after that. Gartner thinks of Windows 2000 Professional as Windows NT Workstation v.5.0, Windows XP as Windows NT Workstation v.5.1 and Blackcomb as Windows NT Workstation v.6.0. Microsoft's Grand Visions In the mid-1990s, Microsoft had a grand vision, known as Cairo, that was intended to form Windows NT v.5.0. Cairo gradually got bigger and bigger, until it was shelved in favor of getting a competitive product, Windows 2000, out of the door. Windows 2000 was needed to deal with the threat from Java and thin-client systems. However, internally, it seems that Blackcomb isMicrosoft's new grand vision. Cairo was too grand a vision to accomplish in the time allotted toit - i.e., the two years after the launch of NT v.4.0 in 1996. Because of competitive threats, the project slipped by two years and Microsoft did not ship Windows 2000 until
Re: V. Urgent - Got Stuck with trigger
sam d£¬ hei, it is easy, logon as osuser and drop the trigger, it is ok. I tested it on my 920 on linux: SQL CREATE OR REPLACE TRIGGER tpp 2before alter or create or drop on database 3 declare 4 uname varchar2(20); 5 begin 6 select username into uname from v$session; 7if uname != 'SYSTEM' then 8raise_application_error(-20002,'notallowed'); 9 end if; 10 end; 11 / Trigger created. SQL conn system/manager Connected. SQL drop trigger tpp; Trigger dropped. Connect as sysdba also works: SQL create table t as select * from user_objects; create table t as select * from user_objects * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 4 SQL conn / as sysdba Connected. SQL drop trigger system.tpp; Trigger dropped. also you can try: add _system_trigger_enabled = false in initsid.ora and then bounce the database and drop it, remove it from the initfile and restart , it will be ok. 2002-07-21 22:38:00 You wrote: Hi List, My friend has foll.(Big)problem. He'was testing the following trigger n now stuck. Do not execute this trigger on ur side. CREATE OR REPLACE TRIGGER tpp before alter or create or drop on database declare uname varchar2(20); begin select osuser into uname from v$session; if uname != 'Sachin' then raise_application_error(-20002,'not allowed); end if; end; Now he can't modify/drop this trigger, He gets the follow error: ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 4 - One thing I suggested is to make sure that there is only one session on server. Is that possible ? What are the other solutions ?? (Do not execute this trigger on ur side. if u don't know the solution) Thx Regards, Sam __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d INET: [EMAIL PROTECTED] 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: [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). Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chaos INET: [EMAIL PROTECTED] 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: [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: download or upload.
I would say: When you load a text file into the database, you call it download or upload? = upload/insertion When you create a text file from your database you call it download or upload? = download/extraction Cheers, Kev. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] 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: [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).
Solution: SQLLOader + nls_date_language
Hi, I asked recently how to provide nls_date_language within sqlloader config file. [EMAIL PROTECTED] provided the solution: specify for the date column: ... date_col to_date(rtrim('Jan 15 1989 11:00:000AM',':000AM'),'Mon dd hh:mi:ss','NLS_DATE_LANGUAGE = American'), ... Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] 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: [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: security bug - join syntax
re: Bug 2121935 ---metalink excerpts--- Doc ID: 190077.1 List of Bugs fixed in Oracle9i Release 2 base release (9.2.0.1) This is a listing of the main bugs fixed in the Oracle9i Release 2 base release. The bugs are listed in categories related to the product area and/or symptom of the bug. A bug may be listed in more than one section. * indicates that an alert exists for this bug. + indicates a particularly notable bug. OERI is used as a short notation for ORA-600. Bug Fixes by Category ... Security ... 2121935* User Privileges Vulnerability in Oracle9i Database Server ... Bug:2121935 * Fixed: 9201 Security This problem is introduced in Oracle9i (9.0.1). There is a user privileges vulnerability in Oracle9i Database Server.. See Note:185074.1 ... --- Doc ID: Note:185074.1 Subject: ALERT: User Privileges Vulnerability in Oracle9i Database Server Type: ALERT Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 18-APR-2002 Last Revision Date: 25-APR-2002 Oracle Security Alert #33 Dated: 17 April 2002 User Privileges Vulnerability in Oracle9i Database Server Description ~~~ A potential security vulnerability has been discovered in Oracle9i database server. It is possible to create a user defined in the Oracle9i database server with limited privileges who can potentially access privileged data using SQL syntax for outer joins. As such, a knowledgeable and malicious user can gain unauthorized access to data in Oracle9i database server. None of the Oracle8i (Release 8.1.x), Oracle8 (Release 8.0.x) or Oracle7 database server release is affected by this vulnerability. Products affected ~ Oracle9i Database, Release 9.0.1.x, only Platforms affected ~~ All Workarounds ~~~ There are no workarounds to protect against this potential vulnerability. Patch Information ~ Oracle has fixed the potential vulnerability identified above in the upcoming Oracle Database server release, Oracle9i, Release 2. Patches with the base bug number, 2121935 are being made available only for supported releases of Oracle9i, Releases 9.0.1.x, database server on all supported platforms. For Windows NT and 2000, the patch is included in 2338791 for 9.0.1.3. Download currently available patches for your platform from Oracle Support web site, iSupport, http://metalink.oracle.com. Activate the Patches button to get to the patches Web page. Enter the base bug fix number indicated above and activate the Submit button. Please check MetaLink or, Oracle Support Services periodically for patch availability if the patch for your platform is not yet available. Oracle strongly recommends that you comprehensively test the stability of your system upon application of any patch prior to deleting any of the original file(s) that are replaced by the patch. Change Record ~ Windows NT and 2000 bug information was addded to the Patch Information section of this alert on 25-Apr-02. . - --- Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. On 19 Jul 2002 at 10:58, Deshpande, Kirti wrote: Date sent: Fri, 19 Jul 2002 10:58:26 -0800 [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L ORACLE- [EMAIL PROTECTED] Send reply to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Is this still a problem in 9iR2? I do not have it installed yet :( - Kirti -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Subject:Re: security bug - join syntax Thanks Linda. Usenet seems to be a little behind the curve though. Jonathan Lewis discovered this and posted on the list ( you saw it here first! ) over a month ago. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/19/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: security bug - join syntax This just in from comp.databases.oracle.server. See metalink bug 2121935. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of
Badge of Oracle8i OCP
I get an Oracle8i OCP, but I don't receive a badge. Is it right? Thank you
RE: Badge of Oracle8i OCP
Badges, badges,,, we don't need no stinkin badges. -Original Message-From: Edouard Dormidontov [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 6:38 AMTo: Multiple recipients of list ORACLE-LSubject: Badge of Oracle8i OCP I get an Oracle8i OCP, but I don't receive a badge. Is it right? Thank you
Re: DB copying : Attack of the Clones!
The good thing with using rman online backups is no down time for production. I clone a 50 gig database in about an hour and a half. I am getting the cites ready as I write this. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 19, 2002 4:34 PM Currently it is taking about 3-4 hours via cold backups. All I could get from the Damagers in the conf call yesterday was that current time is not acceptable. They are doing this over the week-end for 5 of the databases in a staggered fashion (1-2 hour delay), but with 9 more databases (and rather large than these 5), there aren't enough hours in the week-end to support this as well as routine batch processing. Today, I found out that IT Damagers want to present all possible solutions and the COSTS to the User Dept Damagers who will pay for the solution. Will expensive solution force them to continue current method or use hot backup (or RMAN backup)? I am hoping it will. In the long run, they will have to consider subsets of data, as the databases will most likely double in sizes within a couple of years (since we do not like to purge anything). Regards, - Kirti -Original Message- From: Gesler, Rich [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 2:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: DB copying : Attack of the Clones! What is an acceptable time frame. I figure 100G to be around 3 hrs. Is that not an acceptable service level? Also, what will the frequecy of the refreshes be? 14 databases all at once would be overwhelming but could a staggered refresh schedule be agreed upon? (monthly?) I have found that there is a fine line between keeping data fresh and overlaying development projects requires good communication and published service levels. Part of the negotiation should be that ability to do a clone during working hours if possible. At one point we (staff DBA's) got stuck doing off-hour refreshes to keep a pool of developers (hourly contract) from sitting on there hands. Rich -Original Message- From: Deshpande, Kirti [ mailto:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: DB copying : Attack of the Clones! Rich, I was informed that required disks/filesystems for the clone databases is not a problem. Hot backup is being suggested but the issue is to reduce 'cloning' time. I think we also have the out-of-band network connectivity between these servers. Thanks, - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [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.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] 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: [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).
Why Multiple Parses in Trace ?
Qs Why is Parse = 2 in the following Query ? Solaris 8 Oracle 8.1.7 SGA = 60 MB shared_pool_size = 30 MB select mesg, lchg_user_id, TO_CHAR(lchg_time,'DD-MM- HH24:MI:SS'), rcre_user_id, TO_CHAR(rcre_time,'DD-MM- HH24:MI:SS'), tran_id, TO_CHAR(tran_date,'DD-MM- HH24:MI:SS'), NVL(ts_cnt,0), sol_id, contra_acid, tran_amt||'!'||tran_crncy_code, TO_CHAR(value_date,'DD-MM- HH24:MI:SS'), tran_crncy_code, central_or_local_code, req_advc_ind, sys_gen_flg, rowid FROM TBA_REF_TRN_TBL WHERE cmd = :1 AND cust_or_card_id = :2 AND system_date_time = TO_DATE( :3 ,'DD-MM- HH24:MI:SS') AND dcc_id = :4 AND sno = :5 call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse2 0.06 0.07 1 0 1 0 Execute 2 0.00 0.00 0 0 0 0 Fetch2 0.00 0.02 3 6 0 0 --- -- -- -- -- -- -- total6 0.06 0.09 4 6 1 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 40 (TBAGEN) Rows Row Source Operation --- --- 0 TABLE ACCESS BY INDEX ROWID REF_TRN_TBL 1 INDEX UNIQUE SCAN (object id 6561) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS (BY INDEX ROWID) OF 'REF_TRN_TBL' 1INDEX (UNIQUE SCAN) OF 'IDX_REF_TRN_TBL' (UNIQUE) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] 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: [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: Badge of Oracle8i OCP
Title: Message lol /me hands the new ocp person a toffee ;-) -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: 22 July 2002 14:48To: Multiple recipients of list ORACLE-LSubject: RE: Badge of Oracle8i OCP Badges, badges,,, we don't need no stinkin badges. -Original Message-From: Edouard Dormidontov [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 6:38 AMTo: Multiple recipients of list ORACLE-LSubject: Badge of Oracle8i OCP I get an Oracle8i OCP, but I don't receive a badge. Is it right? Thank you
Row Lock Release Without Rollback Commit ?
ROW Locked using SELECT FOR UPDATE Done Qs Is there any Other Possible Means of Releasing the Lock on the Row Without using COMMIT ROLLBACK Commands ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] 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: [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: connecting session to sqlarea to find the sql_text
Title: RE: connecting session to sqlarea to find the sql_text Thanks! rgds amar http://amzone.netfirms.com -Original Message- From: sam d [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 10:04 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE:connecting session to sqlarea to find the sql_text Welcome mate , Same question I posted a month back First get the select osuser,sid from v$session; then use sid in foll. query SELECT sql_text FROM v$sqlarea WHERE (address, hash_value) IN (SELECT sql_address, sql_hash_value FROM v$session WHERE sid = sid_number) --- sam d [EMAIL PROTECTED] wrote: Date: Sun, 9 Jun 2002 20:47:31 -0700 (PDT) From: sam d [EMAIL PROTECTED] Subject: RE: Can we find SQL user To: [EMAIL PROTECTED] CC: Richard Huntley [EMAIL PROTECTED] Really appreciate it Richard, This is what I was missing where a.sql_address =b.address(+) Thx a Lot list, Sam --- Richard Huntley [EMAIL PROTECTED] wrote: Sam, had problems sending this to the list, but thought this might help... here is what you need...enter the specific username then look at the MACHINE field: column username format a12; column osuser format a10; column machine format a20; select username,osuser,server,machine,sid,serial#,status,program, TO_CHAR(logon_time,'DD-MON- HH24:MI:SS')=20 from v$session where username =3D 'username' / -Original Message- From: sam d [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 1:18 AM To: Multiple recipients of list ORACLE-L Subject: Can we find SQL user Hi List, Suppose I have m1,m2,m3 machines, all the users sitting on these machines are using oracle 'user1' to connect to the server. As all the people are logged in with the same user name ,Can we find which user(or machine) has issued which SQL statement. Thanks Sam __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d INET: [EMAIL PROTECTED] 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: [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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com
RE: download or upload.
Store/retrieve -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/22/02 3:53 AM Some terminology confusion. When you load a text file into the database, you call it download or upload? When you create a text file from your database you call it download or upload? rgds amar http://amzone.netfirms.com http://amzone.netfirms.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] 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: [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: Badge of Oracle8i OCP
Title: Message OCP Success Kit After successfully completing all exams in the OCP Track, you will receive an OCP Success Kit which includes: * Letter of Congratulations * Oracle Certified Professional Certificate * OCP ID Card * Oracle Technology Network Membership * Exclusive access to OCP Online Forum * Subscription to Oracle Magazine http://otn.oracle.com/training/certification/introduction_ocpds.html How to get assistance on issues with receiving your OCA, OCP, or OCM credential with Oracle Corporation http://www.oracle.com/education/certification/faq/index.html?faq10a.html -Original Message-From: Edouard Dormidontov [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 7:38 AMTo: Multiple recipients of list ORACLE-LSubject: Badge of Oracle8i OCP I get an Oracle8i OCP, but I don't receive a badge. Is it right? Thank you
RE: download or upload.
Amar - From the dictionary: upload - to transfer data or programs usually from a peripheral computer to a central, often remote computer. In your question of loading a text file into a database, if the text file is already on the Oracle server, I wouldn't refer to that as an upload or download. I would refer to it as load. In the case of producing a text file from the database on the Oracle server, I would refer to that as dump. However, if you meant that you are loading the data from a client system, then I would refer to that as upload. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 2:53 AM To: Multiple recipients of list ORACLE-L Some terminology confusion. When you load a text file into the database, you call it download or upload? When you create a text file from your database you call it download or upload? rgds amar http://amzone.netfirms.com http://amzone.netfirms.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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: Badge of Oracle8i OCP
Edouard, You will probably receive a certificate in the mail. regards, Pat. -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 9:48 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Badge of Oracle8i OCP Badges, badges,,, we don't need no stinkin badges. -Original Message-From: Edouard Dormidontov [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 6:38 AMTo: Multiple recipients of list ORACLE-LSubject: Badge of Oracle8i OCP I get an Oracle8i OCP, but I don't receive a badge. Is it right? Thank you
RE: Badge of Oracle8i OCP
Title: Message I got the badge for my 7.3 and 8 certifications. By the time I did my 8i they'd discontinued them. They're nothing to get too excited about. Better thanIBM's DB2 pins though = ) Regards, Mike Hately Oracle DBA -Original Message-From: Sherman, Edward [mailto:[EMAIL PROTECTED]]Sent: 22 July 2002 15:18To: Multiple recipients of list ORACLE-LSubject: RE: Badge of Oracle8i OCP OCP Success Kit After successfully completing all exams in the OCP Track, you will receive an OCP Success Kit which includes: * Letter of Congratulations * Oracle Certified Professional Certificate * OCP ID Card * Oracle Technology Network Membership * Exclusive access to OCP Online Forum * Subscription to Oracle Magazine http://otn.oracle.com/training/certification/introduction_ocpds.html How to get assistance on issues with receiving your OCA, OCP, or OCM credential with Oracle Corporation http://www.oracle.com/education/certification/faq/index.html?faq10a.html -Original Message-From: Edouard Dormidontov [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 7:38 AMTo: Multiple recipients of list ORACLE-LSubject: Badge of Oracle8i OCP I get an Oracle8i OCP, but I don't receive a badge. Is it right? Thank you This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP.
Rant
Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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).
FW: bind vars change explain plan
prem. Never did get an answer to this question. I don't know why using bind variables changed the execution path. My best guess comes from the developer. She thinks that when we supplied the values, the optimizer knew what the range of values would be, and could therefore determine to use the index. With the bind variable, the optimizer did not have a range of values to work with and therefore did not choose the index in the execution path. I have no knowledge that using bind variables will suppress indexes. Just happened that it did in this case. Also keep in mind that this particular database is using an old version of Oracle (7.3.4). Optimizer got much better in version 8. The list helped me out with a work-around, which was to index-hint the index I wanted. Bind variables are definitely good guys. I highly recommend you continue with your code changes to include binds. Good luck. Barb -- From: oraora oraora[SMTP:[EMAIL PROTECTED]] Reply To: oraora oraora Sent: Sunday, July 21, 2002 8:24 PM To: [EMAIL PROTECTED] Subject: Re: bind vars change explain plan Baker, sorry i did not read the reply to ur query. what was the reply ? will using bind vars suppress index ? kindly let me know b'coz i have also changed my code to SQL with bind vars just now. Regards, prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [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: Rant
So no one responded with, We use raid xx. We don't have to worry about backup/recovery. ;^) -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 7/22/02, mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: Alan Davey INET: [EMAIL PROTECTED] 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: [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: Rant
Obviously you need to lower your standards. Maybe your test questions were culturally biased. Look at the SQLSever MySQL culture and dumb down accordingly. ;-) -Original Message- Sent: Monday, July 22, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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:Rant
mkb, Your surprised? Over the last 6 years I've interviewed many a candidate while we added two DBA's to the group. I've gotten a lot of answers like this: Question: How do you create a table? Answer: The developer sends me a script. I run script. Question: How do you shutdown a database? Answer: Turn off the power to the computer. Question: How do you change the block size of a database. Answer: Change it in init.ora, restart database. Question: How do you add a datafile to a tablespace? Answer: You can't. Question: What are archived redo logs? Answer: There is no such thing. BTW: these folks had an OCP certificate. Best answer to a question I've asked: Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. We hired the guy, he's still here 2 years later and just recently got his OCP. Dick Goulet Reply Separator Author: mkb [EMAIL PROTECTED] Date: 7/22/2002 6:58 AM Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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: Rant
One thing to keep in mind is that it is easy to get rattled during a job interview and have your mind go blank on you. This is especially true with computer technical types who are basically introverts. Some years back when I was a corporate controller I interviewed a young lady for a admin type position. Her interview was a total disaster. She took the typing test and completely messed it up. But there was something about her skills that came through and I hired her. I was never sorry that I did. She could type up complicated tax forms that were always 100% correct. She was a model employee. Sometimes you have to go by your gut feel. Answers to technical questions are not the complete picture. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 9:58 AM Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] 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: [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: bind vars change explain plan
Your colleague hit the nail on the head. Using bind variables in queries can give the database a hit or miss approach to whether or not it uses indexes. Something to do with how skewed the indexes are also. Regards, Kev. -Original Message- Sent: 22 July 2002 16:08 To: Multiple recipients of list ORACLE-L prem. Never did get an answer to this question. I don't know why using bind variables changed the execution path. My best guess comes from the developer. She thinks that when we supplied the values, the optimizer knew what the range of values would be, and could therefore determine to use the index. With the bind variable, the optimizer did not have a range of values to work with and therefore did not choose the index in the execution path. I have no knowledge that using bind variables will suppress indexes. Just happened that it did in this case. Also keep in mind that this particular database is using an old version of Oracle (7.3.4). Optimizer got much better in version 8. The list helped me out with a work-around, which was to index-hint the index I wanted. Bind variables are definitely good guys. I highly recommend you continue with your code changes to include binds. Good luck. Barb -- From: oraora oraora[SMTP:[EMAIL PROTECTED]] Reply To: oraora oraora Sent: Sunday, July 21, 2002 8:24 PM To: [EMAIL PROTECTED] Subject: Re: bind vars change explain plan Baker, sorry i did not read the reply to ur query. what was the reply ? will using bind vars suppress index ? kindly let me know b'coz i have also changed my code to SQL with bind vars just now. Regards, prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [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.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] 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: [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: Rant
uh...raid. Oh yes, I have a script for that. --- Alan Davey [EMAIL PROTECTED] wrote: So no one responded with, We use raid xx. We don't have to worry about backup/recovery. ;^) -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 7/22/02, mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: Alan Davey INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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:Rant
Wait, the best one yet I heard last week: 'the redo log in 9i is going away...' (Surely you mean that undo tbsp can be used instead of rollback segment tablespace, right???) Yes I see your point, but thankfully, I don't do this very often. --- [EMAIL PROTECTED] wrote: mkb, Your surprised? Over the last 6 years I've interviewed many a candidate while we added two DBA's to the group. I've gotten a lot of answers like this: Question: How do you create a table? Answer: The developer sends me a script. I run script. Question: How do you shutdown a database? Answer: Turn off the power to the computer. Question: How do you change the block size of a database. Answer: Change it in init.ora, restart database. Question: How do you add a datafile to a tablespace? Answer: You can't. Question: What are archived redo logs? Answer: There is no such thing. BTW: these folks had an OCP certificate. Best answer to a question I've asked: Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. We hired the guy, he's still here 2 years later and just recently got his OCP. Dick Goulet Reply Separator Subject:Rant Author: mkb [EMAIL PROTECTED] Date: 7/22/2002 6:58 AM Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
Re: Rant
baffling and frustrating. Some of these folks claimed to have 5 years experience!!! Unfortunately for most everyone, the only people that benefit from most certification programs are the facilitators. They're cash cows for the purported issuers of such certifications. Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers INET: [EMAIL PROTECTED] 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: [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:FW: bind vars change explain plan
Barbara, The path that the optimizer chooses is based on what values are bound into the variables, but also on what information it has in the data dictionary. If those particular tables/indexes have not been analyzed recently then the optimizer will make wrong decisions. Also init parameters like db_file_multiblock_read_count can prejudice the optimizer to a particular path over others. I would not so much blame the use of bind variables before looking at the data dictionary entries for the table/indexes and the init.ora file. And yes, the optimizer in 7.x was flaky, at best. Dick Goulet Reply Separator Author: Baker; Barbara [EMAIL PROTECTED] Date: 7/22/2002 7:08 AM prem. Never did get an answer to this question. I don't know why using bind variables changed the execution path. My best guess comes from the developer. She thinks that when we supplied the values, the optimizer knew what the range of values would be, and could therefore determine to use the index. With the bind variable, the optimizer did not have a range of values to work with and therefore did not choose the index in the execution path. I have no knowledge that using bind variables will suppress indexes. Just happened that it did in this case. Also keep in mind that this particular database is using an old version of Oracle (7.3.4). Optimizer got much better in version 8. The list helped me out with a work-around, which was to index-hint the index I wanted. Bind variables are definitely good guys. I highly recommend you continue with your code changes to include binds. Good luck. Barb -- From: oraora oraora[SMTP:[EMAIL PROTECTED]] Reply To: oraora oraora Sent: Sunday, July 21, 2002 8:24 PM To: [EMAIL PROTECTED] Subject: Re: bind vars change explain plan Baker, sorry i did not read the reply to ur query. what was the reply ? will using bind vars suppress index ? kindly let me know b'coz i have also changed my code to SQL with bind vars just now. Regards, prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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[2]: Rant
Ken, The reason I liked the guy we hired as out Junior DBA. He did not know the answer, but did know where to find it in the manuals. He also knew to calm himself down. Premature actions often cause more trouble. Dick Goulet Reply Separator Author: KENNETH JANUSZ [EMAIL PROTECTED] Date: 7/22/2002 7:23 AM One thing to keep in mind is that it is easy to get rattled during a job interview and have your mind go blank on you. This is especially true with computer technical types who are basically introverts. Some years back when I was a corporate controller I interviewed a young lady for a admin type position. Her interview was a total disaster. She took the typing test and completely messed it up. But there was something about her skills that came through and I hired her. I was never sorry that I did. She could type up complicated tax forms that were always 100% correct. She was a model employee. Sometimes you have to go by your gut feel. Answers to technical questions are not the complete picture. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 9:58 AM Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network
Need to have 2 Columns of Size 3000 in 1 Table to Store Character Data
Qs What Datatypes Can be Used for 2 Columns of Size 3000 in 1 Table to Store Character Data ? NOTE - 2 Columns of LONG Datatype are NOT Allowed in 1 Table create table test10 (test1 long,test2 long); create table test10 (test1 long,test2 long) * ERROR at line 1: ORA-01754: a table may contain only one column of type LONG Qs Also please tell any Limitations , Disadvantages when using any Substitute Advised Datatype ? Thanks P.S. Any Disadvantages with using CLOB ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] 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: [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: Rant
Your not the only one. I usually start my interviews with a Metalink question, like... When was the last time you used Metalink, and what problem did it help you solve? I am just amazed at the responses I get... Oh, I haven't used that tool from (take your pick) company... What is a Metalink? Was that on the OCP test? G...it generally goes downhill from there. Perhaps I am being tough with that question. Perhaps I should just ask one question, Connor's... Over there on the far wall is a 6x6m white board. Assuming the space is an 'Oracle database', start filling the blanks in terms of memory, disks, files, caches, buffer etc with all the connecting lines. Start broadly and continue generating more and more levels of detail until you want to stop or we want you to stop. We want to know your favourite and least favourite bits You are the man Connor... -Original Message- Sent: Monday, July 22, 2002 10:58 AM To: Multiple recipients of list ORACLE-L Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] 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: [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: Rant
If that weren't so devastatingly accurate here, I'd laugh. I started, asked about backups, etc etc the response was we're on a netapp filer, they don't go down sigh. they don't go down. Until they do --- Alan Davey [EMAIL PROTECTED] wrote: So no one responded with, We use raid xx. We don't have to worry about backup/recovery. ;^) -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 7/22/02, mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: Alan Davey INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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: Rant
Good rant. :) I sympathize. The answer I get more and more is I click on this item on the GUI... (I didn't ask you that, I asked you the theory behind that little radio button) --- mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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[2]:Rant
Thankfully neither do I. Reply Separator Author: mkb [EMAIL PROTECTED] Date: 7/22/2002 7:30 AM Wait, the best one yet I heard last week: 'the redo log in 9i is going away...' (Surely you mean that undo tbsp can be used instead of rollback segment tablespace, right???) Yes I see your point, but thankfully, I don't do this very often. --- [EMAIL PROTECTED] wrote: mkb, Your surprised? Over the last 6 years I've interviewed many a candidate while we added two DBA's to the group. I've gotten a lot of answers like this: Question: How do you create a table? Answer: The developer sends me a script. I run script. Question: How do you shutdown a database? Answer: Turn off the power to the computer. Question: How do you change the block size of a database. Answer: Change it in init.ora, restart database. Question: How do you add a datafile to a tablespace? Answer: You can't. Question: What are archived redo logs? Answer: There is no such thing. BTW: these folks had an OCP certificate. Best answer to a question I've asked: Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. We hired the guy, he's still here 2 years later and just recently got his OCP. Dick Goulet Reply Separator Subject:Rant Author: mkb [EMAIL PROTECTED] Date: 7/22/2002 6:58 AM Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: end of correction support question
Pat, Sorry for the formatting problems, I didn't check the format of the info after doing a cut/paste from metalink. Note: | EMS includes the following: | Continuance of full metals services, | consisting of: ... -| Error Correction Support (ECS) Here is a reworked version: | EAS includes the following: | Telephone and Electronic support, consisting of: | Answers to customers' questions | Assistance with migration plans to a supported platform | and/or product Workarounds, where possible --- | EAS does NOT include the following: | Error Correction Support (ECS) - No new bug fixes | Backporting of fixes | Certification with supported products, newer operating | system versions or new compilers | Escalation support, response time adherence and skill | availability --- | EMS will be available until 31-DEC-2005, if the customer | purchases EMS and has a current support contract in place. | EMS includes the following: | Continuance of full metals services, consisting of: -| Error Correction Support (ECS) | Answers to customers' questions | Assistance with migration plans to a supported platform | and/or product Backporting of fixes | Escalation support, response time adherence and skill | availability | Workarounds, where possible --- -| EMS does NOT include the following: | Certification with supported products, newer operating | system versions or new compilers --- On 19 Jul 2002 at 8:15, Boivin, Patrice J wrote: I notice EAS does not include Error Correction Support (ECS) - No new bug fixes Backporting of fixes EMS does not include Error Correction Support (ECS) Backporting of fixes http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=148054.1 excerpt: -- Oracle Corporation Product Obsolescence Desupport Notice -- -- Product Details: Platform(s) Details: Product: Oracle Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC Standard Edition/Workgroup Server Product Version(s): 8.1.7 (8i) Platform(s): Platform Version(s): ALL Platforms ALL Desupport End Dates: Error Correction Support (ECS): 31-DEC-2003 Extended Assistance Support (EAS): 31-DEC-2006 Extended Maintenance Support (EMS): 31-DEC-2005 ... Customer Action: To upgrade/migrate, U.S. customers must contact Client Relations at the following: (NOTE: Non-U.S. customers must contact their Oracle Local Support Center (LSC).) West: (719) 785-7600 Central Mountain: (719) 635-8900 East: (407) 240- 8900 Toll-Free: 1-800-223-1711 Exceptions and/or Miscellaneous Information: Extended Maintenance Support (EMS) will be offered on the following platforms ONLY until 31-DEC-2005: Compaq Alpha OpenVMS (DEC) Compaq Tru64 UNIX (Digital Unix) Data General Intel Unix Fujitsu-Siemens RM200-600E Reliant Unix HP 9000 Series HP-UX IBM NUMA-Q DYNIX/ptx (Sequent) IBM OS 390 (MVS) IBM RS/6000 AIX Intel Based Server LINUX Intel Caldera Open UNIX 8 with LKP Microsoft Windows 2000 SGI Unix Sun SPARC Solaris UnixWare (SCO) Novell NetWare Customers: ALL Oracle products on Novell NetWare will be desupported 31-DEC- 2001. In order to ensure that customers have sufficient time to migrate to the terminal release on Novell Netware, Oracle is extending ECS for Oracle Server - Oracle8i 8.1.7 on Novell Netware until 30-SEP-2002. ... This desupport notice is addressed to the customer's contact currently on file with Oracle Corporation. (NOTE: If the contact information is not current, please email the current contact information and CSI# to [EMAIL PROTECTED]) This document is for informational purposes only, and is intended to outline Oracle Corporation's current migration path. The information in this document is subject to change without notice at Oracle Corporation's discretion. In accordance with Oracle Corporation's current transfer policy, future releases of Oracle programs (migration paths) are provided to customers who have a valid support contract only. Customers with a current support contract may also view the current desupport notice via Oracle MetaLink at http://metalink.oracle.com, under Product LifeCycle -- Desupport Notices. - For further assistance, please email [EMAIL PROTECTED] Last modified: 12-Feb-2002 15:31:28 (U.S. Pacific Time) . ---end--- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
RE: Rant
Gurus, ocp will let you enter into an interview - proved. However the candidates failed to prove it. Results spoiling the image on OCP. Nirmal. -Original Message- Sent: Monday, July 22, 2002 6:24 PM To: Multiple recipients of list ORACLE-L mkb, Your surprised? Over the last 6 years I've interviewed many a candidate while we added two DBA's to the group. I've gotten a lot of answers like this: Question: How do you create a table? Answer: The developer sends me a script. I run script. Question: How do you shutdown a database? Answer: Turn off the power to the computer. Question: How do you change the block size of a database. Answer: Change it in init.ora, restart database. Question: How do you add a datafile to a tablespace? Answer: You can't. Question: What are archived redo logs? Answer: There is no such thing. BTW: these folks had an OCP certificate. Best answer to a question I've asked: Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. We hired the guy, he's still here 2 years later and just recently got his OCP. Dick Goulet Reply Separator Author: mkb [EMAIL PROTECTED] Date: 7/22/2002 6:58 AM Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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.com -- Author: Nirmal Kumar Muthu Kumaran INET:
Problem with export 8.1.7 Sun
I am having trouble with a compressed full export. If I run a an interactive export it works fine. But if I run a compressed export if fails with the following error message. The export script is identical to the one used for another sid on the same server. Only the sid is changed. . exporting system procedural objects and actions . exporting pre-schema procedural objects and actions . exporting cluster definitions . about to export SYSTEM's tables via Conventional Path ... EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: Export terminated unsuccessfully EXPORT SCRIPT: #!/bin/ksh -x export ORACLE_SID=cdwtst export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. export USERPASS=system/xxx OUTFILE=/u013/oradata/cdwtst/exp/cdwtst_exp_full_`date '+%m%d%y'`.dmp.Z LOGFILE=/u013/oradata/cdwtst/exp/cdwtst_exp_full_`date '+%m%d%y'`.log cd /u013/oradata/cdwtst/exp # # Create a new pipe # if [ -p exp_pipe_$ORACLE_SID ] then rm exp_pipe_$ORACLE_SID fi mknod exp_pipe_$ORACLE_SID p # # Begin compress job and export to pipe with userid and password hidden # compress /u013/oradata/cdwtst/exp/exp_pipe_cdwtst $OUTFILE exp $USERPASS full=y compress=n consistent=y buffer=100 file=/u013/oradata/cdwtst/exp/exp_pipe_cdwtst log=$LOGFILE -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] 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: [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: Rant
you have a script that GETS rid of BUGS!?! COOL!!! -Original Message- Sent: Monday, July 22, 2002 10:33 AM To: Multiple recipients of list ORACLE-L uh...raid. Oh yes, I have a script for that. --- Alan Davey [EMAIL PROTECTED] wrote: So no one responded with, We use raid xx. We don't have to worry about backup/recovery. ;^) -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 7/22/02, mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: Alan Davey INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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). begin 666 InterScan_Disclaimer.txt
RE: Need to have 2 Columns of Size 3000 in 1 Table to Store Chara
create table t1 (a varchar2(4000)); hope that this will work oracle 8 and above. rgds, nirmal -Original Message- Sent: Monday, July 22, 2002 6:48 PM To: Multiple recipients of list ORACLE-L Data Qs What Datatypes Can be Used for 2 Columns of Size 3000 in 1 Table to Store Character Data ? NOTE - 2 Columns of LONG Datatype are NOT Allowed in 1 Table create table test10 (test1 long,test2 long); create table test10 (test1 long,test2 long) * ERROR at line 1: ORA-01754: a table may contain only one column of type LONG Qs Also please tell any Limitations , Disadvantages when using any Substitute Advised Datatype ? Thanks P.S. Any Disadvantages with using CLOB ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] 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: [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.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] 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: [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: Need to have 2 Columns of Size 3000 in 1 Table to Store Character Data
Why not VARCHAR2(3000) ? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 11:48 AM Data Qs What Datatypes Can be Used for 2 Columns of Size 3000 in 1 Table to Store Character Data ? NOTE - 2 Columns of LONG Datatype are NOT Allowed in 1 Table create table test10 (test1 long,test2 long); create table test10 (test1 long,test2 long) * ERROR at line 1: ORA-01754: a table may contain only one column of type LONG Qs Also please tell any Limitations , Disadvantages when using any Substitute Advised Datatype ? Thanks P.S. Any Disadvantages with using CLOB ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] 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: [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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] 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: [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:Rant
Oh I love the get a cup of coffee in other words... THINK before you act --- [EMAIL PROTECTED] wrote: mkb, Your surprised? Over the last 6 years I've interviewed many a candidate while we added two DBA's to the group. I've gotten a lot of answers like this: Question: How do you create a table? Answer: The developer sends me a script. I run script. Question: How do you shutdown a database? Answer: Turn off the power to the computer. Question: How do you change the block size of a database. Answer: Change it in init.ora, restart database. Question: How do you add a datafile to a tablespace? Answer: You can't. Question: What are archived redo logs? Answer: There is no such thing. BTW: these folks had an OCP certificate. Best answer to a question I've asked: Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. We hired the guy, he's still here 2 years later and just recently got his OCP. Dick Goulet Reply Separator Author: mkb [EMAIL PROTECTED] Date: 7/22/2002 6:58 AM Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com --
RE: Rant
Jim, So how many like this did you hear?. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Monday, July 22, 2002 11:24 AM To: Multiple recipients of list ORACLE-L mkb, Your surprised? Over the last 6 years I've interviewed many a candidate while we added two DBA's to the group. I've gotten a lot of answers like this: Question: How do you create a table? Answer: The developer sends me a script. I run script. Question: How do you shutdown a database? Answer: Turn off the power to the computer. Question: How do you change the block size of a database. Answer: Change it in init.ora, restart database. Question: How do you add a datafile to a tablespace? Answer: You can't. Question: What are archived redo logs? Answer: There is no such thing. BTW: these folks had an OCP certificate. Best answer to a question I've asked: Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. We hired the guy, he's still here 2 years later and just recently got his OCP. Dick Goulet Reply Separator Author: mkb [EMAIL PROTECTED] Date: 7/22/2002 6:58 AM Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
RE: Rant
Best answer to a question I've asked: Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. YES Once upon a time while self-employed as a high powered consultant, er uh, lowly DBA contractor, I was coming into my client about 7AM facing an URGENT recovery of a key production system. I reviewed the manuals on my laptop while riding the train and stood in line for a Venti Sumatra at Starbucks. When I walked in the director looked at my coffee cup but said nothing. Within a few minutes the recovery was complete. Later the director asked about why the recovery went so smooth. My reply was, Good backups and good coffee. The director had hands on technical experience and appreciated the value of both. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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: Rant
I read your rant, and I agree with you. But I do have one little itsy bitsy question... I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. How DO you do an online recovery of a datafile while the database is still in use? I've had to do recoveries before, but never this scenario. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] 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: [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: Need to have 2 Columns of Size 3000 in 1 Table to Store Character Data
varchar2 can go to 4000 (yes, in 8i) it's in the SQL reference manual, under datatypes --- VIVEK_SHARMA [EMAIL PROTECTED] wrote: Qs What Datatypes Can be Used for 2 Columns of Size 3000 in 1 Table to Store Character Data ? NOTE - 2 Columns of LONG Datatype are NOT Allowed in 1 Table create table test10 (test1 long,test2 long); create table test10 (test1 long,test2 long) * ERROR at line 1: ORA-01754: a table may contain only one column of type LONG Qs Also please tell any Limitations , Disadvantages when using any Substitute Advised Datatype ? Thanks P.S. Any Disadvantages with using CLOB ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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: Rant
Referring to the last answer about getting a coffee I don't actually think that is a bad answer!! If he meant I will not rush in and do something rash, rather I will plan what I am going to do and check the book to make sure that I am correct then I think that is a perfectly acceptable approach. You can strike me from the list now after that rash comment John -Original Message- Sent: 22 July 2002 16:24 To: Multiple recipients of list ORACLE-L mkb, Your surprised? Over the last 6 years I've interviewed many a candidate while we added two DBA's to the group. I've gotten a lot of answers like this: Question: How do you create a table? Answer: The developer sends me a script. I run script. Question: How do you shutdown a database? Answer: Turn off the power to the computer. Question: How do you change the block size of a database. Answer: Change it in init.ora, restart database. Question: How do you add a datafile to a tablespace? Answer: You can't. Question: What are archived redo logs? Answer: There is no such thing. BTW: these folks had an OCP certificate. Best answer to a question I've asked: Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. We hired the guy, he's still here 2 years later and just recently got his OCP. Dick Goulet Reply Separator Author: mkb [EMAIL PROTECTED] Date: 7/22/2002 6:58 AM Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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
EMN0
Has anyone experienced problems with Database hanging on shutdown and the only error anywhere is Restarting dead background process EMN0 and that appears consistently before the inability to stop the database. I have created an Itar (which was down graded immediately...) and hunted for answers on metalink. There are two 'solutions' that they suggest. One is to ignore it... if you aren't using Advanced Queuing you don't have to worry anyway... the other is every time you shut down do shutdown abort-startup restricted- shutdown immediate... this will kill all the process (of which at the os level and the DB level the only ones running were Oracle generated processes... oratest 36146 1 0 05:59:02 - 0:07 ora_qmn0_TEST oratest 36384 1 0 05:59:02 - 0:01 ora_smon_TEST oratest 36640 1 0 05:59:02 - 0:01 ora_ckpt_TEST oratest 37156 1 0 05:59:02 - 0:00 ora_dbw0_TEST oratest 37416 1 0 05:59:02 - 0:00 ora_pmon_TEST oratest 37672 1 0 05:59:02 - 0:00 ora_lgwr_TEST oratest 41404 1 0 05:59:02 - 0:00 ora_reco_TEST ) Has anyone dealt with this successfully? It deals, from what I have gathered, with Java in the database (maybe?). Thanks in advance for any advice April Wells Corporate Systems Amarillo Texas begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE %;G0N#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] 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: [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: FW: bind vars change explain plan
I thought it was simply that with values the optimizer could look at the histograms to see if data was skewed, whereas it couldn't with bind variables. So the index may not have too many distinct values but the values you were supplying had less than their fair share of records. I'd guess that someone at some point has done a analyze table for all indexes (or something similar) on the particular table. I'd also tend to agree though that it's better to hint the index rather than use values (if that is in your control) -Original Message- Sent: Monday, July 22, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Barbara, The path that the optimizer chooses is based on what values are bound into the variables, but also on what information it has in the data dictionary. If those particular tables/indexes have not been analyzed recently then the optimizer will make wrong decisions. Also init parameters like db_file_multiblock_read_count can prejudice the optimizer to a particular path over others. I would not so much blame the use of bind variables before looking at the data dictionary entries for the table/indexes and the init.ora file. And yes, the optimizer in 7.x was flaky, at best. Dick Goulet Reply Separator Author: Baker; Barbara [EMAIL PROTECTED] Date: 7/22/2002 7:08 AM prem. Never did get an answer to this question. I don't know why using bind variables changed the execution path. My best guess comes from the developer. She thinks that when we supplied the values, the optimizer knew what the range of values would be, and could therefore determine to use the index. With the bind variable, the optimizer did not have a range of values to work with and therefore did not choose the index in the execution path. I have no knowledge that using bind variables will suppress indexes. Just happened that it did in this case. Also keep in mind that this particular database is using an old version of Oracle (7.3.4). Optimizer got much better in version 8. The list helped me out with a work-around, which was to index-hint the index I wanted. Bind variables are definitely good guys. I highly recommend you continue with your code changes to include binds. Good luck. Barb -- From: oraora oraora[SMTP:[EMAIL PROTECTED]] Reply To: oraora oraora Sent: Sunday, July 21, 2002 8:24 PM To: [EMAIL PROTECTED] Subject: Re: bind vars change explain plan Baker, sorry i did not read the reply to ur query. what was the reply ? will using bind vars suppress index ? kindly let me know b'coz i have also changed my code to SQL with bind vars just now. Regards, prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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.com -- Author: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] 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: [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: bind vars change explain plan
I think I saw the correct answer to this one shoot by on the list. In Oracle8, the use of bind variables completely prevents the Oracle query optimizer from using histograms. Could make a big difference in which plan CBO selects if there's a lot of data skew. In Oracle9, it gets a little better, but things still aren't completely right. Apparently, a session only peeks at the value once and then uses the first plan it computes thereafter. Barb's bottom line is absolutely correct; use bind variables. However you can. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 23-25 Chicago - Miracle Database Forum, Sep 20-22 Middlefart Denmark - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- Barbara Sent: Monday, July 22, 2002 10:08 AM To: Multiple recipients of list ORACLE-L prem. Never did get an answer to this question. I don't know why using bind variables changed the execution path. My best guess comes from the developer. She thinks that when we supplied the values, the optimizer knew what the range of values would be, and could therefore determine to use the index. With the bind variable, the optimizer did not have a range of values to work with and therefore did not choose the index in the execution path. I have no knowledge that using bind variables will suppress indexes. Just happened that it did in this case. Also keep in mind that this particular database is using an old version of Oracle (7.3.4). Optimizer got much better in version 8. The list helped me out with a work-around, which was to index-hint the index I wanted. Bind variables are definitely good guys. I highly recommend you continue with your code changes to include binds. Good luck. Barb -- From: oraora oraora[SMTP:[EMAIL PROTECTED]] Reply To: oraora oraora Sent: Sunday, July 21, 2002 8:24 PM To: [EMAIL PROTECTED] Subject: Re: bind vars change explain plan Baker, sorry i did not read the reply to ur query. what was the reply ? will using bind vars suppress index ? kindly let me know b'coz i have also changed my code to SQL with bind vars just now. Regards, prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [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.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] 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: [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: Rant
Who needs a script! According to the advertising RAID kills BUGS dead -Original Message- Sent: Monday, July 22, 2002 10:19 AM To: Multiple recipients of list ORACLE-L you have a script that GETS rid of BUGS!?! COOL!!! -Original Message- Sent: Monday, July 22, 2002 10:33 AM To: Multiple recipients of list ORACLE-L uh...raid. Oh yes, I have a script for that. --- Alan Davey [EMAIL PROTECTED] wrote: So no one responded with, We use raid xx. We don't have to worry about backup/recovery. ;^) -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 7/22/02, mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: Alan Davey INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
RE: Why Multiple Parses in Trace ?
...Because the application requested two parse calls for this statement from the server. The first one was a hard parse (server had never seen the statement before), and the second one was a parse call that did not result in a hard parse. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 23-25 Chicago - Miracle Database Forum, Sep 20-22 Middlefart Denmark - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- VIVEK_SHARMA Sent: Monday, July 22, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Qs Why is Parse = 2 in the following Query ? Solaris 8 Oracle 8.1.7 SGA = 60 MB shared_pool_size = 30 MB select mesg, lchg_user_id, TO_CHAR(lchg_time,'DD-MM- HH24:MI:SS'), rcre_user_id, TO_CHAR(rcre_time,'DD-MM- HH24:MI:SS'), tran_id, TO_CHAR(tran_date,'DD-MM- HH24:MI:SS'), NVL(ts_cnt,0), sol_id, contra_acid, tran_amt||'!'||tran_crncy_code, TO_CHAR(value_date,'DD-MM- HH24:MI:SS'), tran_crncy_code, central_or_local_code, req_advc_ind, sys_gen_flg, rowid FROM TBA_REF_TRN_TBL WHERE cmd = :1 AND cust_or_card_id = :2 AND system_date_time = TO_DATE( :3 ,'DD-MM- HH24:MI:SS') AND dcc_id = :4 AND sno = :5 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse2 0.06 0.07 1 0 1 0 Execute 2 0.00 0.00 0 0 0 0 Fetch2 0.00 0.02 3 6 0 0 --- -- -- -- -- -- -- total6 0.06 0.09 4 6 1 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 40 (TBAGEN) Rows Row Source Operation --- --- 0 TABLE ACCESS BY INDEX ROWID REF_TRN_TBL 1 INDEX UNIQUE SCAN (object id 6561) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS (BY INDEX ROWID) OF 'REF_TRN_TBL' 1INDEX (UNIQUE SCAN) OF 'IDX_REF_TRN_TBL' (UNIQUE) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] 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: [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.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] 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: [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: Rant
even so, I'd rather have someone tell me my mind has gone blank, but I know I can look it up in this manual --- KENNETH JANUSZ [EMAIL PROTECTED] wrote: One thing to keep in mind is that it is easy to get rattled during a job interview and have your mind go blank on you. This is especially true with computer technical types who are basically introverts. Some years back when I was a corporate controller I interviewed a young lady for a admin type position. Her interview was a total disaster. She took the typing test and completely messed it up. But there was something about her skills that came through and I hired her. I was never sorry that I did. She could type up complicated tax forms that were always 100% correct. She was a model employee. Sometimes you have to go by your gut feel. Answers to technical questions are not the complete picture. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 9:58 AM Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
Re: Re[2]: Rant
only a dba would think of drinking coffee as something that would calm one down! har har har On 22 Jul 2002 at 7:43, [EMAIL PROTECTED] wrote: The reason I liked the guy we hired as out Junior DBA. He did not know the answer, but did know where to find it in the manuals. He also knew to calm himself down. Premature actions often cause more trouble. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] 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: [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: Rant
IT'S NOT a radio button... It is a regular CLICKY button geez -Original Message- Sent: Monday, July 22, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Good rant. :) I sympathize. The answer I get more and more is I click on this item on the GUI... (I didn't ask you that, I asked you the theory behind that little radio button) --- mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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). begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
Re: Rant-Rant
I have been reading this list for the past several months as I prepare to move my universe of databases from 7.3 to 9 (probably 9) and I have a rant of my own. It seems that the implicit expectation is that every DBA should be or should aspire to be a Master Technical DBA. I have a slightly different take on the situation. It is a little convoluted but I believe that the DBA world needs some additional job classifications. In a decent sized organization, the day to day management functions should be accomplished by an Admin DBA who might be someone who was perfectly happy spending his/her working career operating a precision milling machine at Boeing. Since the machinist jobs are going away, I see no reason why a competent machinist could not become a competent admin DBA. Such a person is not suited by aptitude or disposition to become a Master Technical DBA, but would do a great job at the admin level. I'll extend the analogy a little more: the manufacturing organization does not expect the machinist to program the machine. They either have on staff or bring in a numerical control programming specialist. Similarly, the Admin DBA should know which tasks he/she can perform and which tasks should be kicked up or out to the next level. So maybe some of the energy spent on this list about relevance of the OCP and discussing qualifications of DBAs (against an unspecified standard) could be spent defining organizational strategies for getting the best use out of human capital represented by Admin DBAs and pricing the skill set appropriately. The worst possible thing is to get an Admin DBA into a Technical DBA position. I think the key breakthrough is the notion that there is a DBA track that does not inevitably lead to Master Technical DBA. That is why I use the machinist analogy: somebody who is satisfied with a career spending 25 years doing essentially the same thing. If you are into Myers-Briggs type indicator, I think the personality dimension is SJ and roughly 25% of the population fits this profile. I believe that if we think about these things in a way that we ask ourselves how can I maximize the potential of this person in our organization, pay him/her a fair wage for what they can do, and free up my time to address the really gnarly stuff we can help our entire society better transition to the information era and not marginalize a bunch of great people in the process. (Sez the man operating a three person software company). Re: Hotbackups. In the last three months I have adapted the scripts from the Kevin Loney book for 4 separate databases. I have inspected them very carefully to make sure all of the files are the there. I think that I understand the what, how and why of hot backups. And I still had to go look to see that it was an alter tablespace rather than an alter database command to backup the tablespace. re Politics: Given the rather idealistic tone of this missive, I guess I should add that I am down the middle Libertarian who tends to vote Republican because I'm most concerned about taxes. At 06:58 AM 7/22/2002 -0800, you wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical INET: [EMAIL PROTECTED] 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: [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: Rant
re: Results spoiling the image on OCP. what image, the marketing people's garbage? the clueless HR departments? big software companies make a lot of money from training and certification, so they have an incentive to selectively present information in such a way as to convince the inexperienced that they MUST HAVE CERTIFICATION. why should people swallow that kind of terdliness without excersising some prudence and independent judgement? do a web search on the history of computer industry certification to see that there is a lot of controversy about the practical value of the certification the diferent vendors offer, and how it has changed over time (start with Novell around 1990?). On 22 Jul 2002 at 8:13, Nirmal Kumar Muthu Kumaran wrote: Gurus, ocp will let you enter into an interview - proved. However the candidates failed to prove it. Results spoiling the image on OCP. Nirmal. -Original Message- Sent: Monday, July 22, 2002 6:24 PM To: Multiple recipients of list ORACLE-L mkb, Your surprised? Over the last 6 years I've interviewed many a candidate while we added two DBA's to the group. I've gotten a lot of answers like this: Question: How do you create a table? Answer: The developer sends me a script. I run script. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] 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: [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).
dbms_stats vs analyze for statistics
Doing a dbms_stats with method option of 'for all indexed columns size 254' with compute optin. I notice that only indexed columns are getting column stats - as expected. Howver, if do an anaylze command instead, all columns get some sort of stats. For non-index columns, stats are apparently the min/max values for the column. Anybody see a problem with only getting column stats for the indexed columns as dbms_stats is giving me. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: Rant
My favorite is when they claim to run an n Terabyte database, and I ask them how they back it up... uh we don't back it up yet... Bzzzt!! Thank you for playing, bye bye! P.s. I liked your rant... -Original Message- Sent: Monday, July 22, 2002 12:19 PM To: Multiple recipients of list ORACLE-L you have a script that GETS rid of BUGS!?! COOL!!! -Original Message- Sent: Monday, July 22, 2002 10:33 AM To: Multiple recipients of list ORACLE-L uh...raid. Oh yes, I have a script for that. --- Alan Davey [EMAIL PROTECTED] wrote: So no one responded with, We use raid xx. We don't have to worry about backup/recovery. ;^) -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 7/22/02, mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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.com -- Author: Alan Davey INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [EMAIL
RE: Rant
Hm. these are almost verbatim the instructions I got from Rachel Charmichael after we lost a disk drive and I'd been trying to recover a database for nearly 20 hours. (That was immediately before she steered me towards the magic command that recovered the database.) --- Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. We hired the guy, he's still here 2 years later and just recently got his OCP. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [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: Rant
I have, no fun. But at least your only fooling around with one tablespace and/or file vs. the entire database. The method is rather simple: 1) The tablespace/datafile are already offline, SMON does this for you unless it's SYSTEM in which case your not doing this in the first place. 2) Get your SA to restore the datafiles(s) from tape back to where they belong. 3) startup SQL*Plus as internal. 4) Alter database recover tablespace/datafile as you normally would. 5) Alter tablespace/datafile online. 6) Miller time. (After the SA schedules/starts a hot backup of the entire DB). Want to try one? Take a DB that's in archive log mode either in development or test. Use production ONLY if your suicidal. Take the datafile or tablespace offline for a little while. Now try to bring it back online. Then go to step 4 above. Dick Goulet Reply Separator Author: Vergara; Michael (TEM) [EMAIL PROTECTED] Date: 7/22/2002 8:13 AM I read your rant, and I agree with you. But I do have one little itsy bitsy question... I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. How DO you do an online recovery of a datafile while the database is still in use? I've had to do recoveries before, but never this scenario. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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: EMN0
April: I just had something like this over the weekend. In my case, the server was trying to run 'dbms_java.stop_server'. There was some mysterious corruption in the stored Java classes that was making this process hang. If you look at 'ps' or 'top', do you see the client process from svrmgrl running at top speed? If you kill the EMN0 process, does it restart? I was able to run 'sqlplus /nolog' and 'connect internal' even after the shutdown had started, and I looked at the running SQL. That's how I found this. If indeed this is the problem, you will need to deinstall and reinstall Java. Good Luck! Mike -Original Message- Sent: Monday, July 22, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Has anyone experienced problems with Database hanging on shutdown and the only error anywhere is Restarting dead background process EMN0 and that appears consistently before the inability to stop the database. I have created an Itar (which was down graded immediately...) and hunted for answers on metalink. There are two 'solutions' that they suggest. One is to ignore it... if you aren't using Advanced Queuing you don't have to worry anyway... the other is every time you shut down do shutdown abort-startup restricted- shutdown immediate... this will kill all the process (of which at the os level and the DB level the only ones running were Oracle generated processes... oratest 36146 1 0 05:59:02 - 0:07 ora_qmn0_TEST oratest 36384 1 0 05:59:02 - 0:01 ora_smon_TEST oratest 36640 1 0 05:59:02 - 0:01 ora_ckpt_TEST oratest 37156 1 0 05:59:02 - 0:00 ora_dbw0_TEST oratest 37416 1 0 05:59:02 - 0:00 ora_pmon_TEST oratest 37672 1 0 05:59:02 - 0:00 ora_lgwr_TEST oratest 41404 1 0 05:59:02 - 0:00 ora_reco_TEST ) Has anyone dealt with this successfully? It deals, from what I have gathered, with Java in the database (maybe?). Thanks in advance for any advice April Wells Corporate Systems Amarillo Texas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] 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: [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: FW: bind vars change explain plan
Title: RE: FW: bind vars change explain plan Guys, The developer is right. The fact is that the optimizer not knowing what the value will be might not use PK or other indexes when you think it should - have seen this before. The solution in our case since the index had more than one column was to order by more than one column in the index. Yes, we did not use hints because (1) didn't want to create view and force hint to be used always - would not be appropriate in all cases and downright performance degr, (2) couldn't change the selection criteria (where predicate) would be inaccurate, (3) For whatever reason could not use hints (can't remember why) however, just adding one of the other columns in the composite index to the order actually allowed us to use the index. -Original Message- From: Nicoll, Iain (Calanais) [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: FW: bind vars change explain plan I thought it was simply that with values the optimizer could look at the histograms to see if data was skewed, whereas it couldn't with bind variables. So the index may not have too many distinct values but the values you were supplying had less than their fair share of records. I'd guess that someone at some point has done a analyze table for all indexes (or something similar) on the particular table. I'd also tend to agree though that it's better to hint the index rather than use values (if that is in your control) -Original Message- Sent: Monday, July 22, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Barbara, The path that the optimizer chooses is based on what values are bound into the variables, but also on what information it has in the data dictionary. If those particular tables/indexes have not been analyzed recently then the optimizer will make wrong decisions. Also init parameters like db_file_multiblock_read_count can prejudice the optimizer to a particular path over others. I would not so much blame the use of bind variables before looking at the data dictionary entries for the table/indexes and the init.ora file. And yes, the optimizer in 7.x was flaky, at best. Dick Goulet Reply Separator Author: Baker; Barbara [EMAIL PROTECTED] Date: 7/22/2002 7:08 AM prem. Never did get an answer to this question. I don't know why using bind variables changed the execution path. My best guess comes from the developer. She thinks that when we supplied the values, the optimizer knew what the range of values would be, and could therefore determine to use the index. With the bind variable, the optimizer did not have a range of values to work with and therefore did not choose the index in the execution path. I have no knowledge that using bind variables will suppress indexes. Just happened that it did in this case. Also keep in mind that this particular database is using an old version of Oracle (7.3.4). Optimizer got much better in version 8. The list helped me out with a work-around, which was to index-hint the index I wanted. Bind variables are definitely good guys. I highly recommend you continue with your code changes to include binds. Good luck. Barb -- From: oraora oraora[SMTP:[EMAIL PROTECTED]] Reply To: oraora oraora Sent: Sunday, July 21, 2002 8:24 PM To: [EMAIL PROTECTED] Subject: Re: bind vars change explain plan Baker, sorry i did not read the reply to ur query. what was the reply ? will using bind vars suppress index ? kindly let me know b'coz i have also changed my code to SQL with bind vars just now. Regards, prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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:
RE: Rant
you can see how often I use the GUI :) OBTW.. for those of you who are OEM fans... I heard a rumor (from a fairly well-informed, usually accurate source) that Oracle's changing it all again. T --- April Wells [EMAIL PROTECTED] wrote: IT'S NOT a radio button... It is a regular CLICKY button geez -Original Message- Sent: Monday, July 22, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Good rant. :) I sympathize. The answer I get more and more is I click on this item on the GUI... (I didn't ask you that, I asked you the theory behind that little radio button) --- mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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). begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B
RE: Re[2]: Rant
Caffeine calms down hyperactive people, it's one of the symptoms for that condition. As for me, beer puts me to sleep. I don't know what THAT means. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject:Re: Re[2]: Rant only a dba would think of drinking coffee as something that would calm one down! har har har -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] 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: [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).
Moving tables from one schema to another
Hi I have a user with a schema and want to move that schema to another user. I don't need the original user after the change Can I do this without an export/import. All data and tables in this database I care about is in this schema Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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).
Oracle on Linux ..... Red Hat vs. Suse
Have been unable to arrive at a definitive position regarding the question of 'which is the preferred distribution of Linux vis-à-vis Oracle'. I have inherited Suse Oracle Implementations which are Oracle Corp. certified and have had little or no problems. There are other Red Hat (non-Oracle) servers in the 'group' we are looking to 'standardize' on one distribution. I am pro Suse (as I have Oracle databases currently on Suse) whereas there are other application owners that seem to be pro Red Hat, obviously they are running Red Hat. My understanding is that the situation evolved from 'temporary evaluation' implementations which somehow (gosh ... wonder how that happened ?) are now in 'production'. If the general consensus is that 'it is a moot point' I will comply with the majority. I purposely know not which distribution is the most widely deployed. However, someone will have to migrate to achieve a standard platform. Any further comments Please ! All are welcomed . objective, subjective, inductive, deductive, rational, irrational, emotional and experiential. TIA CJR -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Royce INET: [EMAIL PROTECTED] 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: [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: Rant
YUP, Saw the new version at an Oracle event in Boston a couple of months ago. Seems that nothing is sacred anymore. BTW: Installer changes too, now you need a full multimedia terminal, 4 channel audio VR headset recommended. :o) Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 7/22/2002 9:53 AM you can see how often I use the GUI :) OBTW.. for those of you who are OEM fans... I heard a rumor (from a fairly well-informed, usually accurate source) that Oracle's changing it all again. T --- April Wells [EMAIL PROTECTED] wrote: IT'S NOT a radio button... It is a regular CLICKY button geez -Original Message- Sent: Monday, July 22, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Good rant. :) I sympathize. The answer I get more and more is I click on this item on the GUI... (I didn't ask you that, I asked you the theory behind that little radio button) --- mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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). begin 666 InterScan_Disclaimer.txt
Re: Using Old version of SQL Navigator 2.0.d with Oracle 9i.
As I was trying to get this scenario worked out, so here is what I have done to get this combination working. I deinstalled the Oracle 9i software, then installed SQL plus client for Oracle 7.3 using a Developer 2000 CD. After than I installed Oracle 9i to a different Oracle Home and now OLD Sql Navigator is able to connect to Oracle 9i. Thanks. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 1:33 PM I have an OLD version of SQL Navigator 2.0.d, which was compatible with Oracle 7.3.4. But now I have Oracle 9i installed, but I do not have client for Oracle 7.3.4. Is there is a way out that I can connect to Oracle using this SQL navigator. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharminder Kumar INET: [EMAIL PROTECTED] 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: [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.com -- Author: Dharminder Kumar INET: [EMAIL PROTECTED] 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: [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[2]: Rant
And coffee is WAY cheaper than Addrell (my son's prescription). Caffeine helps hyperactive people focus. -Original Message- Sent: Monday, July 22, 2002 1:03 PM To: Multiple recipients of list ORACLE-L Caffeine calms down hyperactive people, it's one of the symptoms for that condition. As for me, beer puts me to sleep. I don't know what THAT means. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject:Re: Re[2]: Rant only a dba would think of drinking coffee as something that would calm one down! har har har -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] 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: [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). begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE %;G0N#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] 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: [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[2]: Rant
Interesting. Coffee has a calming effect? I prefer the good ACME Earthquake Pill effect of iced tea, myself. ;) The last time we had a developer truncate a 3M row table, I had fun with it. Fun because some of our recovery implementations were finally proven successful, no data was lost, and downtime was minimal and limited to off-hours. Current and future Oracle job seekers need to keep the stuff in this thread in mind! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Subject: Re[2]: Rant Ken, The reason I liked the guy we hired as out Junior DBA. He did not know the answer, but did know where to find it in the manuals. He also knew to calm himself down. Premature actions often cause more trouble. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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: Moving tables from one schema to another
Title: RE: Moving tables from one schema to another 1. create new user 2. export schema with data and tables you care about 3. import to newly created schema using parameters fromuser/touser 4. drop old user -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Subject: Moving tables from one schema to another Hi I have a user with a schema and want to move that schema to another user. I don't need the original user after the change Can I do this without an export/import. All data and tables in this database I care about is in this schema Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical Consultant WWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, Australia Mobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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: end of correction support question
Oracle Support replied: 19-JUL-02 15:23:30 UPDATE You are mostly correct. ECS is only for supported versions of Oracle. However, there are some exceptions. Customers running Oracle Applications (E-Business Suite) have full support on certain versions of Oracle software depending on the customer, generally negotiated thru their Sales Rep. It also depends on specific customer situations. It is pretty rare that we do make an exception, but it can be done if the business impact is large enough. That tells me there will be a judgment call involved - if it is a critical security flaw that can be ported back to previous versions, there is a small chance that they will. They will almost certainly do it if you are an Oracle Applications Suite customer. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 1:03 PM To: Multiple recipients of list ORACLE-L Subject:Re: end of correction support question Pat, Sorry for the formatting problems, I didn't check the format of the info after doing a cut/paste from metalink. Note: | EMS includes the following: | Continuance of full metals services, | consisting of: ... -| Error Correction Support (ECS) Here is a reworked version: | EAS includes the following: | Telephone and Electronic support, consisting of: | Answers to customers' questions | Assistance with migration plans to a supported platform | and/or product Workarounds, where possible --- | EAS does NOT include the following: | Error Correction Support (ECS) - No new bug fixes | Backporting of fixes | Certification with supported products, newer operating | system versions or new compilers | Escalation support, response time adherence and skill | availability --- | EMS will be available until 31-DEC-2005, if the customer | purchases EMS and has a current support contract in place. | EMS includes the following: | Continuance of full metals services, consisting of: -| Error Correction Support (ECS) | Answers to customers' questions | Assistance with migration plans to a supported platform | and/or product Backporting of fixes | Escalation support, response time adherence and skill | availability | Workarounds, where possible --- -| EMS does NOT include the following: | Certification with supported products, newer operating | system versions or new compilers --- On 19 Jul 2002 at 8:15, Boivin, Patrice J wrote: I notice EAS does not include Error Correction Support (ECS) - No new bug fixes Backporting of fixes EMS does not include Error Correction Support (ECS) Backporting of fixes http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=148054.1 excerpt: -- Oracle Corporation Product Obsolescence Desupport Notice -- -- Product Details: Platform(s) Details: Product: Oracle Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC Standard Edition/Workgroup Server Product Version(s): 8.1.7 (8i) Platform(s): Platform Version(s): ALL Platforms ALL Desupport End Dates: Error Correction Support (ECS): 31-DEC-2003 Extended Assistance Support (EAS): 31-DEC-2006 Extended Maintenance Support (EMS): 31-DEC-2005 ... Customer Action: To upgrade/migrate, U.S. customers must contact Client Relations at the following: (NOTE: Non-U.S. customers must contact their Oracle Local Support Center (LSC).) West: (719) 785-7600 Central Mountain: (719) 635-8900 East: (407) 240- 8900 Toll-Free: 1-800-223-1711 Exceptions and/or Miscellaneous Information: Extended Maintenance Support (EMS) will be offered on the following platforms ONLY until 31-DEC-2005: Compaq Alpha OpenVMS (DEC) Compaq Tru64 UNIX (Digital Unix) Data General Intel Unix Fujitsu-Siemens RM200-600E Reliant Unix HP 9000 Series HP-UX IBM NUMA-Q DYNIX/ptx (Sequent) IBM OS 390 (MVS) IBM RS/6000 AIX Intel Based Server LINUX Intel Caldera Open UNIX 8 with LKP Microsoft Windows 2000 SGI Unix Sun SPARC Solaris UnixWare (SCO) Novell NetWare Customers: ALL Oracle products on Novell NetWare will be desupported 31-DEC- 2001. In order to ensure that customers have sufficient time to migrate to the terminal release on Novell Netware, Oracle is extending ECS for Oracle Server - Oracle8i 8.1.7 on Novell Netware until
RE: Rant
I was told that same thing in an interview. He said I don't know is not a good answer. I don't know, but I know where to find out. is much better. -Original Message- Sent: Monday, July 22, 2002 9:54 AM To: Multiple recipients of list ORACLE-L even so, I'd rather have someone tell me my mind has gone blank, but I know I can look it up in this manual --- KENNETH JANUSZ [EMAIL PROTECTED] wrote: One thing to keep in mind is that it is easy to get rattled during a job interview and have your mind go blank on you. This is especially true with computer technical types who are basically introverts. Some years back when I was a corporate controller I interviewed a young lady for a admin type position. Her interview was a total disaster. She took the typing test and completely messed it up. But there was something about her skills that came through and I hired her. I was never sorry that I did. She could type up complicated tax forms that were always 100% correct. She was a model employee. Sometimes you have to go by your gut feel. Answers to technical questions are not the complete picture. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 9:58 AM Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] 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: [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: T3's and forcedirectio questions
For setting the db_multiblock_read_count, I suggest the Steve Adams script multiblock_read_test.sql which, on my system, yielded 16 with a block size of 8K. For the optimizer settings, I used the Tim Gorman recommendations from http://www.evdbt.com/SearchIntelligenceCBO.doc which, on my system, suggested values optimizer_index_caching=90 optimizer_index_cost_adj=80 Note that on my system the index cost adj based on the average wait analysis came up higher than Tim's suggested range of 0-50. In any case, these settings produced a noticeable performance boost (thanks Tim and Steve). Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Friday, July 19, 2002 7:13 AM To: Multiple recipients of list ORACLE-L Hi All, I am attempting to improve performance in a shop that uses alot of T3 Storedge arrays to hold the oracle datafiles. I have already moved the redo logs onto to JBOD and tweaked ac couple other settings to make everyone happy but I still have some questions. 1. SUN best practises says set db_multiblock_read_count to a value that with the db block size equals 1M. This forces many foolish full table scans. I have fixed this by knocking the parameter down so the db does reads of 64kK but does anyone know if I can set the optimizer_index_* parameters (and to what values) so that I can set db_multiblock_read_count to match the arrays logical I/O setting? 2 Both Oracle and SUN recommend mounting the arrays with the forcedirectio option and then setting the oracle _filesystemio_options to setall. This causes a 50% performance hit measured by timing representative jobs. Does anyone know why? Even Steve Adams recommends these settings yet the numbers don't lie. A grabbag of other stuff since I can't post to the list from work. Thanks Kirti, for the answer to my listener question a couple of weeks ago Rachel, I have been running Linux/Oracle in production since 8.1.6. I hate to be a paranoid command line hack again but the distribution is irrelevant, Either understand linux, ie compile your own kernels and understand the system libraries, or get a sysadmin who does. Trying to keep up to certified combinations is hard enough for commercial UNIXes, for linux it's easier just to roll your own. So what if Oracle doesn't formally support it. This list will ;) 40% higher throughput than the same box running Oracle under Windblows, 30% less administrative work. Upgrading the OCP. No-one cares what version of the OCP you have. I took mine at 7.3.4 and since then all anyone has asked is do you have it. The only real value I found is it is helpful when applying for a TN visa to work in the US. my $0.013, otherwise known as $CAN 0.02 Dave -- Dave Morgan [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] 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: [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.com -- Author: kkennedy INET: [EMAIL PROTECTED] 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: [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: EMN0
April, I have been fighting this since installing 8.1.7 on windoze. I do an shutdown immediate in my backup script and then it will hang forever periodically. I have not had a solution suggested that has worked. Hope you get better results than I. Are you on windoze also? I know that when I researched this on metastink I found that many others also experience this. I opened a TAR but got nowhere fast. As EP would say. HELP Dave -Original Message- Sent: Monday, July 22, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Has anyone experienced problems with Database hanging on shutdown and the only error anywhere is Restarting dead background process EMN0 and that appears consistently before the inability to stop the database. I have created an Itar (which was down graded immediately...) and hunted for answers on metalink. There are two 'solutions' that they suggest. One is to ignore it... if you aren't using Advanced Queuing you don't have to worry anyway... the other is every time you shut down do shutdown abort-startup restricted- shutdown immediate... this will kill all the process (of which at the os level and the DB level the only ones running were Oracle generated processes... oratest 36146 1 0 05:59:02 - 0:07 ora_qmn0_TEST oratest 36384 1 0 05:59:02 - 0:01 ora_smon_TEST oratest 36640 1 0 05:59:02 - 0:01 ora_ckpt_TEST oratest 37156 1 0 05:59:02 - 0:00 ora_dbw0_TEST oratest 37416 1 0 05:59:02 - 0:00 ora_pmon_TEST oratest 37672 1 0 05:59:02 - 0:00 ora_lgwr_TEST oratest 41404 1 0 05:59:02 - 0:00 ora_reco_TEST ) Has anyone dealt with this successfully? It deals, from what I have gathered, with Java in the database (maybe?). Thanks in advance for any advice April Wells Corporate Systems Amarillo Texas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [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).
[no subject]
Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] 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: [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: Rant
Checking the FM (Oracle 9i Backup and Recovery Concepts). Page 4-16 gives a high level overview of the principles and Oracle 9i User Managed Backup and Recovery, chapter 4 gives a detailed description. Scenario - Loss of one or more datafiles (NOT SYSTEM) In archivelog mode Database status open Recovery - Datafiles are taken offline (automaitcally by Oracle if it can't read/write to them). Take affected tablespace(s) offline normal. Restore datafile(s) from most recent backups along with necessary archivelogs. Recover using recover tablespace tbsp1, tbsp2... Bring affected tablespace(s) online alter tablespace tbsp1 online etc. hth Correct me if I'm wrong. mkb --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: I read your rant, and I agree with you. But I do have one little itsy bitsy question... I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. How DO you do an online recovery of a datafile while the database is still in use? I've had to do recoveries before, but never this scenario. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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: Rant
You have to restore the tablespace with the datafile you want to restore to a clone database and export the datafile's contents from the clone and import it into the database with the bad datafile. HTH, R - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 12:13 PM I read your rant, and I agree with you. But I do have one little itsy bitsy question... I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. How DO you do an online recovery of a datafile while the database is still in use? I've had to do recoveries before, but never this scenario. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] 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: [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.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] 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: [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).
Customized reporting for STATSPACK?
Hey all, Finally have installed STATSPACK on 8.1.7.2.0, but am disappointed at the archaic two-lines-per-row 80-columns in spreport.sql. Anyone have any links to some report SQL that formats STATSPACK reports a little better? I'll probably use TOAD for my usage, but I'll take anything to start. Just trying to prevent the reinvention of the wheel before I go thru the whole SQL and do it myself. (Ick!) TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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: Rant
that Rachel - what a gal! PS - -- - That Barbara, what a suck-up! :) -Original Message- Sent: Monday, July 22, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Hm. these are almost verbatim the instructions I got from Rachel Charmichael after we lost a disk drive and I'd been trying to recover a database for nearly 20 hours. (That was immediately before she steered me towards the magic command that recovered the database.) --- Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. We hired the guy, he's still here 2 years later and just recently got his OCP. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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: Rant
For the GUI-challenged... Hopefully Oracle will offer a class on OEM new features with a certification test on OEM... Probably only a $2000 package and Oracle will market this so headhunters will require OEM button clicking certification before granting an interview. Feeling better now. Sardonically yours, Steve Orr Please click the X button to delete this message. -Original Message- Sent: Monday, July 22, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Importance: High you can see how often I use the GUI :) OBTW.. for those of you who are OEM fans... I heard a rumor (from a fairly well-informed, usually accurate source) that Oracle's changing it all again. T -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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: Unindexed foreign key
Perhaps that would be a better way of putting it. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Friday, July 19, 2002 5:31 PM To: Multiple recipients of list ORACLE-L I'm not sure if done away with is the appropriate term for fk locking, maybe the time exposed to locking is reduced in 9i is better ? hth connor --- Freeman, Robert [EMAIL PROTECTED] wrote: Well, that depends on if the FK is enforced or not too. There should be minimal performance impact with an unenforced FK with regards to inserts. In a DW FK's are often present but not enforced. Unenforced FK's in DW's are used for a number of reasons, query rewrite among them. Some of the old performance and locking issues with FK's were done away with in 9i. What Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Thursday, July 18, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Terrible expecially on inserts into the database, it may have to do a full table scan to insert one record. Don't do it. From: Shishir Kumar Mishra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Unindexed foreign key Date: Thu, 11 Jul 2002 04:13:36 -0800 Hi Gurus! How does the unindexed foreign key affect the performance ? regards Shishir Kumar Mishra Agni Software (P) Ltd. www.agnisoft.com -- Vidya Dadaati Viniyam -- Over and out Basher 59 _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: basher 59 INET: [EMAIL PROTECTED] 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: [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.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] 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: [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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [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
RE: Rant
The interview (exerpts from some of my actual ones, and then some made up) We are in my cube. I've studied the resume for Mr. Morias, who is a Portuguese national who's degree is from University who's name I can't pronounce and who's credentials I can't verify. He is a brand new OCP. Me: Good day Mr. (looks again at resume, I have a short term memory) Morias. Interviewee: Oi aí senhor, está bom encontraá-lo. Me: Sir, I didn't understand you, please try again.. Interviewee: Sorry sir, I forget I need speak English. Good day sir. Me: So, let's start our interview, shall we. Tell me what a rollback segment is please. Interviewee: It is the method by which Oracle database store all database changes. It is used during recovery. Me: (Figuring we have made a Jr. DBA type mistake here) Ok... and tell me about a redo log. Interviewee: It used to provide consistent image to database users. Oracle has automated redo in Oracle9i. Me: Are you sure that you don't have these kind of turned around? Redo logs are used for recovery, rollback segments are used for read consistency. Interviewee: No, you are mistaken, I know it is as I described. I've been a DBA for 10 years, I know what I am doing. Me: Ok... so, when you have a problem with a database, what do you do to solve the problem? Interviewee: I go to ORACLE-L and ask Rachel, she know everything. Me: And if she is on vacation or not responding to questions? Interviewee: I wait for Rachel to return. Me: And if Rachel were to become a Nun and never grace ORACLE-L again? Interviewee: I check out Lazy DBA, Mike Ault is there. Me: AND if the Internet were unavailable? Interviewee: (thinks for a second) I call Oracle? Me: What about the manuals? Interviewee: Oracle has Manuals? I've never seen them. Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Monday, July 22, 2002 1:54 PM To: Multiple recipients of list ORACLE-L you can see how often I use the GUI :) OBTW.. for those of you who are OEM fans... I heard a rumor (from a fairly well-informed, usually accurate source) that Oracle's changing it all again. T --- April Wells [EMAIL PROTECTED] wrote: IT'S NOT a radio button... It is a regular CLICKY button geez -Original Message- Sent: Monday, July 22, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Good rant. :) I sympathize. The answer I get more and more is I click on this item on the GUI... (I didn't ask you that, I asked you the theory behind that little radio button) --- mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the
Re[2]: Using Old version of SQL Navigator 2.0.d with Oracle
OY, what a cludge!! Dick Goulet Reply Separator Author: Dharminder Kumar [EMAIL PROTECTED] Date: 7/22/2002 8:58 AM As I was trying to get this scenario worked out, so here is what I have done to get this combination working. I deinstalled the Oracle 9i software, then installed SQL plus client for Oracle 7.3 using a Developer 2000 CD. After than I installed Oracle 9i to a different Oracle Home and now OLD Sql Navigator is able to connect to Oracle 9i. Thanks. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 1:33 PM I have an OLD version of SQL Navigator 2.0.d, which was compatible with Oracle 7.3.4. But now I have Oracle 9i installed, but I do not have client for Oracle 7.3.4. Is there is a way out that I can connect to Oracle using this SQL navigator. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharminder Kumar INET: [EMAIL PROTECTED] 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: [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.com -- Author: Dharminder Kumar INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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:
Peter, If you want to be obsessive-compulsive safe, shutdown the database. Otherwise update the system clock and don't worry about it. Our HP-UX boxes do that every spring all by themselves. Haven't had a database problem yet. Dick Goulet Reply Separator Author: Peter R [EMAIL PROTECTED] Date: 7/22/2002 10:33 AM Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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: security bug - join syntax
Bug is fixed in 9.0.1.3 (or was it .2, I forget), and is not present in 9.2 (9iR2). A backport for 9.0.1.1 is available as I recall. Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Friday, July 19, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Is this still a problem in 9iR2? I do not have it installed yet :( - Kirti -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: security bug - join syntax Thanks Linda. Usenet seems to be a little behind the curve though. Jonathan Lewis discovered this and posted on the list ( you saw it here first! ) over a month ago. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/19/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: security bug - join syntax This just in from comp.databases.oracle.server. See metalink bug 2121935. Using ANSI syntax joins (CROSS JOIN, LEFT OUTER etc) allows you to view data from tables on which you have no privilege. For example, try this COMPLETE script: connect / as sysdba create user us1 identified by us1; grant create session to us1; connect us1/us1 select userid, password from sys.link$ cross join dual ; Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED]@fatcity.com on 07/19/2002 11:04:17 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Anybody remember the bug number for the security issue with the new join syntax in 9i? Matt Adams - GE Appliances - [EMAIL PROTECTED] The ozone layer or cheese in a spray can. Don't make me choose. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [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.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] 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: [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: EMN0
There is no EMN0 process out there TO kill... that is what concerns me. There are also no user connections (haven't had the listener started in a while... it is (so far) for user testing patches, and we haven't had any patches since we got TEST. Quite honestly I like your solution better than Oracle's... they claim there is no solution other than to shutdown abort, startup restrict, shutdown immediate (EVERY time you shutdown the database... this is a legitimate way of stopping ... per metalink person) -Original Message- Sent: Monday, July 22, 2002 12:38 PM To: Multiple recipients of list ORACLE-L April: I just had something like this over the weekend. In my case, the server was trying to run 'dbms_java.stop_server'. There was some mysterious corruption in the stored Java classes that was making this process hang. If you look at 'ps' or 'top', do you see the client process from svrmgrl running at top speed? If you kill the EMN0 process, does it restart? I was able to run 'sqlplus /nolog' and 'connect internal' even after the shutdown had started, and I looked at the running SQL. That's how I found this. If indeed this is the problem, you will need to deinstall and reinstall Java. Good Luck! Mike -Original Message- Sent: Monday, July 22, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Has anyone experienced problems with Database hanging on shutdown and the only error anywhere is Restarting dead background process EMN0 and that appears consistently before the inability to stop the database. I have created an Itar (which was down graded immediately...) and hunted for answers on metalink. There are two 'solutions' that they suggest. One is to ignore it... if you aren't using Advanced Queuing you don't have to worry anyway... the other is every time you shut down do shutdown abort-startup restricted- shutdown immediate... this will kill all the process (of which at the os level and the DB level the only ones running were Oracle generated processes... oratest 36146 1 0 05:59:02 - 0:07 ora_qmn0_TEST oratest 36384 1 0 05:59:02 - 0:01 ora_smon_TEST oratest 36640 1 0 05:59:02 - 0:01 ora_ckpt_TEST oratest 37156 1 0 05:59:02 - 0:00 ora_dbw0_TEST oratest 37416 1 0 05:59:02 - 0:00 ora_pmon_TEST oratest 37672 1 0 05:59:02 - 0:00 ora_lgwr_TEST oratest 41404 1 0 05:59:02 - 0:00 ora_reco_TEST ) Has anyone dealt with this successfully? It deals, from what I have gathered, with Java in the database (maybe?). Thanks in advance for any advice April Wells Corporate Systems Amarillo Texas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] 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: [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). begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE %;G0N#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] 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: [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[2]: Rant
It might mean that you are not a fun dataRuth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 2:03 PM Caffeine calms down hyperactive people, it's one of the symptoms for that condition. As for me, beer puts me to sleep. I don't know what THAT means. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 2:13 PM To: Multiple recipients of list ORACLE-L only a dba would think of drinking coffee as something that would calm one down! har har har -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] 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: [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.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] 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: [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[2]: Rant
Ruth, Excuse me, but how is that going to fix the bad datafile? Dick Goulet Reply Separator Author: Ruth Gramolini [EMAIL PROTECTED] Date: 7/22/2002 10:13 AM You have to restore the tablespace with the datafile you want to restore to a clone database and export the datafile's contents from the clone and import it into the database with the bad datafile. HTH, R - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 12:13 PM I read your rant, and I agree with you. But I do have one little itsy bitsy question... I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. How DO you do an online recovery of a datafile while the database is still in use? I've had to do recoveries before, but never this scenario. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] 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: [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.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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: Rant
OH MY GOD, someone remembers what I said? thank goodness it worked. I've learned that my first, panicked reaction is almost invariably, if not wrong, certainly not the best way to fix something. Taking time to THINK instead of jumping in and mucking about is usually best. you can now see how bad *my* memory is, I can't remember what that magic command was :) Was it the alter datafile out of backup mode one? (see, I NEVER remember the exact SQL statement, I always hit the reference manual for syntax. There is limited storage space in my brain, if I memorize syntax I have to forget something else... like how to think logically) --- Baker, Barbara [EMAIL PROTECTED] wrote: Hm. these are almost verbatim the instructions I got from Rachel Charmichael after we lost a disk drive and I'd been trying to recover a database for nearly 20 hours. (That was immediately before she steered me towards the magic command that recovered the database.) --- Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. We hired the guy, he's still here 2 years later and just recently got his OCP. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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: OT: MicroSoft Admission
Why, it simply means that appearances are everything at M$. Let's read it carefully: Our strategy has never changed -- i.e., our consultants have always been your foe. but, it sure looked that way -- i.e., our customers started seeing our consultants as foes. diaslignment between our incentives and our resources and our strategy -- i.e., we quit paying our consultants enough to keep pretending that they were your friends which hurt our strategy of maximizing consultant revenue. That caused our consultants to look sometimes less like your friend and more like your foe than we ever have intended it to. -- i.e., we never intended for anyone to see what we are really like. 8-) Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Sunday, July 21, 2002 11:58 PM To: Multiple recipients of list ORACLE-L What the f* does this euphemistic cr*pola mean: ... | Our strategy has never changed with what we are | trying to do with consulting, but it sure looked | that way in the early part of the year because we | managed to get a disalignment between our | incentives and our resources and our strategy in | the marketplace, Ballmer said. That caused our | consultants to look sometimes less like your | friend and more like your foe than we ever have | intended it to. ... ??? On 19 Jul 2002 at 9:19, [EMAIL PROTECTED] wrote: Jared, First off my apologies for an off topic post, but considering the amount of OS discussions we have, I really don't think it's totally off base. Dick Goulet http://www.theregister.co.uk/content/4/26230.html Ballmer 'fesses up to Linux/Windows cost FUD By Thomas C Greene in Washington Posted: 16/07/2002 at 19:23 GMT ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] 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: [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.com -- Author: kkennedy INET: [EMAIL PROTECTED] 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: [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: Rant-Rant
OMG! A Socialist in the group! I believe that if we think about these things in a way that we ask ourselves how can I maximize the potential of this person in our organization, pay him/her a fair wage for what they can do, and free up my time to address the really gnarly stuff we can help our entire society better transition to the information era and not marginalize a bunch of great people in the process. The only problem with your idea that I see is that a typical organization will only keep one (or so) DBA on staff per project - they rarely have the cash for multiple people. So a DBA ends up getting called upon do cross the boundary between very technical stuff as part of the SA group and data access/design with the applications group. Lots of room in between here for talented people. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L I have been reading this list for the past several months as I prepare to move my universe of databases from 7.3 to 9 (probably 9) and I have a rant of my own. It seems that the implicit expectation is that every DBA should be or should aspire to be a Master Technical DBA. I have a slightly different take on the situation. It is a little convoluted but I believe that the DBA world needs some additional job classifications. In a decent sized organization, the day to day management functions should be accomplished by an Admin DBA who might be someone who was perfectly happy spending his/her working career operating a precision milling machine at Boeing. Since the machinist jobs are going away, I see no reason why a competent machinist could not become a competent admin DBA. Such a person is not suited by aptitude or disposition to become a Master Technical DBA, but would do a great job at the admin level. I'll extend the analogy a little more: the manufacturing organization does not expect the machinist to program the machine. They either have on staff or bring in a numerical control programming specialist. Similarly, the Admin DBA should know which tasks he/she can perform and which tasks should be kicked up or out to the next level. So maybe some of the energy spent on this list about relevance of the OCP and discussing qualifications of DBAs (against an unspecified standard) could be spent defining organizational strategies for getting the best use out of human capital represented by Admin DBAs and pricing the skill set appropriately. The worst possible thing is to get an Admin DBA into a Technical DBA position. I think the key breakthrough is the notion that there is a DBA track that does not inevitably lead to Master Technical DBA. That is why I use the machinist analogy: somebody who is satisfied with a career spending 25 years doing essentially the same thing. If you are into Myers-Briggs type indicator, I think the personality dimension is SJ and roughly 25% of the population fits this profile. I believe that if we think about these things in a way that we ask ourselves how can I maximize the potential of this person in our organization, pay him/her a fair wage for what they can do, and free up my time to address the really gnarly stuff we can help our entire society better transition to the information era and not marginalize a bunch of great people in the process. (Sez the man operating a three person software company). Re: Hotbackups. In the last three months I have adapted the scripts from the Kevin Loney book for 4 separate databases. I have inspected them very carefully to make sure all of the files are the there. I think that I understand the what, how and why of hot backups. And I still had to go look to see that it was an alter tablespace rather than an alter database command to backup the tablespace. re Politics: Given the rather idealistic tone of this missive, I guess I should add that I am down the middle Libertarian who tends to vote Republican because I'm most concerned about taxes. At 06:58 AM 7/22/2002 -0800, you wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from
Re:RE: Rant
um no, I mean they are redoing it AGAIN I love Oracle, it provides me with an ever and ever steeper learning curve --- [EMAIL PROTECTED] wrote: YUP, Saw the new version at an Oracle event in Boston a couple of months ago. Seems that nothing is sacred anymore. BTW: Installer changes too, now you need a full multimedia terminal, 4 channel audio VR headset recommended. :o) Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 7/22/2002 9:53 AM you can see how often I use the GUI :) OBTW.. for those of you who are OEM fans... I heard a rumor (from a fairly well-informed, usually accurate source) that Oracle's changing it all again. T --- April Wells [EMAIL PROTECTED] wrote: IT'S NOT a radio button... It is a regular CLICKY button geez -Original Message- Sent: Monday, July 22, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Good rant. :) I sympathize. The answer I get more and more is I click on this item on the GUI... (I didn't ask you that, I asked you the theory behind that little radio button) --- mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of
RE: Rant
You better believe it!!! next time I've been up a gazillion hours and I'm begging for help, I want the goddess to think kindly of me. -- From: Mercadante, Thomas F[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, July 22, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rant that Rachel - what a gal! PS - -- - That Barbara, what a suck-up! :) -Original Message- Sent: Monday, July 22, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Hm. these are almost verbatim the instructions I got from Rachel Charmichael after we lost a disk drive and I'd been trying to recover a database for nearly 20 hours. (That was immediately before she steered me towards the magic command that recovered the database.) --- Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. We hired the guy, he's still here 2 years later and just recently got his OCP. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [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:
Peter, Doesn't matter. Only if you are using Oracle Jobs does the time make any difference - because some jobs will lose their minds when the time changes. Same thing with any cron jobs - I would disable them before you change the time. Within Oracle itself, time is not important. All changes are tracked by an internal SCN number. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 2:34 PM To: Multiple recipients of list ORACLE-L Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] 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: [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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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[2]: Rant
Coffee in the moring for me gives me a boost. Coffee in the afternoon/evening puts me to sleep. You're a psycho/No I'm Not! Tom (splitting personalities) Mercadante -Original Message- Sent: Monday, July 22, 2002 2:29 PM To: Multiple recipients of list ORACLE-L And coffee is WAY cheaper than Addrell (my son's prescription). Caffeine helps hyperactive people focus. -Original Message- Sent: Monday, July 22, 2002 1:03 PM To: Multiple recipients of list ORACLE-L Caffeine calms down hyperactive people, it's one of the symptoms for that condition. As for me, beer puts me to sleep. I don't know what THAT means. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systemes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Region des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject:Re: Re[2]: Rant only a dba would think of drinking coffee as something that would calm one down! har har har -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] 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: [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). begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE %;G0N#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] 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: [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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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).