Re: Please share your experience with RAC on linux:)
I'm working on getting a new system up on the same (?) platform - Dell PowerEdge 6450 nodes, Dell/EMC FC4700 array, and 9i RAC. Click on the Dell/Linux Yes in the certification matrix at: http://www.oracle.com/ip/deploy/database/features/ops/certification/index.ht ml?content2.html 1) The current certification is only for RedHat 7.1 and Oracle 9.0.1, but the Dell rep says that 9.2 should be certified on RedHat Advanced Server within a month or so. There are some distinct advantages to the new RedHat release - and to 9.2. So far, we are just doing some burn-in and get aquatinted with RedHat 7.1 and 9.0.1 RAC. The SA/VP wants to go live ASAP and prefers the current config. After seeing the long list of patches to 9.0.1, some issues with it, and some serious security holes (as mentioned here a month or so ago), I am in favor of testing out 9.2 on Advanced Server and using RH7.1/Oracle9.0.1 only as a fallback position. For one thing, the Oracle-supplied cluster software is (at least) quirky in 9.0.1. It is supposed to be significantly better in 9.2. RedHat Advanced Server is supposed to add a lot also - multiple HBAs, a logical volume manager, etc. 2) I use SuSE at home and it is a much smoother Oracle install than any (6.2-7.2)RedHat - at least for Oracle 9.2. SuSE even supplies an orarun9i.rpm to configure the kernel, startup scripts, and a bunch of stuff for Oracle9i (or orarun8i.rpm for 8i). In addition, there are several very savvy SuSE technical people (e.g. Michael Hasenstein and others) who frequent the SuSE-Oracle mailing list. Oracle on RedHat (any version) seems to always require jumping through a few more flaming hoops. However, RedHat is now in bed with Oracle again - after their little falling out. Even more important is that Dell officially supports only RedHat for RAC. (They also support SuSE, but do not certify it for RAC - or, I think, Oracle in general.) 3) RAC on Dell/RedHat is headed for production soon, but no production experience yet. I'm still working out the basic cluster quirks - like why softdog wants to reboot the nodes several times per week! (The most recent, about 48 hours ago, was because nts hiccuped and the clocks on the two nodes got about 1/2 hour out of synch.) Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 9:28 AM hi, dbas: We plan to setup a new database on a Linux Cluster, using Oracle 9i RAC release 2, with Dell PC Servers (4CPU, 4G memory), to store our online history data and provide read only service and some other misc applications. So, what i care is: 1. Which Oracle version to use, release 1 or release 2. Release 1 is certified on many platforms with proper hardware and os, but release 2 is relatively new. But since oracle supports new version and there is maybe less bugs , i prefer release 2 version . Can you share your opnion? 2. Which OS to choose. Suse and Redhat is the oracle prefered version. For RAC/OPS support , is suse better than redhat? Or if i choose redhat, shall i choose the redhat 7.1(the certified version with rac release 1 on Dell machine) or Redhat Advanced Server, or redhat 7.2/7.3? 3. Has anyone here used RAC in production? Especially on Linux/RAC combination? what about your experience? Please share your valuable experience here:), thanks. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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).
Export syntax
BDY.RTF Description: RTF file
Re: Moving tables from one schema to another
hi! if it's just a few tables you can use copy copy from x/x@db to y/y@db create table_name using select * from original_table if thats not handy i would EXP the scheme and import it with imp y/y@db file=/path fromuser=x touser=y then drop the old scheme regards daniel [EMAIL PROTECTED] wrote: 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). -- Daniel Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser 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: Export syntax
C:\EXP SCOTT/TIGER TABLES=EMP QUERY='WHERE JOB IN (''MANAGER'')'
THIS WORKS FINE...
hth.
nIRMAL
(oCP?).
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L
the following syntax gives invalid col name :
exp test/test file=expt.dmp tables=x1
query=\where x1_cd in \(\'207\'\)\
EXP-8: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-0: Export terminated unsuccessfully
--
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: Export syntax
Title: RE: Export syntax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: lundi, 22. juillet 2002 23:53 To: Multiple recipients of list ORACLE-L Subject: Export syntax the following syntax gives invalid col name : exp test/test file=expt.dmp tables=x1 query=\where x1_cd in \(\'207\'\)\ EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: Export terminated unsuccessfully What version of Oracle, what OS, which UNIX shell? Are you sure you have the column name right? That syntax was successful in my test: $ sqlplus quest SQL*Plus: Release 8.1.6.0.0 - Production on Mon Jul 22 23:59:17 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. Enter password: Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production SQL describe jkilchoer.doctor Name Null? Type - DOCTOR_ID NUMBER DOCTOR_NAME VARCHAR2(30) SQL exit Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production $ exp quest file=x.dmp tables=jkilchoer.doctor query=\where doctor_name in \(\'SMITH\'\)\ Export: Release 8.1.6.0.0 - Production on Mon Jul 22 23:59:33 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. Password: Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) About to export specified tables via Conventional Path ... Current user changed to JKILCHOER . . exporting table DOCTOR 1 rows exported Export terminated successfully without warnings.
RE: Moving tables from one schema to another
Let me know why you put restriction on export/import? -Original Message- Sent: Monday, July 22, 2002 8:59 PM To: Multiple recipients of list ORACLE-L 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). -- 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: Export syntax
BDY.RTF Description: RTF file
RE: FW: bind vars change explain plan
From the O'Reilly Oracle SQL Tuning Pocket Reference There is one situation in which bind variables are not such a great choice. If you have column data in a table having a disproportionate number of rows with certain values, and a very small number of rows with other values, you should be using histograms. Bind variables cannot use histogram information. Using bind variables will prevent the optimizer from doing this, [using histograms] because the optimizer is unaware of the value that will be in the bind variable at the time it decides on the execution plan Beginning with Oracle9i, the optimizer will consider bind variable values when choosing execution plans. HTH Kev. -Original Message- Sent: 22 July 2002 17:29 To: Multiple recipients of list ORACLE-L 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
error when acessing table_privileges
Hi friends . I am getting the error ora-24238 when accessing the table table_privileges . How can I solve this .?? Oracle version is 8.1.7.4.1 in win2k. [EMAIL PROTECTED] SELECT * FROM TABLE_PRIVILEGES; ERROR: ORA-24328: illegal attribute value Thanks shibu
RE: how to force the DB to SKIP tx recovery ?
No, Instance recovery has to take place internally, SMON has to recover the committed transactions which were left hanging in the cache to datafiles so that the files become synchronized. After that the db gets opened and roll backwards takes its own time. It depends SMON does this job in the background and any other Server process if needs that block can rollback the uncommitted transaction and proceed with the block. If you wish to recover the instance recovery very fast then set the LOG_CHECKPOINT_INTERVAL,LOG_CHECKPOINT_TIMEOUT,FAST_START_IO_TARGET parameters to force the checkpoints quite often, this would open the instance under crash quite fast as it has to perform less work. But more the checkpoints initiated more the performance degradations as B'ground processes would be under tremendous work. Hope it clarifies. Vikas Khanna -Original Message- Sent: Tuesday, July 23, 2002 1:48 PM To: Multiple recipients of list ORACLE-L List, ...was doing a looog update, was taking forever, i rebooted the PC, as expected, the *open* of the instance is taking a very long time.. and i cannot wait... is there a way to open the DB *without* letting oracle perform the thread recovery ?? i just to open the DB data lose is acceptable.. TIA -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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: Vikas Khanna 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: Export syntax
Did you run catalog.sql which calls catexp.sql? Sanjay -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 23 July, 2002 4:53 PM To: Multiple recipients of list ORACLE-L Oracle Version: 8.1.7 OS : Sun Solaris Shell: ksh the following syntax gives invalid col name : exp test/test file=expt.dmp tables=x1 query=\where x1_cd in \(\'207\'\)\ EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: Export terminated unsuccessfully -- 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: how to force the DB to SKIP tx recovery ?
Vikas, even if the parameters were set for the checkpoint to happen often, all the transactions *not* commited would still be rolled back !! for example, when i shut down the PC in the middle of doing an update of 1/2 a million rows !!! (how would these parameters help?) -- From: Vikas Khanna[SMTP:[EMAIL PROTECTED]] No, Instance recovery has to take place internally, SMON has to recover the committed transactions which were left hanging in the cache to datafiles so that the files become synchronized. After that the db gets opened and roll backwards takes its own time. It depends SMON does this job in the background and any other Server process if needs that block can rollback the uncommitted transaction and proceed with the block. If you wish to recover the instance recovery very fast then set the LOG_CHECKPOINT_INTERVAL,LOG_CHECKPOINT_TIMEOUT,FAST_START_IO_TARGET parameters to force the checkpoints quite often, this would open the instance under crash quite fast as it has to perform less work. But more the checkpoints initiated more the performance degradations as B'ground processes would be under tremendous work. Hope it clarifies. Vikas Khanna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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: how to force the DB to SKIP tx recovery ?
Rahul, Instance recovery requires Rollforward and Rollbackwards. If the transaction is not committed it has to be rollbacked once the instance gets started. Let us assume that there are no committed transactions which were left in the buffer cache to be flushed back on to datafiles. This means I am left with Uncommitted txns to get them rollbackwards. This is done by SMON in the background or Server process which needs those blocks but the Instance and the db are opened and ready for use. The db is opened ie. what u wanted and that's the way Oracle does work. -Original Message- Sent: Tuesday, July 23, 2002 2:10 PM To: '[EMAIL PROTECTED]' Cc: 'Oracle List I' Vikas, even if the parameters were set for the checkpoint to happen often, all the transactions *not* commited would still be rolled back !! for example, when i shut down the PC in the middle of doing an update of 1/2 a million rows !!! (how would these parameters help?) -- From: Vikas Khanna[SMTP:[EMAIL PROTECTED]] No, Instance recovery has to take place internally, SMON has to recover the committed transactions which were left hanging in the cache to datafiles so that the files become synchronized. After that the db gets opened and roll backwards takes its own time. It depends SMON does this job in the background and any other Server process if needs that block can rollback the uncommitted transaction and proceed with the block. If you wish to recover the instance recovery very fast then set the LOG_CHECKPOINT_INTERVAL,LOG_CHECKPOINT_TIMEOUT,FAST_START_IO_TARGET parameters to force the checkpoints quite often, this would open the instance under crash quite fast as it has to perform less work. But more the checkpoints initiated more the performance degradations as B'ground processes would be under tremendous work. Hope it clarifies. Vikas Khanna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Khanna 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: Oracle - 32bit/64bit??
Just log into the database using sqlplus and it will tell you /u01/app/oraclesqlplus / SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jul 23 10:16:50 2002 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production With the Partitioning option JServer Release 9.0.1.2.0 - Production SQL -Original Message- Sent: 23 July 2002 00:09 To: Multiple recipients of list ORACLE-L Hi, Does anyone know how I can verify if a database is 32 or 64 bit? Thanks. elain _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: elain he 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe 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: Oracle - 32bit/64bit??
If 64 bit then Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production else Oracle9i Enterprise Edition Release 9.0.1.2.0 end if; Vikas Khanna -Original Message- Sent: Tuesday, July 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Just log into the database using sqlplus and it will tell you /u01/app/oraclesqlplus / SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jul 23 10:16:50 2002 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production With the Partitioning option JServer Release 9.0.1.2.0 - Production SQL -Original Message- Sent: 23 July 2002 00:09 To: Multiple recipients of list ORACLE-L Hi, Does anyone know how I can verify if a database is 32 or 64 bit? Thanks. elain _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: elain he 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe 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: Vikas Khanna 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
Security is like insurance, people don't want to think about it. Like people in battle, everyone tells themselves that the person next to them will be the one to get shot. And they advance over the ridge, facing the sun... 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] -- 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).
Discoverer 9i: Export data to PDF gives internal error
Hi there! In discoverer 9.0.2.39.01 (desktop edition), EUL 5.0.0.0.0.0 the export data option to PDF gives the following error: Internal Error in generating report Export failed. In MetaLink you can find bug 780474 for Discoverer 3! It seems to be the same bug?! If there is a workaround please send a hint to the list. Anybody out there who can give me a hint? Best regards! Henrik Henrik Bachmannmailto:[EMAIL PROTECTED] B.I.M.-Consulting Magdeburghttp://www.bim-consulting.de/ D-39108 Magdeburg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bachmann, Henrik 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
Mike: According to the docs, the first time an query is parsed, Oracle peaks at the bind variable and bases the explain plan on those values. The values of the bind variables are never looked at again Kevin -Original Message- Sent: Tuesday, July 23, 2002 6:58 AM To: Multiple recipients of list ORACLE-L Hi, Beginning with Oracle9i, the optimizer will consider bind variable values when choosing execution plans. Does anyone know how Oracle manages to do this? The 9i Database Performance Tuning Guide infers that the treatment of bind variables has not changed but maybe we attribute this to manual lag. Presumably it must perform some kind of parse to rejig the execution plan despite the use of bind variables. Somewhere between hard and soft perhaps. A fairly solid parse. Anyone know the mechanics of this? Has anyone seen this new functionality in practice? Cheers, Mike Hately -Original Message- Sent: 23 July 2002 09:58 To: Multiple recipients of list ORACLE-L From the O'Reilly Oracle SQL Tuning Pocket Reference There is one situation in which bind variables are not such a great choice. If you have column data in a table having a disproportionate number of rows with certain values, and a very small number of rows with other values, you should be using histograms. Bind variables cannot use histogram information. Using bind variables will prevent the optimizer from doing this, [using histograms] because the optimizer is unaware of the value that will be in the bind variable at the time it decides on the execution plan Beginning with Oracle9i, the optimizer will consider bind variable values when choosing execution plans. HTH Kev. 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike 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: Toepke, Kevin M 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
Anita
Oracle Support doesn't really care why it is happening. All I get is, hangs
happen, your two options are shutdown abort/startup restricted/shutdown
immediate (a valid solution) or putting in Dead Connection Detection and
adding overhead. The ever so wonderful Metalink has at least a dozen or
more docs that return on a search of EMN0, all of them acknowledging that
these happen, about half commenting that you only have to worry if AQ is
used, but the other half saying, yeah we know, this is the work around, get
over it. Per the assigned analyst There is nothing we can do to prevent
shutdown immediate hang sometimes. Oh, and this... feature... is not fixed
in 9i, and frequently appears to have something to do with Java in the
database.
Thank you for the help.
April
-Original Message-
Sent: Tuesday, July 23, 2002 12:53 AM
To: Multiple recipients of list ORACLE-L
April,
The Restarting dead background process EMN0 message
immediately prior to a shutdown is an annoying, but
harmless message. The EMN0 process is not started
unless AQ is used and even then it will be killed if
it sits idle long enough. Upon shutdown, however, it
can get awakened to ensure that it processes any
existing messages, if any, and thus this message is
written to the alert.log.
Do you have any shutdown triggers that could be
preventing the db from shutting down cleanly? The
best thing to do to get to the root of the hang is to
take several system state dumps (at least 3, 1 - 2
minutes apart) while the system appears to be hanging.
Connected as internal or a SYSDBA user:
ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME
SYSTEMSTATE LEVEL 10';
System state dumps can be rather large so you may want
to ensure that max_dump_file_size is set very high or
change it before generating the system state dump:
ALTER SESSION SET MAX_DUMP_FILE_SIZE=UNLIMITED;
Oracle Support should be able to determine from them
why the shutdown appears to be hanging.
HTH,
-- Anita
--- April Wells [EMAIL PROTECTED] wrote:
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
MM 5AE(EN9F]R;6%T:6]N
M(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!SM
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T
M:4@:6YT96YD960@=7-EM
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
MM 2!PFEV:6QE9V5D(%N
M9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@M
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L
M;W-UF4L('5S92!OB!CM
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
MM ;B!T:4@:6YT96YD960@
MF5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B
MM@268@6]U(AA=F4@F5C96EV960@=AIR!M97
MM 86=E(EN(5RF]R+!P
M;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961IM
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!O
MF%T92!37-T96US+!)M
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
MM 96YS=7)E('1H870@86YY
M(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%SM
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A
M8V-E'0@;F\@;EA8FELM
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
MM ;V9T=V%R92!V:7)UV5S
M(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5RM
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI
M;F@86YY(%T=%C:UE %;G0N#0H M
M %.$MM
M -- M
Re: Re: Please share your experience with RAC on linux:)
Don Granaman£¬ I write to dell and they said: // We are working on a certified configuration of Oracle 9iRAC - Release 2 on RH Advanced Server on the 6650 platforms. This certified configuration will be available soon. I have cc'ed our Product Marketing Manager, Nicolas Pujol and Stan Nguyen, our Marketing Manager in Dell-Asia, so that they can provide you with more information. // I have another thread open in dbforums:http://dbforums.com/t432663.html, you can take a look there. Redhat Advanced Server seems to be a good choice, but it seems need seperate license, even if we do not buy the technical support, right? 3) RAC on Dell/RedHat is headed for production soon, but no production experience yet. I'm still working out the basic cluster quirks - like why softdog wants to reboot the nodes several times per week! (The most recent, about 48 hours ago, was because nts hiccuped and the clocks on the two nodes got about 1/2 hour out of synch.) We currently have a ops on Suse Linux cluster, and now it seems ok, we rebooted it after it run 60 days. In the beginning, it rebooted every one week also, after i distribute the work load to the two machine, it seems much more stable. Nice that we can communicate on the same configuratoin:) Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 9:28 AM hi, dbas: We plan to setup a new database on a Linux Cluster, using Oracle 9i RAC release 2, with Dell PC Servers (4CPU, 4G memory), to store our online history data and provide read only service and some other misc applications. So, what i care is: 1. Which Oracle version to use, release 1 or release 2. Release 1 is certified on many platforms with proper hardware and os, but release 2 is relatively new. But since oracle supports new version and there is maybe less bugs , i prefer release 2 version . Can you share your opnion? 2. Which OS to choose. Suse and Redhat is the oracle prefered version. For RAC/OPS support , is suse better than redhat? Or if i choose redhat, shall i choose the redhat 7.1(the certified version with rac release 1 on Dell machine) or Redhat Advanced Server, or redhat 7.2/7.3? 3. Has anyone here used RAC in production? Especially on Linux/RAC combination? what about your experience? Please share your valuable experience here:), thanks. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: Rant
But if you restore to a clone and then export and import you won't have the tablespace offline will you? RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 1:53 AM What Ruth describes is tablespace point in time recovery or incomplete recovery. I believe the question was about performing complete recovery on a single tablespace while the rest of the database is in use. (I could be wrong in this assumption.) If a single tablespace (other than SYSTEM!) needs complete recovery, then: 1) SQL alter tablespace BAD_ONE offline; 2) restore corrupted tablespace datafile(s) from backup 3) restore archive log(s) from backup if necessary 4) SQL recover tablespace BAD_ONE; 5) SQL alter tablespace BAD_ONE online; While this is happening, object in other tablespaces are fully accessible, except that there may be some issues with objects in other tablespaces that reference objects in the BAD_ONE tablespace (e.g. foreign key constraints referencingtables in BAD_ONE, tables in other tablespaces with CLOBs stored out-of-line in BAD_ONE, tables with primary or unique key constraint indexes in BAD_ONE, etc.). There are a few variations on the theme for step 5 - for example, recover datafile perhaps if all the datafiles for the tablespace are not corrupted. Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 1:13 PM 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: Don Granaman 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
Re: Myers-Briggs
um the I doesn't mean stubbornness it's where you get your energy -- from yourself (Introvert) or from others (Extrovert) it's the Feeling part that makes me wonder about the DBA/computer stuff... aren't geeks supposed to be loners? --- Boivin, Patrice J [EMAIL PROTECTED] wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. Both my parents are psychologists, go figure. 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 5:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: 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). __ 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
my constant comment to management is If I am doing my job right, you should be wondering why you are paying me this much money. When the world blows up and I fix it, fast, you will KNOW why you are --- Joe Testa [EMAIL PROTECTED] wrote: mkb, you're right, the glory is in tuning nowadays, but i beg to differ, since if you can't/won't do recovery when the chips are down, then the point is moot. I specialize in backup/recovery but getting damagement to think its important today when the db is running fine, is tough. Its only when its time to do recovery does damagement all of a sudden think its important. Joe mkb 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: Joe Testa 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: Myers-Briggs
Where do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this? Rodd Holman On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373
Re: Rant
I start those discussions with are you SURE you want to depend on me being ethical and honest as your security policy? --- Tim Gorman [EMAIL PROTECTED] wrote: I agree that the glory is in tuning, but I also think backup/recovery gets a sufficient amount of respect. It's nice now that advocating RMAN isn't considered snake-oil... Where I get funny looks these days is when I discuss database security. I try to defuse the tension by quoting the old saw about just because you're paranoid doesn't mean they're not out to get you, but people still fidget and look away in pity as if I've lost my mind. I asked two audiences recently how many people utilize the SYSOPER role, and only one person in the second audience raised his hand. Similar effect if you ask about password management... ...I have to admit that some of the scarier folks are the ones who agree totally, though... :-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 8:28 PM mkb, you're right, the glory is in tuning nowadays, but i beg to differ, since if you can't/won't do recovery when the chips are down, then the point is moot. I specialize in backup/recovery but getting damagement to think its important today when the db is running fine, is tough. Its only when its time to do recovery does damagement all of a sudden think its important. Joe mkb 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: Joe Testa 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: Tim Gorman 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
Re: RE: Rant
Banish him to the hinter lands, (where ever they are) and let us purify the list! And Gary, I have root privileges! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 4:49 PM hey - who is this SA and what is he doing here? this is where us'n DBA's get to trash everybody else. go away! -Original Message- Sent: Monday, July 22, 2002 4:10 PM To: Multiple recipients of list ORACLE-L um, I'd schedule step 6 AFTER the backup finishes... I've seen idiot SA's who start the backup then shutdown the machine or kill the process before it completes. Yeah? And there's a good reason we SAs keep root privileges away from you DBAs. :-)) 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). -- 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: 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: SQL Query
Title: RE: SQL Query I hope this is not to late for you. Anyway, this questions comes up often. Below is the solution to pivot rows for up to 12 values of field1. Just adjust to fit your range of values. HTH Tony Aponte Home Shopping Network, Inc. create table tab1 (field1 number,field2 varchar2(30)); insert into tab1 values( 1,'RAM'); insert into tab1 values( 1,'SHAM'); insert into tab1 values( 1,'PAT'); insert into tab1 values( 2,'MAN'); insert into tab1 values( 2,'JOHN'); commit; SELECT g1 ,MAX(DECODE(line_no,01,value,NULL)) || MAX(DECODE(line_no,02,value,NULL)) || MAX(DECODE(line_no,03,value,NULL)) || MAX(DECODE(line_no,04,value,NULL)) || MAX(DECODE(line_no,05,value,NULL)) || MAX(DECODE(line_no,06,value,NULL)) || MAX(DECODE(line_no,07,value,NULL)) || MAX(DECODE(line_no,08,value,NULL)) || MAX(DECODE(line_no,09,value,NULL)) || MAX(DECODE(line_no,10,value,NULL)) || MAX(DECODE(line_no,11,value,NULL)) || MAX(DECODE(line_no,12,value,NULL)) FROM (SELECT g1,value,row_number() over(partition by g1 order by g1 nulls last) line_no FROM (SELECT field1 g1,field2 value from tab1) ) GROUP BY g1; G1 MAX(DECODE(LINE_NO,01,VALUE,NU 1 RAMSHAMPAT 2 MANJOHN -Original Message- From: Ramasubramanian, Shankar (Cognizant) [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 4:35 PM To: Multiple recipients of list ORACLE-L Subject: SQL Query Hi Friends, I just need a help in a sql . I am having rows in a table as follows Field1(ID) Field2(NAME) -- 1 RAM 1 SHAM 1 PAT 2 MAN 2 JOHN Now i want the output to be as follows FIELD1 FIELD2 -- 1 RAMSHAMPAT 2 MANJOHN In the output i have to show all the names for the same id in a single row. Please help me in getting this output using a SQL query and not through cursors. Thanks in advance. Regards, Shankar
RE: 9i RAC on NetApp
It makes it possible to upgrade without bringing the entire cluster down. Erik -Original Message- From: Orr, Steve [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 7:54 PM To: Multiple recipients of list ORACLE-L Subject: 9i RAC on NetApp I'm looking at the NetApp install procedure for 9i RAC and it says that $ORACLE_HOME is not to be shared across the cluster nodes. Why? Is this really impossible? I understand that the files under the $ORACLE_BASE/admin/ORACLE_SID/?dump directories (and other files) should not be shared but is there any REAL reason the executables can't be shared? Has anyone done this on NetApp? Curious. Steve Orr Bozeman, Montana (P.S. Walt and I are playing together on a NetApp 820c eval box for a month so we're RAC'ing on the toaster too.) -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik 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: Rant-Rant
so sweet. so deluded. I'm one of the chronological seniors here.. not the oldest I've found but close on the other hand, AARP (American Association of Retired People) hasn't started sending me their propaganda yet --- [EMAIL PROTECTED] wrote: I didn't know that they gave Managers jobs to people under 20 :-) 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. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22-07-2002 07:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Rant-Rant Oh I know. I was lucky my last job, we had two full-time DBAs (one senior - me, and one junior/mid) and one senior DBA consultant. I *did* look at my boss last week and said I no longer work 20 hour days. Not that I had to. He's good, he's very adamant about the fact that if there is too much work for one person, we will either hire consultants or the deadlines will be changed. I'd fall in love with him but he's way too young for me. :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Rachel, you are actually proving my point - that a company does not have the luxury (or common sense) to have more than one DBA on staff. Robert's utopia just doesn't fly in todays world. hire one person and work-em till they drop is the current motto. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 3:24 PM To: Multiple recipients of list ORACLE-L 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 excuse me while I wipe the Diet Coke off the screen that I spit out when I read this. One DBA per project? Oh God that would be a luxury beyond belief. As I type this I am the DBA for: a new data mart/data warehouse project a new content management system project a new ecommerce project the existing universal login project AND the replacement project the existing asset management application the existing community site (bulletin boards) and anything else that needs a DBA ... and I am it, ain't no other DBAs around .. oh yeah, I'm the data architect and data modeler on half these as well... which is REALLY funny as I have almost zero data modeling experience, other than common sense --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: 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
locking issues in web based applications
Hi I'm not very familiar with web based application development. One of our programmers has asked me a question regarding locking issues in web based applications.In a typical scenario , users access the oracle database thro a browser via app-svr/web-svr . Connection pooling is implemented on the web-svr to support large no of users. If a user locks some objects via updates or deletes , then kills his browser , the objects remains locked. The question is how to design the system such that abnormal client browser termination does not lock any objects.One solution is not to lock objects at all , and commit immediately after update if the object timestamp has not changed .But this approach is suitable only for short sweet transactions. Connection timeout is too time-taking for intensive applications to be of any use. There must be other better ways of doing this. I need your suggestions. TIA, ratnesh --- Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/110/128/350 Ext. 2107 Home : (91 22) 8662162 http://www.patni.com World-Wide Partnerships. World-Class Solutions. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh 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: OEM changes
Now please, please tell me you don't REALLY talk about this geeky stuff at parties! Jim -Original Message- Sent: Monday, July 22, 2002 9:53 PM To: Multiple recipients of list ORACLE-L Wish I could. This was at a party, and the person speaking was an Oracle employee. We were talking/ranting about how often Oracle changes things and he mentioned that OEM was changing AGAIN. That's all he said Rachel --- Boivin, Patrice J [EMAIL PROTECTED] wrote: Rachel, Could you shed any light on the changes they are proposing? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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
-Anniversary -Wife's birthday Suck up. ;o) -Original Message- Sent: Monday, July 22, 2002 3:10 PM To: Multiple recipients of list ORACLE-L For me, two things are embedded in permanent memory Anniversary Wife's birthday All that is good flows from these (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) -- 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). -- 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).
archived log file shipping to standby site from master site
Hi Guys , I have a standby server at diffrent city and Automotic log transfer which is performed via listener is not fast fast becuase of our network structer and so I have decided to ship logs via an autotamed shell ftp script but may be is there an intellegent tool for this kind of tasks. Is there any body have info about any toools
Index performance
Hi
I am executing following query adn this query hits a number of indices on
this table.let me know what is wrong please.all in where clause are having
indexes.
select name,last_access, reg_date from empmaster where emp_id100
and reg_dateto_date('2001-01-01','-MM-DD') and
emp_st='valid' and last_accessto_date ('2001-01-01','-MM-DD')
and emp_status='S' and match='FIRST'
Here all conditions in where clause are having indexes.
How to rewrite this query.
The primary key is emp_id.
Thanks
-Seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
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).
Recompiling blocked package - locating blocking session
Had a problem this morning where a package was invalid and it would hang when we tried to recompile. We assumed that some other session was trying to recompile it but was hanging for some reason. I have plenty of ways to look at table locks but don't have a query to show locked packages. Frantic searching through the index of the SQL PL/SQL Annotated Archives didn't help. I ended up searching the Active sessions that looked likely and killing them (and needing to do a kill -9 on the OS level as well) until I was able to recompile the package. Does anyone have a query that will save the random searching next time? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Myers-Briggs
do a search for Meyers-Briggs and there are sites A lot of companies use this as a way of finding out what type a person is so you can learn how to deal with the people you work with. It's supposed to help with management styles etc --- Rodd Holman [EMAIL PROTECTED] wrote: Where do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this? Rodd Holman On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. 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 of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ 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-Rant
What's your mailing address? I can make the arrangements for you. Ken Janusz,CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 8:33 AM so sweet. so deluded. I'm one of the chronological seniors here.. not the oldest I've found but close on the other hand, AARP (American Association of Retired People) hasn't started sending me their propaganda yet --- [EMAIL PROTECTED] wrote: I didn't know that they gave Managers jobs to people under 20 :-) 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. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22-07-2002 07:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Rant-Rant Oh I know. I was lucky my last job, we had two full-time DBAs (one senior - me, and one junior/mid) and one senior DBA consultant. I *did* look at my boss last week and said I no longer work 20 hour days. Not that I had to. He's good, he's very adamant about the fact that if there is too much work for one person, we will either hire consultants or the deadlines will be changed. I'd fall in love with him but he's way too young for me. :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Rachel, you are actually proving my point - that a company does not have the luxury (or common sense) to have more than one DBA on staff. Robert's utopia just doesn't fly in todays world. hire one person and work-em till they drop is the current motto. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 3:24 PM To: Multiple recipients of list ORACLE-L 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 excuse me while I wipe the Diet Coke off the screen that I spit out when I read this. One DBA per project? Oh God that would be a luxury beyond belief. As I type this I am the DBA for: a new data mart/data warehouse project a new content management system project a new ecommerce project the existing universal login project AND the replacement project the existing asset management application the existing community site (bulletin boards) and anything else that needs a DBA ... and I am it, ain't no other DBAs around .. oh yeah, I'm the data architect and data modeler on half these as well... which is REALLY funny as I have almost zero data modeling experience, other than common sense --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: 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
RE: Rant-Rant
OH, to be young again and know what I know now. AARP has some nice offers when you travel. Mentioning the youth in management, At my last job (pre golden handshake) I loved letting my manager know that I had more time in the company then they had on the face of the earth. . It helped when discussions and decisions had to be made by the group. The wisdom of the silver hair helped. Ron ROR mª¿ªm [EMAIL PROTECTED] 07/23/02 09:33AM so sweet. so deluded. I'm one of the chronological seniors here.. not the oldest I've found but close on the other hand, AARP (American Association of Retired People) hasn't started sending me their propaganda yet --- [EMAIL PROTECTED] wrote: I didn't know that they gave Managers jobs to people under 20 :-) 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. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22-07-2002 07:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Rant-Rant Oh I know. I was lucky my last job, we had two full-time DBAs (one senior - me, and one junior/mid) and one senior DBA consultant. I *did* look at my boss last week and said I no longer work 20 hour days. Not that I had to. He's good, he's very adamant about the fact that if there is too much work for one person, we will either hire consultants or the deadlines will be changed. I'd fall in love with him but he's way too young for me. :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Rachel, you are actually proving my point - that a company does not have the luxury (or common sense) to have more than one DBA on staff. Robert's utopia just doesn't fly in todays world. hire one person and work-em till they drop is the current motto. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 3:24 PM To: Multiple recipients of list ORACLE-L 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 excuse me while I wipe the Diet Coke off the screen that I spit out when I read this. One DBA per project? Oh God that would be a luxury beyond belief. As I type this I am the DBA for: a new data mart/data warehouse project a new content management system project a new ecommerce project the existing universal login project AND the replacement project the existing asset management application the existing community site (bulletin boards) and anything else that needs a DBA ... and I am it, ain't no other DBAs around .. oh yeah, I'm the data architect and data modeler on half these as well... which is REALLY funny as I have almost zero data modeling experience, other than common sense --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: 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:
RE: Is Oracle University Courses reqd for OCP Upgrade ??
As I understand it the classes are required now to get certified straight from nothing to 9i. Only a test is required to go from 8i to 9i. Also, I believe it is only one course to get OCP. It is two more advanced courses for OCM. -Original Message- Sent: Friday, July 19, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Dear List, Is it compulsory to take Oracle University courses for OCP upgrade exams also? I heard that Oracle made it compulsory to take atleast 2 OU courses to get OCP certification. Thanks, -- Babu -Original Message- Sent: Friday, July 19, 2002 8:08 AM To: Multiple recipients of list ORACLE-L I am a Newbee, preparing for OCP/DBA Oracle8i Exams. I would appreciate if some one can help me for the following queries. 1)When exactly Oracle8i is expiring? ... - 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 Product Obsolescence / Desupport Information: Oracle Corporation announces the end of Error Correction Support for Oracle Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC Standard Edition/Workgroup Server version(s) 8.1.7 (8i) on the following platform(s): ALL Platforms, effective 31-DEC-2003. Oracle Corporation recommends customers upgrade/migrate to the following as soon as possible to maintain the highest level of support: Customers running on one of Oracle's strategic platforms should upgrade to the current version of Oracle Server. Please refer to the most current version of Oracle's Strategic Platform Advisory published on Metalink. At the time of this notice, Oracle Server 9.0.1 is the current release but it is likely that others may be released prior to the desupport date for 8.1.7. Customers who are NOT running on one of the above-mentioned strategic platforms should plan to migrate to a then-supported platform in time to upgrade to a currently-supported version of Oracle Server. EAS will be provided until 31-DEC-2006, if the customer has a current support contract in place. EAS includes the following: EAS does NOT include 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 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: EMS does NOT include 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 Certification with supported products, newer operating system versions or new compilers 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
Re: Rant-Rant
AARP has already stopped sending me propaganda. I think I am the oldest on the list. RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 9:33 AM so sweet. so deluded. I'm one of the chronological seniors here.. not the oldest I've found but close on the other hand, AARP (American Association of Retired People) hasn't started sending me their propaganda yet --- [EMAIL PROTECTED] wrote: I didn't know that they gave Managers jobs to people under 20 :-) 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. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22-07-2002 07:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Rant-Rant Oh I know. I was lucky my last job, we had two full-time DBAs (one senior - me, and one junior/mid) and one senior DBA consultant. I *did* look at my boss last week and said I no longer work 20 hour days. Not that I had to. He's good, he's very adamant about the fact that if there is too much work for one person, we will either hire consultants or the deadlines will be changed. I'd fall in love with him but he's way too young for me. :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Rachel, you are actually proving my point - that a company does not have the luxury (or common sense) to have more than one DBA on staff. Robert's utopia just doesn't fly in todays world. hire one person and work-em till they drop is the current motto. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 3:24 PM To: Multiple recipients of list ORACLE-L 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 excuse me while I wipe the Diet Coke off the screen that I spit out when I read this. One DBA per project? Oh God that would be a luxury beyond belief. As I type this I am the DBA for: a new data mart/data warehouse project a new content management system project a new ecommerce project the existing universal login project AND the replacement project the existing asset management application the existing community site (bulletin boards) and anything else that needs a DBA ... and I am it, ain't no other DBAs around .. oh yeah, I'm the data architect and data modeler on half these as well... which is REALLY funny as I have almost zero data modeling experience, other than common sense --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: 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
RE: locking issues in web based applications
Ratnesh I assume you are using the JDBC interface, rather than J2EE. You may want to consider buying the book Java Programming with Oracle JDBC by Donald Bales. He devotes a chapter to this subject. One issue he raises that will limit your options is whether you have other applications besides your Web-based application accessing this database. If not, that gives you additional flexibility. Bales distinguishes between locking and detection. He contends that locking alone does not solve the problem of multiuser data access integrity, and offers several examples to support his contention. He then outlines 3 methods for employing detection. He defines detection as the ability to detect if data you are about to modify has changed since the point when you selected it to be updated. 1. Pessimistic. Use an updatestamp 2. Pessimistic. Compare all the columns in the table or attributes of an object with their original values. 3. Optimistic. Compare only modified columns or attributes in a WHERE clause. I wish I could speak from experience, but I think this author has studied this issue in more detail than I could. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 23, 2002 8:53 AM To: Multiple recipients of list ORACLE-L Hi I'm not very familiar with web based application development. One of our programmers has asked me a question regarding locking issues in web based applications.In a typical scenario , users access the oracle database thro a browser via app-svr/web-svr . Connection pooling is implemented on the web-svr to support large no of users. If a user locks some objects via updates or deletes , then kills his browser , the objects remains locked. The question is how to design the system such that abnormal client browser termination does not lock any objects.One solution is not to lock objects at all , and commit immediately after update if the object timestamp has not changed .But this approach is suitable only for short sweet transactions. Connection timeout is too time-taking for intensive applications to be of any use. There must be other better ways of doing this. I need your suggestions. TIA, ratnesh --- Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/110/128/350 Ext. 2107 Home : (91 22) 8662162 http://www.patni.com World-Wide Partnerships. World-Class Solutions. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh 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: 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).
IO wait
All, We are tuning a new vital process on our data warehouse, and it is IO intensive - lots of parallel direct reads and writes. During our testing we are driving IO wait to ~60% (per top). questions: 1) is top a valid measure of IO wait? 2) Is a high io wait an issue to be concerned about? 3) how else can it be accurately measured? 4) How can I link IO wait to what is happening inside the database? Thanks, Jack __ 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: Jack Silvey 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: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate What I sometimes use is alter system checkpoint startup force restrict shutdown normal -Rich -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 10:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] The solutions (the ones that I got) aren't good ones. Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID solution'???) This might be a naive question, but why is - shutdown immediate better than - shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
Re: Myers-Briggs
Here is the online test, very interesting. I am INTJ as well. http://www.humanmetrics.com/cgi-win/JTypes1.htm Jack That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. 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 of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ 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: Jack Silvey 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: Myers-Briggs
We used to use these at my last company, and I turned out to be a High C.. Which actually meant that I was a classic sales person profile.. Funny.. I always thought of myself as more of a techie in a sales persons role.. ;) -Original Message- Carmichael Sent: 23 July 2002 16:18 To: Multiple recipients of list ORACLE-L do a search for Meyers-Briggs and there are sites A lot of companies use this as a way of finding out what type a person is so you can learn how to deal with the people you work with. It's supposed to help with management styles etc --- Rodd Holman [EMAIL PROTECTED] wrote: Where do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this? Rodd Holman On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systhmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rigion des Maritimes, MPO of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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
RE: Rant-Rant
Hmmm... thats intersting. I'm somewhat your junior and I've been getting their propaganda for a couple of years already. -Original Message- Sent: Tuesday, July 23, 2002 9:34 AM To: Multiple recipients of list ORACLE-L so sweet. so deluded. I'm one of the chronological seniors here.. not the oldest I've found but close on the other hand, AARP (American Association of Retired People) hasn't started sending me their propaganda yet --- [EMAIL PROTECTED] wrote: I didn't know that they gave Managers jobs to people under 20 :-) 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. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22-07-2002 07:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Rant-Rant Oh I know. I was lucky my last job, we had two full-time DBAs (one senior - me, and one junior/mid) and one senior DBA consultant. I *did* look at my boss last week and said I no longer work 20 hour days. Not that I had to. He's good, he's very adamant about the fact that if there is too much work for one person, we will either hire consultants or the deadlines will be changed. I'd fall in love with him but he's way too young for me. :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Rachel, you are actually proving my point - that a company does not have the luxury (or common sense) to have more than one DBA on staff. Robert's utopia just doesn't fly in todays world. hire one person and work-em till they drop is the current motto. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 3:24 PM To: Multiple recipients of list ORACLE-L 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 excuse me while I wipe the Diet Coke off the screen that I spit out when I read this. One DBA per project? Oh God that would be a luxury beyond belief. As I type this I am the DBA for: a new data mart/data warehouse project a new content management system project a new ecommerce project the existing universal login project AND the replacement project the existing asset management application the existing community site (bulletin boards) and anything else that needs a DBA ... and I am it, ain't no other DBAs around .. oh yeah, I'm the data architect and data modeler on half these as well... which is REALLY funny as I have almost zero data modeling experience, other than common sense --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: 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
RE: archived log file shipping to standby site from master site
Arslan - Have you looked at mapping a network drive (or is that what you mean by automatic log transfer)? What do you mean that it is not fast, and why should an FTP be faster? For example, is it a matter of the time taken to transfer each log, or the amount of network bandwidth used? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 23, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Hi Guys , I have a standby server at diffrent city and Automotic log transfer which is performed via listener is not fast fast becuase of our network structer and so I have decided to ship logs via an autotamed shell ftp script but may be is there an intellegent tool for this kind of tasks. Is there any body have info about any toools -- 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: Myers-Briggs
http://www.humanmetrics.com/cgi-win/JTypes1.htm -Original Message-From: Rodd Holman [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 11:18 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Myers-BriggsWhere do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this? Rodd Holman On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. 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 of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373
Loading tables from XML files
Is there a utility similar to SQLLDR which will load tables from XML files? I found the Java and PL/SQL APIs for loading tables from XML files and wrote a trivial Java application to load data so my immediate problem is solved. I just wanted to make sure that I hadn't missed a simpler way to do it. thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter 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
Has anybody ever come across a virus that affects Oracle db's via sqlnet? Just curious how such a thing would work (have some ideas). There have to be thousands of vulnerable db's out there (sys/change_on_install, system/manager, etc.) (I've been reading Tom Clancy lately... Getting even more paranoid!) - Jerry -Original Message- Sent: Tuesday, July 23, 2002 7:39 AM To: Multiple recipients of list ORACLE-L Security is like insurance, people don't want to think about it. Like people in battle, everyone tells themselves that the person next to them will be the one to get shot. And they advance over the ridge, facing the sun... 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] -- 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). This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient(s). Any review, reliance, or distribution by others or forwarding without permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cunningham, Gerald 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: 9i RAC on NetApp
On an installation on a Tru64 Cluster, with the Cluster-File-System, there *is* only 1 ORACLE_HOME, shared by both nodes. I don't see why it cannot be done on another platforms, provided that the platform allows the file-system to be mounted on both nodes concurrently. Hemant At 03:53 PM 22-07-02 -0800, you wrote: I'm looking at the NetApp install procedure for 9i RAC and it says that $ORACLE_HOME is not to be shared across the cluster nodes. Why? Is this really impossible? I understand that the files under the $ORACLE_BASE/admin/ORACLE_SID/?dump directories (and other files) should not be shared but is there any REAL reason the executables can't be shared? Has anyone done this on NetApp? Curious. Steve Orr Bozeman, Montana (P.S. Walt and I are playing together on a NetApp 820c eval box for a month so we're RAC'ing on the toaster too.) -- 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). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale 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
That happens even to us SAs who are also DBAs (or vice versa). About five years ago, I was explaining DCL and VMS to a new co-worker and describing how I help protect against accidental file deletion by having DEL*ETE :== DELETE/LOG/CONFIRM in my SYS$LOGIN:LOGIN.COM. So, I confidently issued a DEL *.*.* -- in SYS$LIBRARY -- after running AUTOGEN. Seasoned VMS SAs know that AUTOGEN quietly deletes all global symbols, including those protecting accidental file deletes. After a Putz! comment from our Operations group, the files were given an emergency restore. The thing is that I knew better. Doing DBA work in Oracle, however, has made me even more paranoid. Hasn't happened since and I don't rely on site addons to protect me from myself. Now I know, and knowing is half the battle. -- G.I.Joe, a real American Hero :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 9:14 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Rant you betcha. okay, I'll tell a story on myself. I really am usually very careful about doing something that is a sweeping change without checking either the directory I'm in or doing it so that I have to confirm. VAX/VMS, in my home directory. I could have SWORN I was in a temp directory, my login was supposed to be set up to tell me the directory I was in. It wasn't, 'cause I did the VMS equivalent of rm * and deleted EVERYTHING in my home directory (scripts, notes, login profile) I very meekly called the data center and asked them to please please restore my directory from the prior night's backup tape. After they stopped laughing, they made it a rush. See, I used to buy them pizza if I had to ask them to work late and do extra stuff. I know my limitations. I'm a pretty good general DBA but I ain't an SA Rachel -- 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: Myers-Briggs
Beware of self-reports! They are notoriously innacurate. e.g. ask people what they will be doing in the next three years, they are almost always wrong. Ask them what they are like, ask them their traits, and often they are wrong. Wishful thinking kicks in, perhaps. Also when people think something is a big concern, often it is because they focus on that particular trait - most people probably don't pay attention to it as much. E.g. my mother-in-law keeps saying she can't do anything right, that it takes her longer than everyone else to get things done properly... turns out she is a perfectionist! Same thing with the enneagram, people's self-image tends to discard chief feature, they think their personality revolves around something else. : ) anyway, back to DBA work. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, July 23, 2002 12:29 PM To: Multiple recipients of list ORACLE-L Subject:Re: Myers-Briggs Here is the online test, very interesting. I am INTJ as well. http://www.humanmetrics.com/cgi-win/JTypes1.htm Jack That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. 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 of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ 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: Jack Silvey 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City
RE: OEM changes
not often... but there were at least 8 or 10 people there who were DBAs and this party was the thank goodness the darned book is done party so we started talking about writing books and someone said something about OEM 101 and I'm usually the one at the party saying (screaming?) NO MORE GEEK TALK :) --- Conboy, Jim [EMAIL PROTECTED] wrote: Now please, please tell me you don't REALLY talk about this geeky stuff at parties! Jim -Original Message- Sent: Monday, July 22, 2002 9:53 PM To: Multiple recipients of list ORACLE-L Wish I could. This was at a party, and the person speaking was an Oracle employee. We were talking/ranting about how often Oracle changes things and he mentioned that OEM was changing AGAIN. That's all he said Rachel --- Boivin, Patrice J [EMAIL PROTECTED] wrote: Rachel, Could you shed any light on the changes they are proposing? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: Myers-Briggs
We did a personality assessment class as a facilitation to team building. It was supposed to make 'us' aware of other personalities, and how they think and how they work best and how they interact and what they can bring to a team. Was a kinda neat class... but it needed to be given to more than just the initial 35 people who took it... it needed to be done as a company or at least everyone on a team. Might stop the phrase sit down and shut up from being snarled out between gritted teeth on occasion... -Original Message- Sent: Tuesday, July 23, 2002 10:18 AM To: Multiple recipients of list ORACLE-L do a search for Meyers-Briggs and there are sites A lot of companies use this as a way of finding out what type a person is so you can learn how to deal with the people you work with. It's supposed to help with management styles etc --- Rodd Holman [EMAIL PROTECTED] wrote: Where do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this? Rodd Holman On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. 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 of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ 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
How to notify the password expiration in oracle using email?
Hi All, Does anybody have a standard code or process for sending email from oracle to address the following issue. Thanks, Ashoke -Original Message- Sent: Monday, July 22, 2002 3:37 PM To: Multiple recipients of list ORACLE-L Not sure it would be the best but... logically I would: 1. get sysdate 2. get expiration date 3. if expiration date - sysdate = 7 (let's say you wanted to warn them 7 days in advance) send them e-mail. I have not done e-mail from Oracle but there are plenty examples everywhere. Or, I think you could create a screen in your app. and display that screen for them any time they get close to expiration date. You can even let them change their password through that screen, too. -Original Message- Sent: Monday, July 22, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Greetings, As I understand that from Oracle 8 onward we have the feature of password management like account locking, password aging and expiration, password history and password complexity requirements. My understanding is that if the password is expired for an user then that user will be notified during his first attempt to login to the oracle database. Instead of waiting for the user to login and then know about his password expiration, we are trying to find out a way by which the oracle can automatically send an email to the respective user as it is close to the password expiration or as the password has just expired. Any ideas? Thanks in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: Lyuda Hoska 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: Mandal, Ashoke 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).
(memes) not making much headway with critiquing elitist dba
Robert, I got into computers after being in the fertilizer industry, a segue which has many times seemed quite apt. A year or two ago, I noticed that Oracle Education had a training/certification track for something they called Database Operator (DBO) that was quite similar to what you are talking about. The trainee was to know how to conduct routine, basic tasks under the supervision of a senior dba (on big databases), or would be a SA running a 3rd party type application that ran on top of Oracle where the 3rd party app people would provide dba technical consulting/support, or a SA that was running a small/non-critical database, etc. (the web site education.oracle.com doesn't seem to be working right now, so I can't confirm if they still have a DBO track.) Re: critiquing of the cultish/elitist mentality that predominates in DBA circles? ha haaa haa. The thing is to make crucial distinction between: good elitism: - high level specialization, - expertise required, - capacity of an individual to absorb tecnical complexity/theory and learn to apply it to problem solving, etc. and: bad elitism: - arrogant/selfish attitude, greedy, etc. Presumably the worst case scenario is having a person that exhibits bad elitism with little or no sign of any of the attributes of good elitism. I support your efforts at articulating a more populist scenario for defining technical job positions. You of course realize that any sort of populist argument, libertarian or otherwise, will get caught in the hellish middle of a cultural landscape that is mainly defeined by snobby *ssholes in either the politically correct (liberal) or country club (conservative) camps. Besides retreating to a libertarian position (which I think is an honorable approach, if somewhat stasist), there is also another alternative: embrace a holistic, integrative (transcendant/universal) paradigm that recognises the evolutionary limits (and evils) of both classic liberalism and conservatism. http://members.ams.chello.nl/f.visser3/wilber/mgm2.html Explanation of color schemes used in Spiral Dynamics type Memetic theory: http://members.ams.chello.nl/f.visser3/wilber/wilber_sd.html regards, ep On 22 Jul 2002 at 9:23, Robert Monical wrote: ... 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). ... -- 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
RE: Myers-Briggs
About 15 years ago, I was working as a contractor for a federal agency. The director got this bright idea to have everyone, both fed and contract, take the Myers-Briggs. I got through about the first 10 questions before I gave up in disgust and frustration. I was able to answer about 1 or 2 of the questions. On the rest, my answer was two or more of the selections depending on the situation. Naturally, the situational background was never given. I decided I was too flexible to be pigeonholed. My boss was sympathetic. He pointed out that there is a Myers-Briggs pigeonhole for people who don't like the Myers-Briggs test. I'm still trying to figure out if he was pulling my leg 8-) Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 23, 2002 8:18 AM To: Multiple recipients of list ORACLE-L do a search for Meyers-Briggs and there are sites A lot of companies use this as a way of finding out what type a person is so you can learn how to deal with the people you work with. It's supposed to help with management styles etc --- Rodd Holman [EMAIL PROTECTED] wrote: Where do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this? Rodd Holman On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. 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 of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ 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
Re: Index performance
why do you think hitting the indexes is a bad thing? what is the
performance of this query? What's the explain plan?
--- Seema Singh [EMAIL PROTECTED] wrote:
Hi
I am executing following query adn this query hits a number of
indices on
this table.let me know what is wrong please.all in where clause are
having
indexes.
select name,last_access, reg_date from empmaster where emp_id100
and reg_dateto_date('2001-01-01','-MM-DD') and
emp_st='valid' and last_accessto_date ('2001-01-01','-MM-DD')
and emp_status='S' and match='FIRST'
Here all conditions in where clause are having indexes.
How to rewrite this query.
The primary key is emp_id.
Thanks
-Seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
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: shutdown abort / startup restrict / shutdown vs. shutdown immedia
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate For openers, shutdown immediate is generally quicker than the combination ofshutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standardsoftware shutdown (and maybe tell Windows that you really want to end that hung process)or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 7:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] The solutions (the ones that I got) aren't good ones. Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID solution'???) This might be a naive question, but why is - shutdown immediate better than - shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
Re: Rant-Rant
oh, thanks, but they'll start sending me stuff next year and I can wait until then :) --- KENNETH JANUSZ [EMAIL PROTECTED] wrote: What's your mailing address? I can make the arrangements for you. Ken Janusz,CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 8:33 AM so sweet. so deluded. I'm one of the chronological seniors here.. not the oldest I've found but close on the other hand, AARP (American Association of Retired People) hasn't started sending me their propaganda yet --- [EMAIL PROTECTED] wrote: I didn't know that they gave Managers jobs to people under 20 :-) 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. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22-07-2002 07:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Rant-Rant Oh I know. I was lucky my last job, we had two full-time DBAs (one senior - me, and one junior/mid) and one senior DBA consultant. I *did* look at my boss last week and said I no longer work 20 hour days. Not that I had to. He's good, he's very adamant about the fact that if there is too much work for one person, we will either hire consultants or the deadlines will be changed. I'd fall in love with him but he's way too young for me. :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Rachel, you are actually proving my point - that a company does not have the luxury (or common sense) to have more than one DBA on staff. Robert's utopia just doesn't fly in todays world. hire one person and work-em till they drop is the current motto. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 3:24 PM To: Multiple recipients of list ORACLE-L 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 excuse me while I wipe the Diet Coke off the screen that I spit out when I read this. One DBA per project? Oh God that would be a luxury beyond belief. As I type this I am the DBA for: a new data mart/data warehouse project a new content management system project a new ecommerce project the existing universal login project AND the replacement project the existing asset management application the existing community site (bulletin boards) and anything else that needs a DBA ... and I am it, ain't no other DBAs around .. oh yeah, I'm the data architect and data modeler on half these as well... which is REALLY funny as I have almost zero data modeling experience, other than common sense --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: 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
RE: Myers-Briggs
I think this is funny, corporations relying on the Myers-Briggs which is based on Jung's depth psychology - archetypes, synchronicity, collective consciousness, alchemy and magic... I don't believe most HR realize this. Bureaucracies are supposed to be rational and here they rely on knowledge that comes from studying the subconscious and alchemy. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, July 23, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Subject:Re: Myers-Briggs do a search for Meyers-Briggs and there are sites A lot of companies use this as a way of finding out what type a person is so you can learn how to deal with the people you work with. It's supposed to help with management styles etc --- Rodd Holman [EMAIL PROTECTED] wrote: Where do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this? Rodd Holman On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. 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 of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ 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). -- 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,
new OEM / Re:RE: Rant
Hold on does that mean that since I never learned it, I should just wait for the new one? :) Will it support 8.1.7 in client-server mode? :):) (Or just Oracle9i?) regards, ep On 22 Jul 2002 at 10:13, [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. ... -- 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: Myers-Briggs
I sit corrected... Intuitive = stuborn. Intraverted = leave me alone, I need to recharge. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, July 23, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject:Re: Myers-Briggs um the I doesn't mean stubbornness it's where you get your energy -- from yourself (Introvert) or from others (Extrovert) it's the Feeling part that makes me wonder about the DBA/computer stuff... aren't geeks supposed to be loners? --- Boivin, Patrice J [EMAIL PROTECTED] wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. Both my parents are psychologists, go figure. 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 5:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: 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). __ 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). -- 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).
Re[2]: Rant-Rant
Well, just watch your mailbox for when the American society of Morticians starts sending you funeral planning information. Now you know your REALLY old. Dick Goulet Reply Separator Author: Ruth Gramolini [EMAIL PROTECTED] Date: 7/23/2002 7:38 AM AARP has already stopped sending me propaganda. I think I am the oldest on the list. RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 9:33 AM so sweet. so deluded. I'm one of the chronological seniors here.. not the oldest I've found but close on the other hand, AARP (American Association of Retired People) hasn't started sending me their propaganda yet --- [EMAIL PROTECTED] wrote: I didn't know that they gave Managers jobs to people under 20 :-) 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. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22-07-2002 07:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Rant-Rant Oh I know. I was lucky my last job, we had two full-time DBAs (one senior - me, and one junior/mid) and one senior DBA consultant. I *did* look at my boss last week and said I no longer work 20 hour days. Not that I had to. He's good, he's very adamant about the fact that if there is too much work for one person, we will either hire consultants or the deadlines will be changed. I'd fall in love with him but he's way too young for me. :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Rachel, you are actually proving my point - that a company does not have the luxury (or common sense) to have more than one DBA on staff. Robert's utopia just doesn't fly in todays world. hire one person and work-em till they drop is the current motto. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 3:24 PM To: Multiple recipients of list ORACLE-L 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 excuse me while I wipe the Diet Coke off the screen that I spit out when I read this. One DBA per project? Oh God that would be a luxury beyond belief. As I type this I am the DBA for: a new data mart/data warehouse project a new content management system project a new ecommerce project the existing universal login project AND the replacement project the existing asset management application the existing community site (bulletin boards) and anything else that needs a DBA ... and I am it, ain't no other DBAs around .. oh yeah, I'm the data architect and data modeler on half these as well... which is REALLY funny as I have almost zero data modeling experience, other than common sense --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: 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
Re: error when acessing table_privileges
Select using a column list, excluding the CREATED column. ORA-24328 means 'illegal attribute value', so I think the CREATED column is the problem because it's defined as a varchar2(0). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos 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).
PTFM? / Re:RE: RE: Rant
You can get a color laser printer cheaper than that. besides RTFM, is there going to now be PTFM? On 22 Jul 2002 at 12:36, [EMAIL PROTECTED] wrote: Patrice, You can still get them, you just have to order them seperatly at a platinum plated cost. Last time I looked is was $1500 per set. Dick Goulet Reply Separator Author: Boivin; Patrice J [EMAIL PROTECTED] Date: 7/22/2002 11:53 AM I can see why they stopped distributing them though, it must have been costly. It doesn't remove the fact that it would be handy to have paper copies of the manuals. It's hard to put yellow sticknote tabs on a CD. ... -- 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: Myers-Briggs
strange I seem to have changed somewhat I'm now an ISFJ... hm, it still seems to fit me Okay, no more on this here... it needs to move to the OT list now! --- Jack Silvey [EMAIL PROTECTED] wrote: Here is the online test, very interesting. I am INTJ as well. http://www.humanmetrics.com/cgi-win/JTypes1.htm Jack That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. 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 of list ORACLE-L Subject:RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ 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: Jack Silvey 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
Gerald, Contact SANS, they are working on an Oracle step-by-step guide, they are looking for people who might want to volunteer as test sites. SANS Research Office [[EMAIL PROTECTED]] Send e-mail with subject line: Oracle bench test. They are just collecting names for now, waiting for feedback on the last draft. 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: Tuesday, July 23, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Subject:RE: Rant Has anybody ever come across a virus that affects Oracle db's via sqlnet? Just curious how such a thing would work (have some ideas). There have to be thousands of vulnerable db's out there (sys/change_on_install, system/manager, etc.) (I've been reading Tom Clancy lately... Getting even more paranoid!) - Jerry -Original Message- Sent: Tuesday, July 23, 2002 7:39 AM To: Multiple recipients of list ORACLE-L Security is like insurance, people don't want to think about it. Like people in battle, everyone tells themselves that the person next to them will be the one to get shot. And they advance over the ridge, facing the sun... 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] -- 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). This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient(s). Any review, reliance, or distribution by others or forwarding without permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cunningham, Gerald 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: 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).
How can I check the time when any table is updated under a schema?
Hi, One of my developer wants to know what are the tables or any other objects being modified during the execution of his application. dba_objects have following 3 date fields. But I am not sure if any of these date fields will capture the last DML(update, insert or delete) time. CREATED LAST_DDL_TIME TIMESTAMP Any idea? Thanks in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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
Jerry, Don't laugh! I did an interview a couple, or has it been longer, of years ago at a financial institution in my neighborhood (northern Mass). Anyway, the interviewer who was the head of the DBA group suggested I show him how I would troubleshoot a problem that they were having. OK, so I give them a couple of pointers that make things better, no problem I pass those out here all the time. Anyway, he had me sit down at a terminal was going to call one of his staff to create me an account. Well no one was available so I tried system/manager on their PROD database. Was I ever surprised when it worked, so was the interviewer especially when sys/change_on_install worked too! Can you say AW S^%!! To say the least, I do not work for them even though they laid a very nice offer on the table. Dick Goulet Reply Separator Author: Cunningham; Gerald [EMAIL PROTECTED] Date: 7/23/2002 8:48 AM Has anybody ever come across a virus that affects Oracle db's via sqlnet? Just curious how such a thing would work (have some ideas). There have to be thousands of vulnerable db's out there (sys/change_on_install, system/manager, etc.) (I've been reading Tom Clancy lately... Getting even more paranoid!) - Jerry -Original Message- Sent: Tuesday, July 23, 2002 7:39 AM To: Multiple recipients of list ORACLE-L Security is like insurance, people don't want to think about it. Like people in battle, everyone tells themselves that the person next to them will be the one to get shot. And they advance over the ridge, facing the sun... 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] -- 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). This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient(s). Any review, reliance, or distribution by others or forwarding without permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cunningham, Gerald 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: Myers-Briggs
I'm: ENTJ (Extroverted, Intuitive, Thinking, Judging) slightly expressed extrovert slightly expressed intuitive personality moderately expressed thinking personality slightly expressed judging personality LOL I'm a Field Marshall.. -Original Message- Sent: 23 July 2002 16:29 To: Multiple recipients of list ORACLE-L Here is the online test, very interesting. I am INTJ as well. http://www.humanmetrics.com/cgi-win/JTypes1.htm Jack That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systhmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rigion des Maritimes, MPO of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ 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: Jack Silvey 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: Mark Leith 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
AMEN!!! Those yellow stickies all over the CD case just don't cut it and there is not enough screen space on any terminal I've seen that replaces multiple books open at the same time or books with paper weights holding them open to two separate sections for quick flipping. On the other hand, the CDs are easier to come by and I've learned to live with them. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Monday, July 22, 2002 10:03 PM To: Multiple recipients of list ORACLE-L CDs have some advantages - expense, searchability, and storage space primarily, but... 1) CDs are more difficult to read in bed, on a plane, waiting in the terminal, etc. 2) Books are easier to read, require less equipment, and are more portable than a computer and a CD 3) Try having six different CD manuals open to related sections spread out in front of you - reading them while you work against the database. 4) An open book shows two full pages of information. An open PDF about half a page. 5) I could usually grab a manual and flip through it to the relevant info about 10x faster than a computer search - and with a lot less extraneous (click/point/scroll/type) activity. 6) Highlighters, margin notes, and sticky-note bookmarks don't work at all with CDs I miss hardcopy manuals! Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 3:18 PM RE: RE: RantNot me. I LOVE the cds. I copy them onto my hard drive and use the pdf versions. they are SEARCHABLE. I can find things much more quickly in the pdf's than paper. Oracle is the only product that I feel this way about .. probably because they have more documentation than the library of congress! -Original Message- [EMAIL PROTECTED] Sent: Monday, July 22, 2002 3:54 PM To: Multiple recipients of list ORACLE-L I can see why they stopped distributing them though, it must have been costly. It doesn't remove the fact that it would be handy to have paper copies of the manuals. It's hard to put yellow sticknote tabs on a CD. 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] -- 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: Don Granaman 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:How to notify the password expiration in oracle using ema
What version? Reply Separator Author: Mandal; Ashoke [EMAIL PROTECTED] Date: 7/23/2002 8:53 AM Hi All, Does anybody have a standard code or process for sending email from oracle to address the following issue. Thanks, Ashoke -Original Message- Sent: Monday, July 22, 2002 3:37 PM To: Multiple recipients of list ORACLE-L Not sure it would be the best but... logically I would: 1. get sysdate 2. get expiration date 3. if expiration date - sysdate = 7 (let's say you wanted to warn them 7 days in advance) send them e-mail. I have not done e-mail from Oracle but there are plenty examples everywhere. Or, I think you could create a screen in your app. and display that screen for them any time they get close to expiration date. You can even let them change their password through that screen, too. -Original Message- Sent: Monday, July 22, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Greetings, As I understand that from Oracle 8 onward we have the feature of password management like account locking, password aging and expiration, password history and password complexity requirements. My understanding is that if the password is expired for an user then that user will be notified during his first attempt to login to the oracle database. Instead of waiting for the user to login and then know about his password expiration, we are trying to find out a way by which the oracle can automatically send an email to the respective user as it is close to the password expiration or as the password has just expired. Any ideas? Thanks in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: Lyuda Hoska 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: Mandal, Ashoke 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: Myers-Briggs
Title: RE: Myers-Briggs I have been subjected to this rubbish repeatedly for the last 20 years or so, including being forced to do my senior project in college on non-sense related to this test and the results. My personal opinion: it's a bunch of crapola. One of the major precepts of this test is that, if admististered correctly, the results will not change over time (you are what you are). I wholeheartedly disagree. I find the 16 possible permutations to be shallow and insufficent. I could go on and on, but I really don't think it even worth the effort. this probably need to be moved to the off-topic list. -- Matt Adams - GE Appliances - [EMAIL PROTECTED] Thus spake the master programmer: Let the programmers by many and the managers few, Then all will be productive - The Tao of Programming -Original Message- From: kkennedy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 1:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: Myers-Briggs About 15 years ago, I was working as a contractor for a federal agency. The director got this bright idea to have everyone, both fed and contract, take the Myers-Briggs. I got through about the first 10 questions before I gave up in disgust and frustration. I was able to answer about 1 or 2 of the questions. On the rest, my answer was two or more of the selections depending on the situation. Naturally, the situational background was never given. I decided I was too flexible to be pigeonholed. My boss was sympathetic. He pointed out that there is a Myers-Briggs pigeonhole for people who don't like the Myers-Briggs test. I'm still trying to figure out if he was pulling my leg 8-) Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 23, 2002 8:18 AM To: Multiple recipients of list ORACLE-L do a search for Meyers-Briggs and there are sites A lot of companies use this as a way of finding out what type a person is so you can learn how to deal with the people you work with. It's supposed to help with management styles etc --- Rodd Holman [EMAIL PROTECTED] wrote: Where do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this? Rodd Holman On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. 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 of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ Do You Yahoo!?
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate Check this out too :) http://www.speakeasy.org/~jwilton/oracle/shutdown-abort-bad.html - Kirti -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 12:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown immedia For openers, shutdown immediate is generally quicker than the combination ofshutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standardsoftware shutdown (and maybe tell Windows that you really want to end that hung process)or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 7:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] The solutions (the ones that I got) aren't good ones. Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID solution'???) This might be a naive question, but why is - shutdown immediate better than - shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
RE: PTFM? / Re:RE: RE: Rant
How about PARTFM (pronouned 'PartyFM' ;) ? - Kirti -Original Message- Sent: Tuesday, July 23, 2002 12:34 PM To: Multiple recipients of list ORACLE-L You can get a color laser printer cheaper than that. besides RTFM, is there going to now be PTFM? On 22 Jul 2002 at 12:36, [EMAIL PROTECTED] wrote: Patrice, You can still get them, you just have to order them seperatly at a platinum plated cost. Last time I looked is was $1500 per set. Dick Goulet Reply Separator Author: Boivin; Patrice J [EMAIL PROTECTED] Date: 7/22/2002 11:53 AM I can see why they stopped distributing them though, it must have been costly. It doesn't remove the fact that it would be handy to have paper copies of the manuals. It's hard to put yellow sticknote tabs on a CD. ... -- 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: 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).
RE: Index performance
Also do you know what is the most selective part of the query. If you know
that one index will bring back the fewest rows then try hinting to use it.
-Original Message-
Sent: Tuesday, July 23, 2002 5:59 PM
To: Multiple recipients of list ORACLE-L
why do you think hitting the indexes is a bad thing? what is the
performance of this query? What's the explain plan?
--- Seema Singh [EMAIL PROTECTED] wrote:
Hi
I am executing following query adn this query hits a number of
indices on
this table.let me know what is wrong please.all in where clause are
having
indexes.
select name,last_access, reg_date from empmaster where emp_id100
and reg_dateto_date('2001-01-01','-MM-DD') and
emp_st='valid' and last_accessto_date ('2001-01-01','-MM-DD')
and emp_status='S' and match='FIRST'
Here all conditions in where clause are having indexes.
How to rewrite this query.
The primary key is emp_id.
Thanks
-Seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
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).
--
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: IO wait
Have you considered trying StorageXpert from Quest? - Kirti -Original Message- Sent: Tuesday, July 23, 2002 10:58 AM To: Multiple recipients of list ORACLE-L All, We are tuning a new vital process on our data warehouse, and it is IO intensive - lots of parallel direct reads and writes. During our testing we are driving IO wait to ~60% (per top). questions: 1) is top a valid measure of IO wait? 2) Is a high io wait an issue to be concerned about? 3) how else can it be accurately measured? 4) How can I link IO wait to what is happening inside the database? Thanks, Jack __ 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: Jack Silvey 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).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate I don't necessarily agree that shutdown immediate is quicker. If you force a checkpoint prior to the shutdown abort the subsequent crash recovery upon startup is usually pretty fast. Parallel recovery could be a factor as well. - Rich -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown immedia For openers, shutdown immediate is generally quicker than the combination ofshutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standardsoftware shutdown (and maybe tell Windows that you really want to end that hung process)or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 7:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] The solutions (the ones that I got) aren't good ones. Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID solution'???) This might be a naive question, but why is - shutdown immediate better than - shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
Re: error when acessing table_privileges
Not a problem under 8.1.5 or 9.2. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 12:58 PM Select using a column list, excluding the CREATED column. ORA-24328 means 'illegal attribute value', so I think the CREATED column is the problem because it's defined as a varchar2(0). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos 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: Index performance
Title: RE: Index performance
Seema,
It would really help to see your index scripts also. If you have an index that includes emp_id, reg_date, emp_st, last_access, emp_status, and match, that index should work best. Use a hint on that index.
You say that this query hits a number of indices on this table. Do you have the explain plan that shows which and how the indexes are hit? You can't assume that just because you have an index that it is being used. If you have a bunch of indexes each on a different column or two, the indexes are probably not doing this SQL any good and surely making inserts and updates take a lot longer.
Also how big is the table? How big is it expected to become? When's the last time it was analyzed?
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Hi
I am executing following query adn this query hits a number of indices on
this table.let me know what is wrong please.all in where clause are having
indexes.
select name,last_access, reg_date from empmaster where emp_id100
and reg_dateto_date('2001-01-01','-MM-DD') and
emp_st='valid' and last_accessto_date ('2001-01-01','-MM-DD')
and emp_status='S' and match='FIRST'
Here all conditions in where clause are having indexes.
How to rewrite this query.
The primary key is emp_id.
Thanks
-Seema
RE: IO wait
Jack, You can run 'iostat -x 5 5' to see which disk are being used. In this example, the arguments state 5 sec increments, 5 times. This output may show a need to spread your data amongst your disk differently. -reggie -Original Message- From: Jack Silvey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Subject: IO wait All, We are tuning a new vital process on our data warehouse, and it is IO intensive - lots of parallel direct reads and writes. During our testing we are driving IO wait to ~60% (per top). questions: 1) is top a valid measure of IO wait? 2) Is a high io wait an issue to be concerned about? 3) how else can it be accurately measured? 4) How can I link IO wait to what is happening inside the database? Thanks, Jack __ 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: Jack Silvey 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: Beavers, Reginald 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: Myers-Briggs - Too many off topic topics!
There have been a lot of off topic topics lately. I finally had to add the "Rant" thread to my filters so I wouldn't get any more of it. Can we please stick to things Oracle?? Boivin, Patrice J wrote: I think this is funny, corporations relying on the Myers-Briggs which is based on Jung's depth psychology - archetypes, synchronicity, collective consciousness, alchemy and magic... I don't believe most HR realize this. Bureaucracies are supposed to be "rational" and here they rely on knowledge that comes from studying the subconscious and alchemy. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, July 23, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: Myers-Briggs do a search for Meyers-Briggs and there are sites A lot of companies use this as a way of finding out what "type" a person is so you can learn how to deal with the people you work with. It's supposed to help with management styles etc --- Rodd Holman [EMAIL PROTECTED] wrote: Where do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this? Rodd Holman On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Jesse W. Asher "They that can give up essential liberty to purchase a little temporary safety, deserve neither liberty or safety." - Benjamin Franklin
Re: How can I check the time when any table is updated under a schema?
none of them will capture DML changes you have two choices: 1) turn on auditing... this will tell you at a macro level what has been touched, but won't necessarily tell you who did it or if it was done by the execution of his app 2) add an update_dt and an updated_by column to all tables and create a trigger which fires on insert/update/delete to fill the column of the row with sysdate and the userid of the user. This is very detailed, down to the row level but may also not give you whether or not the change was made during the execution of his application --- Mandal, Ashoke [EMAIL PROTECTED] wrote: Hi, One of my developer wants to know what are the tables or any other objects being modified during the execution of his application. dba_objects have following 3 date fields. But I am not sure if any of these date fields will capture the last DML(update, insert or delete) time. CREATED LAST_DDL_TIME TIMESTAMP Any idea? Thanks in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate The differences are 1.shutdown abort - is more drastic, no new users are allowed to log in, disconnects current sessions without rollback, recovery however would have to be done when restarted. 2. shutdown immediate - no new users are allowed to log in, terminating current connections, transactionsterminated are rollbacked, recovery would not happen at restart 3. shutdown normal - no new users are allowed to log in, transactions in progress are rollbacked, but would wait for all existing transactions to finish and users to log off, so if a user is logged in when shutdown normal is executed, it would wait forever. So shutdown immediate is much quicker and safer. ...Ishrat -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 9:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] The solutions (the ones that I got) aren't good ones. Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID solution'???) This might be a naive question, but why is - shutdown immediate better than - shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
RE: (memes) not making much headway with critiquing elitist dba
Eric, Huh? Tom (you lost me at hallo) -Original Message- Sent: Tuesday, July 23, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Robert, I got into computers after being in the fertilizer industry, a segue which has many times seemed quite apt. A year or two ago, I noticed that Oracle Education had a training/certification track for something they called Database Operator (DBO) that was quite similar to what you are talking about. The trainee was to know how to conduct routine, basic tasks under the supervision of a senior dba (on big databases), or would be a SA running a 3rd party type application that ran on top of Oracle where the 3rd party app people would provide dba technical consulting/support, or a SA that was running a small/non-critical database, etc. (the web site education.oracle.com doesn't seem to be working right now, so I can't confirm if they still have a DBO track.) Re: critiquing of the cultish/elitist mentality that predominates in DBA circles? ha haaa haa. The thing is to make crucial distinction between: good elitism: - high level specialization, - expertise required, - capacity of an individual to absorb tecnical complexity/theory and learn to apply it to problem solving, etc. and: bad elitism: - arrogant/selfish attitude, greedy, etc. Presumably the worst case scenario is having a person that exhibits bad elitism with little or no sign of any of the attributes of good elitism. I support your efforts at articulating a more populist scenario for defining technical job positions. You of course realize that any sort of populist argument, libertarian or otherwise, will get caught in the hellish middle of a cultural landscape that is mainly defeined by snobby *ssholes in either the politically correct (liberal) or country club (conservative) camps. Besides retreating to a libertarian position (which I think is an honorable approach, if somewhat stasist), there is also another alternative: embrace a holistic, integrative (transcendant/universal) paradigm that recognises the evolutionary limits (and evils) of both classic liberalism and conservatism. http://members.ams.chello.nl/f.visser3/wilber/mgm2.html Explanation of color schemes used in Spiral Dynamics type Memetic theory: http://members.ams.chello.nl/f.visser3/wilber/wilber_sd.html regards, ep On 22 Jul 2002 at 9:23, Robert Monical wrote: ... 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). ... -- 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
RE: Myers-Briggs
well, I've done a number of test, both under trained supervision and ones like this (and yes, I do discount a lot of the online stuff) I've also worked with a therapist for years to get to really understand me. I'm pretty sure I'm not mis-stating who I am :) --- Boivin, Patrice J [EMAIL PROTECTED] wrote: Beware of self-reports! They are notoriously innacurate. e.g. ask people what they will be doing in the next three years, they are almost always wrong. Ask them what they are like, ask them their traits, and often they are wrong. Wishful thinking kicks in, perhaps. Also when people think something is a big concern, often it is because they focus on that particular trait - most people probably don't pay attention to it as much. E.g. my mother-in-law keeps saying she can't do anything right, that it takes her longer than everyone else to get things done properly... turns out she is a perfectionist! Same thing with the enneagram, people's self-image tends to discard chief feature, they think their personality revolves around something else. : ) anyway, back to DBA work. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, July 23, 2002 12:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: Myers-Briggs Here is the online test, very interesting. I am INTJ as well. http://www.humanmetrics.com/cgi-win/JTypes1.htm Jack That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. 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 of list ORACLE-L Subject:RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ 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: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Rant-Rant
what a nice way to put that :) maybe they are taking mental age into account and so think I'm about 16? either that or they have you confused with someone else, it was my understanding that they tag you as soon as you hit 50 --- Toepke, Kevin M [EMAIL PROTECTED] wrote: Hmmm... thats intersting. I'm somewhat your junior and I've been getting their propaganda for a couple of years already. -Original Message- Sent: Tuesday, July 23, 2002 9:34 AM To: Multiple recipients of list ORACLE-L so sweet. so deluded. I'm one of the chronological seniors here.. not the oldest I've found but close on the other hand, AARP (American Association of Retired People) hasn't started sending me their propaganda yet --- [EMAIL PROTECTED] wrote: I didn't know that they gave Managers jobs to people under 20 :-) 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. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22-07-2002 07:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Rant-Rant Oh I know. I was lucky my last job, we had two full-time DBAs (one senior - me, and one junior/mid) and one senior DBA consultant. I *did* look at my boss last week and said I no longer work 20 hour days. Not that I had to. He's good, he's very adamant about the fact that if there is too much work for one person, we will either hire consultants or the deadlines will be changed. I'd fall in love with him but he's way too young for me. :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Rachel, you are actually proving my point - that a company does not have the luxury (or common sense) to have more than one DBA on staff. Robert's utopia just doesn't fly in todays world. hire one person and work-em till they drop is the current motto. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 3:24 PM To: Multiple recipients of list ORACLE-L 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 excuse me while I wipe the Diet Coke off the screen that I spit out when I read this. One DBA per project? Oh God that would be a luxury beyond belief. As I type this I am the DBA for: a new data mart/data warehouse project a new content management system project a new ecommerce project the existing universal login project AND the replacement project the existing asset management application the existing community site (bulletin boards) and anything else that needs a DBA ... and I am it, ain't no other DBAs around .. oh yeah, I'm the data architect and data modeler on half these as well... which is REALLY funny as I have almost zero data modeling experience, other than common sense --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: 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
RE: new OEM / Re:RE: Rant
Eric, I learned OEM and decided it just wasn't worth it. I saw nothing of added value there. I can and do everything that OEM does via either Cron or any other scheduling tool. The product makes no sense to me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 23, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Hold on does that mean that since I never learned it, I should just wait for the new one? :) Will it support 8.1.7 in client-server mode? :):) (Or just Oracle9i?) regards, ep On 22 Jul 2002 at 10:13, [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. ... -- 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: 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: Rant
oh goodie, now I can stop feeling badly over it :) I've learned that whenever I log into a database as a superuser (connect internal or / as sysdba) the FIRST command I issue is select * from v$database so that I confirm that I am in the database I think I'm in. just a habit, but one that stopped me cold from shutting down the forward-facing database, which would have effectively shutdown the website. --- Jesse, Rich [EMAIL PROTECTED] wrote: That happens even to us SAs who are also DBAs (or vice versa). About five years ago, I was explaining DCL and VMS to a new co-worker and describing how I help protect against accidental file deletion by having DEL*ETE :== DELETE/LOG/CONFIRM in my SYS$LOGIN:LOGIN.COM. So, I confidently issued a DEL *.*.* -- in SYS$LIBRARY -- after running AUTOGEN. Seasoned VMS SAs know that AUTOGEN quietly deletes all global symbols, including those protecting accidental file deletes. After a Putz! comment from our Operations group, the files were given an emergency restore. The thing is that I knew better. Doing DBA work in Oracle, however, has made me even more paranoid. Hasn't happened since and I don't rely on site addons to protect me from myself. Now I know, and knowing is half the battle. -- G.I.Joe, a real American Hero :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 9:14 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Rant you betcha. okay, I'll tell a story on myself. I really am usually very careful about doing something that is a sweeping change without checking either the directory I'm in or doing it so that I have to confirm. VAX/VMS, in my home directory. I could have SWORN I was in a temp directory, my login was supposed to be set up to tell me the directory I was in. It wasn't, 'cause I did the VMS equivalent of rm * and deleted EVERYTHING in my home directory (scripts, notes, login profile) I very meekly called the data center and asked them to please please restore my directory from the prior night's backup tape. After they stopped laughing, they made it a rush. See, I used to buy them pizza if I had to ask them to work late and do extra stuff. I know my limitations. I'm a pretty good general DBA but I ain't an SA Rachel -- 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). __ 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-Rant
Actually I'd think entj would be just about the ideal for a dba or sa. You have the leadership ability to ride herd on people (such as developers), are driven to keep up on the technical stuff, are well-organized enough to keep track of everything... I very aware of working against my natural instincts when I set up my backup and recovery plans, since improvisation and leaving things open is generally *not* advisable. Oh, we'll figure it out as we go along isn't a good choice there :), despite being my being rather good at doing just that. Jay -Original Message- Sent: Monday, July 22, 2002 5:25 PM To: Multiple recipients of list ORACLE-L How about an ENTJ as a DBA and System Admin... I'm loads of fun with a bunch of touchy feely type SP's here at the college I work for ;-) Joe On Mon, 22 Jul 2002, Miller, Jay wrote: FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Joe LaCascio 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: Miller, Jay 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: How can I check the time when any table is updated under a sc
I am surprised that the developer doesn't know the code s/he wrote/maintains. g Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! --- Mandal, Ashoke [EMAIL PROTECTED] wrote: Hi, One of my developer wants to know what are the tables or any other objects being modified during the execution of his application. dba_objects have following 3 date fields. But I am not sure if any of these date fields will capture the last DML(update, insert or delete) time. CREATED LAST_DDL_TIME TIMESTAMP Any idea? Thanks in advance, Ashoke *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate The Backup Recovery Handbook has a great treatment of what happens in the various shutdown methods. Here is a quick summary: ABORT - Disallow new connections, drop file locks, terminate processes IMMEDIATE - Disallow new connections, terminate current connections and rollback active transactions, flush db block and redo log caches, update file headers, close files, synchronize control files, terminate processes TRANSACTIONAL - Disallow new connections,allow active transactions to complete, terminate current connections, flush db block and redo log caches, update file headers, close files, synchronize control files, terminate processes NORMAL - Disallow new connections,allow current connections to be completed and sessions logged out, flush db block and redo log caches, update file headers, close files, synchronize control files, terminate processes. Obviously, if the users did not log out of the sessions, the db would not come down. If ABORT is used, transactions will be rolled back upon startup (which is why it may take longer to open). In 9i, there was (is?) a known bug where an ABORT would cause the database to not open. Also note that the caches are not flushed. The database will be in an inconsistent state and is not valid for a backup if it is not in archivelog mode (though you may get lucky...). -Original Message-From: Ishrat Jehan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 12:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm The differences are 1.shutdown abort - is more drastic, no new users are allowed to log in, disconnects current sessions without rollback, recovery however would have to be done when restarted. 2. shutdown immediate - no new users are allowed to log in, terminating current connections, transactionsterminated are rollbacked, recovery would not happen at restart 3. shutdown normal - no new users are allowed to log in, transactions in progress are rollbacked, but would wait for all existing transactions to finish and users to log off, so if a user is logged in when shutdown normal is executed, it would wait forever. So shutdown immediate is much quicker and safer. ...Ishrat -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 9:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] The solutions (the ones that I got) aren't good ones. Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID solution'???) This might be a naive question, but why is - shutdown immediate better than - shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
RE: RE: Rant
I like the hyperlinks on the CD docs. I like the improved master index and the search facility I HATE not being able to write my own notes on the page or reading the docs on the train --- kkennedy [EMAIL PROTECTED] wrote: AMEN!!! Those yellow stickies all over the CD case just don't cut it and there is not enough screen space on any terminal I've seen that replaces multiple books open at the same time or books with paper weights holding them open to two separate sections for quick flipping. On the other hand, the CDs are easier to come by and I've learned to live with them. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Monday, July 22, 2002 10:03 PM To: Multiple recipients of list ORACLE-L CDs have some advantages - expense, searchability, and storage space primarily, but... 1) CDs are more difficult to read in bed, on a plane, waiting in the terminal, etc. 2) Books are easier to read, require less equipment, and are more portable than a computer and a CD 3) Try having six different CD manuals open to related sections spread out in front of you - reading them while you work against the database. 4) An open book shows two full pages of information. An open PDF about half a page. 5) I could usually grab a manual and flip through it to the relevant info about 10x faster than a computer search - and with a lot less extraneous (click/point/scroll/type) activity. 6) Highlighters, margin notes, and sticky-note bookmarks don't work at all with CDs I miss hardcopy manuals! Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 3:18 PM RE: RE: RantNot me. I LOVE the cds. I copy them onto my hard drive and use the pdf versions. they are SEARCHABLE. I can find things much more quickly in the pdf's than paper. Oracle is the only product that I feel this way about .. probably because they have more documentation than the library of congress! -Original Message- [EMAIL PROTECTED] Sent: Monday, July 22, 2002 3:54 PM To: Multiple recipients of list ORACLE-L I can see why they stopped distributing them though, it must have been costly. It doesn't remove the fact that it would be handy to have paper copies of the manuals. It's hard to put yellow sticknote tabs on a CD. 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] -- 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: Don Granaman 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). __ 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
RE: Myers-Briggs - Too many off topic topics!
Maybe during these stressful times of financial market chaos and job uncertainty, some people just need to clear the air and get stuf off their chest. The rest of us are just goofs. ;o) -Original Message-From: Jesse W. Asher [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 1:09 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Myers-Briggs - Too many off topic topics!There have been a lot of off topic topics lately. I finally had to add the "Rant" thread to my filters so I wouldn't get any more of it. Can we please stick to things Oracle??Boivin, Patrice J wrote: I think this is funny, corporations relying on the Myers-Briggs which is based on Jung's depth psychology - archetypes, synchronicity, collective consciousness, alchemy and magic... I don't believe most HR realize this. Bureaucracies are supposed to be "rational" and here they rely on knowledge that comes from studying the subconscious and alchemy. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, July 23, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: Myers-Briggs do a search for Meyers-Briggs and there are sites A lot of companies use this as a way of finding out what "type" a person is so you can learn how to deal with the people you work with. It's supposed to help with management styles etc --- Rodd Holman [EMAIL PROTECTED] wrote: Where do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this? Rodd Holman On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. 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 of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Jesse W. Asher "They that can give up essential liberty to purchase a little temporary safety, deserve neither liberty or safety." - Benjamin Franklin
Re: How can I check the time when any table is updated under a
Ashoke, Any programer worth their salt should know what tables or objects are modified by their applications. They documented and wrote it and should know what happens when an update, delete, insert, etc happens to the data. If they do not know what happens, How did they write the application?. If it is an inherited application and the documentation is not available, that is a different story. Then you will have to use auditing or the trigger to table method. I know that I sound harsh in my statements but in the old school that's how we had to work, documentation, test, documentation I have found in today's programming world that to many times it is easier to cut and paste code to get the project running and not even do the documentation. PS( I retired from an ISO9001/2 company) ROR mª¿ªm [EMAIL PROTECTED] 07/23/02 02:33PM none of them will capture DML changes you have two choices: 1) turn on auditing... this will tell you at a macro level what has been touched, but won't necessarily tell you who did it or if it was done by the execution of his app 2) add an update_dt and an updated_by column to all tables and create a trigger which fires on insert/update/delete to fill the column of the row with sysdate and the userid of the user. This is very detailed, down to the row level but may also not give you whether or not the change was made during the execution of his application --- Mandal, Ashoke [EMAIL PROTECTED] wrote: Hi, One of my developer wants to know what are the tables or any other objects being modified during the execution of his application. dba_objects have following 3 date fields. But I am not sure if any of these date fields will capture the last DML(update, insert or delete) time. CREATED LAST_DDL_TIME TIMESTAMP Any idea? Thanks in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate Well. I'll agree with you only on the basis that shutdown immediate sometimes hangs and in those cases it is quicker to do the abort/start/shut normal combination. However, based on a quick review of my logs from last night (cold backup),I see the shutdown immediatetook about 12 seconds. The following startup (which needed no recovery)took about a minute. Had I used the shut abort technique, I expect I would have seen, let's say5 seconds for the shut abort, 60 seconds or so for the startup restricted, then about 12 seconds for the shutdown normal. Hmmm. Doesn't seem so cut and dried to me. I think I'll keep using my shutdown script that tries shutdown immediate and only does the abort, etc. if immediate takes too long. At this site, the shutdown immediate only seems to fail about once a month. I can live with that unless someone comes up with a more compelling reason why the shutdown abort is better than a shutdown immediate. So far, all I've seen is the argument that shutdown abort is not evil -- I'm not one who thinks it is evil, I'm just not convinced that it is somehow better. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Gesler, Rich [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm I don't necessarily agree that shutdown immediate is quicker. If you force a checkpoint prior to the shutdown abort the subsequent crash recovery upon startup is usually pretty fast. Parallel recovery could be a factor as well. - Rich -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown immedia For openers, shutdown immediate is generally quicker than the combination ofshutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standardsoftware shutdown (and maybe tell Windows that you really want to end that hung process)or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 7:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] The solutions (the ones that I got) aren't good ones. Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID solution'???) This might be a naive question, but why is - shutdown immediate better than - shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
RE: How can I check the time when any table is updated under a sc
It is common situation. He/she is probably a GUI developer. Most front end
developers are not too familiar with dba tables.
Mandal, you can do run this query next time you have a similar queston:
1 select column_name, comments
2 from dba_col_comments
3 where table_name='DBA_OBJECTS'
4* AND COLUMN_NAME IN ('TIMESTAMP','LAST_DDL_TIME','CREATED')
SQL /
COLUMN_NAME COMMENTS
---
---
CREATED Timestamp for the creation of the object
LAST_DDL_TIME Timestamp for the last DDL change (including GRANT and
REVOKE) to the object
TIMESTAMP Timestamp for the specification of the object
Look for more help on TIMESTAMP column, if it is not what you are looking
for and there are only a few tables you need information about, may be
creating trigger would help.
SQL -Original Message-
Sent: Tuesday, July 23, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
I am surprised that the developer doesn't know the code s/he
wrote/maintains.
g
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
--- Mandal, Ashoke [EMAIL PROTECTED] wrote:
Hi,
One of my developer wants to know what are the tables or any other
objects being modified during the execution of his application.
dba_objects have following 3 date fields. But I am not sure if any of
these date fields will capture the last DML(update, insert or delete)
time.
CREATED
LAST_DDL_TIME
TIMESTAMP
Any idea?
Thanks in advance,
Ashoke
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lyuda Hoska
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: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate Yes, I WHOLE heartedly agree, and we do a shutdown immediate now, but the point is... Oracle SUPPORT seems to be of the opinion that rather than trying to figure out what is 'wrong' we should just do a shutdown abort it 'Is a valid solution'. I'm guessing there IS a REASON it is doing this... and that it is only doing it in one of my three financials instances CONSISTENTLY... and NOT the one that was the source of the recent clone. ajw -Original Message-From: Ishrat Jehan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 1:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm The differences are 1.shutdown abort - is more drastic, no new users are allowed to log in, disconnects current sessions without rollback, recovery however would have to be done when restarted. 2. shutdown immediate - no new users are allowed to log in, terminating current connections, transactionsterminated are rollbacked, recovery would not happen at restart 3. shutdown normal - no new users are allowed to log in, transactions in progress are rollbacked, but would wait for all existing transactions to finish and users to log off, so if a user is logged in when shutdown normal is executed, it would wait forever. So shutdown immediate is much quicker and safer. ...Ishrat -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 9:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] The solutions (the ones that I got) aren't good ones. Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID solution'???) This might be a naive question, but why is - shutdown immediate better than - shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict) The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment.
