RE: Boolean dates...
Jared's close. It's 2718 - BC -. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Wednesday, October 22, 2003 3:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Boolean dates... Jared, If that's true there has got to be something a little "strange" in the way that Oracle computes julian dates. Beacuse to_date(728,464,'J') returns 05-JUN-2718, where as to_char(sysdate,'J') returns 2,452,935. (comma's added for clarity) Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 22, 2003 11:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Boolean dates...I think what your boss really means is 'julian' date. Does he also want his database in mauve? Try this: select to_date(bdate,'j') from paam; That said, the dates in your example are about 700 years into the future. Jared Jose Luis Delgado [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/22/2003 08:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Boolean dates...Hi to all!We have an old app that manages something that my bosscalls: boolean dates.He told me that exists an algorithm that manages datesas a boolean format.We have several tables in this form:Note: The following table: PAAM has the field BDATE defined as NUMBER.sql select bdate from paamsql where rownum 6BDATE--728464728434728403728495728283now, I need to convert that format to an'understandable' format to get the old data and olddates.I'm looking (google-ing) for that subject but, withoutluck.any ideas? help?, pls...Thanks in advanceRegards!JL__Do you Yahoo!?The New Yahoo! Shopping - with improved product searchhttp://shopping.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jose Luis DelgadoINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California-- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
db version control - schemas, code
Hi All, Client would like me to propose a solution for managing schemas and code in their databases. There are several developers, each making changes to their own schema, and then there's test, qa, and production. There are both schema changes and code changes. Mostly schema changes though. Client would like software (scripts and/or packaged sw) AND a methodology. I've looked at the specs for Oracle Change Manager. Any experiences with that? Can anyone recommend a methodology and/or sw for this? Or articles/books? Thanks, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db version control - schemas, code
Title: RE: db version control - schemas, code It's on their website, and it does look excellent. Thanks for the tip. Anyone ever use OEM Change Manager? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, October 16, 2003 3:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: db version control - schemas, code there was an excellent presentation by Mark Stock at SEOUC 2002 called Tag! Whose Code is it? about embedding versioning inside of Oracle objects. I'm reluctant to send it without getting approval from the copyright holder, but the authors e-mail address is [EMAIL PROTECTED] Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- From: Yosi Greenfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 16, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Subject: db version control - schemas, code Hi All, Client would like me to propose a solution for managing schemas and code in their databases. There are several developers, each making changes to their own schema, and then there's test, qa, and production. There are both schema changes and code changes. Mostly schema changes though. Client would like software (scripts and/or packaged sw) AND a methodology. I've looked at the specs for Oracle Change Manager. Any experiences with that? Can anyone recommend a methodology and/or sw for this? Or articles/books? Thanks, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Change PCTINCREAE for SYSTEM Tablespace
Ken, The system tablespace is created in the file sql.bsq, which should be found in %ORACLE_HOME%\rdbms\admin. Create tablespace system is the first statement in the file. However, before you touch that file, you MUST read Steve's article at http://www.ixora.com.au/tips/creation/bsq.htm. Two points he makes: 1 - Don't edit sql.bsq, make a copy and edit and use the copy, 2- leave the defaults alone, and set a minimum extent of 64k on the system ts. Really, read the page before you do it. HTH, Yosi Ken Janusz wrote: Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace without recreating the DB? For some reason the person who created the DB I am working on set PCTINCREASE to 50 (or didn't did not include this parameter).I am using this DB for a data conversion so there is no software connected to it and in turn no users on it. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Messy Messy SQL
Jeff,
That's a pretty silly way to store zip codes. Could you create a
zipcode-id table, where you break out each zip and its id? Then
search that table and join back to table a?
Or, if you're at 8i, and if you only get up to a really small number
(like the 3 you display) of zips in a combined zip field, you could
create the first index on the zip field, and two additional function-
based indexes on the second and third zip codes. Then instead of
using like '%9%', you could use the function with which you
created the index, like where substr(instr(zip_field, ' ')+1) like
'9%'.
Some thoughts, hope they help.
God bless America.
Yosi
Jeff Wiegard wrote:
I've been asked to review some troublesome SQL queries, and since I
don't know what to do with this one, I thought I'd see what you all
can come up with.
They are doing the following:
select A.value 1, C.value2, A.value3
from Table A, Table B, Table C
where A.id = B.id
and B.id = C.id
and (A.ZIPS like ('%54016%')
or A.ZIPS like ( '%54021%')
or A.ZIPS like ( '%54351%')
or A.ZIPS like ( '%54025%')
or A.ZIPS like ( '%54246%')
or A.ZIPS like ( '%54071%')
or A.ZIPS like ( '%54023%')
or A.ZIPS like ( '%54029%')
or A.ZIPS like ( '%54078%')
or A.ZIPS like ( '%54651%')
or A.ZIPS like ( '%54901%')
or A.ZIPS like ( '%55514%'))
The only problem is that the actual data in the ZIPS field could be
in the format of one of the following 3 samples:
55306:50
55358:100 56601:100
56301:25 56304:25 56379:25
The joins are on 400,000 row tables, and it's doing a full table
scan on all three tables because of the first % wildcard in the like
clause. It would be easy to get the values if they were all like the
first format, because I could use 'substr(A.zips,1,5) = '55514'',
but I don't know what to do with the second two samples, where there
is more than one zipcode in the field.
I would like to be able to find the ':' character and subtract 5 to
get the zipcode, but there could be 3 ':' characters corresponding
to 3 zips in one field. Any ideas?
Thanks,
Jeff
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yosi Greenfield
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 Loader questions
Lisa, No and no. Loader loads rows into tables. If you ask nicely, it will clean out the table completely before it does that. That's all it does. And it does it pretty well. It does not let users redefine tables. And it does not do selective update and delete based on the incoming data file. Other loading tools do that (I know DataJunction does, and others) but not Loader. Yosi YTTRI Lisa wrote: Hi everyone - I need some help. We have an application running on 8.0.5 on NT. My programmer tells me that she should be able to add columns to a table simply by changing the sql loader control file definition of the input. I have looked through the documentation and tried several tests, but I can't see any way that this would work. Is this actually possible with SQL Loader? Also, she tells me that if a record exists in the table and she has the same record (key value only) in the input file, that SQL Loader should update the record with any changed field values. Is there a special keyword to do this - I can't seem to find anything on that either? Thanks in advance for any help you can give me. Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Question about temporary segments
Mike, When it creates an index, Oracle doesn't make it visible as it's being built. So basically, Oracle creates the index as a temporary segment in the location it will belong when it's done being created. When Oracle finishes creating the index, Oracle then makes the index 'un-temporary', gives it its specified index name, and leaves it where it is. The alternative would be to create the index in TEMP and then take the extra step of moving the index to its final destination. Oracle doesn't do that. Note that these are different temp segments than the ones Oracle uses to sort the data in order to build the index. Those are, as you noted, stored in TEMP. HTH, Yosi Petrus, Mike (CAP, GEFA) wrote: Greetings All; I am confused and hope someone can straighten me out. My confusion surrounds temporary segments and where they are created. I had assumed that temporary segments were created in a user's, assigned temporary tablespace. However when I have a creation failure, for example, if I am attempting to rebuild an index that is currently in tablespace aww_index1, I received the following error: (ORA-1652: unable to extend temp segment by 1280 in tablespace AWW_INDEX1), this is telling me that the temp segment is being created in the tablespace that the permanent object exists in. Is this always the case? Is the only purpose of the user's, assigned TEMPORARY table space for sorting. Can I tell Oracle to redirect the creation of the temp segment to a different tablespace? If so how is that accomplished? Thanks in advance. Michael L. Petrus GE Auto Warranty Services 7125 W. Jefferson Av. #200 Lakewood, CO 80235 Database Administrator Phone: (303) 987 4129 Fax: (303) 987 4298 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: weekends/holidays
Lyuda,
For weekends, you can check to_char('date', 'D'). The 'D'
format returns the day of the week. A 1 or a 7 would indicate
Sunday or Saturday. For holidays, you'd have to write your
own function. You could set up a table of legal holiday dates,
that you would have to populate. Truth be told, there are lots
of holidays, some more observed than others. So you'd really
have to define for yourself which holidays count and which don't.
Then write a function is_holiday to return true if a specific date
is found in the holidays table, or false if its not.
hth,
Yosi
[EMAIL PROTECTED] wrote:
Hi list,
Is there a function in Oracle that will determine if particular calendar day
is weekend or a US holiday. I need to write a function that will check the
data integrity of my db. It will check data entered into the system and
notice any gaps. I have to go by days(i.e. every day there should be an
entry/ies unless it is a weekend or holiday.)
Thank you in advance,
Lyuda Hoska
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yosi Greenfield
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: CTAS use of rollback
Confirmed. Nicoll, Iain (Calanais) wrote: Could anyone tell me whether Create table .. as select .. uses rollback. I initially thought it would (despite being a cross between ddl and dml) but having created a 3.5 million row table and checked the sum of the writes in v$rollstat it had only done ~130k writes between the start of the ctas and the end. It also doesn't create the table initially but just has a numbered object which it seems to rename only at the very end, so if it fails I would have though it would just drop that object and if it completes successfully then a commit would be done because of the ddl aspects of the command. I tried inserting 10k rows into the same table and this came back with about 25k writes (seemed reasonable if it's only storing the rowid). Given this it doesn't seem to be using rollback (other than recording changes to extents etc) but I'd appreciate confirmation. Iain Nicoll -- 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). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Notification when something changes in the DB
I'm fairly certain Oracle Forms does this too. I've had to write some complex forms that worked on updateable views, and I had to re-write Forms' on-update and on-lock triggers myself. yosi [EMAIL PROTECTED] wrote: Not so weird, PeopleSoft does things in a similar manner. When a panel in PeopleTools is queried a copy of the data is sent to the screen for modification. A second in retained in memory as the original version. When the user presses the 'save' button a third copy is retrieved from the database and compared to the second copy. If they match the modified data is saved to the database which was queried the second time 'for update of' so that a row level lock is established at that time. Now if the data had been modified this irratating message pop-up appears telling you that the underlying data has been modified you have to start all over again. In general letting Oracle handle the locking of data is the best way to go, so either acquire a 'for update' lock when you pull the data or do the double query if you really need it. Dick Goulet -- Reply Separator -- Author: John Lewis [EMAIL PROTECTED] Date: 9/4/01 1:51 PM For whatever reasons this solutions was found to be not sound by a 3rd party consulting company which reccommended Oracle native technology to perform this check. Hmm... a trigger seem native to me. Perhaps they meant auditing. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 2:33 PM To: Multiple recipients of list ORACLE-L Hello fellow DBAs', I have a weird question that I was asked. My first reaction was to answer: There is no such thing, however I was talked into posting this question here :-) 1. An applicaiton selects certain records (from different tables) from a database.. 2. When time comes to update some of these records in the datbase application needs to know if records that it's about to update have been modified by some other user. 3. Currently this is achieved with via triggers. Before performing an update application checks if trigger updated a certain field in the database which serves as an indication that records/fields of interest have been updated. For whatever reasons this solutions was found to be not sound by a 3rd party consulting company which reccommended Oracle native technology to perform this check. This company is now unreachable and management is requesting to change the application to follow this review. Management explanation of how it needs to be done is based on what ADO would do where if you perform an optimistoc lock and then later on try to update an already updated record it would tell you about this upfront., or you would be able to check upfront WITHOUT requiring the DB. I am not familiar with ADO, that much so I can not comment on it. Can somebody tell me if they can think of way to achieve this? I know it sounds rather weird request -- it is. Thanks in advance for any thoughts on this, Val Gamerman. Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: !! *Very* important Oracle-L message !!
I was away, and when I came back responded with the following, which the list bounced because of the V-word! How dare I take a v.! Here it was, with a few words now slightly touched up: Aw man, I was on v*a*c_a.t_i*o*n and missed the whole thing! Perkins Pond, Sunapee, New Hampshire. Absolutely marvelous place! I'm in a good mood now after a relaxing week. I'm in. I'd stay in even if I had a cruddy week. Oh - thanks for not making it pay-per-view. I like the public radio model, - and yes, I donate to public radio - some people like it and value it more than others, and are more able or willing to contribute. They cover for those who can't. Thanks to Jared and Bruce, as always, for their tremendous work. Yosi Anybody ever visit the Sunapee area? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: !! *Very* important Oracle-L message !!
Nope, not really nearby. Same state and all that, but not nearby. Heck, we barely visited the people on the farm up the road. But I'm sure the Albacore misses you! Ken Janusz wrote: Did you stop by Portsmouth and visit my old friend the USS Albacore (AGSS-569)? Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. -Original Message- Sent: Wednesday, September 05, 2001 11:16 AM To: Multiple recipients of list ORACLE-L I was away, and when I came back responded with the following, which the list bounced because of the V-word! How dare I take a v.! Here it was, with a few words now slightly touched up: Aw man, I was on v*a*c_a.t_i*o*n and missed the whole thing! Perkins Pond, Sunapee, New Hampshire. Absolutely marvelous place! I'm in a good mood now after a relaxing week. I'm in. I'd stay in even if I had a cruddy week. Oh - thanks for not making it pay-per-view. I like the public radio model, - and yes, I donate to public radio - some people like it and value it more than others, and are more able or willing to contribute. They cover for those who can't. Thanks to Jared and Bruce, as always, for their tremendous work. Yosi Anybody ever visit the Sunapee area? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Append date/time stamp to logfile name (NT 4.0)
Chuck, It's doable, and I've seen scripts on the net that do it, but it's a bit cumbersome. However, you could also do it in sqlplus, using spool, where the name of the spool file is taken from a new_value of a date query, i.e., col x new_value fn select to_char (sysdate, 'DDMMHHMI') || '.txt' x from dual; spool fn hth, yosi Speaks, Chuck W. wrote: OS: NT 4.0 I have scheduled a query against a database that pipes results to a log file. Ex. Select * from any_table; logfile.txt Since I need a trend on this query I need to keep the logfile names unique. Best case scenario is to append a date/time stamp to the logfile name as in 230820011200.txt (daymonthyeartime). Does anyone know how to do this with NT scripting? Any help would be greatly appreciated. Thanks, Chuck Speaks Database Administrator Lithonia Lighting 770-860-3450 http://www.lithonia.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Speaks, Chuck W. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 do you audit a DBA?
I once told a user - on a dumb terminal - (or was that a dumb user on a terminal...) that the character mode computer system monitors what they do at their desks. I was kidding, I promise. Maybe I even smiled. Within hours I was called in to the CFO. The users were revolting. Oy vey. yosi Mohan, Ross wrote: Maybe too clever? Hell, they haven't fired me yet! Of course, every time i type something, my network card lights up and my hard drive whirs, but other than that, I have no reason to suspect my every breath is being monitored! -Original Message- Sent: Thursday, August 23, 2001 1:27 PM To: Multiple recipients of list ORACLE-L '..fire him, not the trigger.' ver-y clever. -Original Message- Sent: Thursday, August 23, 2001 9:47 AM To: Multiple recipients of list ORACLE-L Oh hell, if you don't trust him, just fire him, not the trigger. -Original Message- Sent: Thursday, August 23, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Anyone who can help, I've been asked if Oracle can somehow audit the DBA ie. Raise an alert if the DBA were to execute DML statements against sensitive tables, this assumes the DBA has the SYS password. I thought this was a pretty reasonable question but couldn't think of an answer. My trail of though was maybe an email alert to a designated member of staff sent via a trigger on the table. Any comments would be very appreciated. Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi
Re: Memory Sizing
Did you maybe use a different init file? Did you check the parameters in your email from sql or from the init file you think you're using to start the database? Just a sanity check, I'm sure you did all the right things... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sqlloader stops
So again I ask, how about running something while running your batched loads, so you can see - and even maybe let us know - what it's getting stuck on. You may even find that it's got NO sql session running, and the problem is in your batch process. That really sounds like your next step in debugging. Check it out, it might help. y lyudah wrote: If I execute one load at the time maually it loads fine. It gives me hard time when I try to run multiple loads(one after another) through the batch file. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 9:05 PM How about using some GUI tool (or even SQL) to see what SQL its running, if any, and what counters and waits are incrementing... Good luck, keep in touch :-) Yosi [EMAIL PROTECTED] wrote: Thanks Yosi. No, that is not the case..:-( -Original Message- Sent: Tuesday, August 07, 2001 5:37 PM To: Multiple recipients of list ORACLE-L Silly ol' me. Are you out of space in your archive log destination? This is like a guessing game. :-) [EMAIL PROTECTED] wrote: Hi List, I have another problem. I have a process that loads multiple (~ 20 ) files through sqlloader. It works fine on other servers. There is this one server that is giving me a hard time. It loads 3 files and then stops. I commented out the third call to sqlloader thinking may be there is something wrong with a third text file. It loaded 3 files again and stopped on the forth one. There is nothing in alert log (no errors). Also, there is enough space on the drive where the logs are going. Oracle 7.3.4 on NT. If anyone has any idea please let me know... Lyuda Hoska (703)797-8656 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
Re: OT : Way OT
My guess is that everyone's got too much time on their hands these days...
The market'll pick up, and the list will soften up.
I hope, on both counts.
Yosi
Kevin Kostyszyn wrote:
Wow!!! You're correct sir!!:)
KK
-Original Message-
Thomas F
Sent: Monday, August 06, 2001 2:42 PM
To: Multiple recipients of list ORACLE-L
Wow!
you can tell we are approaching a full moon. this list is getting a bit
nasty!
Tom Mercadante
{Very Humble} Oracle Certified Professional
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yosi Greenfield
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: sqlloader stops
Silly ol' me. Are you out of space in your archive log destination? This is like a guessing game. :-) [EMAIL PROTECTED] wrote: Hi List, I have another problem. I have a process that loads multiple (~ 20 ) files through sqlloader. It works fine on other servers. There is this one server that is giving me a hard time. It loads 3 files and then stops. I commented out the third call to sqlloader thinking may be there is something wrong with a third text file. It loaded 3 files again and stopped on the forth one. There is nothing in alert log (no errors). Also, there is enough space on the drive where the logs are going. Oracle 7.3.4 on NT. If anyone has any idea please let me know... Lyuda Hoska (703)797-8656 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sqlloader stops
How about using some GUI tool (or even SQL) to see what SQL its running, if any, and what counters and waits are incrementing... Good luck, keep in touch :-) Yosi [EMAIL PROTECTED] wrote: Thanks Yosi. No, that is not the case..:-( -Original Message- Sent: Tuesday, August 07, 2001 5:37 PM To: Multiple recipients of list ORACLE-L Silly ol' me. Are you out of space in your archive log destination? This is like a guessing game. :-) [EMAIL PROTECTED] wrote: Hi List, I have another problem. I have a process that loads multiple (~ 20 ) files through sqlloader. It works fine on other servers. There is this one server that is giving me a hard time. It loads 3 files and then stops. I commented out the third call to sqlloader thinking may be there is something wrong with a third text file. It loaded 3 files again and stopped on the forth one. There is nothing in alert log (no errors). Also, there is enough space on the drive where the logs are going. Oracle 7.3.4 on NT. If anyone has any idea please let me know... Lyuda Hoska (703)797-8656 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Unix and Oracle
How in the world did you come up with a subject line of 'Unix and Oracle?' I can't help you get that counter column on top of the buy and sell header line, you may want to put its column to the left of Officer, and maybe BREAK on it to not print duplicate values. And you may have to change some formatting to get the columns how and where you want them, and you can try using the TTITLE command to print column headers and not print column headers themselves (SET HEAD OFF). All that said, as far as the SQL is concerned, here: SELECT counter, officer, sum ( decode ( type, 'BUY', 1, 0) * Price ) Buy, sum ( decode ( type, 'SELL', 1, 0) * Price ) Sell FROMsome_table GROUP BY counter, officer / hth, Yosi Sinardy wrote: Hi all, I have a table with 3 columns which are Counter, Officer, TYPE, PRICE, Counter number 4 TYPE is only contain either Sell or Buy Officer number 4 price number 11 I want to spool out report with SQL to be like this example Counter : 0 -Buy- -Sell- Officer == 10 11 12 13 1212 0 1 1213 0 0 Total 22 25 I have a problem combining buy and sell column can someone help me please Thank you Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Bozeman
Walt (the resident Bozemanian), and All, I don't know if you heard or saw, the cover story in Inc magazine this week was all about Bozeman (and some other places). Some absolutely beautiful pictures in there too. (I shoulda posted this on Friday. When you're on extended vacation, Friday is much the same as Monday, and Friday I was out mostly.) Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: completely off-topic question...
Oy - I could NOT get through The Silmarillion, even though I loved the Hobbit (I was but a kid), and I really liked the Trilogy (although I admit to skipping lots of the songs and such...) Some people really read The Silmarillion, huh? Rachel Carmichael wrote: at least I read all of them, I even read The Silmarillion (sp?) before deciding that these were books that were never going to be on my to be re-read list I remember, from the animated Hobbit, the face of Frodo, and Gollum saying over and over MY Preciouss and SNEAKING! it sometimes amazes me what I can dredge up from the depths of the black hole I call my memory... I haven't seen that in at least 20 years, and I haven't read the books in longer than that. And no, I'm not going to try to read them again now to see if they are better than I remember. Too much to read, too little time to read it in From: Jared Still [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: completely off-topic question... Date: Sun, 05 Aug 2001 14:50:23 -0800 On Saturday 04 August 2001 16:25, Rachel Carmichael wrote: putting on armor in preparation for being stoned as a heretic here I am NOT a fan of Tolkein. I have read the Lord of the Rings trilogy and The Hobbit, seen the Bakshi version of the trilogy and the cartoon version of The Hobbit. Sorry, he just doesn't do it for me /removing armor Oh my, it's a good thing this is via email. Just wait till the next IOUG and I'll slip my ring on... Jared Rachel From: Thater, William [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: completely off-topic question... Date: Sat, 04 Aug 2001 10:46:04 -0800 Rachel Carmichael wrote: oh, my library is relatively small -- when you add in all technical, fiction, science fiction, mystery, craft books, throw in the knitting magazines I still only have about 7 bookcases. only 7?;-) sadly my collection was ... um... dispatched by a vindictive first wife so i have nothing left.:-( i miss many of them including stranger in a strange land and a boxed set of hobbit and lord of the rings. *sigh* i guess if i had the time i should start hunting in the second hand book shops. maybe later today if i get out of work in time. having fun playing with 9iAS and portal.;-) -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Management server??
You need to install it. The Console talks to a Management Server, which in turn manages the agents and other processes that monitor the database etc. You really oughtta read the basic installation manual. Not much, just like the first page or two might help. Raghu Kota wrote: Hi Friends When Iam starting my Enterprise Manger console, Its asking Oracle Management server??? What is that?? I tried with giving host name, But it did't work?? How to connect my EPM?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Question
Darren, Just as the % character is a wildcard that matches any number of characters, the _ character is a wildcard that matches any single character. So it matches the S in WORKSTATION, and then the % sign matches TATION_LOCATION. hth, Yosi Browett, Darren wrote: I have a simple query, but the results are somewhat puzzling select table_name from dba_tables where table_name like 'EDL_WORK_%' and I received the following TABLE_NAME - EDL_WORKSTATION_LOCATION EDL_WORK_AR_ENTITIES Why would I be receiving the first record (EDL_WORKSTATION) if I try EDL_WORK_A% I get the correct result. Is there something about the _% combination ? To solve the problem I used the substr command as part of the where clause. Darren - Darren Browett P.EngThis message was transmitted Systems Admin/DBA using 100% recycled electrons Information and Communications Technology. City of Coquitlam P:(604) 927 - 3614 E:[EMAIL PROTECTED] - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- suggestions to ensure nerdiness in potential IT
I taught a high school class to program Turbo Pascal running on CP/M. Now that was a program. There was one kid in the class who knew way more about this stuff than I did. They all got As. If I remember correctly, Microsoft bought QDOS from Seattle Computer Works for around $50k so they could have an O/S for IBM's first PC. I cannot remember the name of the guy who owned CP/M, but they would not sign IBM's non-disclosure agreement, and sent IBM to Gates. MS had nothing to lose so they signed and the rest is history. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: truncate during query
Ben,
You could test this yourself in about a minute. I don't have a db in front
of me, but I'm pretty sure the truncate, or any ddl operation, will fail
telling you it couldn't get a nowait lock.
Try it. Create a table, say t (a varchar2(1)); Then, insert into t ('x');
Then insert into t select * from t; Do this many, many times until
it takes several seconds to execute. (If you commit between those
inserts, it'll be easier on your rollbacks.)
When you have all these rows inserted, open another SQL session.
Type truncate table t; but DONT press enter yet.
Back in the first window, run a long query on t, maybe union the
query with itself a few times, so that the query takes 10 or 11 seconds
to execute; that should give you enough time to switch to the truncate
window and hit enter.
Then see what happens, and you'll have your answer.
Simple, no?
Ben Poels wrote:
Hi
What happens if you truncate a table, or drop an index, that
is currently in use by a long running query? Does the query
fail or does the truncate/drop hang up?
Thanks in advance,
Ben
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yosi Greenfield
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: OT -- suggestions to ensure nerdiness in potential IT
3) What company made the first Portable (luggable) computers? It was either Kaypro or Osborne. The Ozzy had a little tiny 40-column screen and dual 5.25 floppies. The Kaypro had an 80-column screen and dual floppies. I had a compaq 'portable' that was the size of an old, big, not-yet invented 486, but had a monitor embedded in the box. 15 years later, my brother tried to use this computer for something real, and I had to explain to him why I couldn't shlep around this thing, and why it wouldn't do that much for him altogether. He probably still has it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- the volume of job postings is way down
As one who has searched these boards of late, I concur. Someone posted a while back a good summary that went something like this: ... The postings are the same ones that have been there for months, but they get a new date on them every three days, the jobs that the postings are for don't exist, if there ever is a real opening all the boards post it from several different recruiters (call them what you will), and for those real jobs they want someone who's done dba, Legato, Veritas, Perl (12 yrs), and Sybase and DB2 to boot. AND they're offering 30k less than you were making at your last job I paraphrased, but that's what I've found too. Also, aside from the poor market, its summertime. Not many new projects start in the summer. I have my *first* interview with an actual hiring company in several *months* of looking, and that didn't come off the standard job boards, nor did it come from a recruiter. Wish me luck. By the way, I've alternately referred to the dot-bomb I came from as dot-compost. It has a nice ring to it. Maybe I can coin the term and make the rent that way... Sigh. Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Data Modeling opinion? Help?
Chris, It sounds like the client feels that the Business Mailer is simply a customer, albeit a customer with special needs, and therefore special fields. In your summary, you wrote: Aside from the average consumer, a Business Mailer(BM) can also file a claim. The BM has a special agreement with the client and gets special treatment when filing claims, and therefore a Business Mailer profile is created. ... which actually sounds also like the BM is simply a customer. So I can hear their point of view. Then again, as you point out, the BM is not actually a customer tied to a claim, like most customers, he's a repeat customer. And that sounds like a whole different logical beast, a different logical entity. So, from here, I find it's hard to tell if the BM is simply another customer or a new beast entirely. This would seem to me to be the crux of the problem. So they want to define their relationship with their client, the BM. My gut then says let 'em. It's possible to accomodate a 'customer type' in a customer table, so think of BM as an extremely limited way to handle customer type. (I know that's not how one would implement customer type, but they've decided they ONLY allow two customer types, I think I can deal with that.) What I don't know is do you feel there are already existing specific functions or reports that their spec won't be able to handle? If there are, then I go back leaning towards your design, otherwise I'd let them define their relationship with the BM. (Now my KIDS' relationship with THEIR bm, that's a whole different story!) My2c fwiw. Good luck in general, and in getting out before their model falls apart in particular, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Command History in SQL*PLUS
Bill, I'm on NT and the up and down arrows work peachy! That's one of the few things I don't miss about Unix. I didn't think there was anything additional running on my pc to allow the arrows to work, but they do for me. Hmm... Unless you're referring to the windows client. (I just thought of this right before clicking 'send.') I use the DOS client in a cmd window just for this reason. The Windows client doesn't use the arrow keys, the DOS version does. Is that what you meant? Yosi Thater, William wrote: Deshpande, Kirti wrote: On NT, I guess use your arrow keys... (Not sure of that, though).. nope, at least not with the 8.1.7 client. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 standby
Mark, isn't RAC just the upgrade for OPS? Then that would make it a 'standby' for the instance, but not a standby for the database, no? Am I misunderstanding something? y Mark Leith wrote: I attended the Oracle 9i opening yesterday at Oracle HQ in the UK, and one of the main points they discussed about 9i, was the use of Real Application Clusters (RAC). Of course you have to be running on Compaq hardware at the moment, but it takes the need for a standby away, as you essentially just plug the standby in to the cluster, and make use of it's computing power, instead of having the standby just stood waiting for a failure.. Just a thought.. Mark -Original Message- Turner Sent: Thursday, July 12, 2001 08:26 To: Multiple recipients of list ORACLE-L Anyone know if the standby in 9i can be in readonly mode while the logs are being applied? I've heard about this as being the case and also that this isn't the case. Thanks, Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 standby
Mark Leith wrote: No it is not the upgrade of OPS as I understand. They even put OPS down themselves saying that it was sparsely used, and far to complicated to set up. Th king is dead; long live the king! OPS was sparsely used, so they renamed it. I'm reading a book about the Communist system and the KGB in the USSR, and this sounds vaguely familiar. What RAC does, is essentially link every machine together in to a cluster, then each physical machine can touch the same database concurrently (probably on a central storage unit). There is no actual standby when this is in use, as all machines connected to the cluster work together - but if one of the machines has a hardware failure, the load is simply spread between the remaining machines.. Which is exactly what OPS did. You had several machines linked to a centrally stored db. One wen't down, the others picked up the slack. A fat lot I know, I never used it. But I'm pretty sure that's what OPS was all about. I'm sure they've added some functionality. At least, I *hope* they've added some functionality. When the central storage goes down, the RAC instances have nothing to run against. That's where standby comes in. It duplicates the central storage. As I said, I've never done either of these, AND I'm unemployed. So I MUST be an expert! Have a great weekend. Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sqlplus question ???
Yes, there is. You'll get at least 5 replies for this, 'cause it's an easy one, but maybe I'll be first. Sum computes on breakpoints, so you have to set the sum (which you did) and also set the breakpoint (which you did not). Add break on report to the sql file. Good luck, yosi Andrea Oracle wrote: Hi all, I have these in sqlplus: set pagesize 999 Set linesize 100 Col file_name format a50 Col bytes format 999,999,999,999 compute sum of bytes on report select file_name, bytes from dba_data_files order by file_name; The query returns all the data files back, but it did NOT show the sum of the bytes. Is there anything I forgot to set? Thank you. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Problem with performance
Alexander, All of the performance books you may one day read will tell you that before you tune waits, first make sure your SQL is good. That is, run explain plan (or any gui tool that will run explain plan for you) and make sure the sql is using the appropriate indexes, etc. If all that works, then try increasing your buffer cache. hth, Yosi Alexander Ordonez wrote: Hi gurus, I have problem with the performance of the Database the user report that db is very slow. i check the statistics i get: free buffer waits in 72774 buffer busy waits in 171940 this isthe only high..other is normal the dba shutdown every day in the night for backup somebody can help me!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED] UNIX is very user friendly, It's just very particular about who it makes friends with. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MINUS--Sql help
Rivandra, The minus operator is a set operator. It subtracts one result set from another. That is, the rows from the second result set that exist in the first result set are removed from the first result set, and the remaining rows are returned. To substract one sql numeric result from another, use sqlplus variables. col a new_value a_hold select 15 a from dual; -- a_hold now contains 15 select 25 - a_hold from dual; will provide the desired result. hth, Yosi Ravindra Basavaraja wrote: I am writing a SQL query using the MINUS operator.Both the select statements return a number result and I am trying to get the o/p with the difference of both the queries using the MINUS between the two select statements.But I am getting the o/p of the first query only and the displayed result is not the subtracted value.Both select statements give different number o/p when run individually.What could be wrong. Is there anything that i am missing to consider when using the MINUS operator. Pls help Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sqlplus command
Milind, You can't do sqlplus from procedures. There are some ways to get output from pl/sql. One is to use the dbms_output package, which does send output to a sqlplus session if you have set serveroutput on. Another idea that's used might be to put your output lines into a staging table, each record containing a field with the sequence number of that line in the output. Then when the procedure finishes populating that table, simply select the data from the staging table. (Oracle 8i global temporary tables are good for that too.) Good luck, y milind ambegaoker wrote: Dear mailing list, is it possible to execute SQLPLUS commands from subprograms like procedures and functions ? If possible pl. send me how to do it ? If not please tell me why and alternate way as i want to write sub programs(procedures) that would generate reports on the SQL prompt by using the SQLPLUS formatting commands. Do You Yahoo!? For regular News updates go to http://in.news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?milind=20ambegaoker?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Batch updates
We briefly thought of using Oracle Lite. It uses a subset of replication and advanced queueing to do its magic. It looked like it might have worked. But, as we wanted to sell a product, Oracle Lite licensing added like 300 bucks a seat to the product, so the boss decided not to go with it. Of course, 6 months later, that department is now dead, there is NO product, including no product that would have cost an extra 300 bucks. Yosi Guy Hammond wrote: Does Oracle Lite do this? I remember attending a seminar where Oracle were talking about running Lite on PDAs to support sales force automation. They could take orders and check inventory on their PDAs, query contacts and itineraries, etc, then it would replicate to real Oracle in one batch when they connected to dial-up every day. There was a mechanism for reconciling conflicts, for example if you had 100 units in stock, salesman A sold 50 and B sold 60, maybe customer A would get 45 units and B 55 until new inventory was ready. That sort of thing. g -Original Message- Sent: Friday, July 06, 2001 4:41 PM To: Multiple recipients of list ORACLE-L I'd appreciate hearing from folk what solutions there are for the following scenario. Users with laptops want to be able to input data whilst not connected to database for subsequent upload to database. Apart from developing PL/SQL code to realise this functionality with associated integrity checks etc. are there other possible (3rd party) solutions? If database was small enough there has been some notion of copying database to laptop and subsequently re-synchronising when connecting to central database. Are there solutions out there for this? I've a sneaking suspicion the solution to this is hidden in the caverns of my memory but it ain't coming out! Thanx in advance for anyone who takes time to reply :) Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 DBA Needed in Phoenix..
My turn. As someone with a current salary of $0.00, if I were to take a job with a 75k base, it would take _years_ to work my way back up to my most recent salary. (We're talking NY, so cost of living and salaries are higher than in many other places.) Although, as you write, Dick, I'm looking to the future with my seat firmly in the present. In the future I see a clear possibility of hungry children who need diapers, ambling about in tattered clothing. (Violins, anyone?) At which time, 75k may seem like alot. (Ok - it's really not that bad - only one of the kids needs diapers, the clothing shouldn't tatter for at least two or three months, and the kids are ALWAYS hungry anyway.) The question is a good one, 75k now or wait a few months, lose thousands and thousands of dollars, but get a salary commensurate with where I've been. A six month consulting gig would work awfully well now. Yosi [EMAIL PROTECTED] wrote: OH, I've stayed out of this one, but I think a word or two should be acceptable. $75K with minimal relocation may be cheap upfront, but if your current salary is $0.00 then this is better, even if the relocation $$$ are not what one would expect. Besides, I started here at $36K some 9 years ago pretty darn soon their going to crack the $100K barrier. So look to the future, even if one must live in the present (when one is at the bottom of the barrel, all roads point up). Besides I understand Arizona is a low cost of living state. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 7/6/2001 12:09 PM Here we go again! OCP means You Read The Book and Passed 5 Tests, Congratulations, Thank You for Your Money! Experience is what counts. $75,000 is middle ground. Again, I say! Middle ground salary with menial relocation package? CHEEAP! -Original Message- From: ef 8454 [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 06, 2001 2:42 PM To: Multiple recipients of list ORACLE-L Subject: RE: * Oracle DBA Needed in Phoenix.. $75,000 is pretty good. Our company (in Washington, DC) just hire a ORACLE DBA. He claimed he have OCP certificate and ONLY asked $60,000. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Politics vs. What's Right - long, sorry
Empathy oh empathy! Buckets and buckets of empathy! YOU candid and frank? No way!!! ;-)) y Koivu, Lisa wrote: Happy Friday everyone I've gone from a fast paced environment (small company), to an extremely fast paced environment (dot-com) , to my current employer (large company) that is so bogged down in politics that nothing is done 'right'. Even the tapes aren't switched for the backups on a regular basis - it's so bad that the operators will pop a tape out and push it right back in, and there's no protection on the backup files. In other words, backups may or may not work. I am not the one responsible for the db I am referring to above. The person who is claims that there's nothing much he can do other than complain to his boss, who complains to someone else (in another state) and suppossedly comes down on the operators. This has been going on for months and months. So as we were talking, he says to me, What would you do? Play the game, try to slowly change the system, or buck it? Well, since he's been taking the route of slow change, I said BUCK IT. I gave him three alternatives and even suggested either 1. quantifying the loss of one day's worth of data, or even being down for 10 minutes, or 2. flying out there and meeting the operators/their manager face to face and explain what the impact is, or do both. He said #2 would be viewed as going around his boss (well, don't do it without talking to your boss first, you clown). I also said, What's your #1 priority? He said, Keep my job. I said, yes, but a dba's job is to always be able to recover, dude, you know that! There's a lot more than this situation above that is stuck in a political game. Most notably, funds for the project I am suppossed to work on - coincidentally, we have no hardware. I may be blowing off steam here, and if that's what you think I am sorry. However I'd be interested in what angle you would take. I am NOT a politician - I am very candid and frank. I am no buttkisser. This is gonna be difficult and I honestly don't know if I want to stick around for this. How many of you have been in this type of situation? Thanks Lisa Koivu Oracle DataBORED Administrator 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 11 disks to build a DB, suggestions
Diego, I think log02 is not a redundant log01, I'm pretty sure it's the second redo log group, without which it will be pretty difficult to run the database :-). Maybe Rahul shouldn't delete it. Yosi -Original Message- From: Diego Cutrone [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 5:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: 11 disks to build a DB, suggestions Hi Rahul, Here's what I think. I would eliminate log02 , because redo log files are already mirrored (D1 is mirrored right?) Another recomendation is to use RAW for the redo logs. By eliminating log02, and according to your load (600,000 rows using sql*loader) every night, I think you are going to improve performance a lot. If you can't use RAW for the REDO, at least try to use aync I/O or direct I/O on these filesystems. I would create only one control file mirrored by hardware too. Also if your internal disks are faster than the external ones, I would place redo logs over the faster disks. And I'd leave D1 dedicated to redo logs in order to eliminate seek times. please someone correct me if I'm wrong hope it helps greetings Diego - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 7:25 AM List, i have been given 11 Hdisks (36GB each) to build a database (816) the DB involves heavy loads (600,000 rows using sql*loader) every night. three drives are internal and the rest are external. main table involved is SALES , which i have partitioned by year 2000, 2001 and a scratch partitioned to hold any other years sales data (which i will split later) the DB will be running in NOARCHIVELOG, to provide some guard against failure i plan to mirror (1:1) 4 drives, which leaves me with 7 drives to use. D1 to D4 are mirrored. D5,D6,D7 are NOT mirrored D1 - log01 + SALES DATA FOR 2000 (keeping this partition with the log because 2000 sales data wil not be queried often) D2 - DATA1 + DATA2 + SALES DATA FOR 2001 D3 - SALES SCRATCH + log02 ( this scratch partition will be used when rows for year 2002 starts coming in) D4 - DATA3 + DATA4 + SYSTEM D5 - RBS01 + USER_TEMP + INDEX01 D6 - RBS-2 + INDEX02 + TEMP_TABLES D7 - solaris system + oracle engine. would really appreciate if someone could review this config , and suggest improvements. Regards 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: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Online backup script..........
Now THAT is both useful AND entertaining! -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 04, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Subject: Re: Online backup script.. Robert, After going through the archives I find that in the past year you have posted 14 times to this list, and once you had something to say about Oracle. The rest were rude replies that were completely unnecessary. I've reached the level of my tolerance with your acrimony. This list is supposed to be useful and occasionally entertaining. You contribute to neither. Goodbye, Jared On Wednesday 04 July 2001 15:55, Hutchins, Robert wrote: Ask me if I care -Original Message- Sent: Wednesday, July 04, 2001 5:35 PM To: Multiple recipients of list ORACLE-L My, my...were you afraid he wouldn't understand the 1st reply? In the vein of 'if you were the last man on earth...' you can delete my mails in the future, because you can be sure I will be deleting yours. Have a good day anyway!! Laura -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, July 04, 2001 4:05 PM To: Multiple recipients of list ORACLE-L Read the F--- manual. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tracing Events - Anybody have a list of the Events?
Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: Tracing Events - Anybody have a list of the Events? Very cool, Thank You. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Scott Shafer sknd100@yahoTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] o.com cc: Sent by: Subject: Re: Tracing Events - Anybody have a list of the Events? root@fatcity. com 07/05/2001 11:51 AM Please respond to ORACLE-L Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: Morning Folks - Hope those of you in the US had a safe and happy 4th - for those of you who didn't celebrate this particular holiday, hope your day was also safe and happy ( every day should be safe and happy!). I'm trying to set up some tracing for various events/levels. Not using OEM. In the past (and currently), I've just used: event=10046 trace name context forever,level 4 This of course provides the requisite information, but really can tell you much more than you want (or need) to know. The trace levels given on Metalink are: 1 - Enable standard SQL_TRACE functionality (Default) 4 - As Level 1 PLUS trace bind values 8 - As Level 1 PLUS trace waits However they state in multiple messages that: Events should be set only under the direction of Oracle Support and/or Development. Some events produce additional diagnostic information, others are intrusive into database operations, while others can effect data in the database. Syntax varies between events as does the meaning of the level. Oracle Support/Development will identify the proper syntax and level (if applicable) you
RE: Tracing Events - Anybody have a list of the Events?
Yeah, thanx all. It seems us poor NT users can't see the events list. We only rate an MSB file, not an MSG file. -Original Message- From: Scott Shafer [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 3:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Tracing Events - Anybody have a list of the Events? Try oraus.msg (if it exists). Sorry I don't have an NT install (woohoo! ;-) to check on... Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: Tracing Events - Anybody have a list of the Events? Very cool, Thank You. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OFA (Optimal Flexible Architecture) in practice
Linda, Try ls -ltr /*/oradata/db_name1/* Didn't think of that, didja. It's actually pretty cool that (in Unix) you can actually reference all your data/log/control files with one filespec. Doesn't work well on NT, but it's better than non-OFA. HTH, Yosi "Hagedorn, Linda" wrote: Does anyone use OFA as their company standard? If so, are there any complaints about it's structure? For example, the commingling of different database subdirectories under a given mount point? e.g.. /u02/oradata/db_name1/userdata01.dbf /u02/oradata/db_name2/userdata01.dbf /u03/oradata/db_name1/userdata02.dbf /u03/oradata/db_name2/userdata02.dbf You cannot cd to a given subdirectory, ls -ltR | more to see all the datafiles associated with a given database. Instead, from / you have to ls -ltR | grep db_name1 to scan the full file system. Seems like there should be a better way. Any input, pro or con, is appreciated. Thanks, Linda -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED]
RE: Disk layout for datafiles
Pronounced "ofa?" I've always pronounced it "Oh Eff Ay." Does this say something about my certification? Or is it a 9i thing? :-) I need a job. Pronounced "job." Yosi -Original Message-From: Guy Hammond [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 03, 2001 4:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Disk layout for datafiles It's called the Optimal Flexible Architecture, or OFA (pronounced "ofa"). A Google search brings up lots of resources onit: http://www.google.com/search?q=Optimal+Flexible+Architecturehl=xx-borklr=lang_en g -Original Message-From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 7:31 PMTo: Multiple recipients of list ORACLE-LSubject: Disk layout for datafiles I found and then lost a Metalink document about laying out datafiles underfive or seven mount points. Does anyone have a link to this note, or any regarding datafile naming conventions/path layouts for unix/sun? Thanks, Linda
RE: sqlloader question
Lyuda, According to the good ol' doc, when you use a direct load with the ROWS param, Loader will count the rows it's building into blocks, and 'save' the blocks when each time ROWS is reached. I've used ROWS in direct loads, and it worked as advertised. The loads were still fast, and data was saved at the number of ROWS specified. There is a difference between a 'save' during a direct load with ROWS, and a COMMIT during a conventional load with ROWS. According to the doc, the only difference is that during a direct load, any indexes are marked unusable. If the load crashes, 'saved' rows will still be there, and you're indexes will need to be recreated. (You're indexes would need to be recreated anyway if a direct load crashes. Just that if you use ROWS, whatever's been saved so far is saved.) Hope this helps somewhat, Yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 1:02 PM To: Multiple recipients of list ORACLE-L Subject: sqlloader question Hello oradba's, I have a general question about sqlloader. There is an option called ROWS. According to Oracle Complete reference by G.Koch and K.Loney ROWS is the number of rows to buffer together for an insert and commit. Default value is 64. According to one of my coworkers specifying ROWS in combination with LOAD=DIRECT is not a good idea. Supposedly it will confuse and slow down the load, possibly throw it to a non-direct load. The theory is based on the following idea: during direct load sql loader is not supposed to count and commit records. Does it sound like true? Lyuda Hoska -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql question
John, It's a pretty common practice to create a dates table. Comes in handy in many ways, one of which you've just encountered. Sorry that wasn't the answer you wanted. Have a great weekend anyway :-). Yosi -Original Message- From: Shaw, John B [mailto:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Subject: Sql question I want to get every date between two user entered date's whether or not it exists in the table and then the quantity of data for the date if any exists. My table t1 has date and quantity values (may be more than one quantity field per date) and I want 0 for all dates in the range where no data exists. Is there a sql to get this without making some kind of date table? so if the user enters 03/02/01 and 03/06/01 they get. 03/02/01 10 03/03/01 1 03/04/01 0 03/05/01 0 03/06/01 8 They want to load into a spreadsheet. tia. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Urgent! Virus Alert.
All, I just got two emails from Venkata Apparao 'replying' to posts I made weeks go. The only line in the text told me to see the attachment. Yeah, I'll do that. My mail server told me it found and cleaned a virus. I imagine most of you, if you also received such, figured it out yourselves. For those of you that didn't, consider youselves warned. Yosi -- 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: * Sr. Oracle DBA Needed in Kansas City, Kansas area..
Oh c'mon guys. Don't stop. 4 years replication, 3 years data warehouses - minimum 2 terabytes; Erwin, Designer 2000. Toad is a plus. I go through 10 of these a day now. Ugh. Yosi [EMAIL PROTECTED] wrote: Lisa: You need to update this. Must not be over 30 years old with a minimum of 15 years of post graduate work as an Oracle DBA with a minimum of 5 years of experience with 9i and 11i. etc. Ken Janusz, CPIM Requirements: Must be able to lift heavy database files. Must be at least 30 years old, having graduated from college and immediately become a DBA and put in your 7 years. This position is with a Great company offering: Base salary only. 110K is only to get your attention. The opportunity to become the most abused member of a team. The opportunity to live in Kansas City (is that good or bad?) I can't stand headhunters. They serve a real purpose but a majority of them are jerks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
Reality check. Is write on that table granted to public? -Original Message- From: Krishnan, Manjula R. [mailto:[EMAIL PROTECTED]] Sent: Friday, June 22, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Subject: Dear DBA's: Have any of you come across this bizzare behavior? We have an application that was written using Forms 6i. It runs on the web (using OAS 4.0.8.2) on an 8i database. A user has been granted access through a role. This role APP_READ only has select privileges on all the tables for the application. But, on one of the forms the user is able to write into a table. This form uses a package to write into the table. The role has execute on the package. I checked the form code to see if there was any explicit connect. There was none. I even recreated the user and the same thing is happening. Can anyone explain this? Thanks, Manjula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishnan, Manjula R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Large volumes of users
All, Can someone please point me to a paper or papers on supporting large numbers of users and connections? I find that most scalability papers talk about data, not users. How do you support thousands of users? Does anyone use cman? My current volume of zero users (one on a good day) has sort of left me out of reality on this, and my job search is forcing me to actually think about things like this. Thanks, as always, Yosi Yosi Greenfield Oracle Certified Professional [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).
RE: exp performance question ( direct=y)
I believe so. It may have a slightly different meaning. Rows, commit, these things act a little differently. (Is that not specific enough?) And direct is an exp param, that greatly affects your imp. Statistics is another exp parameter that takes affect on import. The export puts a stats statement in the dump file, which imp finds and executes. I imagine direct works the same way. A quick test on a tiny table shows that conventional exp creates a dump file that's slightly bigger. Visually, in a text editor, both files look very much alike. And the timing difference - for the export - was BIG. The conventional exported in12 seconds, the direct was INSTANT, less than a second. I've experienced the same onlarge tables, and I probably even have timings saved somewhere. HTH, Yosi -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 4:01 PMTo: Multiple recipients of list ORACLE-LSubject: RE: exp performance question ( direct=y) I dunno. Does the BUFFER still matter when DIRECT=Y? If so, I either remove it entirely, or multiply it by about a factor of five or so. my $0.02 -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:43 PMTo: Multiple recipients of list ORACLE-LSubject: Re: exp performance question ( direct=y) Ron, ok i'm now confused, exp direct=n|y imp no such option sql_loader has direct also. or am i missing something here? joe [EMAIL PROTECTED] 06/22/01 03:00PM I thought that DIRECT=Y was for imports only. It makes since because in the import you are placing the data directly into the blocks with out a redo log.I have no idea why there was a difference in the times unless it was the extra overhead for a command that was not used.ROR mª¿ªm [EMAIL PROTECTED] 06/22/01 12:55PM Oracle : 8.0.5Platform : SunCurrently we have cron job every night (starting from 11pm) to do export. I changed the setting "direct" to "y" two days ago while leaving all other parameters unchanged, hoping to gain some performance. I am a bit surprused to find that it did not. It actually took longer to create dump file with less data to export. The whole exp process takes about 2 hours to finish. Yes, there could be lots of other unix processes running during that time. But I would still expect to see some improvement because we are doing this way for quite a while. So my questions are:1. From your "real" export experience, how much performance boost did you see when you set "direct=y"?2. If "direct=y" improves the performance, why would anyone want to use "direct=n"?Thanks.Guang-- here is my orcle dump file's time stamp:(dmp.1 and dmp.2 are from direct=y,dmp.3, dmp.4 and dmp.5 are from direct=n).-rw-rw-r-- 1 mt prog 1042197132 Jun 18 01:05 oracle.dmp.5.gz-rw-rw-r-- 1 mt prog 1042375633 Jun 19 01:04 oracle.dmp.4.gz-rw-rw-r-- 1 mt prog 1042556662 Jun 20 00:25 oracle.dmp.3.gz-rw-rw-r-- 1 mt prog 1034773279 Jun 21 01:17 oracle.dmp.2.gz-rw-rw-r-- 1 mt prog 1035237986 Jun 22 01:22 oracle.dmp.1.gz--here is the parameter file:BUFFER = 64000COMPRESS = YCONSISTENT = NCONSTRAINTS = YDIRECT = YFILE = /oracle/exports/oracle.dmp.pipe#FULL = YGRANTS = YINDEXES = YLOG = /oracle/exports/export.logROWS = YUSERID = xxx/yyyOWNER = (aaa,bbb)_Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
RE: exp performance question ( direct=y)
Don't you wish you could take back posts? (Jared, Bruce - how's that for a feature!?) Rows is SQL*Loader, not exp/imp. I mean it's exp/imp also, but it means something else in Loader, and in Loader it differs for direct path. And I meant Loader's bindsize also, not exp/imp's buffer. I mean... well never mind what I mean. Basically, ignore that first para- graph. Read Chris' post, ignore mine, I've had it, and I'm outta here. It's been a long week, and it's time for a weekend. Have a great one y'all. y -Original Message-From: Yosi Sent: Friday, June 22, 2001 5:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: exp performance question ( direct=y) I believe so. It may have a slightly different meaning. Rows, commit, these things act a little differently. (Is that not specific enough?) And direct is an exp param, that greatly affects your imp. Statistics is another exp parameter that takes affect on import. The export puts a stats statement in the dump file, which imp finds and executes. I imagine direct works the same way. A quick test on a tiny table shows that conventional exp creates a dump file that's slightly bigger. Visually, in a text editor, both files look very much alike. And the timing difference - for the export - was BIG. The conventional exported in12 seconds, the direct was INSTANT, less than a second. I've experienced the same onlarge tables, and I probably even have timings saved somewhere. HTH, Yosi -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 4:01 PMTo: Multiple recipients of list ORACLE-LSubject: RE: exp performance question ( direct=y) I dunno. Does the BUFFER still matter when DIRECT=Y? If so, I either remove it entirely, or multiply it by about a factor of five or so. my $0.02 -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:43 PMTo: Multiple recipients of list ORACLE-LSubject: Re: exp performance question ( direct=y) Ron, ok i'm now confused, exp direct=n|y imp no such option sql_loader has direct also. or am i missing something here? joe [EMAIL PROTECTED] 06/22/01 03:00PM I thought that DIRECT=Y was for imports only. It makes since because in the import you are placing the data directly into the blocks with out a redo log.I have no idea why there was a difference in the times unless it was the extra overhead for a command that was not used.ROR mª¿ªm [EMAIL PROTECTED] 06/22/01 12:55PM Oracle : 8.0.5Platform : SunCurrently we have cron job every night (starting from 11pm) to do export. I changed the setting "direct" to "y" two days ago while leaving all other parameters unchanged, hoping to gain some performance. I am a bit surprused to find that it did not. It actually took longer to create dump file with less data to export. The whole exp process takes about 2 hours to finish. Yes, there could be lots of other unix processes running during that time. But I would still expect to see some improvement because we are doing this way for quite a while. So my questions are:1. From your "real" export experience, how much performance boost did you see when you set "direct=y"?2. If "direct=y" improves the performance, why would anyone want to use "direct=n"?Thanks.Guang-- here is my orcle dump file's time stamp:(dmp.1 and dmp.2 are from direct=y,dmp.3, dmp.4 and dmp.5 are from direct=n).-rw-rw-r-- 1 mt prog 1042197132 Jun 18 01:05 oracle.dmp.5.gz-rw-rw-r-- 1 mt prog 1042375633 Jun 19 01:04 oracle.dmp.4.gz-rw-rw-r-- 1 mt prog 1042556662 Jun 20 00:25 oracle.dmp.3.gz-rw-rw-r-- 1 mt prog 1034773279 Jun 21 01:17 oracle.dmp.2.gz-rw-rw-r-- 1 mt prog 1035237986 Jun 22 01:22 oracle.dmp.1.gz--here is the parameter file:BUFFER = 64000COMPRESS = YCONSISTENT = NCONSTRAINTS = YDIRECT = YFILE = /oracle/exports/oracle.dmp.pipe#FULL = YGRANTS = YINDEXES = YLOG = /oracle/exports/export.logROWS = YUSERID = xxx/yyyOWNER = (aaa,bbb)_Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists--
Passwords - another angle - sqlarea
All, I just tested changing my password and looking in the v$sql... views to find my new pw. As I figured, the statement stops at ident. How does this work? Does Oracle automatically not keep parsed pw-changing SQL in memory, giving up parse time for security? Obviously, you'd never rerun that SQL statement anyway, so it's not even giving up anything. I just want to confirm that Oracle is indeed doing this on purpose. Thanks, Yosi -- 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: * I'm Looking for an Oracle Financials DBA for Miami,
There's a posting from New York City for an Oracle DBA, but it would involve a minimum 25k pay cut. I have friends who work for the city and like it, but I just can't see taking out the 25k. Money isn't everything, but I've got a bunch of mouths to feed. I'm not complaining - I thank God every day for those mouths. But they just keep on eating! :-) y -Original Message- From: Gene Sais [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: * I'm Looking for an Oracle Financials DBA for Miami, yeah - i went from a .com to govt, 17k pay cut. but heck, i work 4 10 hr days. money isnt everything :) [EMAIL PROTECTED] 06/20/01 08:42AM I don't doubt that there are openings available in the Govt sector. The pay scale for Govt workers is notoriously lower that the open market. I had a job offer to work for the Dept of Natural Resources in GA but I could not handle the $20K pay cut. ROR mª¿ªm -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: New system, cart blanche, what to buy
That sounds wrong. Thanks everybody, not just Gene. This discussion is great. I just meant I liked Gene's format on this posting. y -Original Message- From: Yosi Sent: Wednesday, June 20, 2001 12:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: New system, cart blanche, what to buy Gene, that was great. Thanks. y -Original Message- From: Gene Sais [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 8:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: New system, cart blanche, what to buy Vendor=dec (well compaq) Cost=moderate Reliable=sometimes, if openvms Support=good Positives=cluster sw Negatives=pc company, not sure of future for vms or digital unix Vendor=hp Cost=moderate/high Reliable=yes Support=good Positives=ha mc service guard Negatives=you are on your own Vendor=ibm Cost=moderate if you buy everything from them Reliable=yes Support=excellent Positives=hacmp, ibm will hold your hand all the way and insist on it :) Negatives=ibm does it their way Vendor=sun Cost=cheap Reliable=depends on hw Support=ok Positives=cheap and open systems Negatives=you put it together [EMAIL PROTECTED] 06/19/01 07:36PM I would vote for AIX and RS/6000. From my experience, those are robust servers and IBM has got good phone support. However, I do not I would fully second that. (And your SAs are going to love its easy Admin capabilities) real bad experience. Other than that, AIX is one of the best OSs I have worked on. FWIW .. truss will be available with AIX 5L (this fall, I was told). That's good news, Kirti. However, there are lots of other utilities out there from IBM that they have not really advertised or pushed out for AIX - I wonder why... John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Quick select question
I use this script, counter.sql: set echo offset pages 0set trimspool onset lines 199set feed off set term offspool counter1.sql prompt col table_name form a30 head 'Table Name'prompt col cnt form ,999,999 head 'Count'prompt spool counter.lstprompt set term onprompt prompt Table Name Countprompt prompt -- -. select 'select ''' || table_name || ''' table_name, count(*) cnt from ' || table_name || ';'from user_tables/prompt spool offprompt set feed onprompt set pages 40spool offset term on@counter1$ del counter1.sql -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 20, 2001 1:17 PMTo: Multiple recipients of list ORACLE-LSubject: Quick select question All, Anyone know how to get a list of tablenames and the count of rows in them TABLE_NAME COUNT === == LEE 10 LEE1 25 LEE2 17etc etc I know it can be done if the tables are analyzed and from user_tables but was wanting to know how to do it from sqlplus. Tru64 8.0.5.0.0 TIA Lee The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
New system, cart blanche, what to buy
All, For a position that would (possibly) like me to set up an Oracle infrastructure from scratch, on Unix. Given the opportunity to choose from any system, what hardware would you pick? From the small bit of information I've been able to glean, it'll be fairly large, and need failover. I obviosuly can't guess the size of the system, but one part of the question is vendor. I'm familiar with Solaris, but HP seems to be platform of choice these days. And each vendor has their own storage methodologies, and their own HA clustering mechanisms. And there's always OPS. Any opinions, pointers, caveats? (Is this a broad enough question? :-) Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Multiple databases under the same ORACLE_HOME
Yes. Each db gets its own service, created by you, using the oradim command (and/or two services, and/or oradim80, both depending on the version of Oracle you're running.) You would want to separate the db's data files from the Oracle_Home anyway. The only thing in Oracle_Home would be the init.ora file, which would contain the line ifile=FILENAME where FILENAME is the name of the db's real init.ora file, which you put in its own database specific directory outside of Oracle_Home. Check out the paper(s) on OFA, Oracle Optimal Flexible Architecture, available in many places on the net, I imagine Metalink has it too. HTH, Yosi -Original Message- Sent: Monday, June 18, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Dear list ! Is it possible to create multiple databases/instances under the same ORACLE_HOME on NT ? If yes , what should be done (create services etc..) ? Thanks a lot in advance for your answer. -- 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).
Reorgs in general
All, Oracle's party line has for a while been that for the most part reorgs aren't necessary anymore, right? Assuming storage initially has been set decently? Are reorgs very common in these parts? Also, even according to those who find reorgs still necessary, they should completely go away with LMT's, right? Opinions all? Thanks, Yosi Greenfield Oracle DBA, Will work for food [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).
Re: Need Help
Ken, Welcome to the club. Are we starting a trend? At least we're not competing against each other. Good luck, Yosi [EMAIL PROTECTED] wrote: I need some help. I was an Oracle DBA with ADC Telecomm in Minnesota and was laid off along with 7,000 other ADC employees. The job market here in the TCs has been very slow. Any assistance finding another Oracle related position would be greatly appreciated. Please contact me directly at [EMAIL PROTECTED] Relocation from the Mpls / St. Paul, MN is not an option. Thanks much, Ken Janusz, CPIM -- 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). -- Thanks, Yosi - Yosi Greenfield Database Architect Comhill Systems, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT SPAM : Become an Oracle Certified DBA in 5 Weeks
Yup. And another one today also from a recruiter with a french name that I don't remember that sort of demanded I email him my current whereabouts, statistics and resume. Deleted them both - and I'm pretty desperately LOOKING for a job. How not to win friends and influence people. Yosi Joe S. Testa wrote: Did anyone else on the list get this stupid spam besides me? thanks, joe -Original Message- To: [EMAIL PROTECTED] Sent: 6/12/01 5:48 PM OraKnowledge eBoot Camp for the Oracle8i DBA Track OraKnowledge has created a blended e-learning program that GUARANTEES Oracle DBAs will become certified. The 5-week program combines the best of self-paced and instructor-led e-learning utilizing: * Syllabus for Success * Certification Exam Guides * Pre-assessment tests * Live, virtual classroom instruction from an OCP * 24 x 7 OCP Mentoring * eFlash Cards * Hundreds of Practice Questions * Guarantee Seats are available for our July 16th (EST) and July 18th (PST) start dates!! Visit http://www.oraknowledge.com for more information. To UNSUBSCRIBE from our list, reply to this email and replace the subject line with UNSUBSCRIBE. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe S. 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). -- Thanks, Yosi - Yosi Greenfield Database Architect Comhill Systems, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rollback use query
Right. I knew that part too, and I'm feeling much better now. I was beginning to get a queasy uneasy feeling there, where your world spins out of focus type thing. :-) Thanks, Anita. -Original Message- From: A. Bardeen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 2:02 PM To: Multiple recipients of list ORACLE-L Subject: RE: rollback use query Kirti and Yosi, It's a good idea to not argue with Anita! :) Oh puhleeze!! Argue with me all you want, especially when I'm wrong. I'm a big girl, I can take it ;) Now if you want to convince my boyfriend not to argue with me, be my guest! You're both correct and I should have been more specific in my response. The rollback generated is due to the dd changes for creating the new table and extent allocation, so it's no where near the amount used for the equivalent create table and conventional inserts. It's not exclusively DDL, though as it does require a non-system RBS, whereas a simple create table statement doesn't. -- Anita --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Hi Yosi, It's a good idea to not argue with Anita! :) Just do a simple test to confirm. Monitor 'writes' in v$rollstat before and after running the CTAS. Good, if you have a test db and no one but you are the sole user. You will never ever forget what you find. Just do it! :) Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 4:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: rollback use query I'd hate to argue with Anita, but I'm pretty sure that rollback won't be used on CTAS, since it's ddl. Somebody verify or correct please? Thanx, Yosi -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 1:21 PM To: Multiple recipients of list ORACLE-L Subject: rollback use query Hi Gurus I have one question. Create table tbl2 as select * from tbl1; will above query use the rollback segment or not? and why? Thx -Seema -- 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Job search on this list
All, I hate interrupting all the scrumptious, gastronomic activity going on today, but... How much of a no-no is it to use this list to declare myself officially almost- unemployed and looking for work? The way I figure it is that if one does this regularly and uses this board as a free advertising forum, that would be bad, but to let everyone know that the writing is on the wall, in bold, and I'll consider all offers for food would be ok. Since that's how I figure it, here goes: For rent or sale: one 15-year Oracle dba / engineer / architect, with certification. Market-rate to possibly pricey, communicates very well, and can (usually) make the database sing. For details, contact Yosi Greenfield at [EMAIL PROTECTED] (for a LIMITED time!), or at [EMAIL PROTECTED] Any offers of employment will be considered - possibly gasped at with a look of horror, but considered. Any offers of food will be queued until the offers of employment run out. Ok y'all, really now, if anybody's got a need or a lead, lemme know. MUCH thanks, Yosi Yosi Greenfield [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).
RE: rollback use query
I'd hate to argue with Anita, but I'm pretty sure that rollback won't be used on CTAS, since it's ddl. Somebody verify or correct please? Thanx, Yosi -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 1:21 PM To: Multiple recipients of list ORACLE-L Subject: rollback use query Hi Gurus I have one question. Create table tbl2 as select * from tbl1; will above query use the rollback segment or not? and why? Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.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). -- 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: Need help tuning FTS
Wild guess, way out of left field, is there a sequence in the select statement, that might have a high cache value in QA, but a low cache value in prod? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 2:47 PM To: Multiple recipients of list ORACLE-L Subject: Need help tuning FTS All, I need some help in tuning a select statement that performs a FTS. (The FTS is deliberate !) It takes over 5 hours to run in our prod instance, but takes less than 10 min in our QA instance. The QA instance was copied from prod about 6 weeks ago and is identical to prod, except for db_block_buffers whose value is 2 in prod and 15000 in QA. The instances run on identical hardware (Compaq TRU 64, 8 Gig RAM 8 cpus). The table in question has 3 million rows in prod and 2.8 million rows in QA. Explain plans are identical. DB version in both is 8.1.6.0 and both are using RBO. While running in prod, I took a level 12 trace and here is a snippet form the trace file - WAIT #1: nam='latch free' ela= 2 p1=17190174328 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17190304728 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189692728 p2=66 p3=0 WAIT #1: nam='dbfile scattered read' ela= 1 p1=12 p2=266267 p3=16 WAIT #1: nam='latch free' ela=2 p1=17189819928 p2=66 p3=0 WAIT #1: nam='latch free' ela= 27 p1=17190272728 p2=66 p3=0 WAIT #1: nam='db file scattered read' ela= 0 p1=12 p2=266269 p3=15 WAIT #1: nam='latch free' ela= 3 p1=17189935928 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189917528 p2=66 p3=0 WAIT #1: nam='db file scattered read' ela= 5 p1=12 p2=266804 p3=16 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266820 p3=16 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266836 p3=16 WAIT #1: nam='db file scattered read' ela= 4 p1=12 p2=266852 p3=16 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266868 p3=16 WAIT #1: nam='latch free' ela= 5 p1=17190273528 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17190310328 p2=66 p3=0 WAIT #1: nam='latch free' ela=1 p1=17189831128 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189801528 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189801528 p2=66 p3=0 WAIT #1: nam='latch free' ela= 3 p1=17190166328 p2=66 p3=0 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266884 p3=16 WAIT #1: nam='db file scattered read' ela= 3 p1=12 p2=266900 p3=16 WAIT #1: nam='latch free' ela= 2 p1=17190259928 p2=66 p3=0 I see a lot of time is spent in waiting for latch #66 (cache buffer chains) - Metalink states that this could be because of a *very* hot block being accessed frequently, further snooping (via x$bh) shows that there is no such contention. Can anybody help ? Thanks much ! Srini Chavali Oracle DBA Cummins Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: what to put in place of null
Don't think so. Use: ... union select '', '', dd2, dd3 / The empty string is equivalent to null for inserts and updates. hth, Yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 6:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: what to put in place of null Try applying data conversion function to_char/to_date or nvl function if dd and dd1 are numbers to the nulls in the second select. Example: cursor c1 is select dd,dd1,dd2,dd3 from dd union select to_char(null),to_char(null),dd2,dd3 from dd1; The point here is you need to have as many columns in your second select statement as your first select has and the datatypes have to match. -Original Message- Sent: Tuesday, June 05, 2001 5:31 PM To: Multiple recipients of list ORACLE-L Hi, I have a cursor declared as cursor c1 is select dd,dd1,dd2,dd3 from dd union select null,null,dd2,dd3 from dd1; i am getting error: * ERROR at line 1: ORA-01790: expression must have same datatype as corresponding expression ORA-06512: at DY.REST, line 4 ORA-06512: at DY.REST, line 10 ORA-06512: at line 1 what to replace null with.. dd1 has only 2 columns dd2 and dd3. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: what to put in place of null
On second thought, to_char and to_number as well, I just prefer '' for chars. So, never mind. (And I just told Lisa that I was NOT an idiot, not today at least. That was then, this is now.) -Original Message- From: Yosi Sent: Tuesday, June 05, 2001 7:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: what to put in place of null Don't think so. Use: ... union select '', '', dd2, dd3 / The empty string is equivalent to null for inserts and updates. hth, Yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 6:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: what to put in place of null Try applying data conversion function to_char/to_date or nvl function if dd and dd1 are numbers to the nulls in the second select. Example: cursor c1 is select dd,dd1,dd2,dd3 from dd union select to_char(null),to_char(null),dd2,dd3 from dd1; The point here is you need to have as many columns in your second select statement as your first select has and the datatypes have to match. -Original Message- Sent: Tuesday, June 05, 2001 5:31 PM To: Multiple recipients of list ORACLE-L Hi, I have a cursor declared as cursor c1 is select dd,dd1,dd2,dd3 from dd union select null,null,dd2,dd3 from dd1; i am getting error: * ERROR at line 1: ORA-01790: expression must have same datatype as corresponding expression ORA-06512: at DY.REST, line 4 ORA-06512: at DY.REST, line 10 ORA-06512: at line 1 what to replace null with.. dd1 has only 2 columns dd2 and dd3. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: RE: Fire your DBA's you don't need them anymore...
Yeah, I'd say that proportion would have worked in my group too. And when I interviewed others, I rarely got any great people applying, and it's almost solely because at that level, dollars were so much better as independents, and the only people who wanted to come were visa-sponsors or relative newbies. Again, I really had a great run there, and I'm grateful. (I don't know why I need to keep saying that.) And, I'd even probably go back if I could work out the salary. But I haven't tried. Anyway, still rambling, Yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Subject: Re:OT: RE: Fire your DBA's you don't need them anymore... Yosi, I interviewed for one of those jobs here in Boston, MA. Although there was one VERY good individual in the bunch I was a little perplexed by the others. Most were very junior and had not been in an outside shop before, one was straight out of school and bootcamp and only one had done a real recovery. It also hit me as strange that other than the smart guy, none of them had ever created a database from scratch. Thankfully I did not take the job. Dick Goulet Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 5/25/2001 11:52 AM From experience, I have used consultants from Oracle. The 1st one sent was right out of DBA school. We sent him back after 1 week. At that time, Oracle didn't allow you to interview their DBA's. According to Oracle, they were all good. The 2nd DBA Oracle sent had only NT experience, never been on a Unix machine. Ok, sent him back too. By this time, we were about to give up, then Oracle sent DBA #3 and she was sharp. The moral of the story, Oracle will send the juniors 1st b/c they save the good ones for the 3rd strike :) [EMAIL PROTECTED] 05/25/01 03:01PM I was once one of those superior i-dba consultants. I was pretty good, and as with this list, some of my colleagues were amazingly talented, knowledgable and great to work with. Others were, well, others. It's lots of fun to ridicule, disparage, deride, belittle, and mock Oracle Consulting, and don't even get me started about Oracle Support, and I do this all the time too, I just want to put in a good word for SOME of my old friends. Have a great weekend. Yosi -Original Message- From: PD Miller [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 1:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: Fire your DBA's you don't need them anymore... I've just spent most of today repairing damage left at a site by some of Oracle's 'superior' consultants! At 8:27 -0800 25/5/01, Gary Weber wrote: Far as their superior i-dba team, I sure hope those are different people from the ones you get on first line of Support... Cheers Paul Miller -- - Banned and proud of it! Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
RE: session pga memory value is much higher than Sort_Area_Size
I had the same problem. First, i realized that - it seems - there are other things that will bump the PGA. For me it was insert /*+ append */. However, after upgrading from 8.1.5 to 8.1.7 the problem went away. Hope this helps, and your mileage may vary. Good luck, Yosi -Original Message- From: Srikannan Gopalsamy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 6:58 PM To: Multiple recipients of list ORACLE-L Subject: session pga memory value is much higher than Sort_Area_Size We've set sort_area_size to 8M, but the session pga memory usage shows much higher than 8M, in fact its about 176M. The heap value for the shadow process also confirms the size of the PGA area. 01A4 180496K read/write/exec [ heap ] I thought that the PGA size should not go beyond sort_area_size. Are we missing anything here? Thank for your help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srikannan Gopalsamy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OT: RE: Fire your DBA's you don't need them anymore...
Yeah, I think they've got a retention problem, since the money is better outside, and consultants have a good idea of what they're being billed for. But the internal resources are great, as are their internal email lists. Of course, now we've got much of their internal stuff on metalink - if you can get access - and the odtug lists and oracle-l are right up there too. All in all, I liked working there very very much, and if they'd been able to keep up with what the market was offering I never would have left. And for those of us looking now, we know where the market is going, and Oracle's salaries are getting more in line with everyone else's anyway. (Boy, am I rambling or what? I've got a migraine, the fiorinal didn't do it's usual magic, and I really ought to go home.) -Original Message- From: Hillman, Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 6:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT: RE: Fire your DBA's you don't need them anymore... Oracle charges for such guys 250-350 an hour and pay them 50-90K/year (15-20% bonus and 4 weeks of training per year). I would say that Oracle DBA knowing what he or she is doing can make more money in consulting. Alex Hillman PS. It would be very useful if US participants of this list post their rates or salaries on www.realrates.com - it is fully anonimous. Also there is very interesting contractors BBS -Original Message- Sent: Friday, May 25, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Yosi, I interviewed for one of those jobs here in Boston, MA. Although there was one VERY good individual in the bunch I was a little perplexed by the others. Most were very junior and had not been in an outside shop before, one was straight out of school and bootcamp and only one had done a real recovery. It also hit me as strange that other than the smart guy, none of them had ever created a database from scratch. Thankfully I did not take the job. Dick Goulet Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 5/25/2001 11:52 AM From experience, I have used consultants from Oracle. The 1st one sent was right out of DBA school. We sent him back after 1 week. At that time, Oracle didn't allow you to interview their DBA's. According to Oracle, they were all good. The 2nd DBA Oracle sent had only NT experience, never been on a Unix machine. Ok, sent him back too. By this time, we were about to give up, then Oracle sent DBA #3 and she was sharp. The moral of the story, Oracle will send the juniors 1st b/c they save the good ones for the 3rd strike :) [EMAIL PROTECTED] 05/25/01 03:01PM I was once one of those superior i-dba consultants. I was pretty good, and as with this list, some of my colleagues were amazingly talented, knowledgable and great to work with. Others were, well, others. It's lots of fun to ridicule, disparage, deride, belittle, and mock Oracle Consulting, and don't even get me started about Oracle Support, and I do this all the time too, I just want to put in a good word for SOME of my old friends. Have a great weekend. Yosi -Original Message- From: PD Miller [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 1:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: Fire your DBA's you don't need them anymore... I've just spent most of today repairing damage left at a site by some of Oracle's 'superior' consultants! At 8:27 -0800 25/5/01, Gary Weber wrote: Far as their superior i-dba team, I sure hope those are different people from the ones you get on first line of Support... Cheers Paul Miller -- - Banned and proud of it! Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: Fire your DBA's you don't need them anymore...
I was once one of those superior i-dba consultants. I was pretty good, and as with this list, some of my colleagues were amazingly talented, knowledgable and great to work with. Others were, well, others. It's lots of fun to ridicule, disparage, deride, belittle, and mock Oracle Consulting, and don't even get me started about Oracle Support, and I do this all the time too, I just want to put in a good word for SOME of my old friends. Have a great weekend. Yosi -Original Message- From: PD Miller [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 1:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: Fire your DBA's you don't need them anymore... I've just spent most of today repairing damage left at a site by some of Oracle's 'superior' consultants! At 8:27 -0800 25/5/01, Gary Weber wrote: Far as their superior i-dba team, I sure hope those are different people from the ones you get on first line of Support... Cheers Paul Miller -- - Banned and proud of it! Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Windows vs. UNIX
Roy, Forgive me my lack of understanding, but if you don't know why one would choose Unix over Windows, why are you proposing Unix altogether? Yosi -Original Message- From: Roy Ferguson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 2:46 PM To: Multiple recipients of list ORACLE-L Subject: Windows vs. UNIX this is not to bring up a heated debate over the two platforms... I am making a proposal to move the current access 97 databases to an oralce platform running solaris I would like to put in the proposal a brief reason why a UNIX platform will be better than a Windows platform. the current environment: MS Access 97 databases running on Compaq server. Databases are about 20GB in size... proposed solution: Sun E3500 T3 Storage Array Solaris 8 Oracle 8i Just need a couple FACTS as to why one would choose UNIX over Windows Thanks in advance roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: cdump, bdump, udump
Wow. I feel just the opposite. When I had the paper docs, I could take one on the train, take it home, know what I read, feel like I'd accomplished something when I'd read a chunk, etc. I had a relationship with the books, my tuning guide had a corner bent, the app dev guide was missing a cover. With this electronic stuff, I can't 'sit down and study', I find its hard to get a feel of what I should read because it all looks and feels the same. I really miss the hard copy docs. My two pence. Yosi -Original Message- From: Joseph S. Testa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Subject: Re: cdump, bdump, udump read the tuning guide and the administrators guide. nowadays this is a valid answer now that oracle docs are online, NO ONE HAS AN EXCUSE to not read the docs unlike back in the days when you had to pay thousands of dollars for paper docs. joe Venkat_Kalepalli wrote: Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer. I want to know what are the advantages we get on this and what are the steps to implement this? Any help is grateful... Rgd Venkat DBA. -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Grumble - OTN is now as ugly as Oracle.com
WHINE MODE Why do they insist on making these sites unreadable, blinding to the eye, and so on? There's nowhere on the NEW! OTN to rest your eye, to focus, to stabilize, etc... Why would anyone want their site to look like this? /WHINE MODE Sorry, and thanks for letting me vent (like you had a choice...) Yosi -- 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: cdump, bdump, udump
Printer's not the same. I understand this is all ethereal, but it's not the same. I've got a collection of the docs in big black looseleaf binders with a label I printed on the side that says which book it is. It's not as carriable as a smaller book, (try opening one of those on a subway...) and all the books look alike - since all the looseleafs are identical. (Maybe I should get colored looseleafs...) As for buying the books - no way management wants to pay for them any more than Oracle does. And that's probably justifiable. I'll live - I just liked the hardcopy way better. -Original Message- From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 2:11 PM To: Multiple recipients of list ORACLE-L Subject: RE: cdump, bdump, udump what's wrong with your printer? what's wrong with just spending a bunch of money on hardcopy documentation like you used to do On 24 Apr 2001, at 8:15, [EMAIL PROTECTED] wrote: Date sent:Tue, 24 Apr 2001 08:15:54 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ... With this electronic stuff, I can't 'sit down and study', I find its hard to get a feel of what I should read because it all looks and feels the same. I really miss the hard copy docs. ... -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Parallel Query Option
Hi Chris, PQO is great if you have the hardware to support it. For example, say you have a large table in lots of partitions, and each partition is on a separate device. Then, a query can scan the whole table way faster, since the query is broken into parallel pieces, each scanning a small part - one parition - of the table independently of the others. If, however, you only have a small number of devices - say, 3 - then even if you only parallelize to two pieces, chances are the two pieces will fight each other over disk access, causing a BIGGER bottleneck and slower response then you would have had with a single nonparallel full table scan. Your mileage may vary, but my experience has been that PQO worked great with LOTS of disks, not as great with medium number of disks, and not well at all with just a few disks, even striped. (Actually, I wonder if striping would make it better or worse; ins't that always the case with striping...?) Good luck, Yosi -Original Message- From: CC Harvest [mailto:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 12:11 PM To: Multiple recipients of list ORACLE-L Subject: Parallel Query Option I am trying to tune a 30GB database and to configure the initSID.ora files to use PQO. From my understand, they are some back requirements: multiple CPUs of the machine, stripe the tablespace datafiles, etc. If I only have 3 disk drive, do I have to stripe the datafiles to 3 disks, index files to 3 disks? Anyone has the real example of initSID.ora file to share? Thanks, Chris Harvest __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Insert ... nologging
Hello all, I'm trying to do inserts with NOLOGGING. It works if I don't specify insert columns OR if I have no where clause. If I have EITHER insert column specification OR a where clause, Oracle can't interpret the SQL. HELP PLEASE!! The following syntax works fine: -- 1. This has a where clause in the select, and no insert -- column specification. Nologging is up top. INSERT into table1 -- defined as table1 (a varchar2 (5)) NOLOGGING SELECT dummy FROMdual WHERE dummy = 'X'; (Don't know if it actually skips logs, but I imagine it does. But at least it inserts.) Following statement also works: -- 2. This has column specifications but no where clause. -- Nologging is moved to the end of the statement. INSERT into table1 (a) SELECT dummy FROMdual NOLOGGING; The following, however, I can't get to work. -- 3. This HAS a where clause AND column specification, -- with Nologging at the end of the statement. INSERT into table1 (a) SELECT dummy FROMdual WHERE dummy = 'X' NOLOGGING; SQL / NOLOGGING * ERROR at line 5: ORA-00933: SQL command not properly ended Nologging is (seemingly) interpreted as some part of the where clause, and Oracle does not understand it. Moving nologging up, does not work either, as follows: -- 4. This HAS a where clause AND column specification, -- and Nologging before the select clause. INSERT into table1 (a) NOLOGGING SELECT dummy FROMdual WHERE dummy = 'X'; SQL / NOLOGGING * ERROR at line 2: ORA-00926: missing VALUES keyword Can anyone shed any light here? Thanks in advance, as always, Yosi [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).
RE: Insert ... nologging
Thank you. I wish I would have realized that the nologging was becoming an alias. :-( Yosi -Original Message- From: Vadim Gorbounov [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 5:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Insert ... nologging Yosi, I suggest you the following syntax for direct path insert with nologging option: insert /*+ APPEND NOLOGGING */ into tab1 select from tab2; The word NOLOGGING in your first insert is treated as table alias (and really does nothing with nologging), i believe, otherwise the statement is invalid. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, April 19, 2001 4:48 PM To: Multiple recipients of list ORACLE-L Hello all, I'm trying to do inserts with NOLOGGING. It works if I don't specify insert columns OR if I have no where clause. If I have EITHER insert column specification OR a where clause, Oracle can't interpret the SQL. HELP PLEASE!! The following syntax works fine: -- 1. This has a where clause in the select, and no insert -- column specification. Nologging is up top. INSERT into table1 -- defined as table1 (a varchar2 (5)) NOLOGGING SELECT dummy FROMdual WHERE dummy = 'X'; (Don't know if it actually skips logs, but I imagine it does. But at least it inserts.) Following statement also works: -- 2. This has column specifications but no where clause. -- Nologging is moved to the end of the statement. INSERT into table1 (a) SELECT dummy FROMdual NOLOGGING; The following, however, I can't get to work. -- 3. This HAS a where clause AND column specification, -- with Nologging at the end of the statement. INSERT into table1 (a) SELECT dummy FROMdual WHERE dummy = 'X' NOLOGGING; SQL / NOLOGGING * ERROR at line 5: ORA-00933: SQL command not properly ended Nologging is (seemingly) interpreted as some part of the where clause, and Oracle does not understand it. Moving nologging up, does not work either, as follows: -- 4. This HAS a where clause AND column specification, -- and Nologging before the select clause. INSERT into table1 (a) NOLOGGING SELECT dummy FROMdual WHERE dummy = 'X'; SQL / NOLOGGING * ERROR at line 2: ORA-00926: missing VALUES keyword Can anyone shed any light here? Thanks in advance, as always, Yosi [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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Basic logon architecture for multiple apps in a db
Denny, Thanks for the tip, I'll give it a try. It sounds like it will work. Of course, there's a list on Metalink of places where it doesn't work or where it causes errors. But it sounds just right - thanks. Yosi -Original Message- Sent: Thursday, April 12, 2001 3:48 PM To: Multiple recipients of list ORACLE-L Hi Yosi, You may want to check alter session set current_schema=application schemaname This gives you the best of both worlds. You can let the users login using their own logins and still access the objects in the application schema without using synonyms. Regards, Denny [EMAIL PROTECTED] wrote: Ron, When they log in directly, do they access the tables by fully qualifying the owner, or do they use synonyms? Yosi -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 12:23 PM To: Multiple recipients of list ORACLE-L Subject: Re: Basic logon architecture for multiple apps in a db Yosi The users at our location do both methods of logons. Some access the database directly with "create session" privileges and have a role granted to them that can access the data. Other applications have the user login from the application access the database and the table privileges are granted to the application id. The user assessing the database was inplace before I started working here. I control the tables the users have assess to by using roles on all of the new applications if the developer does not code it to have an application id hitting the database. Both methods work well and I am still able to "see" the originating user's machine name that they logged onto the client with. That helps in tracking down who is accessing the servers. ROR mm [EMAIL PROTECTED] 04/11/01 04:40PM O Esteemed and Wise Colleagues, (My first sending of this didn't seem to make it to the list... Knowing our mail server it may show up in a few weeks!) How do application (Forms or other) users access your tables? Do they logon as themselves? Do you switch their logon behind their backs to that of the app owner (like Oracle Apps does?) I'm wrestling with this now. The way I see it, I've got two choices, with several subchoices: 1. User logs in as self and accesses the tables either: a. via synonyms (to tables or to table API package), or b. via full table path qualification, i.e., GL.ACCOUNT or GL.ACCOUNT_API (package). 2. User logs in (knowingly or unknowingly via behind the scenes smoke-and-mirrors) as app owner, and accesses tables directly. Peronally, I much prefer the logging in as self route. It's easier to trace users, sessions, security, access, performance, etc. I also prefer using synonyms, since most application design environments - including Forms - don't fully qualify tables or views by default. The problem is that synonym names can conflict between applications. One solution is to prefix the app_short_name to the name of each table or view. I hate that. Another thought is to create synonyms dynamically as the user logs on to an application. That's no good if the user logs on to two apps at the same time. If you go with relogging in as the app owner, you somehow have to keep track of who the user really is (some common package variable, most likely) and then use that info as needed. That sounds like lots of extra code. So, how do YOUR users access your apps? Any ideas? I need guidance, and I'll really, truly, honestly, very much appreciate any you can send my way. TIA, Yosi -- Denny Koovakattu http://www.oneco.net/ _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 O
RE: Re[2]: Basic logon architecture for multiple apps in a db
Dick, Thanks. So a user can have two different logons? Say, YOSI_OE for when I log on to the Order Entry Application and YOSI_STAT for when I use the Statistics app? Is this what you mean? Or, as I've been doing, just user YOSI, who's assigned both the OE_USER and the STATS_USER roles, but then how do you qualify objects - In code or as synonyms? And what happens to conflicts? Thanks again, and thanks to all who've been responding. Yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 10:22 AM To: Multiple recipients of list ORACLE-L Subject: Re[2]: Basic logon architecture for multiple apps in a db I prefer having multiple logons. There should be a generic, self explanatory schema that owns the objects followed by one of more roles that grants are made to followed by individual user accounts. That way it's easy to find out who's plugging up the drain every once in a while. Also if you need any kind of audit trail on the records it's easy to get one. Now for third party apps your stuck. Dick Goulet Reply Separator Author: Regina Harter [EMAIL PROTECTED] Date: 4/11/2001 2:06 PM We have the users log in as themselves, because that was the only way to handle the permissions properly. We also use fully qualified table names rather than synonyms, though that was mostly because we have data split among several schemas using identical table names. We just make the table owner dynamic and swap in the proper name at runtime. Works much better than trying to handle swapping and redefining synonyms. At 12:40 PM 4/11/01 -0800, you wrote: O Esteemed and Wise Colleagues, (My first sending of this didn't seem to make it to the list... Knowing our mail server it may show up in a few weeks!) How do application (Forms or other) users access your tables? Do they logon as themselves? Do you switch their logon behind their backs to that of the app owner (like Oracle Apps does?) I'm wrestling with this now. The way I see it, I've got two choices, with several subchoices: 1. User logs in as self and accesses the tables either: a. via synonyms (to tables or to table API package), or b. via full table path qualification, i.e., GL.ACCOUNT or GL.ACCOUNT_API (package). 2. User logs in (knowingly or unknowingly via behind the scenes smoke-and-mirrors) as app owner, and accesses tables directly. Peronally, I much prefer the logging in as self route. It's easier to trace users, sessions, security, access, performance, etc. I also prefer using synonyms, since most application design environments - including Forms - don't fully qualify tables or views by default. The problem is that synonym names can conflict between applications. One solution is to prefix the app_short_name to the name of each table or view. I hate that. Another thought is to create synonyms dynamically as the user logs on to an application. That's no good if the user logs on to two apps at the same time. If you go with relogging in as the app owner, you somehow have to keep track of who the user really is (some common package variable, most likely) and then use that info as needed. That sounds like lots of extra code. So, how do YOUR users access your apps? Any ideas? I need guidance, and I'll really, truly, honestly, very much appreciate any you can send my way. TIA, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: Basic logon architecture for multiple apps in a db
Ron, When they log in directly, do they access the tables by fully qualifying the owner, or do they use synonyms? Yosi -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 12:23 PM To: Multiple recipients of list ORACLE-L Subject: Re: Basic logon architecture for multiple apps in a db Yosi The users at our location do both methods of logons. Some access the database directly with "create session" privileges and have a role granted to them that can access the data. Other applications have the user login from the application access the database and the table privileges are granted to the application id. The user assessing the database was inplace before I started working here. I control the tables the users have assess to by using roles on all of the new applications if the developer does not code it to have an application id hitting the database. Both methods work well and I am still able to "see" the originating user's machine name that they logged onto the client with. That helps in tracking down who is accessing the servers. ROR mm [EMAIL PROTECTED] 04/11/01 04:40PM O Esteemed and Wise Colleagues, (My first sending of this didn't seem to make it to the list... Knowing our mail server it may show up in a few weeks!) How do application (Forms or other) users access your tables? Do they logon as themselves? Do you switch their logon behind their backs to that of the app owner (like Oracle Apps does?) I'm wrestling with this now. The way I see it, I've got two choices, with several subchoices: 1. User logs in as self and accesses the tables either: a. via synonyms (to tables or to table API package), or b. via full table path qualification, i.e., GL.ACCOUNT or GL.ACCOUNT_API (package). 2. User logs in (knowingly or unknowingly via behind the scenes smoke-and-mirrors) as app owner, and accesses tables directly. Peronally, I much prefer the logging in as self route. It's easier to trace users, sessions, security, access, performance, etc. I also prefer using synonyms, since most application design environments - including Forms - don't fully qualify tables or views by default. The problem is that synonym names can conflict between applications. One solution is to prefix the app_short_name to the name of each table or view. I hate that. Another thought is to create synonyms dynamically as the user logs on to an application. That's no good if the user logs on to two apps at the same time. If you go with relogging in as the app owner, you somehow have to keep track of who the user really is (some common package variable, most likely) and then use that info as needed. That sounds like lots of extra code. So, how do YOUR users access your apps? Any ideas? I need guidance, and I'll really, truly, honestly, very much appreciate any you can send my way. TIA, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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).
Basic logon architecture for multiple apps in a db
O Esteemed and Wise Colleagues, (My first sending of this didn't seem to make it to the list... Knowing our mail server it may show up in a few weeks!) How do application (Forms or other) users access your tables? Do they logon as themselves? Do you switch their logon behind their backs to that of the app owner (like Oracle Apps does?) I'm wrestling with this now. The way I see it, I've got two choices, with several subchoices: 1. User logs in as self and accesses the tables either: a. via synonyms (to tables or to table API package), or b. via full table path qualification, i.e., GL.ACCOUNT or GL.ACCOUNT_API (package). 2. User logs in (knowingly or unknowingly via behind the scenes smoke-and-mirrors) as app owner, and accesses tables directly. Peronally, I much prefer the logging in as self route. It's easier to trace users, sessions, security, access, performance, etc. I also prefer using synonyms, since most application design environments - including Forms - don't fully qualify tables or views by default. The problem is that synonym names can conflict between applications. One solution is to prefix the app_short_name to the name of each table or view. I hate that. Another thought is to create synonyms dynamically as the user logs on to an application. That's no good if the user logs on to two apps at the same time. If you go with relogging in as the app owner, you somehow have to keep track of who the user really is (some common package variable, most likely) and then use that info as needed. That sounds like lots of extra code. So, how do YOUR users access your apps? Any ideas? I need guidance, and I'll really, truly, honestly, very much appreciate any you can send my way. TIA, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Command to view stored procedure
Easiest bet is to use any one of the gui tools available, such as Toad, or Procedure Builder, etc... hth, Yosi -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 5:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: SQL Command to view stored procedure Valerie, The text for the procedures are stored in the dba_source tables. Set your environment to a longer line and select the text where name = procedure. ROR mm [EMAIL PROTECTED] 04/03/01 04:35PM What is the SQL command, v$ table or SQL*Plus command to see the contents of a stored procedure? I looked at DBA_SOURCE but it stored the code in separate rows based on the owner and procedure name. Is there any way to see the source code for OEM view of the procedures? It displays what I want to see but developer doesn't have access to OEM. Thanks in advance. Val Valerie H. Webber Management Systems Designers, Inc Database Administrator [EMAIL PROTECTED] 704-566-5321 -- 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). -- 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).
EMC TimeFinder, and EMC TimeFinder vs Hot Standby
Hi All, Can anyone give me a quick (free!) lesson on the concepts behind timefinder? How does this differ from their standard SRDF which (to my understanding) is to split the mirror and back it up. Or is it that they add their BCV stuff to SRDF so you can access the data while the mirror is split? Then, is it like a Hot Standby DB? (We used to get something in high school that was some sort of mixture between fish and potatoes, and we could never figure out if it was fish or if it was potatoes, or both, or neither. Somehow, this is reminding me of that.) Thanks loads, Yosi -- 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).
More Metajunk frustration (at end of a long day...)
All, For those of us paying tens to hundreds of thousands of dollars for support, can we sue Oracle for not honoring support contracts and get rich quick? Considering that it's near impossible to create a tar, is this not a valid thought? And if we can't get rich quick, can we force them to no longer make us enter tars through Metamisery? Signed, Frustrated in Metaloo land. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reporting database
You don't need replication. You can simply create tables on one machine across a db link fom the first. Depends on the volume and type of data. We (only a few Gb) rebuild our reporting environment from transaction. Reporting doesn't have ALL the tables from OLTP, just the ones we need, somewhat denormalized, summarized, etc. G'luck. Yosi -Original Message- From: Terrian, Thomas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 7:26 AM To: Multiple recipients of list ORACLE-L Subject: Reporting database How are you all creating reporting databases? We currently have an OLTP database and we wish to create a reporting database from it. As I see it, we have the following options: 1. Create the reporting database as a Standby database. I don't think that this will work since the database must be up and not in standby mode. 2. Use Oracle replication. I have heard it is cumbersome and has trouble keeping up with lots of transactions. 3. Snapshots/materialized views. 4. Beef up our current machine so that it can handle OLTP transactions and reports. 5. Since we are using a BMC disk array, we could break the mirror periodically and mount the disks on a new machine. 6. Other 3rd party replication products. 7. We could probably use some type of import/exports. How are the rest of you doing it? Are there any other options that I forgot? Thanks, Tom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terrian, Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thanks and another book request
Yeah, but Rachel, think of the FAME! Didn't I hear you were opening for Billy Joel and Elton John in LA on Feb 6? :-) Yosi -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 04, 2001 1:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: Thanks and another book request Djordje, the $5 was for each book sold. not per hour. My rate (before the book) was more than the average. The $150/hour is really an average, I know people getting more than that and they haven't written a book, or done lots of presentations etc. NY is a higher paying market. And in any case, even at $10/hour, it's still NOT worth spending the time writing instead of consulting. And the real question is, since I write in my limited, minimal spare time, what is the value per hour of THAT time? Time not spent with family and friends, or doing the things that feed my soul? Rachel From: "djordjej" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Thanks and another book request Date: Sat, 03 Feb 2001 23:45:21 -0800 Hi Rachel, I definitively believe that the prime drive for writing a book must come from the love to teach, to help other people and share some of the experience and knowledge that you came to the hard way with others. And I agree that one should not think of writing a book to make money. But for the math you did to be fair, I guess it should be mentioned that having a name on a good book also helps to reach $150 per hour. I would not say that this is an average that a senior/experienced/expert/knowledgeable/... DBA gets even in NY ? If the name on the book can bring this number up by at least, say $10/hour, this changes your math by at least $1600*10 = $16,000. Am I right in this assumption? Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 02, 2001 8:05 PM well, let's do the math. let's say I get $5 for each book that is sold (I don't, and the royalties change depending on if the book has sold at full price or from a discount house) but the $5 makes the math easier (and it's less than minimum wage in the US!) let's round the numbers, and say that an independent DBA consultant can earn $150/hr in New York, where I live. (That's an average, some make more, some less) and 150/5 = 30 so I'd have to work 30 times as many hours writing books as I would as a consultant to make the same amount of money Most personnel departments assume that there are 200 workdays in a year (vacation, weekends and holidays excluded), and that a workday is 8 hours long. Yes, I know no DBA works a 40 hour week, this is just an example. so 200*8 = 1600 hours work in a year. 1600/500= 3.2 books a year and 1600*5=$8000 a year 1600*150=$240,000 don't know about you, I'd rather be a consultant! I repeat -- you don't make money writing books, and if that is why you are writing them, you'd be better off just consulting. Even if you write in your "spare time", you lose -- I worked evenings, and all day all weekend writing. I didn't see my friends or family for the time I was writing. Oh, and since my name does show up when my messages post, so it's easy to see how it is spelled it's Rachel, not Rachael From: "orclbabu" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Thanks and another book request Date: Fri, 02 Feb 2001 12:32:11 -0800 Rachael consultant for that number of hours Not profitable to write one. The very fact that you often repeat this in response to mails that refer to your books, makes us think otherwise $$$ ;-) babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orclbabu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -
RE: OT_RE:_Réf._:_Re:_asy
Important addendum. For those of us that note these things, each letter of WNT is one letter up from the letters of VMS. (And, HAL, from 2001, A Space Oddysey, is one letter removed from IBM.) fwiw, Yosi -Original Message- From: Steve Orr [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 1:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT_RE:_Rf._:_Re:_asyn_i/o_on_sun_ Close. It's Dave Cutler. There's too much old DOS/Windows backward compatibility for WinNT/2000 to achieve stability like VMS despite Cutler's leadership. I knew VMS and you, Mr. NT, are no VMS! With apologies to Senator Bentsen, Steve Orr -Original Message- stephane Sent: Thursday, February 01, 2001 9:22 AM To: Multiple recipients of list ORACLE-L NT is based on VMS (talk about a real OS) and if my memory is good the guy's name is Cutter. Do I win a toaster ? a microwave oven ? a palm-pilot ? --- "Mohan, Ross" [EMAIL PROTECTED] a crit: "...Standing, corrected, and sniggering." Odd picture, that.. Anyways, pop quiz: On what OS kernel technology is NT based? Who was the original designer and what was his/her first OS? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
