Ang: Re: How can I tell if a procedure/package is running?
Can anyone give me a good example on how this works? Thanks in advance Roland Connor McDonald <[EMAIL PROTECTED]>@fatcity.com den 2001-10-25 01:45 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: I would say that the best way is in its coding typically by adding calls to dbms_application_info - which is great way of tying SQL to its owning PL/SQL as well. You might be lucky to catch it in sql_address in v$session (depending on what its actually doing at the time). Similarly, you could possibly glean some info from V$SQL via USERS_EXECUTING You could always try modify the proc which would probably hang on library cache pin or similar - hardly a recommended way of course :-) hth connor --- Doug C <[EMAIL PROTECTED]> wrote: > How can I tell if a stored procedure or package is > in the middle of execution? > (for lack of doing what it does)..I've heard of > parse locks, is that a way? > > Thanks, > D > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Doug C > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Nokia Game is on again. Go to http://uk.yahoo.com/nokiagame/ and join the new all media adventure before November 3rd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L 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: Export 7.3.4 / Import 8.1.7?
Actually, SYSTEM *is* included in a full export. This can cause you some problems on import if you forget about it. The few times I've recreated a database and populated it with a 'full' export, I've dropped the SYSTEM user from the new database before running the import. Since the discussion is on importing a v7 database into 8i, it might be a good idea to drop the SYSTEM user after the import as well, and recreate. Jared On Monday 21 January 2002 04:10, Boivin, Patrice J wrote: > Trial and error... > > We have migrated a couple of development databases. > > Things to watch out for: > > Oracle says replication-related objects are not handled "very well" by > export / import. We haven't encountered any problems in that regard, but > all the snapshots had been turned off before the full export. > > SYS and SYSTEM objects are not included in the full export, so any public > synonyms, anything referring to objects stored in there will be invalid or > point to objects. > > If you have users with objects stored in the SYSTEM schema, kiss them bye > bye. Ironically we noticed that the default accounts (for the demo db) in > one 7.3.4. database were stored in SYSTEM. We don't need those accounts so > we removed them. > > The Web Development Toolkit is included in 8.1.7 by default, it is placed > in the SYS schema as a built-in package. On our databases here only one > user was using the toolkit, so he had installed it in his own schema. Now > we have two copies in the new database, with public synonyms pointing to > the SYS schema. > > Ensure you use the same character set for both. > > Double-check everything -- take an inventory of what is in your database, > what is valid / invalid, etc. in the first database, then run that test > again on the new one, and compare the results. > > Ensure you run the same /rdbms/admin scripts in the new database as you did > in the old one, before you do your migration. > > Change Manager is a useful tool, to a degree -- with OEM 2.2. on NT there > are bugs / shortcomings in it. My list so far: > -- the JVM screen properties go beserk after a while, but it doesn't appear > to affect the final results. Just leave the screen alone, and if you see > an error save the reports BEFORE you acknowledge the error. > -- it is extremely slow if you don't run it from the OEM console, > -- it doesn't verify whether packages have body text in them, > -- it does not log constraint name changes, esp. SYS_C names > -- I am not sure, I think it doesn't log the number of constraints per > table either. > > One amazing thing is that some objects that were invalid in the old > database are valid in the new one. Hopefully these old objects were > invalid only because someone had altered a parent object... > > They tightened up the code in 8i, some of the shortcuts that were used in > the older version by developers will result in invalid objects in the new > version. > > 8i doesn't prevent people from writing code that doesn't explicitly specify > the schema. > > run utlrp.sql from /rdbms/admin before you do your comparisons. > > If others know of other shotcomings, or ideas, please let me know. > > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > -Original Message- > Sent: Monday, January 21, 2002 4:50 AM > To: Multiple recipients of list ORACLE-L > > > > Hi smith ! > > I haven't done it but in my opinion, there should be no problem, but > anyways, the best way to find out is to try it!! > > > > Arslan Zaheer Dar > [EMAIL PROTECTED] > Database Administrator > Shaukat Khanum Memorial Cancer Hosptial & Research Centre > www.shaukatkhanum.org.pk > > > -Original Message- > > Sent: Saturday, January 19, 2002 12:57 AM > To: Multiple recipients of list ORACLE-L > > Can I do a full export from 7.3.4 and then do a full import into 8.1.7? > > Ron Smith Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: QUOTED-PRINTABLE Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.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
Re: Alias Table Error...why?
Check the " a.pc_session_user_name = 'tsokol'" There is no alias "a". Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "Lance Prais" <[EMAIL PROTECTED]> 22/01/2002 08:15 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Alias Table Error...why? I have the following SQL Statement but am getting and ORA-00904 Invalid Column Error. What Could I be doing wrong? SELECT Launch.oc_session_id FROM pt_client_eventdetails launch, pt_client_eventdetails logout WHERE a.pc_session_user_name = 'tsokol' and (logout.pc_event_op = 'LAUNCH' and logout.pc_event_op <> 'LOGOUT' and logout.pc_event_op <> 'SOLUTION_VIEWED') and launch.pc_session_id = logout.pc_session_id -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBA Vs Apps DBA
Thanks John and others for very good update. -- On Mon, 21 Jan 2002 12:10:25 John Kanagaraj wrote: >Hi all, > >I guess this question has been asked many times both in this list and >offline. I had promised to write this sometime back, so it's time to get >to the bottom of this: > >History: Oracle has had an ERP (Enterprise Resource Planning) application - >simply named "Oracle Applications" - for a long time. Originally developed >as a Forms 2.4 (yes - 2.4 was a 'special' version of Forms 2.x that could >handle what they called Flex fields) and ReportWriter 1.x based application >starting at Applications release 9, it developed into a version 10.x and at >some point moved to 'Client/Server' mode (10.7 Smart Client) and then onto a >N-tier mode (10.7NCA, 11.0 and now 11i). Starting off as an packages >Application that catered purely to the Financial side of the organization in >the beginning days, the scope has been widened to cater to almost all >aspects of a Business, including CRM (Customer Relations Management). In >short, 'Apps' now caters to Finance (GL/AR/AP, etc.), HR, Inventory, Order >Entry, Manufacturing, Sales, CRM, etc. > >The Database has always been Oracle, starting with 7.0 and moving onto 7.3, >and later 8.0.x and now 8.1.x/9.0.x. To support the Web layer in an N-tier >architecture, Oracle started using OWAS 3.0/4.0 and then progressed to WebDB >2.x (short lived) and is currently using Oracle 9iAS based on the Apache Web >server for the Web portion. The Forms and Reports versions has moved from >2.4 (character only) to Dev2K and now stands at Dev 6i. The forms runs off a >Forms server that is accessed via the Intranet/Internet and interacts with a >JInitiator that is downloaded to your PC. > >All versions of Apps have had a batch job scheduler - known as the >Concurrent Manager. This is quite a complicated (and well thought-out) piece >of technology and handles Report/Scripts and other execution on the >Application layer. A set of FND (Foundation) tables forms the base for the >Concurrent Manager. Multiple queues, Specialization rules, Interface tables, >Responsibility-based access have been part of the whole system since >inception. This 'Application stack' - as it is usually referred to >*normally* runs in an OS account (usually 'applmgr') that is separate from >the 'oracle' account. > >Apps caters to most of the standard functionality, but a lot of >customization is still required. All of this needs to be done outside of the >Standard schemas. The system is highly parameterized and there are strict >guidelines as to what can be done and what cannot be 'tweaked'. For e.g., >until 11i (or 11.5.x), the optimizer_mode *HAD* to be set to RULE. A lot of >sites that upgraded from 10.7/11.0 to 11i are now tripping up on performance >issues related to the change in mode. > >Because of the complexity and business involvement required, there are two >types of people who manage this - a 'Functional' person who understands the >business side of things and maps the business process to the Apps >functionality. Then there is the 'Technical' person who again consists of >the Apps Developers/System Admins and the DBAs. While the System Admins are >supposed to deal with the Setup and management of the Concurrent manager, >etc. there is quite a bit of overlap and depending on the organization, the >DBAs sometimes act in this capacity. There are also cases of Apps SysAdmins >becoming DBAs by default. > >Since Apps is a complex application, it is inevitable that it needs constant >maintenance, mainly to fix functionality problems. Hence 'Apps Patching' is >a *MAJOR* issue, especially for DBAs and the Tech team. There are literally >hundreds of patches to be applied between minor version releases, so much so >that patches are rolled up into 'Family packs', one per application schema. >This effort is usually underestimated, and the need for a Dev, Test, UAT >environment and a proper Change management system becomes critical. > >Upgrades from one version of Apps to the next are *MAJOR* steps, both >Organizationally and Technically. Upgrade projects need to be well managed >and there are highly paid Consultants (some upto $300/hr and above) that >need to be brought in to perform these or at least plan this out. These >upgrades are mandatory as the Database/Apps versions change, and the >Business depends on it. > >So, what does a 'normal' DBA need to know? In addition to the Oracle DBA >related stuff, the Apps DBA needs to know about the Apps setup, Concurrent >Managers, Forms/Reports servers, Web servers, Patching, Upgrades. Most >important, you need to know what's allowed and what's not - a wrong step can >mess up the whole thing and take you out-of-support. Depending on the >organization and the role, you may also be performing critical work during >period closes (monthend/quarter or year end) as well as SysAdmin stuff. >Going into an Apps situation with both guns blazing can have dire >consequences, m
Connecting INGRES using database link
Dear all, Can I create database link using generic connectivity (ODBC)? Was there someony already try this? I'm using oracle 8.1.6 on WIN2K box with INGRES NET, and INGRES 6.4 on VAX/VMS. TIA, Holly -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yet Another Off Topic Discussion
>> ( list owner, baby sitter and part time DBA ) Jared, What happened to that Perl thingy ?? Thank you so much for doing a wonderful job in keeping this list going On your list, I have learnt more than I can offer others. Not only just Oracle things I have made a few good friends, for life. Can't say the same about some other 'strict' list(s).. Regards, - Kirti -Original Message- Sent: Monday, January 21, 2002 7:50 PM To: Multiple recipients of list ORACLE-L Thanks Joe. A little OT has usually been acceptable here. Even some humor. The only time it became a problem is when it veered away from having anything to do with Oracle and oracle related work issues. People would start posting ethnic and off color jokes, ranting about their favorite pet peeve, ad nauseum. If you want to do that, go to the off topic list. They will welcome you with open arms. We won't even discuss how Ross and Eric may welcome you. Jared ( list owner, baby sitter and part time DBA ) Joe Testa <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/21/02 05:10 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: OT: Yet Another Off Topic Discussion Tim, i'm with you, and since Paul does not evidently know who the list owner is here since he's making waves on the very few anymore OT posts that are here anymore and that the list owner was the one talking about tribbles. Paul, feel free to start your own list and manage it as you please. joe Johnston, Tim wrote: > My own 2 cents... Stating a viewpoint such as this and then saying "do not > reply to this" is just not acceptable... This topic has been discussed on > the list innumerable times over the years and it is always a hot bed of > discussion... And, it always seems to reach the same conclusion... In > summary, keep it on topic but the occasional OT post is tolerated... > Anything more then that should not be done or moved to the OT list... So, > here we are yet again... And, here is MY opinion... I view this list as a > community... Not just a technical list... Many people on this list have > been on for years and enjoy to occasionally have some fun... I personally > enjoy the occasional joke or OT thread... It gives the list personality and > allows me feel like I am getting to know the other people on the list... > That is why I am on this list and not some of the other discussion forums... > Some other forums operate as you desire... I avoid those... The reason is > that I want to enjoy my job... And the occasional laugh I get from this > list has more then once made a miserable day better... If I wanted to > purely technical list I would go to another forum... But I don't I > like this list AS IS... And, if I feel that I am getting to much email, the > delete key works great... > > Tim > > > -Original Message- > Sent: Monday, January 21, 2002 11:10 AM > To: Multiple recipients of list ORACLE-L > > > Hello all, > > My 2 cents' worth: > > Far too much time is spent by a number of users in the Oracle List sending > e-mail of no worth whatsoever. Half the msgs I read are what charitably > might be called 'chat'. I understand that there is an off-line site for > 'chat' - why not use it and stop mucking up the e-mail waves with crap. Even > a small drop in aimless e-mails would be appreciated; 90%+ directed, > professional queries and replies would be wonderful. > > Please do not reply to this e-mail; this is my one-time attempt to bring > about a positive change. > > Thank you, > > Paul Sherman > DBA > voice - 781-501-4143 (office) > fax- 781-278-8341 (office) > email - [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, January 21, 2002 10:36 AM > To: Multiple recipients of list ORACLE-L > > > Love is all you need. > > --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > >>or, of course, the answer to life, the universe and everything is? >> >>--- Jared Still <[EMAIL PROTECTED]> wrote: >> >>>If the question is "Which episode of Star Trek was 'The Trouble >>> >>with >> >>>Tribbles'", then yes. ;) >>> >>>Jared >>> >>>On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: >>> Yep. And we also found logoff-triggers in 8i to be useful for the >>>same >>> (and additional) purposes. But if I had to guess, I'm sure the answer would be 42 :-). Mogens [EMAIL PROTECTED] wrote: >Raj, >Maybe another option would be to "audit session" for the > >>database. >> >>> For >>> >each logon/logoff you would see the logical/physical reads and > >>>the >>> >logical writes ( in dba_audit_session) by Oracle username (or >osusername). Chaim > > > > >"Aponte, Tony" <[EMAIL PROTECTED]>@fatcity.com on 01/16/2002 > >>>06:15:24 PM >>> >Please respond to [EMAIL PROTECTED] > >Sent by:
RE: RE: HP vs SUN for a UNIX box
We have all.. HP-UX, Sun, AIX, Irix etc.. No major issues in the past several years. We had EMC go bad a couple of times. But all these servers have never crashed on us all of a sudden (touching wood). A couple of times we did have a couple of HP servers go down, but it was due to our internal problems (you know those - pebkac types) Our flagship application www.superpages.com will soon find a stable home on Sun Servers (from another stable home : SGI Irix), while a couple of other 'Bread & Butter' systems will run on stable AIX and HP-UX. No Linux on the horizon yet!! - Kirti -Original Message- Sent: Monday, January 21, 2002 7:30 PM To: Multiple recipients of list ORACLE-L You will be ok. The only issues I have had are the normal hardware issues (CPU gone bad, etc). One thing that did concern me though is I was able to crash a box due to heave IO to one disk. We never did get around to investigating it any further though before they shut the plant. -Original Message- McClure Sent: Monday, January 21, 2002 1:01 PM To: Multiple recipients of list ORACLE-L Considering I have a brand spanking new Sun box waiting for me in the Server room, this thread has been less than comforting. Not Stable?!? I am starting to miss my DG boxes already. Steve -Original Message- Smith Sent: Monday, January 21, 2002 7:00 AM To: Multiple recipients of list ORACLE-L I heard that they already did. Something about Sun not being stable. -Original Message- Sent: Sunday, January 20, 2002 9:55 PM To: Multiple recipients of list ORACLE-L Oracle Magazine have alot "Oracle for HP" articles, I think they are switching from Sun to HP -Original Message- [EMAIL PROTECTED] Sent: 19 January 2002 06:16 To: Multiple recipients of list ORACLE-L Sergey, I asked my SA to add his 2 cents, guess he's not inclined. Anyway, I've been on HP for the last 10 years, coming from VMS, & I love it. VERY stable, easy to use, although I don't do the admin any longer it was easy with SAM even when it was a character based tool. Rman/OmniBack integration is well documented in the OmniBack manuals & works as advertised. HP support is pretty darn good as well, especially in the middle of the night when the system won't boot. I've had HP support tech's remotely logged in to the system helping get it back online. Also if you have a problem that is not in the area of the tech you call they normally conference in the needed assistance. Problems can be resolved as fast as they occur. We also don't use disk arrays from HP, but then HP & EMC really like each other. If you want an inexpensive disk alternative look into NetAppliance. Dick Goulet Senior Oracle DBA Reply Separator Author: "Babich ; Sergey" <[EMAIL PROTECTED]> Date: 1/18/2002 1:25 PM Thank you, Paul, I'll forward it to my boss... Anyone else to add to it? Thank you very much, Sergey Babich -Original Message- Sent: Friday, January 18, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Stay with HP. It's a hell of a lot more reliable, and does not require anywhere near the # of patches, and its patches work far more often that Sun's. I've done 5 years with each, and there's no question that HP is superior. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Our shop is switching from HP to Sun. No one can tell me why. There must be a cost savings somewhere. -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Yet Another Off Topic Discussion
Aint that the truth, open arms and then some :) joe [EMAIL PROTECTED] wrote: > Thanks Joe. > > A little OT has usually been acceptable here. > > Even some humor. The only time it became a problem > is when it veered away from having anything to do with > Oracle and oracle related work issues. > > People would start posting ethnic and off color jokes, > ranting about their favorite pet peeve, ad nauseum. > > If you want to do that, go to the off topic list. They will > welcome you with open arms. We won't even discuss > how Ross and Eric may welcome you. > > Jared > ( list owner, baby sitter and part time DBA ) > > > > > > > Joe Testa <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 01/21/02 05:10 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: OT: Yet Another Off Topic Discussion > > > Tim, i'm with you, and since Paul does not evidently know who the list > owner is here since he's making waves on the very few anymore OT posts > that are here anymore and that the list owner was the one talking about > tribbles. > > Paul, feel free to start your own list and manage it as you please. > > joe > > > Johnston, Tim wrote: > > >>My own 2 cents... Stating a viewpoint such as this and then saying "do >> > not > >>reply to this" is just not acceptable... This topic has been discussed >> > on > >>the list innumerable times over the years and it is always a hot bed of >>discussion... And, it always seems to reach the same conclusion... In >>summary, keep it on topic but the occasional OT post is tolerated... >>Anything more then that should not be done or moved to the OT list... >> > So, > >>here we are yet again... And, here is MY opinion... I view this list >> > as a > >>community... Not just a technical list... Many people on this list >> > have > >>been on for years and enjoy to occasionally have some fun... I >> > personally > >>enjoy the occasional joke or OT thread... It gives the list personality >> > and > >>allows me feel like I am getting to know the other people on the list... >>That is why I am on this list and not some of the other discussion >> > forums... > >>Some other forums operate as you desire... I avoid those... The reason >> > is > >>that I want to enjoy my job... And the occasional laugh I get from this >>list has more then once made a miserable day better... If I wanted to >>purely technical list I would go to another forum... But I don't I >>like this list AS IS... And, if I feel that I am getting to much email, >> > the > >>delete key works great... >> >>Tim >> >> >>-Original Message- >>Sent: Monday, January 21, 2002 11:10 AM >>To: Multiple recipients of list ORACLE-L >> >> >>Hello all, >> >>My 2 cents' worth: >> >>Far too much time is spent by a number of users in the Oracle List >> > sending > >>e-mail of no worth whatsoever. Half the msgs I read are what charitably >>might be called 'chat'. I understand that there is an off-line site for >>'chat' - why not use it and stop mucking up the e-mail waves with crap. >> > Even > >>a small drop in aimless e-mails would be appreciated; 90%+ directed, >>professional queries and replies would be wonderful. >> >>Please do not reply to this e-mail; this is my one-time attempt to bring >>about a positive change. >> >>Thank you, >> >>Paul Sherman >>DBA >>voice - 781-501-4143 (office) >>fax- 781-278-8341 (office) >>email - [EMAIL PROTECTED] >> >> >>-Original Message- >>Sent: Monday, January 21, 2002 10:36 AM >>To: Multiple recipients of list ORACLE-L >> >> >>Love is all you need. >> >>--- Rachel Carmichael <[EMAIL PROTECTED]> wrote: >> >> >>>or, of course, the answer to life, the universe and everything is? >>> >>>--- Jared Still <[EMAIL PROTECTED]> wrote: >>> >>> If the question is "Which episode of Star Trek was 'The Trouble >>>with >>> >>> Tribbles'", then yes. ;) Jared On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: >Yep. And we also found logoff-triggers in 8i to be useful for the > > same >(and additional) purposes. > >But if I had to guess, I'm sure the answer would be 42 :-). > >Mogens > >[EMAIL PROTECTED] wrote: > > >>Raj, >>Maybe another option would be to "audit session" for the >> >> >>>database. >>> >>> For >>each logon/logoff you would see the logical/physical reads and >> >> the >>logical writes ( in dba_audit_session) by Oracle username (or >>osusername). Chaim >> >> >> >> >>"Aponte, Tony" <[EMAIL PROTECTED]>@fatcity.com on 01/16/2002 >> >> 06:15:24 PM >>Please respond to [EMAIL PROTECTED] >> >>Sent by:[EMAIL PROTECTED] >> >> >>To:Multiple recipients of list ORACLE-L >>
Re: OT: Yet Another Off Topic Discussion
Thanks Joe. A little OT has usually been acceptable here. Even some humor. The only time it became a problem is when it veered away from having anything to do with Oracle and oracle related work issues. People would start posting ethnic and off color jokes, ranting about their favorite pet peeve, ad nauseum. If you want to do that, go to the off topic list. They will welcome you with open arms. We won't even discuss how Ross and Eric may welcome you. Jared ( list owner, baby sitter and part time DBA ) Joe Testa <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/21/02 05:10 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: OT: Yet Another Off Topic Discussion Tim, i'm with you, and since Paul does not evidently know who the list owner is here since he's making waves on the very few anymore OT posts that are here anymore and that the list owner was the one talking about tribbles. Paul, feel free to start your own list and manage it as you please. joe Johnston, Tim wrote: > My own 2 cents... Stating a viewpoint such as this and then saying "do not > reply to this" is just not acceptable... This topic has been discussed on > the list innumerable times over the years and it is always a hot bed of > discussion... And, it always seems to reach the same conclusion... In > summary, keep it on topic but the occasional OT post is tolerated... > Anything more then that should not be done or moved to the OT list... So, > here we are yet again... And, here is MY opinion... I view this list as a > community... Not just a technical list... Many people on this list have > been on for years and enjoy to occasionally have some fun... I personally > enjoy the occasional joke or OT thread... It gives the list personality and > allows me feel like I am getting to know the other people on the list... > That is why I am on this list and not some of the other discussion forums... > Some other forums operate as you desire... I avoid those... The reason is > that I want to enjoy my job... And the occasional laugh I get from this > list has more then once made a miserable day better... If I wanted to > purely technical list I would go to another forum... But I don't I > like this list AS IS... And, if I feel that I am getting to much email, the > delete key works great... > > Tim > > > -Original Message- > Sent: Monday, January 21, 2002 11:10 AM > To: Multiple recipients of list ORACLE-L > > > Hello all, > > My 2 cents' worth: > > Far too much time is spent by a number of users in the Oracle List sending > e-mail of no worth whatsoever. Half the msgs I read are what charitably > might be called 'chat'. I understand that there is an off-line site for > 'chat' - why not use it and stop mucking up the e-mail waves with crap. Even > a small drop in aimless e-mails would be appreciated; 90%+ directed, > professional queries and replies would be wonderful. > > Please do not reply to this e-mail; this is my one-time attempt to bring > about a positive change. > > Thank you, > > Paul Sherman > DBA > voice - 781-501-4143 (office) > fax- 781-278-8341 (office) > email - [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, January 21, 2002 10:36 AM > To: Multiple recipients of list ORACLE-L > > > Love is all you need. > > --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > >>or, of course, the answer to life, the universe and everything is? >> >>--- Jared Still <[EMAIL PROTECTED]> wrote: >> >>>If the question is "Which episode of Star Trek was 'The Trouble >>> >>with >> >>>Tribbles'", then yes. ;) >>> >>>Jared >>> >>>On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: >>> Yep. And we also found logoff-triggers in 8i to be useful for the >>>same >>> (and additional) purposes. But if I had to guess, I'm sure the answer would be 42 :-). Mogens [EMAIL PROTECTED] wrote: >Raj, >Maybe another option would be to "audit session" for the > >>database. >> >>> For >>> >each logon/logoff you would see the logical/physical reads and > >>>the >>> >logical writes ( in dba_audit_session) by Oracle username (or >osusername). Chaim > > > > >"Aponte, Tony" <[EMAIL PROTECTED]>@fatcity.com on 01/16/2002 > >>>06:15:24 PM >>> >Please respond to [EMAIL PROTECTED] > >Sent by:[EMAIL PROTECTED] > > >To:Multiple recipients of list ORACLE-L > >><[EMAIL PROTECTED]> >> >cc: > > > > >Then you're in luck. I'd recommend starting with Oracle > >>Response >> >>>Time >>> >Analysis from www.orapub.com. Although it won't give you > >>exactly >> >>>what >>> >you need, it will help you get to the next step. Once you > >>>understand a >>> >session's response time components, it's a short hop to > >
RE: RE: HP vs SUN for a UNIX box
You will be ok. The only issues I have had are the normal hardware issues (CPU gone bad, etc). One thing that did concern me though is I was able to crash a box due to heave IO to one disk. We never did get around to investigating it any further though before they shut the plant. -Original Message- McClure Sent: Monday, January 21, 2002 1:01 PM To: Multiple recipients of list ORACLE-L Considering I have a brand spanking new Sun box waiting for me in the Server room, this thread has been less than comforting. Not Stable?!? I am starting to miss my DG boxes already. Steve -Original Message- Smith Sent: Monday, January 21, 2002 7:00 AM To: Multiple recipients of list ORACLE-L I heard that they already did. Something about Sun not being stable. -Original Message- Sent: Sunday, January 20, 2002 9:55 PM To: Multiple recipients of list ORACLE-L Oracle Magazine have alot "Oracle for HP" articles, I think they are switching from Sun to HP -Original Message- [EMAIL PROTECTED] Sent: 19 January 2002 06:16 To: Multiple recipients of list ORACLE-L Sergey, I asked my SA to add his 2 cents, guess he's not inclined. Anyway, I've been on HP for the last 10 years, coming from VMS, & I love it. VERY stable, easy to use, although I don't do the admin any longer it was easy with SAM even when it was a character based tool. Rman/OmniBack integration is well documented in the OmniBack manuals & works as advertised. HP support is pretty darn good as well, especially in the middle of the night when the system won't boot. I've had HP support tech's remotely logged in to the system helping get it back online. Also if you have a problem that is not in the area of the tech you call they normally conference in the needed assistance. Problems can be resolved as fast as they occur. We also don't use disk arrays from HP, but then HP & EMC really like each other. If you want an inexpensive disk alternative look into NetAppliance. Dick Goulet Senior Oracle DBA Reply Separator Author: "Babich ; Sergey" <[EMAIL PROTECTED]> Date: 1/18/2002 1:25 PM Thank you, Paul, I'll forward it to my boss... Anyone else to add to it? Thank you very much, Sergey Babich -Original Message- Sent: Friday, January 18, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Stay with HP. It's a hell of a lot more reliable, and does not require anywhere near the # of patches, and its patches work far more often that Sun's. I've done 5 years with each, and there's no question that HP is superior. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Our shop is switching from HP to Sun. No one can tell me why. There must be a cost savings somewhere. -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -
Re: Alias Table Error...why?
I will have a go at it being a.pc_session_user_name = 'tsokol' a doesn't appear to be defined or do you actuall have a table called "a" Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = "Lance Prais" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 22/01/2002 10:15 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject:Alias Table Error...why? I have the following SQL Statement but am getting and ORA-00904 Invalid Column Error. What Could I be doing wrong? SELECT Launch.oc_session_id FROM pt_client_eventdetails launch, pt_client_eventdetails logout WHERE a.pc_session_user_name = 'tsokol' and (logout.pc_event_op = 'LAUNCH' and logout.pc_event_op <> 'LOGOUT' and logout.pc_event_op <> 'SOLUTION_VIEWED') and launch.pc_session_id = logout.pc_session_id -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Experiences with Oracle and RAID 0+1
How about Singapore for both Oracle OpenWorld and Miracle Master Class ? ;) I'd even take leave-without-pay and pay for the registration charges myself to attend, if necessary. ;) ;) Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "Boivin, Patrice J" <[EMAIL PROTECTED]>22/01/2002 01:12 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: DBA Experiences with Oracle and RAID 0+1 As a cost-cutting measure: They could combine the U.S. and European conventions, all they have to do is hold them in Halifax ... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, January 21, 2002 11:56 AM To:Multiple recipients of list ORACLE-L Oracle OpenWorld in the Americas will never leave the West Coast and is highly unlikely to leave San Francisco. Too convenient to Headquarters If Miracle gave that class in Halifax, I'd go! --- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > May I suggest Halifax, Canada as a great location for this course??? > > StilL waiting for Oracle OpenWorld to come here, somehow they never > do. > > : ) > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, January 21, 2002 8:06 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: DBA Experiences with Oracle and RAID 0+1 > > you have no idea how badly most of us now want to come to that class. > Not that I'd understand most of what was said, but just to listen :) > > > --- Mogens Nørgaard <[EMAIL PROTECTED]> wrote: > > Jared, > > > > Good thought! We're running our annual Miracle Master Class (this > > year > > with Jonathan Lewis) this week and Cary Millsap (and his gang), > > Jonathan > > and James will arrive tomorrow (Monday), while Steve Adams, Lex de > > Haan, > > Stephan Haisley and a bunch of other guys will arrive on Tuesday. > > I'll > > keep this message and throw it up for discussion on the Oak Table > > (see > > Cary's wonderful article on www.Undskyld.Org)... > > > > Jared Still wrote: > > > > >Mogens, > > > > > >In regard to the number of spindles issue: James Morle has some > > >excellent discussion on that in 'Scaling Oracle 8i'. ( I think > > it's that > > >book ) > > > > > >When some of the newer larges drives are used in a given > > configuration, > > >they mabe be able to outperform older drives in a similar > > configuration with > > >a larger number of spindles. > > > > > >I say 'older' since smaller drives usually aren't using the latest > > technology > > >and the newer ones have sufficiently higher throughput to match > the > > >capability of a larger number of drives in given configuration. > > > > > >Food for thought, anyway. > > > > > >Jared > > > > > > > > >On Sunday 20 January 2002 06:50, Mogens Nørgaard wrote: > > > > > >>Diego, > > >> > > >>I agree with you 100% and didn't express myself correctly in my > > email. > > >>The more spindles the better. What I meant to say was that you > must > > >>never buy disks by taking your total needed amount of space and > > divide > > >>by the number of big disks you can get hold on :). It's the > number > > of > > >>IO's required by the disk system that matters, not the size... > > >> > > >>Thanks for making this clear to everyone. > > >> > > >>Mogens > > >> > > >>Diego Cutrone wrote: > > >> > > >>>Mogens: > > >>> Just let me disagree with you at only one point. According to > > my > > >>>experience, I think that the size of the disks in an array does > > matter > > >>>sometimes. It's not the same to have 24 9GB disks that to have > > only 3 of > > >>>73GB. You have 24 spindles againts 3, the first option (in a > well > > >>>configured system of course) will give you better performance in > > >>>enviroments where you have a lot of concurrency and many users. > > >>> However I think that what I've written above might not be > > correct (may > > >>>be it shoul
Re: OT: Yet Another Off Topic Discussion
Tim, i'm with you, and since Paul does not evidently know who the list owner is here since he's making waves on the very few anymore OT posts that are here anymore and that the list owner was the one talking about tribbles. Paul, feel free to start your own list and manage it as you please. joe Johnston, Tim wrote: > My own 2 cents... Stating a viewpoint such as this and then saying "do not > reply to this" is just not acceptable... This topic has been discussed on > the list innumerable times over the years and it is always a hot bed of > discussion... And, it always seems to reach the same conclusion... In > summary, keep it on topic but the occasional OT post is tolerated... > Anything more then that should not be done or moved to the OT list... So, > here we are yet again... And, here is MY opinion... I view this list as a > community... Not just a technical list... Many people on this list have > been on for years and enjoy to occasionally have some fun... I personally > enjoy the occasional joke or OT thread... It gives the list personality and > allows me feel like I am getting to know the other people on the list... > That is why I am on this list and not some of the other discussion forums... > Some other forums operate as you desire... I avoid those... The reason is > that I want to enjoy my job... And the occasional laugh I get from this > list has more then once made a miserable day better... If I wanted to > purely technical list I would go to another forum... But I don't I > like this list AS IS... And, if I feel that I am getting to much email, the > delete key works great... > > Tim > > > -Original Message- > Sent: Monday, January 21, 2002 11:10 AM > To: Multiple recipients of list ORACLE-L > > > Hello all, > > My 2 cents' worth: > > Far too much time is spent by a number of users in the Oracle List sending > e-mail of no worth whatsoever. Half the msgs I read are what charitably > might be called 'chat'. I understand that there is an off-line site for > 'chat' - why not use it and stop mucking up the e-mail waves with crap. Even > a small drop in aimless e-mails would be appreciated; 90%+ directed, > professional queries and replies would be wonderful. > > Please do not reply to this e-mail; this is my one-time attempt to bring > about a positive change. > > Thank you, > > Paul Sherman > DBA > voice - 781-501-4143 (office) > fax- 781-278-8341 (office) > email - [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, January 21, 2002 10:36 AM > To: Multiple recipients of list ORACLE-L > > > Love is all you need. > > --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > >>or, of course, the answer to life, the universe and everything is? >> >>--- Jared Still <[EMAIL PROTECTED]> wrote: >> >>>If the question is "Which episode of Star Trek was 'The Trouble >>> >>with >> >>>Tribbles'", then yes. ;) >>> >>>Jared >>> >>>On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: >>> Yep. And we also found logoff-triggers in 8i to be useful for the >>>same >>> (and additional) purposes. But if I had to guess, I'm sure the answer would be 42 :-). Mogens [EMAIL PROTECTED] wrote: >Raj, >Maybe another option would be to "audit session" for the > >>database. >> >>> For >>> >each logon/logoff you would see the logical/physical reads and > >>>the >>> >logical writes ( in dba_audit_session) by Oracle username (or >osusername). Chaim > > > > >"Aponte, Tony" <[EMAIL PROTECTED]>@fatcity.com on 01/16/2002 > >>>06:15:24 PM >>> >Please respond to [EMAIL PROTECTED] > >Sent by:[EMAIL PROTECTED] > > >To:Multiple recipients of list ORACLE-L > >><[EMAIL PROTECTED]> >> >cc: > > > > >Then you're in luck. I'd recommend starting with Oracle > >>Response >> >>>Time >>> >Analysis from www.orapub.com. Although it won't give you > >>exactly >> >>>what >>> >you need, it will help you get to the next step. Once you > >>>understand a >>> >session's response time components, it's a short hop to > >>figuring >> >>>out the >>> >V$SESSTAT statistics that make up the CPU time, > >>physical/logical >> >>>I/O >>> >operations and memory footprint. > >HTH >Tony >-Original Message- >Sent: Wednesday, January 16, 2002 5:54 PM >To: Aponte, Tony; [EMAIL PROTECTED] > > >Database Load ... is the main target at this time ... > >Thanks Tony, > >Raj >__ > >Rajendra Jamadagni MIS, ESPN Inc. > >Rajendra dot Jamadagni at ESPN dot com > >Any opinion expressed here is personal and doesn't reflect that > >>>of ESPN >>> >Inc. > >QOTD: Any clod can have facts, but having an opinion is an > >>art! >> >
Alias Table Error...why?
I have the following SQL Statement but am getting and ORA-00904 Invalid Column Error. What Could I be doing wrong? SELECT Launch.oc_session_id FROM pt_client_eventdetails launch, pt_client_eventdetails logout WHERE a.pc_session_user_name = 'tsokol' and (logout.pc_event_op = 'LAUNCH' and logout.pc_event_op <> 'LOGOUT' and logout.pc_event_op <> 'SOLUTION_VIEWED') and launch.pc_session_id = logout.pc_session_id -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Limits on referential integrity
Yeah, I've heard the performance arguments before. I've never worked on a really large OLTP system, but I have worked on some of 20 gig or so with a few key tables having millions of rows ( 20 gig used to be big! ). One in particular had quite a bit of RI. Running on a DG/UX system with 512M Ram and 4 cpus, with 3 mirrored pairs and 2 RAID 5 stripes, we were generally happy with the performance. The transactions were very query intensive and performed upto about 20k transactions per day with an average transaction time of 1-2 seconds. These were very complex transactions. There were also 10-20 operators at any one time entering manual transactions and doing customer service from the same database. There was a CFO requesting all kinds of complex reports during the middle of the day. Did I forget to mention that Oracle apps 9 was on the same box? RI was never to blame for performance problems. In fact, our biggest performance problem was non-performance when the database died. ( Steve, I couldn't resist :) This was on Oracle 7.0.16 to start with. RI was not the cause of any performance problems that I can recall. One thing that kept the RI overhead low was that all transactions tables had surrogate keys generated from a sequence. Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/21/02 02:35 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Limits on referential integrity Jared - I wasn't clear, but then again it is Monday. I have a team of inexperienced developers starting a big, new Java application. They have a good, experienced data model consultant helping them create the data model. They are eager to include referential integrity. So eager it has me a little worried. My question: "Is there too much of a good thing?". In Oracle 7, sometimes sites would remove RI to ensure good performance (we are starting this project on Oracle9i). Has anyone encountered problems with too many constraints? Any guidelines you use with developers? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 4:16 PM To: Multiple recipients of list ORACLE-L I would be you lunch that what they are implementing in their code is not actually RI. They may be implementing code to ensure things get inserted in the right order, and that child rows have a parent. This is a very weak form of RI. Oracle is very good at implementing RI, and it is not dependent on an application. RI in the database is the route to choose unless there is some good reason not to. RI in the database will prevent orphaned data created through updates, deletes or even ( gasp! ) bugs in the app. Programmers tend to dislike RI in the database because it forces them to maintain data integrity in a transaction. This is not a bad thing, it just forces them to have a good understanding of their transactions. Point out to them that it is less code to write as well. :) Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/21/02 01:35 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Limits on referential integrity How much referential integrity should be implemented in Oracle? We are starting a large new Java project. Our current applications keep their referential integrity inside their own dictionary, so I haven't had to deal much with referential integrity recently. Can there be too much of a good thing? What guidelines do you tend to use? At this point the developers are designing the data model so they are busily linking all the little boxes. My attitude at this point is "implement what you've got and if there are performance problems we'll deal with them when they arise". Can anyone give me a better motto? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---
RE: Can't find 8.1.7.3 patchset
Anita: I'm an idiot. Next time I'll read your entire message. (Got so excited to see the patch that I went looking for it before I read your entire message. I need to get a life) Barb > -- > > > -- > From: A. Bardeen[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Monday, January 21, 2002 6:55 AM > To: Multiple recipients of list ORACLE-L > Subject:8.1.7.3 patchset now available for two platforms > > Hi all! > > 8.1.7.3 is now available on MetaLink for the following > platforms: > > 32-bit Oracle on Solaris > 64-bit Oracle on HP-UX > > IMPORTANT: A 32-bit OS can run only the 32-bit > version or Oracle; a 64-bit OS can run both the 32-bit > and 64-bit versions of Oracle. > > A 32-bit patch can be applied only to the 32-bit > version of Oracle for the same release (first 3 > digits); likewise a 64-bit patch can be applied only > to a 64-bit version of Oracle. > > The bit version of the OS selected (32-bit or 64-bit) > when downloading a patch is based on the bit version > of the Oracle software NOT the OS. So if you're > running 32-bit Oracle on 64-bit Solaris, you must > download the patchset for 32-bit Solaris! > > New patchsets are available only on MetaLink: > > > You may find it by searching using the following > criteria after selecting PATCHES from the left-hand > menu: > > Product Family:Oracle Server > Release: 8.1.7.3 > Platform: > Limit Search to: Latest Product Patchsets or > Minipacks > > Alternatively, you may look it up by using the patch # > for the 8.1.7.3 patchset: 218975 > > > HTH, > > -- Anita > > > __ > Do You Yahoo!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > -- > 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: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Moving databases from WIN2K to Unix
Hi All, We plan to move our OLTP databases which were accessed through the internet to Sun Solaris. Could someone who has done such a thing already tell me if there is anything I should look out for in this process? Thanks. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yet Another Off Topic Discussion
this is the reason we started the oracle-l off-topic list. to subscribe just send an email to: [EMAIL PROTECTED] --- "Johnston, Tim" <[EMAIL PROTECTED]> wrote: > My own 2 cents... Stating a viewpoint such as this and then saying > "do not > reply to this" is just not acceptable... This topic has been > discussed on > the list innumerable times over the years and it is always a hot bed > of > discussion... And, it always seems to reach the same conclusion... > In > summary, keep it on topic but the occasional OT post is tolerated... > Anything more then that should not be done or moved to the OT list... > So, > here we are yet again... And, here is MY opinion... I view this > list as a > community... Not just a technical list... Many people on this list > have > been on for years and enjoy to occasionally have some fun... I > personally > enjoy the occasional joke or OT thread... It gives the list > personality and > allows me feel like I am getting to know the other people on the > list... > That is why I am on this list and not some of the other discussion > forums... > Some other forums operate as you desire... I avoid those... The > reason is > that I want to enjoy my job... And the occasional laugh I get from > this > list has more then once made a miserable day better... If I wanted > to > purely technical list I would go to another forum... But I don't > I > like this list AS IS... And, if I feel that I am getting to much > email, the > delete key works great... > > Tim > > > -Original Message- > Sent: Monday, January 21, 2002 11:10 AM > To: Multiple recipients of list ORACLE-L > > > Hello all, > > My 2 cents' worth: > > Far too much time is spent by a number of users in the Oracle List > sending > e-mail of no worth whatsoever. Half the msgs I read are what > charitably > might be called 'chat'. I understand that there is an off-line site > for > 'chat' - why not use it and stop mucking up the e-mail waves with > crap. Even > a small drop in aimless e-mails would be appreciated; 90%+ directed, > professional queries and replies would be wonderful. > > Please do not reply to this e-mail; this is my one-time attempt to > bring > about a positive change. > > Thank you, > > Paul Sherman > DBA > voice - 781-501-4143 (office) > fax- 781-278-8341 (office) > email - [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, January 21, 2002 10:36 AM > To: Multiple recipients of list ORACLE-L > > > Love is all you need. > > --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > > or, of course, the answer to life, the universe and everything is? > > > > --- Jared Still <[EMAIL PROTECTED]> wrote: > > > > > > If the question is "Which episode of Star Trek was 'The Trouble > > with > > > Tribbles'", then yes. ;) > > > > > > Jared > > > > > > On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: > > > > Yep. And we also found logoff-triggers in 8i to be useful for > the > > > same > > > > (and additional) purposes. > > > > > > > > But if I had to guess, I'm sure the answer would be 42 :-). > > > > > > > > Mogens > > > > > > > > [EMAIL PROTECTED] wrote: > > > > >Raj, > > > > >Maybe another option would be to "audit session" for the > > database. > > > For > > > > >each logon/logoff you would see the logical/physical reads > and > > > the > > > > > logical writes ( in dba_audit_session) by Oracle username (or > > > > > osusername). Chaim > > > > > > > > > > > > > > > > > > > > > > > > >"Aponte, Tony" <[EMAIL PROTECTED]>@fatcity.com on 01/16/2002 > > > 06:15:24 PM > > > > > > > > > >Please respond to [EMAIL PROTECTED] > > > > > > > > > >Sent by:[EMAIL PROTECTED] > > > > > > > > > > > > > > >To:Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > > > >cc: > > > > > > > > > > > > > > > > > > > > > > > > >Then you're in luck. I'd recommend starting with Oracle > > Response > > > Time > > > > >Analysis from www.orapub.com. Although it won't give you > > exactly > > > what > > > > > you need, it will help you get to the next step. Once you > > > understand a > > > > > session's response time components, it's a short hop to > > figuring > > > out the > > > > > V$SESSTAT statistics that make up the CPU time, > > physical/logical > > > I/O > > > > > operations and memory footprint. > > > > > > > > > >HTH > > > > >Tony > > > > >-Original Message- > > > > >Sent: Wednesday, January 16, 2002 5:54 PM > > > > >To: Aponte, Tony; [EMAIL PROTECTED] > > > > > > > > > > > > > > >Database Load ... is the main target at this time ... > > > > > > > > > >Thanks Tony, > > > > > > > > > >Raj > > > > >__ > > > > > > > > > >Rajendra Jamadagni MIS, ESPN Inc. > > > > > > > > > >Rajendra dot Jamadagni at ESPN dot com > > > > > > > > > >Any opinion expressed here is personal and doesn't reflect > that > > > of ESPN > > > > >Inc. > > > > > > > > > >
RE: Yet Another Off Topic Discussion
Yeah !!! Concurring, JoJo -Original Message- Tim Sent: Monday, January 21, 2002 2:31 PM To: Multiple recipients of list ORACLE-L My own 2 cents... Stating a viewpoint such as this and then saying "do not reply to this" is just not acceptable... This topic has been discussed on the list innumerable times over the years and it is always a hot bed of discussion... And, it always seems to reach the same conclusion... In summary, keep it on topic but the occasional OT post is tolerated... Anything more then that should not be done or moved to the OT list... So, here we are yet again... And, here is MY opinion... I view this list as a community... Not just a technical list... Many people on this list have been on for years and enjoy to occasionally have some fun... I personally enjoy the occasional joke or OT thread... It gives the list personality and allows me feel like I am getting to know the other people on the list... That is why I am on this list and not some of the other discussion forums... Some other forums operate as you desire... I avoid those... The reason is that I want to enjoy my job... And the occasional laugh I get from this list has more then once made a miserable day better... If I wanted to purely technical list I would go to another forum... But I don't I like this list AS IS... And, if I feel that I am getting to much email, the delete key works great... Tim -Original Message- Sent: Monday, January 21, 2002 11:10 AM To: Multiple recipients of list ORACLE-L Hello all, My 2 cents' worth: Far too much time is spent by a number of users in the Oracle List sending e-mail of no worth whatsoever. Half the msgs I read are what charitably might be called 'chat'. I understand that there is an off-line site for 'chat' - why not use it and stop mucking up the e-mail waves with crap. Even a small drop in aimless e-mails would be appreciated; 90%+ directed, professional queries and replies would be wonderful. Please do not reply to this e-mail; this is my one-time attempt to bring about a positive change. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 10:36 AM To: Multiple recipients of list ORACLE-L Love is all you need. --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > or, of course, the answer to life, the universe and everything is? > > --- Jared Still <[EMAIL PROTECTED]> wrote: > > > > If the question is "Which episode of Star Trek was 'The Trouble > with > > Tribbles'", then yes. ;) > > > > Jared > > > > On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: > > > Yep. And we also found logoff-triggers in 8i to be useful for the > > same > > > (and additional) purposes. > > > > > > But if I had to guess, I'm sure the answer would be 42 :-). > > > > > > Mogens > > > > > > [EMAIL PROTECTED] wrote: > > > >Raj, > > > >Maybe another option would be to "audit session" for the > database. > > For > > > >each logon/logoff you would see the logical/physical reads and > > the > > > > logical writes ( in dba_audit_session) by Oracle username (or > > > > osusername). Chaim > > > > > > > > > > > > > > > > > > > >"Aponte, Tony" <[EMAIL PROTECTED]>@fatcity.com on 01/16/2002 > > 06:15:24 PM > > > > > > > >Please respond to [EMAIL PROTECTED] > > > > > > > >Sent by:[EMAIL PROTECTED] > > > > > > > > > > > >To:Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > > >cc: > > > > > > > > > > > > > > > > > > > >Then you're in luck. I'd recommend starting with Oracle > Response > > Time > > > >Analysis from www.orapub.com. Although it won't give you > exactly > > what > > > > you need, it will help you get to the next step. Once you > > understand a > > > > session's response time components, it's a short hop to > figuring > > out the > > > > V$SESSTAT statistics that make up the CPU time, > physical/logical > > I/O > > > > operations and memory footprint. > > > > > > > >HTH > > > >Tony > > > >-Original Message- > > > >Sent: Wednesday, January 16, 2002 5:54 PM > > > >To: Aponte, Tony; [EMAIL PROTECTED] > > > > > > > > > > > >Database Load ... is the main target at this time ... > > > > > > > >Thanks Tony, > > > > > > > >Raj > > > >__ > > > > > > > >Rajendra Jamadagni MIS, ESPN Inc. > > > > > > > >Rajendra dot Jamadagni at ESPN dot com > > > > > > > >Any opinion expressed here is personal and doesn't reflect that > > of ESPN > > > >Inc. > > > > > > > >QOTD: Any clod can have facts, but having an opinion is an > art! > > > >-Original Message- > > > >Sent: Wednesday, January 16, 2002 5:53 PM > > > >To: [EMAIL PROTECTED] > > > >Cc: [EMAIL PROTECTED] > > > > > > > > > > > > > > > >Raj, sorry for me being confused. Are you trying to measure > what > > the > > > >application executable is doing outside the database (i.
RE: DBA Vs Apps DBA
Excellent Peter -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = John Kanagaraj <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 22/01/2002 06:10 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject:RE: DBA Vs Apps DBA Hi all, I guess this question has been asked many times both in this list and offline. I had promised to write this sometime back, so it's time to get to the bottom of this: History: Oracle has had an ERP (Enterprise Resource Planning) application - simply named "Oracle Applications" - for a long time. Originally developed as a Forms 2.4 (yes - 2.4 was a 'special' version of Forms 2.x that could handle what they called Flex fields) and ReportWriter 1.x based application starting at Applications release 9, it developed into a version 10.x and at some point moved to 'Client/Server' mode (10.7 Smart Client) and then onto a N-tier mode (10.7NCA, 11.0 and now 11i). Starting off as an packages Application that catered purely to the Financial side of the organization in the beginning days, the scope has been widened to cater to almost all aspects of a Business, including CRM (Customer Relations Management). In short, 'Apps' now caters to Finance (GL/AR/AP, etc.), HR, Inventory, Order Entry, Manufacturing, Sales, CRM, etc. The Database has always been Oracle, starting with 7.0 and moving onto 7.3, and later 8.0.x and now 8.1.x/9.0.x. To support the Web layer in an N-tier architecture, Oracle started using OWAS 3.0/4.0 and then progressed to WebDB 2.x (short lived) and is currently using Oracle 9iAS based on the Apache Web server for the Web portion. The Forms and Reports versions has moved from 2.4 (character only) to Dev2K and now stands at Dev 6i. The forms runs off a Forms server that is accessed via the Intranet/Internet and interacts with a JInitiator that is downloaded to your PC. All versions of Apps have had a batch job scheduler - known as the Concurrent Manager. This is quite a complicated (and well thought-out) piece of technology and handles Report/Scripts and other execution on the Application layer. A set of FND (Foundation) tables forms the base for the Concurrent Manager. Multiple queues, Specialization rules, Interface tables, Responsibility-based access have been part of the whole system since inception. This 'Application stack' - as it is usually referred to *normally* runs in an OS account (usually 'applmgr') that is separate from the 'oracle' account. Apps caters to most of the standard functionality, but a lot of customization is still required. All of this needs to be done outside of the Standard schemas. The system is highly parameterized and there are strict guidelines as to what can be done and what cannot be 'tweaked'. For e.g., until 11i (or 11.5.x), the optimizer_mode *HAD* to be set to RULE. A lot of sites that upgraded from 10.7/11.0 to 11i are now tripping up on performance issues related to the change in mode. Because of the complexity and business involvement required, there are two types of people who manage this - a 'Functional' person who understands the business side of things and maps the business process to the Apps functionality. Then there is the 'Technical' person who again consists of the Apps Developers/System Admins and the DBAs. While the System Admins are supposed to deal with the Setup and management of the Concurrent manager, etc. there is quite a bit of overlap and depending on the organization, the DBAs sometimes act in this capacity. There are also cases of Apps SysAdmins becoming DBAs by default. Since Apps is a complex application, it is inevitable that it needs constant maintenance, mainly to fix functionality problems. Hence 'Apps Patching' is a *MAJOR* issue, especially for DBAs and the Tech team. There are literally hundreds of patches to be applied between minor version releases, so much so that patches are rolled up into 'Family packs', one per application schema. This effort is usually underestimated, and the need for a Dev, Test, UAT environment and a proper Change management system becomes critical. Upgrades from one version of Apps to the next are *MAJOR* steps, both Organizationally and Technically. Upgrade projects need to be well managed and there are highly paid Consultants (some upto $300/hr an
RE: Limits on referential integrity
Title: RE: Limits on referential integrity Jared and Dennis, In the J2EE world I've found that developers can have a little trouble with RI because in some cases it is not the developer that is performing the DML operations - the J2EE container does this for them when using Container Managed Persistence (CMP). Some CMP implementations do not understand RI yet, and this is especially true when multiple containers are used in the middle tier - that is, there is no/little coordination between the containers to issue the DML in the correct order. Cheers, Craig. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 22 January 2002 9:16 AM To: Multiple recipients of list ORACLE-L Subject: Re: Limits on referential integrity I would be you lunch that what they are implementing in their code is not actually RI. They may be implementing code to ensure things get inserted in the right order, and that child rows have a parent. This is a very weak form of RI. Oracle is very good at implementing RI, and it is not dependent on an application. RI in the database is the route to choose unless there is some good reason not to. RI in the database will prevent orphaned data created through updates, deletes or even ( gasp! ) bugs in the app. Programmers tend to dislike RI in the database because it forces them to maintain data integrity in a transaction. This is not a bad thing, it just forces them to have a good understanding of their transactions. Point out to them that it is less code to write as well. :) Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/21/02 01:35 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Limits on referential integrity How much referential integrity should be implemented in Oracle? We are starting a large new Java project. Our current applications keep their referential integrity inside their own dictionary, so I haven't had to deal much with referential integrity recently. Can there be too much of a good thing? What guidelines do you tend to use? At this point the developers are designing the data model so they are busily linking all the little boxes. My attitude at this point is "implement what you've got and if there are performance problems we'll deal with them when they arise". Can anyone give me a better motto? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
CHECKPOINT?
Hi I checked the following events Name total_waits time_waited log file switch completion 181188 log file sync 99909 667388 This value is increasing.I checked following stats and found ok. background checkpoints Completed 15 background checkpoints started 16 Oracle suggest if above wait events is repeated frequently with considerable values then we need to atke a action like adding more redo log files or increasing their sizes or modifying checkpointing parameters. Thanks -Dinesh _ 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: 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).
OT: Yet Another Off Topic Discussion
My own 2 cents... Stating a viewpoint such as this and then saying "do not reply to this" is just not acceptable... This topic has been discussed on the list innumerable times over the years and it is always a hot bed of discussion... And, it always seems to reach the same conclusion... In summary, keep it on topic but the occasional OT post is tolerated... Anything more then that should not be done or moved to the OT list... So, here we are yet again... And, here is MY opinion... I view this list as a community... Not just a technical list... Many people on this list have been on for years and enjoy to occasionally have some fun... I personally enjoy the occasional joke or OT thread... It gives the list personality and allows me feel like I am getting to know the other people on the list... That is why I am on this list and not some of the other discussion forums... Some other forums operate as you desire... I avoid those... The reason is that I want to enjoy my job... And the occasional laugh I get from this list has more then once made a miserable day better... If I wanted to purely technical list I would go to another forum... But I don't I like this list AS IS... And, if I feel that I am getting to much email, the delete key works great... Tim -Original Message- Sent: Monday, January 21, 2002 11:10 AM To: Multiple recipients of list ORACLE-L Hello all, My 2 cents' worth: Far too much time is spent by a number of users in the Oracle List sending e-mail of no worth whatsoever. Half the msgs I read are what charitably might be called 'chat'. I understand that there is an off-line site for 'chat' - why not use it and stop mucking up the e-mail waves with crap. Even a small drop in aimless e-mails would be appreciated; 90%+ directed, professional queries and replies would be wonderful. Please do not reply to this e-mail; this is my one-time attempt to bring about a positive change. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 10:36 AM To: Multiple recipients of list ORACLE-L Love is all you need. --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > or, of course, the answer to life, the universe and everything is? > > --- Jared Still <[EMAIL PROTECTED]> wrote: > > > > If the question is "Which episode of Star Trek was 'The Trouble > with > > Tribbles'", then yes. ;) > > > > Jared > > > > On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: > > > Yep. And we also found logoff-triggers in 8i to be useful for the > > same > > > (and additional) purposes. > > > > > > But if I had to guess, I'm sure the answer would be 42 :-). > > > > > > Mogens > > > > > > [EMAIL PROTECTED] wrote: > > > >Raj, > > > >Maybe another option would be to "audit session" for the > database. > > For > > > >each logon/logoff you would see the logical/physical reads and > > the > > > > logical writes ( in dba_audit_session) by Oracle username (or > > > > osusername). Chaim > > > > > > > > > > > > > > > > > > > >"Aponte, Tony" <[EMAIL PROTECTED]>@fatcity.com on 01/16/2002 > > 06:15:24 PM > > > > > > > >Please respond to [EMAIL PROTECTED] > > > > > > > >Sent by:[EMAIL PROTECTED] > > > > > > > > > > > >To:Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > > >cc: > > > > > > > > > > > > > > > > > > > >Then you're in luck. I'd recommend starting with Oracle > Response > > Time > > > >Analysis from www.orapub.com. Although it won't give you > exactly > > what > > > > you need, it will help you get to the next step. Once you > > understand a > > > > session's response time components, it's a short hop to > figuring > > out the > > > > V$SESSTAT statistics that make up the CPU time, > physical/logical > > I/O > > > > operations and memory footprint. > > > > > > > >HTH > > > >Tony > > > >-Original Message- > > > >Sent: Wednesday, January 16, 2002 5:54 PM > > > >To: Aponte, Tony; [EMAIL PROTECTED] > > > > > > > > > > > >Database Load ... is the main target at this time ... > > > > > > > >Thanks Tony, > > > > > > > >Raj > > > >__ > > > > > > > >Rajendra Jamadagni MIS, ESPN Inc. > > > > > > > >Rajendra dot Jamadagni at ESPN dot com > > > > > > > >Any opinion expressed here is personal and doesn't reflect that > > of ESPN > > > >Inc. > > > > > > > >QOTD: Any clod can have facts, but having an opinion is an > art! > > > >-Original Message- > > > >Sent: Wednesday, January 16, 2002 5:53 PM > > > >To: [EMAIL PROTECTED] > > > >Cc: [EMAIL PROTECTED] > > > > > > > > > > > > > > > >Raj, sorry for me being confused. Are you trying to measure > what > > the > > > >application executable is doing outside the database (i.e.. > host > > system > > > >load) or the activity inside the database (i.e.. per > > user/program/module > > > >DB stats)? > > > > > > > >T
RE: Database Replication
Systems - A big consideration is whether your application is designed to be replicated. I have been able to find two books on replication: Oracle Distributed Systems by Charles Dye. O'Reilly. 1999. This is specific to Oracle, and is pretty good. Data Replication - Tools and Techniques for Managing Distributed Information by Marie Buretta. Wiley. 1997. This is much more general, addressing how to design an application for replication. HTH Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 20, 2002 9:15 PM To: Multiple recipients of list ORACLE-L Hi All We have got two Oracle Databases physically connected.We want to replicate one database with the other database.We are quite new to this subject.Kindly guide us with the procedure of replication and the conditions to be considered for replication. Thanks in advance Regards Systems -- 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Limits on referential integrity
Jared - I wasn't clear, but then again it is Monday. I have a team of inexperienced developers starting a big, new Java application. They have a good, experienced data model consultant helping them create the data model. They are eager to include referential integrity. So eager it has me a little worried. My question: "Is there too much of a good thing?". In Oracle 7, sometimes sites would remove RI to ensure good performance (we are starting this project on Oracle9i). Has anyone encountered problems with too many constraints? Any guidelines you use with developers? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 4:16 PM To: Multiple recipients of list ORACLE-L I would be you lunch that what they are implementing in their code is not actually RI. They may be implementing code to ensure things get inserted in the right order, and that child rows have a parent. This is a very weak form of RI. Oracle is very good at implementing RI, and it is not dependent on an application. RI in the database is the route to choose unless there is some good reason not to. RI in the database will prevent orphaned data created through updates, deletes or even ( gasp! ) bugs in the app. Programmers tend to dislike RI in the database because it forces them to maintain data integrity in a transaction. This is not a bad thing, it just forces them to have a good understanding of their transactions. Point out to them that it is less code to write as well. :) Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/21/02 01:35 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Limits on referential integrity How much referential integrity should be implemented in Oracle? We are starting a large new Java project. Our current applications keep their referential integrity inside their own dictionary, so I haven't had to deal much with referential integrity recently. Can there be too much of a good thing? What guidelines do you tend to use? At this point the developers are designing the data model so they are busily linking all the little boxes. My attitude at this point is "implement what you've got and if there are performance problems we'll deal with them when they arise". Can anyone give me a better motto? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Limits on referential integrity
I would be you lunch that what they are implementing in their code is not actually RI. They may be implementing code to ensure things get inserted in the right order, and that child rows have a parent. This is a very weak form of RI. Oracle is very good at implementing RI, and it is not dependent on an application. RI in the database is the route to choose unless there is some good reason not to. RI in the database will prevent orphaned data created through updates, deletes or even ( gasp! ) bugs in the app. Programmers tend to dislike RI in the database because it forces them to maintain data integrity in a transaction. This is not a bad thing, it just forces them to have a good understanding of their transactions. Point out to them that it is less code to write as well. :) Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/21/02 01:35 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Limits on referential integrity How much referential integrity should be implemented in Oracle? We are starting a large new Java project. Our current applications keep their referential integrity inside their own dictionary, so I haven't had to deal much with referential integrity recently. Can there be too much of a good thing? What guidelines do you tend to use? At this point the developers are designing the data model so they are busily linking all the little boxes. My attitude at this point is "implement what you've got and if there are performance problems we'll deal with them when they arise". Can anyone give me a better motto? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: HP vs SUN for a UNIX box
I have both Sun and HP boxes. IMHO for OS installation and hardware replacement, Sun is much easier than HP. Actually, I've found everything easier on Sun, but for the really hard core SA stuff, I do rely on the SA "gods" here and they probably have a different opinion than I do. My bias toward Sun is mostly from better familiarity with Sun than HP and I haven't noticed the Sun machines being any less stable than the HP's for anything. Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server Administrator -Original Message- Sent: January 21, 2002 2:01 PM To: Multiple recipients of list ORACLE-L Thanks, Dennis, my boss is thinking HP already. As far as flavor of UNIX, that wouldn't matter much. I'll have to learn it from scratch anyway. Best regards, Sergey -Original Message- Sent: Monday, January 21, 2002 3:25 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Sergey - Sorry for the confusion. Our ERP system is Lawson and I somehow had a brain fart and thought you were on that email list. If you management is just thinking about Unix, then the last thing you want to do is scare them off with an argument about which Unix. Start every reply with "of course all these are excellent choices and it will be no doubt difficult to choose between these really great systems". It sounds as if your application won't be very dependent on the flavor of Unix, so then you don't need to be so concerned about the long-term trends. Boxes are easier to replace than in-house developed software, it's just that software doesn't show up in the financial reports. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 7:45 AM To: Multiple recipients of list ORACLE-L Hi, Dennis, Just got back to work and found your message. It's a shame, but I don't know what Lawson is. Well, I used to be a chemical engineer in Soviet Union and didn't know Oracle existed... Anyway, I appreciate your reply. As far as that box, it's supposed to be a box for our main production. We have a pretty simple financial application, but huge OLTP and A LOT of reports. There's no programming except for my short scripts which I create to extend the app functionality (it is VERY old). The company is very lax on investments. Nonetheless, they're contemplating a switch to UNIX, and that I call a major move! Let's see what happens. Thanks for your reply again. Best regards, Sergey -Original Message- Sent: Friday, January 18, 2002 5:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Sergey - One factor you may want to consider is the timeframe of your decision. If it is just a decision for your Lawson box, then that isn't so critical. It is pretty easy to move Lawson from one system to another. Last fall we were looking at making a decision for all our systems. We are on Compaq Tru64, and that doesn't have a long future ahead of it. The META Group advice was that only three operating systems can be considered to have a stable future: 1. MS W2K 2. Linux 3. Solaris Most of the other Unix vendors are facing the next generation of computer chip architecture. I don't believe that HP is investing in the next generation itself, but will be switching to the new Intel 64-bit chips. Based on that advice, we chose Solaris because W2K and Linux are not up to the same standards as Solaris today. To repeat, we are looking at a lot of programming beyond Lawson, so our decision was based on more than simply purchasing the next box. We will have our Lawson system on Tru64 for several more years. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:25 PM To: Multiple recipients of list ORACLE-L Thank you, Paul, I'll forward it to my boss... Anyone else to add to it? Thank you very much, Sergey Babich -Original Message- Sent: Friday, January 18, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Stay with HP. It's a hell of a lot more reliable, and does not require anywhere near the # of patches, and its patches work far more often that Sun's. I've done 5 years with each, and there's no question that HP is superior. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Our shop is switching from HP to Sun. No one can tell me why. There must be a cost savings somewhere. -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation
RE: Searching Inside CLOBs
Sundeep, You couldn't have made a better case for using interMedia Text index(es) on your CLOB column(s) if you'd had help from Oracle Marketing! ;-) interMedia Text is very powerful and efficient. We use it to index and search almost 15 million CLOB documents, many in HTML format. interMedia even supports section searching, so you can search only between selected tags within a CLOB. Check out the interMedia Text docs. It's even available in Standard Edition. You (and your users) will love it. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- maini Sent: Monday, January 21, 2002 3:06 PM To: Multiple recipients of list ORACLE-L Our developers store XML docuements inside CLOBS and want to search the CLOB contents based on a search string. I have lot of concern about such queries but could benefit from someone on the list who has already solved the performnce issues with such searches. Typical existing queries I have come across are: SELECT columns FROM list of tables WHERE join conditions AND UPPER(tab1.topic) LIKE '%:in_string%' OR UPPER(tab2.subtopic) LIKE '%:in_string%' OR . OR dbms_lob.instr(bodytext,:in_string,1,1) <> 0; Note: in_string is always upper case but the column contents are not. Concerns: 1. Poor index selection due to UPPER 2. CLOB searches are wrong as the CLOB contents are case sensitive. One way to remedy this would be to build a user defined function which will read the CLOB col. in chunks and look for string matches inside individual chunks till a success or end of CLOB. Either way that is a pretty intense way to search for a string among table data when a user is waiting for a quick response. Keyword searches are supported differently. This mechanism is only for random string searches. Any cues or suggestions? Especially for case sensitive searches inside CLOBS? TIA Sundeep = Sundeep Maini Consultant Currently on Assignement at Marshfield Clinic WI [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBA Vs Apps DBA
On the consulting side, I've seen both. The way I've seen it is if they ask for an "Apps DBA" the rate is lower than for a DBA, but if they ask for "a DBA with [Financials|Manufacturing]" the rate is higher. HTH, Bambi. -Original Message- Sent: Monday, January 21, 2002 3:06 PM To: Multiple recipients of list ORACLE-L -Original Message- Sent: Monday, January 21, 2002 2:41 PM To: Multiple recipients of list ORACLE-L The DBA has more responsibility, usually more experience (this usually translates into higher pay as well) than Apps DBA. Well, yes and no. I have seen many orginizations pay the Apps DBA more, because of the "Specailized" knowledge they have. Jon Baker Database Architect <[EMAIL PROTECTED]> www.netsec.net Terry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Limits on referential integrity
How much referential integrity should be implemented in Oracle? We are starting a large new Java project. Our current applications keep their referential integrity inside their own dictionary, so I haven't had to deal much with referential integrity recently. Can there be too much of a good thing? What guidelines do you tend to use? At this point the developers are designing the data model so they are busily linking all the little boxes. My attitude at this point is "implement what you've got and if there are performance problems we'll deal with them when they arise". Can anyone give me a better motto? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Returning multiple rows as a single row
Hi All, I know I've seen this before but I forget ... Given a table like Customer_Software( Custid Number SoftwareVarchar ) How do I return the customerid and all the software entries in a single row? Desired output is like Custid -- 1 Excel Word StarOffice 2 vi tgif oracle ... I know it's a group by with a subquery but TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Lookup Table Usage
Hello Mogens, TCH is the touch count. Cheers Connor OT - enjoy JL's conference this week. --- Mogens Nørgaard <[EMAIL PROTECTED]> wrote: > And in 8i there's a column in x$bh which counts the > number of times the > buffer is touched (as I recall) called XNC or > something? > > Rachel Carmichael wrote: > > >you could turn auditing on on the table and count > the number of times > >it was selected > > > > > >--- Whittle Jerome Contr NCI > <[EMAIL PROTECTED]> wrote: > > > >>Hi, > >> > >>Oracle 7.3.4 on Unix. > >> > >>The database has dozens of little lookup tables. > I'd like to cache > >>those > >>used the most. Is there a way to see how often a > table is queried? > >> > >>Thanks, > >> > >>Jerry Whittle > >>ACIFICS DBA > >>NCI Information Systems Inc. > >>[EMAIL PROTECTED] > >>618-622-4145 > >>-- > >>Please see the official ORACLE-L FAQ: > http://www.orafaq.com > >>-- > >>Author: Whittle Jerome Contr NCI > >> INET: [EMAIL PROTECTED] > >> > >>Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > >>San Diego, California-- Public Internet > access / Mailing > >>Lists > >> > >>To REMOVE yourself from this mailing list, send an > E-Mail message > >>to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > >>the message BODY, include a line containing: UNSUB > ORACLE-L > >>(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!? > >Send FREE video emails in Yahoo! Mail! > >http://promo.yahoo.com/videomail/ > > > > = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBD::Oracle: "" vs NULL, and a possible change to the ChopBlanks attribute
On Mon, Jan 21, 2002 at 10:52:06AM -0800, [EMAIL PROTECTED] wrote: > Tim, > > I've always chosen to just deal with the nulls rather than worry about > padded strings or storing a single space. Personally I can't stand > storing a single space to represent an empty string and prefer the null. > > Not all share my opinion obviously, but I've just gone along with > the trinary logic of working with nulls whenever working with Oracle. Personally I'm very happy with NULLs and trinary logic. I like NULLs, in their place. But there is a _world_ of difference between a NULL and an empty string. But since we all know that here let's not start a long thread rehashing that old topic :) > If I were to use other databases extensively and were concerned > about writing portable code, that sentiment would likely change. > > The authors of modules that provide a generic interface to many > different databases will no doubt thank you for this. I hope so. Certainly it, or something like it, will be important to me migrating from MySQL to Oracle (an ongoing background project). Tim. > Sent by: [EMAIL PROTECTED] > 01/20/02 03:15 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:DBD::Oracle: "" vs NULL, and a possible change to the >ChopBlanks attribute > > > It's well know that Oracle#s state of the art database server can > rarely tell the difference between an empty string and a NULL > (I presume that's not changed recently, though I'd be very happy > to be told otherwise). > > So people who don't want empty strings being stored as NULLs in > their fields tend to use some specific non-empty string insead, > a single space being very common. > > The DBI has an attribute called ChopBlanks that, when set true, > enables the automatic removal of trailing spaces from fetched CHAR > field data (which Oracle has 'helpfully' padded out to the declared > fixed width). > > I'm considering extending the definition of ChopBlanks to include > VARCHAR type fields. This has been requested several times over the > years by DBI users. The change would neatly hide the use of a space > to represent an empty string. > > I'd like to get some feedback on this idea from DBD::Oracle users. > > I'm especially interested in the risk of changing the behaviour of > existing code. That would _only_ happen if you explicitly set > ChopBlanks, and fetch VARCHAR data that has trailing spaces, and the > removal of those spaces would change the behaviour of your application. > > An alternative approach would be to add a new private attribute > that just translates a single space value into an empty value. > That would be "safer" but less generically useful. > > Tim > > p.s. I've sent this to both [EMAIL PROTECTED] and [EMAIL PROTECTED] > Please delete at least one of these addresses when replying. Thanks. > > p.p.s. A corresponding mechanism to optionally automatically treat > empty strings bound to placeholders as a single space will probably > also be added to DBD::Oracle and enabled via private attribute. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tim Bunce > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Bunce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Raw I/O
Its like one of the most common arguments against raw. "Don't use raw since a sysadmin might mistakenly create a file system over the top of it"... ... I've always thought thats an argument against having a shoddy sysadmin rather than not using raw :-) --- Mogens Nørgaard <[EMAIL PROTECTED]> wrote: > One of the funnier arguments for raw I heard a year > ago was this (from a > DBA): "I always use raw files, because it makes it > highly unlikely that > anybody will delete a datafile by accident, since > it's so hard to get > rid of raw devices." :-). > > Dejam, Ruth wrote: > > >I had responded to Witold privately but it seems > that people want more so > >here goes: > > > >We went raw with our production billing system a > few months ago > >because the vendor told damagement that it would be > faster. We also > >converted our failover and testing environments > because we do some > >combination of SRDFs and BCVs of the production > system (we are an HP shop). > >FWIW, each of these monsters is a 2.4T OLTP > database. > > > >Their code was crappy in a cooked database, and > unbelievable as > >it may seems, performs slightly less crappy in a > raw database. > > > >We have few SAs and DBAs that have ever worked with > raw devices. > >Despite excellent documentation, configuring aio > was *challenging*. > >The lack of experience has also given us ample > opportunity to practice > >backups and restores. > > > >The good news is that our failover has worked > flawlessly. :) > > > >The upshot is yes, we've gotten slight performance > gains. Can you imagine > >what would happen if we tuned the code, make a few > database architectural > >changes, etc? In the meantime, it was easier and > faster to go raw rather > >than fix the code. Add in the poor resources and > you have a weiner! > > > >My personal opinion is that we will not realize > enough gains to justify > >going raw. I imagine it's only a matter of time > before our business grows > >enough to bring the system to a screeching halt > again. By them we will have > >implemented yet another version or 2 and will not > be able to figure out > >exactly what to do. I guess, at that time, we can > go back to cooked. :) > > > >It was probably done for the vendor's own job > security and most of our > >management is totally clueless. For me personally, > it's been great because > >I'm one of 3 DBAs here who have worked with raw > before so I have more things > >to play with now. > > > >If you decide to go this route, make sure your SAs > and DBAs are educated and > >careful and get thyself some good backup software. > > > >You can check out past discussions about raw vs > cooked at > >http://www.fatcity.com/ListGuru/login.php > > > >hth, > >~Ruth > > > >Ruth Dejam > >Senior Oracle DBA > >VoiceStream Wireless > > > >Do not meddle in the affairs of dragons for you are > crunchy and taste good > >with ketchup. > > > >-Original Message- > >To: Multiple recipients of list ORACLE-L > >Sent: 1/17/02 6:50 AM > > > >I have been searching for the same answers for a > long time and have > >downloaded a lot of papers on the "raw vs cooked" > and to get definitive > >answers is a complicated task. Simple methods and > opinions and examples > >will go a long way in the understanding of a > controversial and > >complicated subject. Yes, I know that it is faster, > more complicated, a > >bear to administer but the answer is "it is used > today in quite a few > >shops". More informative answers would be > appreciated and would help in > >the decision process of "should we or shouldn't we > use raw devices" and > >what are the pitfalls and advantages if we do. A > guide ,reference, or > >link to help in the decisions would be a blessing. > >ROR mª¿ªm > > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fa
Re: max_io_size
This is sort of true. Steve's test will tell you what you can currently achieve based on your current system. File system and/or kernel restrictions may limit what is actually possible on the platform. eg a stock-standard newfs on Solaris will typically limit you to 256k; playing with maxcontig can lift that (or raw does away with all that nonsense altogether) Cheers Connor --- [EMAIL PROTECTED] wrote: > Patrice, > > You can determine this for yourself with a script: > > http://www.ixora.com.au/scripts/io_opt.htm > > The script is at the bottom of the page. > > It's a pretty simple test, you can easily do it > manually as well. > > Jared > > > > > > "Boivin, Patrice J" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 01/18/02 11:56 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:max_io_size > > > Where can I find information on this parameter on > the Tru64 UNIX platform? > > I did a scan of the manuals for Tru64 UNIX at > docs.oracle.com, but didn't > find mention of it anywhere. > > I want to set db_file_multiblock_read_count > properly... > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des > systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de > l'informatique > Maritimes Region, DFO | Région des Maritimes, > MPO > > E-Mail: [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > > -- > 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Searching Inside CLOBs
Our developers store XML docuements inside CLOBS and want to search the CLOB contents based on a search string. I have lot of concern about such queries but could benefit from someone on the list who has already solved the performnce issues with such searches. Typical existing queries I have come across are: SELECT columns FROM list of tables WHERE join conditions AND UPPER(tab1.topic) LIKE '%:in_string%' OR UPPER(tab2.subtopic) LIKE '%:in_string%' OR . OR dbms_lob.instr(bodytext,:in_string,1,1) <> 0; Note: in_string is always upper case but the column contents are not. Concerns: 1. Poor index selection due to UPPER 2. CLOB searches are wrong as the CLOB contents are case sensitive. One way to remedy this would be to build a user defined function which will read the CLOB col. in chunks and look for string matches inside individual chunks till a success or end of CLOB. Either way that is a pretty intense way to search for a string among table data when a user is waiting for a quick response. Keyword searches are supported differently. This mechanism is only for random string searches. Any cues or suggestions? Especially for case sensitive searches inside CLOBS? TIA Sundeep = Sundeep Maini Consultant Currently on Assignement at Marshfield Clinic WI [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sundeep maini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HP vs SUN for a UNIX box
Thanks, Dennis, my boss is thinking HP already. As far as flavor of UNIX, that wouldn't matter much. I'll have to learn it from scratch anyway. Best regards, Sergey -Original Message- Sent: Monday, January 21, 2002 3:25 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Sergey - Sorry for the confusion. Our ERP system is Lawson and I somehow had a brain fart and thought you were on that email list. If you management is just thinking about Unix, then the last thing you want to do is scare them off with an argument about which Unix. Start every reply with "of course all these are excellent choices and it will be no doubt difficult to choose between these really great systems". It sounds as if your application won't be very dependent on the flavor of Unix, so then you don't need to be so concerned about the long-term trends. Boxes are easier to replace than in-house developed software, it's just that software doesn't show up in the financial reports. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 7:45 AM To: Multiple recipients of list ORACLE-L Hi, Dennis, Just got back to work and found your message. It's a shame, but I don't know what Lawson is. Well, I used to be a chemical engineer in Soviet Union and didn't know Oracle existed... Anyway, I appreciate your reply. As far as that box, it's supposed to be a box for our main production. We have a pretty simple financial application, but huge OLTP and A LOT of reports. There's no programming except for my short scripts which I create to extend the app functionality (it is VERY old). The company is very lax on investments. Nonetheless, they're contemplating a switch to UNIX, and that I call a major move! Let's see what happens. Thanks for your reply again. Best regards, Sergey -Original Message- Sent: Friday, January 18, 2002 5:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Sergey - One factor you may want to consider is the timeframe of your decision. If it is just a decision for your Lawson box, then that isn't so critical. It is pretty easy to move Lawson from one system to another. Last fall we were looking at making a decision for all our systems. We are on Compaq Tru64, and that doesn't have a long future ahead of it. The META Group advice was that only three operating systems can be considered to have a stable future: 1. MS W2K 2. Linux 3. Solaris Most of the other Unix vendors are facing the next generation of computer chip architecture. I don't believe that HP is investing in the next generation itself, but will be switching to the new Intel 64-bit chips. Based on that advice, we chose Solaris because W2K and Linux are not up to the same standards as Solaris today. To repeat, we are looking at a lot of programming beyond Lawson, so our decision was based on more than simply purchasing the next box. We will have our Lawson system on Tru64 for several more years. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:25 PM To: Multiple recipients of list ORACLE-L Thank you, Paul, I'll forward it to my boss... Anyone else to add to it? Thank you very much, Sergey Babich -Original Message- Sent: Friday, January 18, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Stay with HP. It's a hell of a lot more reliable, and does not require anywhere near the # of patches, and its patches work far more often that Sun's. I've done 5 years with each, and there's no question that HP is superior. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Our shop is switching from HP to Sun. No one can tell me why. There must be a cost savings somewhere. -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
RE: DBA Vs Apps DBA
-Original Message- Sent: Monday, January 21, 2002 2:41 PM To: Multiple recipients of list ORACLE-L The DBA has more responsibility, usually more experience (this usually translates into higher pay as well) than Apps DBA. Well, yes and no. I have seen many orginizations pay the Apps DBA more, because of the "Specailized" knowledge they have. Jon Baker Database Architect <[EMAIL PROTECTED]> www.netsec.net Terry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: HP vs SUN for a UNIX box
Considering I have a brand spanking new Sun box waiting for me in the Server room, this thread has been less than comforting. Not Stable?!? I am starting to miss my DG boxes already. Steve -Original Message- Smith Sent: Monday, January 21, 2002 7:00 AM To: Multiple recipients of list ORACLE-L I heard that they already did. Something about Sun not being stable. -Original Message- Sent: Sunday, January 20, 2002 9:55 PM To: Multiple recipients of list ORACLE-L Oracle Magazine have alot "Oracle for HP" articles, I think they are switching from Sun to HP -Original Message- [EMAIL PROTECTED] Sent: 19 January 2002 06:16 To: Multiple recipients of list ORACLE-L Sergey, I asked my SA to add his 2 cents, guess he's not inclined. Anyway, I've been on HP for the last 10 years, coming from VMS, & I love it. VERY stable, easy to use, although I don't do the admin any longer it was easy with SAM even when it was a character based tool. Rman/OmniBack integration is well documented in the OmniBack manuals & works as advertised. HP support is pretty darn good as well, especially in the middle of the night when the system won't boot. I've had HP support tech's remotely logged in to the system helping get it back online. Also if you have a problem that is not in the area of the tech you call they normally conference in the needed assistance. Problems can be resolved as fast as they occur. We also don't use disk arrays from HP, but then HP & EMC really like each other. If you want an inexpensive disk alternative look into NetAppliance. Dick Goulet Senior Oracle DBA Reply Separator Author: "Babich ; Sergey" <[EMAIL PROTECTED]> Date: 1/18/2002 1:25 PM Thank you, Paul, I'll forward it to my boss... Anyone else to add to it? Thank you very much, Sergey Babich -Original Message- Sent: Friday, January 18, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Stay with HP. It's a hell of a lot more reliable, and does not require anywhere near the # of patches, and its patches work far more often that Sun's. I've done 5 years with each, and there's no question that HP is superior. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Our shop is switching from HP to Sun. No one can tell me why. There must be a cost savings somewhere. -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul 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
RE: 8.1.7.3 patchset now available for two platforms
OK, I give. Where's it hiding? I'm sitting at the ftp site where I found the 8.1.7.2 patchset server/patchsets/unix/SUN_SOLARIS2/81patchsets/32BIT there's no 8.1.7.3 patchset there. (There's an 8.1.6.3, but no 8.1.7.3) Any clues??? Thx! Barb > -- > From: A. Bardeen[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Monday, January 21, 2002 6:55 AM > To: Multiple recipients of list ORACLE-L > Subject: 8.1.7.3 patchset now available for two platforms > > Hi all! > > 8.1.7.3 is now available on MetaLink for the following > platforms: > > 32-bit Oracle on Solaris > 64-bit Oracle on HP-UX > > IMPORTANT: A 32-bit OS can run only the 32-bit > version or Oracle; a 64-bit OS can run both the 32-bit > and 64-bit versions of Oracle. > > A 32-bit patch can be applied only to the 32-bit > version of Oracle for the same release (first 3 > digits); likewise a 64-bit patch can be applied only > to a 64-bit version of Oracle. > > The bit version of the OS selected (32-bit or 64-bit) > when downloading a patch is based on the bit version > of the Oracle software NOT the OS. So if you're > running 32-bit Oracle on 64-bit Solaris, you must > download the patchset for 32-bit Solaris! > > New patchsets are available only on MetaLink: > > > You may find it by searching using the following > criteria after selecting PATCHES from the left-hand > menu: > > Product Family:Oracle Server > Release: 8.1.7.3 > Platform: > Limit Search to: Latest Product Patchsets or > Minipacks > > Alternatively, you may look it up by using the patch # > for the 8.1.7.3 patchset: 218975 > > > HTH, > > -- Anita > > > __ > Do You Yahoo!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > -- > 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: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Vs Apps DBA
Title: RE: DBA Vs Apps DBA From past experience: Many companies may classify a DBA as the person that administers the database and the Apps DBA to administer the applications that utilize that database. The Apps DBA may be more of a glorified database developer with some DBA duties and understanding of how the database interacts or is utilized by the application (whether it be COTS or a local beast). The DBA has more responsibility, usually more experience (this usually translates into higher pay as well) than Apps DBA. Jon Baker Database Architect <[EMAIL PROTECTED]> www.netsec.net > -Original Message- > From: C.S.Venkata Subramanian [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 21, 2002 12:15 AM > To: Multiple recipients of list ORACLE-L > Subject: OT:DBA Vs Apps DBA > > > Hello Listers, > Can any one tell me, what is the basic difference between a > "DBA" and an "Apps DBA", what additional tasks an Apps dba > has to do than compared to a normal dba. > > Secondly what will be career prospective of a Support DBA in > the long run. > > Pl enlighten me. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: C.S.Venkata Subramanian > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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 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).
RE: dropped datafile problem
you HAVE to drop the tablespace. You do not have a consistent database, and your database is a disaster recovery scenario waiting to happen. The question is, why did you drop the datafile without researching the ramifications? --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > no , and i can not do so (it's a more than 1TB tablespace , i can't > recreate > it = no time frame). > thanks ! > > > > -Original Message- > Sent: 21 January 2002 18:01 > To: Multiple recipients of list ORACLE-L > > > did you drop the tablespace as well? > > > --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > > Dear gurus ! > > > > I have an "offline dropped" datafile at my database. The file was > > physically > > deleted at the OS level after "offline drop". > > Before dropping the file , all the objects that had extents > allocated > > in > > that file (from dba_extents) were dropped. > > Now , V$datafile shows this file as of size=0 and status = > 'RECOVER' > > which > > is fine. > > BUT , file$ show this file as of size 8GB, which is the file size > as > > it used > > to be before being dropped. > > Moreover , fet$ shows 8GB as free extents residing at this file . > > And , after all , tables get created in that file , i.e. > dba_extents > > show > > extents with FILE_ID of that file ! > > When a select statement tries to access a table with extents > residing > > in > > that file , i get an error message , off course. > > > > So , the question is , how do i make the file's extents disappear > > from fet$ > > ? > > Thanks a lot. > > > > Andrey. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Andrey Bronfin > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrey Bronfin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HP vs SUN for a UNIX box
Sergey - Sorry for the confusion. Our ERP system is Lawson and I somehow had a brain fart and thought you were on that email list. If you management is just thinking about Unix, then the last thing you want to do is scare them off with an argument about which Unix. Start every reply with "of course all these are excellent choices and it will be no doubt difficult to choose between these really great systems". It sounds as if your application won't be very dependent on the flavor of Unix, so then you don't need to be so concerned about the long-term trends. Boxes are easier to replace than in-house developed software, it's just that software doesn't show up in the financial reports. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 7:45 AM To: Multiple recipients of list ORACLE-L Hi, Dennis, Just got back to work and found your message. It's a shame, but I don't know what Lawson is. Well, I used to be a chemical engineer in Soviet Union and didn't know Oracle existed... Anyway, I appreciate your reply. As far as that box, it's supposed to be a box for our main production. We have a pretty simple financial application, but huge OLTP and A LOT of reports. There's no programming except for my short scripts which I create to extend the app functionality (it is VERY old). The company is very lax on investments. Nonetheless, they're contemplating a switch to UNIX, and that I call a major move! Let's see what happens. Thanks for your reply again. Best regards, Sergey -Original Message- Sent: Friday, January 18, 2002 5:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Sergey - One factor you may want to consider is the timeframe of your decision. If it is just a decision for your Lawson box, then that isn't so critical. It is pretty easy to move Lawson from one system to another. Last fall we were looking at making a decision for all our systems. We are on Compaq Tru64, and that doesn't have a long future ahead of it. The META Group advice was that only three operating systems can be considered to have a stable future: 1. MS W2K 2. Linux 3. Solaris Most of the other Unix vendors are facing the next generation of computer chip architecture. I don't believe that HP is investing in the next generation itself, but will be switching to the new Intel 64-bit chips. Based on that advice, we chose Solaris because W2K and Linux are not up to the same standards as Solaris today. To repeat, we are looking at a lot of programming beyond Lawson, so our decision was based on more than simply purchasing the next box. We will have our Lawson system on Tru64 for several more years. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:25 PM To: Multiple recipients of list ORACLE-L Thank you, Paul, I'll forward it to my boss... Anyone else to add to it? Thank you very much, Sergey Babich -Original Message- Sent: Friday, January 18, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Stay with HP. It's a hell of a lot more reliable, and does not require anywhere near the # of patches, and its patches work far more often that Sun's. I've done 5 years with each, and there's no question that HP is superior. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Our shop is switching from HP to Sun. No one can tell me why. There must be a cost savings somewhere. -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Smith, Ron L. INET:
RE: RE: HP vs SUN for a UNIX box
When Oracle said Sun was not stable I do not think they meant that in terms of running. I believe they mean that the libraries and what not change to much. When you are trying to code to a particular OS that can be annoying I guess. However, I am getting this not from Oracle themselves so who really knows if its true or not. -Original Message- Sent: Monday, January 21, 2002 8:30 AM To: Multiple recipients of list ORACLE-L These threads always crack me up. Its like religious wars. We've got both in house. Most of my stuff runs on the SUN boxes, and I have had no problems with the stability. I guess administration of the HPs is easier, but the Sun SAs aren't complaining so its pretty much a non-issue for us. As far as cost, HP wasn't competitive, Sun was much cheaper. Due to the cost difference we probably wouldn't be buying any more HPs, except when a certain product is only certified on HP or when the purchase decision is made by an HP-centric manager. Jim -Original Message- Sent: Monday, January 21, 2002 10:00 AM To: Multiple recipients of list ORACLE-L I heard that they already did. Something about Sun not being stable. -Original Message- Sent: Sunday, January 20, 2002 9:55 PM To: Multiple recipients of list ORACLE-L Oracle Magazine have alot "Oracle for HP" articles, I think they are switching from Sun to HP -Original Message- [EMAIL PROTECTED] Sent: 19 January 2002 06:16 To: Multiple recipients of list ORACLE-L Sergey, I asked my SA to add his 2 cents, guess he's not inclined. Anyway, I've been on HP for the last 10 years, coming from VMS, & I love it. VERY stable, easy to use, although I don't do the admin any longer it was easy with SAM even when it was a character based tool. Rman/OmniBack integration is well documented in the OmniBack manuals & works as advertised. HP support is pretty darn good as well, especially in the middle of the night when the system won't boot. I've had HP support tech's remotely logged in to the system helping get it back online. Also if you have a problem that is not in the area of the tech you call they normally conference in the needed assistance. Problems can be resolved as fast as they occur. We also don't use disk arrays from HP, but then HP & EMC really like each other. If you want an inexpensive disk alternative look into NetAppliance. Dick Goulet Senior Oracle DBA Reply Separator Author: "Babich ; Sergey" <[EMAIL PROTECTED]> Date: 1/18/2002 1:25 PM Thank you, Paul, I'll forward it to my boss... Anyone else to add to it? Thank you very much, Sergey Babich -Original Message- Sent: Friday, January 18, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Stay with HP. It's a hell of a lot more reliable, and does not require anywhere near the # of patches, and its patches work far more often that Sun's. I've done 5 years with each, and there's no question that HP is superior. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Our shop is switching from HP to Sun. No one can tell me why. There must be a cost savings somewhere. -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the na
RE: DBA Vs Apps DBA
Hi all, I guess this question has been asked many times both in this list and offline. I had promised to write this sometime back, so it's time to get to the bottom of this: History: Oracle has had an ERP (Enterprise Resource Planning) application - simply named "Oracle Applications" - for a long time. Originally developed as a Forms 2.4 (yes - 2.4 was a 'special' version of Forms 2.x that could handle what they called Flex fields) and ReportWriter 1.x based application starting at Applications release 9, it developed into a version 10.x and at some point moved to 'Client/Server' mode (10.7 Smart Client) and then onto a N-tier mode (10.7NCA, 11.0 and now 11i). Starting off as an packages Application that catered purely to the Financial side of the organization in the beginning days, the scope has been widened to cater to almost all aspects of a Business, including CRM (Customer Relations Management). In short, 'Apps' now caters to Finance (GL/AR/AP, etc.), HR, Inventory, Order Entry, Manufacturing, Sales, CRM, etc. The Database has always been Oracle, starting with 7.0 and moving onto 7.3, and later 8.0.x and now 8.1.x/9.0.x. To support the Web layer in an N-tier architecture, Oracle started using OWAS 3.0/4.0 and then progressed to WebDB 2.x (short lived) and is currently using Oracle 9iAS based on the Apache Web server for the Web portion. The Forms and Reports versions has moved from 2.4 (character only) to Dev2K and now stands at Dev 6i. The forms runs off a Forms server that is accessed via the Intranet/Internet and interacts with a JInitiator that is downloaded to your PC. All versions of Apps have had a batch job scheduler - known as the Concurrent Manager. This is quite a complicated (and well thought-out) piece of technology and handles Report/Scripts and other execution on the Application layer. A set of FND (Foundation) tables forms the base for the Concurrent Manager. Multiple queues, Specialization rules, Interface tables, Responsibility-based access have been part of the whole system since inception. This 'Application stack' - as it is usually referred to *normally* runs in an OS account (usually 'applmgr') that is separate from the 'oracle' account. Apps caters to most of the standard functionality, but a lot of customization is still required. All of this needs to be done outside of the Standard schemas. The system is highly parameterized and there are strict guidelines as to what can be done and what cannot be 'tweaked'. For e.g., until 11i (or 11.5.x), the optimizer_mode *HAD* to be set to RULE. A lot of sites that upgraded from 10.7/11.0 to 11i are now tripping up on performance issues related to the change in mode. Because of the complexity and business involvement required, there are two types of people who manage this - a 'Functional' person who understands the business side of things and maps the business process to the Apps functionality. Then there is the 'Technical' person who again consists of the Apps Developers/System Admins and the DBAs. While the System Admins are supposed to deal with the Setup and management of the Concurrent manager, etc. there is quite a bit of overlap and depending on the organization, the DBAs sometimes act in this capacity. There are also cases of Apps SysAdmins becoming DBAs by default. Since Apps is a complex application, it is inevitable that it needs constant maintenance, mainly to fix functionality problems. Hence 'Apps Patching' is a *MAJOR* issue, especially for DBAs and the Tech team. There are literally hundreds of patches to be applied between minor version releases, so much so that patches are rolled up into 'Family packs', one per application schema. This effort is usually underestimated, and the need for a Dev, Test, UAT environment and a proper Change management system becomes critical. Upgrades from one version of Apps to the next are *MAJOR* steps, both Organizationally and Technically. Upgrade projects need to be well managed and there are highly paid Consultants (some upto $300/hr and above) that need to be brought in to perform these or at least plan this out. These upgrades are mandatory as the Database/Apps versions change, and the Business depends on it. So, what does a 'normal' DBA need to know? In addition to the Oracle DBA related stuff, the Apps DBA needs to know about the Apps setup, Concurrent Managers, Forms/Reports servers, Web servers, Patching, Upgrades. Most important, you need to know what's allowed and what's not - a wrong step can mess up the whole thing and take you out-of-support. Depending on the organization and the role, you may also be performing critical work during period closes (monthend/quarter or year end) as well as SysAdmin stuff. Going into an Apps situation with both guns blazing can have dire consequences, maybe not immediately, but certainly at period-closes or upgrades when it falls apart. There is a lot more to it, such as Printer configuration, Self-Service Web apps setup, etc. that
RE: Ftp command
If you turn prompt off you do not get the question. -Original Message- Lee - lerobe Sent: Monday, January 21, 2002 7:36 AM To: Multiple recipients of list ORACLE-L Is there a reason why you don't want to use the perfectly acceptable mput/mget utilities provided with ftp ?? -Original Message- Sent: 21 January 2002 14:55 To: Multiple recipients of list ORACLE-L Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying 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 computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Trigger Question
Hamid Alavi wrote: > > List, > > I have some problem with Trigger, I want to Insert a record as Primary Key > on each insert into Table1 and the same time create another Primary key in > table2 plus PK from Tabl1 inserting in Table2 as Forign Key, Is there any > way to do all these steps in one trigger and assign this trigger to table1 > or some thing like this or not? > THanks Alot > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > Convoluted logic. Use a sequence as the key for table1 and refer to seq.currval inside the trigger to insert the FK into table2. Do not try to do in triggers what Oracle does perfectly well as a standard feature. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Guru's advise needed.Partitioned IOT. Despaired
shuli wrote: > > Dear listers, > Could someone share his/her experience on partitioned IOT. I am quite > confused now. I have an partitioned IOT. The performance of query data from one > partiton of the partitioned IOT is worse than query data from the unpartitioned > IOT. > Any advice would be greatly appreciared. > Shu > Shu, IOTs are not, whether they are partitioned or not, any more than anything else, the answer. They are an answer to some special queries which are highly important to your application (and, possibly, reasons linked to ease of operation). If non-partitioned performs better, go for non-partitioned. The only problem I am aware of with partitioned IOTs is that you may have deadlocks with SELECTs if you are concurrently partitioning them (true in both 8.1.6 and 8.1.7). -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RMAN-20202 error while recovery
Have you tried removing the "" from around the tablespace name?
Sona wrote:
> Hi
> i am trying to recover the database from the loss of SYSTEM datafile.
> After mounting the database ,I tried recovery using RMAN
> RMAN> run
> 2> {
>3> allocate channel c1 type disk ;
> 4> restore tablespace "system";
> 5> recover tablespace "system";
> 6> sql 'alter database open';
> 7> release channel c1;
> 8> }
>
> I have a Incremental level 0 backup and also a incremental level 1 database
> backup.
> i got the following error while recpovering
> RMAN-03022: compiling command: allocate
> RMAN-03023: executing command: allocate
> RMAN-08030: allocated channel: c1
>RMAN-08500: channel c1: sid=11 devtype=DISK
>
> RMAN-03022: compiling command: restore
> RMAN-03025: performing implicit partial resync of recovery catalog
>
>>RMAN-03023: executing command: partial resync
>>RMAN-08003: starting partial resync of recovery catalog
>>RMAN-08005: partial resync complete
>>
>>RMAN-03022: compiling command: IRESTORE
>>RMAN-03026: error recovery releasing channel resources
>>RMAN-08031: released channel: c1
>>RMAN-00571: ===
>>RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
>>RMAN-00571: ===
>>RMAN-03002: failure during compilation of command
>>RMAN-03013: command type: restore
>>RMAN-03002: failure during compilation of command
>>RMAN-03013: command type: IRESTORE
>>RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202:
>>tablespace not found in the recovery catalog
>>RMAN-06019: could not translate tablespace name "system"
>>
>Any ideas why this error occurs
>The intersting thing is that if i use "recover datafile" ,the recovery goes
> thru.
>
>TIA
>
_
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: Ed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Sql query
[EMAIL PROTECTED] wrote: > > Try, > select col1 from table1 where col1 not in (SELECT col1 from table2) > Rha -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
where to download designer 6i ?
Hi, I tried to download Designer 6i from OTN, but I got: Oracle Designer 6i Release 4.1.1 (Coming Soon) Does anyone know where can I download release 4 or release 3? Thank you. Andrea __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: HP vs SUN for a UNIX box
I want to thank everyone for the input. Best regards, Sergey Babich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database link and decode in 9i -- The Plot Thickens
The developer updated me with the following information regarding this problem: 'If I edit the inline view and removed the decode from the outer query, the query works' This update leads me to believe that this might be some kind of bug or altered feature in 9.0.1 instead of some stupid permissions problem on my part. Anybody seen any changes to decodes or decodes in views in 9i? I'm sifting through the stuff on Metalink but it's slow going. Thanks for any feedback you might have on this issue. I am also opening a TAR with Oracle on this problem. Cherie Machler Oracle DBA Gelco Information Network. Cherie Machler To: [EMAIL PROTECTED] 01/21/02 11:05 cc: AM Subject: Database link and inline view (permissions problem?) (Document link: Cherie Machler) I am terrible with database links. We are having a problem with a link from a 9.0.1 database to an 8.0.4 database. Following is the problem: (Embedded image moved to file: pic09961.pcx) Full Description:I am trying to run a SQL query with an inline view (see below) in EDWDEV01 using a link to DWDEV01 to access the ACCT_PAY_TYPE table. If I run the query in EDWDEV01 I get "no rows selected". If I move the query to DWDEV01 and remove the conneciton descriptions, I get 10 rows selected. Is this permissions, database versions, or what? Any suggestions, ideas? SELECT apt.acct_no, apt.pay_seq_no, apt.src_chng_batch_win_dt_key wh_date_key, 0 wh_time_key, apt.data_whse_mod_dt_tmwh_mod_dt_tm, DECODE(apt.src_chng_batch_win_dt_key, subq.maxkey,'C','H') wh_row_sts, apt.data_src_mod_dt_tm wh_row_eff_dt_tm, apt.data_src_mod_dt_tm upd_dt_tm, apt.acct_pay_desc, apt.status FROM acct_pay_type@whse_dbo_dwdev01 apt, (SELECT acct_no, data_sts, pay_seq_no, eff_dt_x, MAX(src_chng_batch_win_dt_key) maxkey FROM acct_pay_type@whse_dbo_dwdev01 GROUP BY acct_no, data_sts, pay_seq_no, eff_dt_x) subq WHERE apt.acct_no = subq.acct_no AND apt.data_sts = subq.data_sts AND apt.pay_seq_no = subq.pay_seq_no AND apt.eff_dt_x = subq.eff_dt_x ORDER BY 1, 2, 3 DESC; Following is the link information: SQL> select * from dba_db_links; OWNER DB_LINK USERNAME HOST CREATED -- --- -- -- -- PUBLIC WHSE_DBO_DWDEV0 WHSE_DBO DWDEV0121-JAN-02 1.GELCO.COM If I do a select * from acct_pay_type@whse_dbo_dwdev01 from within the remote database (not DWDEV01), I get ten rows returned. If I run this sql from the remote database, (not DWDEV01), I get no rows returned. If I run the SQL from DWDEV01 with the @whse_dbo_dwdev01 removed, I get 10 rows returned. What is my problem? Seems like I'm missing permissions somewhere or something like that. Any help is appreciated. Cherie Machler Oracle DBA Gelco Information Network pic09961.pcx Description: Binary data
Re: multiple extents are OK, dagnabbit!
Can you elaborate on exactly what happened? 8.1.5 to 8.1.6 is just a catalog script and a binary change. What error did you encounter, and at which step in the upgrade? Extents should not matter in an upgrade. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 21 Jan 2002, Dave Morgan wrote: > Actually, in extreme cases ( >87000 in my case, and I had 12 > tables > like that) it can cause problems with upgrading. Not sure what, but we > had to do CTAS into new tables with much larger extents to do the > upgrade from 8.1.5 to 8.1.6 here. Had Oracle support and consultants > baffled also > > I still like to keep the number of extents below 500, but I'm paranoid > :) > > Rachel wrote: > Snip > > There really is NO reason to worry about large numbers of extents these > > days. I mean, I wouldn't want to really test the "unlimited" ability > > but other than that, there is no problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN-20202 error while recovery
Hi
i am trying to recover the database from the loss of SYSTEM datafile.
After mounting the database ,I tried recovery using RMAN
RMAN> run
2> {
3> allocate channel c1 type disk ;
4> restore tablespace "system";
5> recover tablespace "system";
6> sql 'alter database open';
7> release channel c1;
8> }
I have a Incremental level 0 backup and also a incremental level 1 database
backup.
i got the following error while recpovering
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=11 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03025: performing implicit partial resync of recovery catalog
> RMAN-03023: executing command: partial resync
> RMAN-08003: starting partial resync of recovery catalog
> RMAN-08005: partial resync complete
>
> RMAN-03022: compiling command: IRESTORE
> RMAN-03026: error recovery releasing channel resources
> RMAN-08031: released channel: c1
> RMAN-00571: ===
> RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
> RMAN-00571: ===
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: restore
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: IRESTORE
> RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202:
> tablespace not found in the recovery catalog
> RMAN-06019: could not translate tablespace name "system"
>
Any ideas why this error occurs
The intersting thing is that if i use "recover datafile" ,the recovery goes
thru.
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sona
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 Subset Tool?
Dale, Thanks for your reply. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dale Edgar > Sent: Saturday, January 19, 2002 1:05 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Data Subset Tool? > > > Hi Larry > > Disclaimer: I work for Net 2000 Ltd. the authors of DataBee. > > >...but does anyone have > >recommendations on a tool that will create a subset of > production data that > >is referentially intact? I am aware of DataBee... > > I don't mind telling you who the competition is - we are confident that we > are better value both in price and functionality:-) Two other subsetting > tools on the market are DataManager from Quest > http://quest.com/schema_manager/ and CheckMate from BitByBit > http://www.bitbybit.co.uk > > >, but it might be more cost effective to buy > > something if the price is right. The main feature I would be > interested in > > is a tool that maintained the distribution characteristics of the data. > > DataBee is designed specifically to cope with this requirement. > You can set > up the rules (called an Extraction Set) based on multiple drivers. You > could, for example, sample 10% of a table (even on ora7.x) and then put on > other rules which pick up specific date ranges. You can also use multiple > tables: ie get 5% of all invoices from the INVOICE table and 25 specific > customers from the CUSTOMER table. DataBee would cheerfully get all of the > customers to support the invoices and all of the invoices to support the > customers. Basically the rows are adjusted until every table has the data > required required to support all of the rest and the subset is in balance. > > > I know it can be built by hand > They can but it is (as I'm sure you know) a lot of hassle - and > it can be a > nightmare to get the FK constraints to re-enable if you have a > lot of them. > An automated tool really is cost-effective. One of our customers used to > take a week and 45 skilled DBA hours to cut a subset database - even then > only about 200 of the 500 constraints would enable. DataBee cuts > the subset > in 4 hours (its a push button operation once the Extraction Set is setup) > and all 500 constraints enable. > > DataBee: http://www.databee.com > > Cheers > Dale Edgar > Net 2000 Ltd. > [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBD::Oracle: "" vs NULL, and a possible change to the ChopBlanks
Tim, I've always chosen to just deal with the nulls rather than worry about padded strings or storing a single space. Personally I can't stand storing a single space to represent an empty string and prefer the null. Not all share my opinion obviously, but I've just gone along with the trinary logic of working with nulls whenever working with Oracle. If I were to use other databases extensively and were concerned about writing portable code, that sentiment would likely change. The authors of modules that provide a generic interface to many different databases will no doubt thank you for this. Jared Tim Bunce <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/20/02 03:15 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:DBD::Oracle: "" vs NULL, and a possible change to the ChopBlanks attribute It's well know that Oracle#s state of the art database server can rarely tell the difference between an empty string and a NULL (I presume that's not changed recently, though I'd be very happy to be told otherwise). So people who don't want empty strings being stored as NULLs in their fields tend to use some specific non-empty string insead, a single space being very common. The DBI has an attribute called ChopBlanks that, when set true, enables the automatic removal of trailing spaces from fetched CHAR field data (which Oracle has 'helpfully' padded out to the declared fixed width). I'm considering extending the definition of ChopBlanks to include VARCHAR type fields. This has been requested several times over the years by DBI users. The change would neatly hide the use of a space to represent an empty string. I'd like to get some feedback on this idea from DBD::Oracle users. I'm especially interested in the risk of changing the behaviour of existing code. That would _only_ happen if you explicitly set ChopBlanks, and fetch VARCHAR data that has trailing spaces, and the removal of those spaces would change the behaviour of your application. An alternative approach would be to add a new private attribute that just translates a single space value into an empty value. That would be "safer" but less generically useful. Tim p.s. I've sent this to both [EMAIL PROTECTED] and [EMAIL PROTECTED] Please delete at least one of these addresses when replying. Thanks. p.p.s. A corresponding mechanism to optionally automatically treat empty strings bound to placeholders as a single space will probably also be added to DBD::Oracle and enabled via private attribute. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Bunce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ftp command
Try prompt before issuing the mget or mput command. Terry -Original Message- Sent: 21 January 2002 14:55 To: Multiple recipients of list ORACLE-L Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying 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 computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Q$INSTL Package From Savant Does not Import
Hi, On January 2 this year (for troubleshooting purposes) I imported a database from one of our clients. The import was fine, except for a few objects that did not compile. Since these objects were not part of our application and did not appear to interfere with our application, we ignored them. We made some application changes to the database, created an export, and returned the dump file to our client. The log file indicated no unusual errors. Our client has encountered difficulties importing the dump file. The import crashes on a package called Q$INSTL with the "end of file on communications channel" error. The package is wrapped, but a comment at the top says it is written by Savant. There is additional evidence to indicate the package is used to control changes to existing packages. When we test the import here, we also receive the "end of file on communications channel" error. However, if the dump file with no changes is imported, (which also includes the wrapped Q$INSTL package), the import completes successfully. Can anybody tell me anything about the Q$INSTL package and how it impacts a database? Any way to get around this problem? Thanks for any input! Sam Bootsma -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Trigger Question
List, I have some problem with Trigger, I want to Insert a record as Primary Key on each insert into Table1 and the same time create another Primary key in table2 plus PK from Tabl1 inserting in Table2 as Forign Key, Is there any way to do all these steps in one trigger and assign this trigger to table1 or some thing like this or not? THanks Alot Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 extents are OK, dagnabbit!
And I was worried about 20 to 60 extents. :) But I do have one question, if a table has multiple extents, 20 extents at 1Mb each, and they are contiguous, is that equal to 1 extent of 20Mb big ?? Does oracle have to work harder to get those 20 extents ? (okay two questions) Darren -Original Message- Sent: January 21, 2002 8:51 AM To: Multiple recipients of list ORACLE-L Hi All, Actually, in extreme cases ( >87000 in my case, and I had 12 tables like that) it can cause problems with upgrading. Not sure what, but we had to do CTAS into new tables with much larger extents to do the upgrade from 8.1.5 to 8.1.6 here. Had Oracle support and consultants baffled also I still like to keep the number of extents below 500, but I'm paranoid :) Dave Rachel wrote: Snip > There really is NO reason to worry about large numbers of extents these > days. I mean, I wouldn't want to really test the "unlimited" ability > but other than that, there is no problem. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
pipes vs message queues
Dear list ! Sorry for an ignorent question : what's the difference (functional and technical) among Oracle pipes and Oracle message queues ? DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dropped datafile problem
no , and i can not do so (it's a more than 1TB tablespace , i can't recreate it = no time frame). thanks ! -Original Message- Sent: 21 January 2002 18:01 To: Multiple recipients of list ORACLE-L did you drop the tablespace as well? --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > Dear gurus ! > > I have an "offline dropped" datafile at my database. The file was > physically > deleted at the OS level after "offline drop". > Before dropping the file , all the objects that had extents allocated > in > that file (from dba_extents) were dropped. > Now , V$datafile shows this file as of size=0 and status = 'RECOVER' > which > is fine. > BUT , file$ show this file as of size 8GB, which is the file size as > it used > to be before being dropped. > Moreover , fet$ shows 8GB as free extents residing at this file . > And , after all , tables get created in that file , i.e. dba_extents > show > extents with FILE_ID of that file ! > When a select statement tries to access a table with extents residing > in > that file , i get an error message , off course. > > So , the question is , how do i make the file's extents disappear > from fet$ > ? > Thanks a lot. > > Andrey. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrey Bronfin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dropped datafile problem
nope. The file was physically deleted at the OS level after "offline drop". Thanks DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -Original Message- Sent: 21 January 2002 17:51 To: Andrey Bronfin esoft.com> cc: Subject: RE: dropped datafile problem 21/01/02 15:39 Hi Mike & other gurus! Thanks for your reply. I'm aware of what u have said - i just have no choice , i can't rebuild the tablespace. I just need to prevent Oracle from allocating extents in that "bad" datafile. Thanks! -Original Message- Sent: 21 January 2002 16:51 To: 'Andrey Bronfin'; 'LazyDBA.com Discussion' OFFLINE DROP does not allow the dropping of a datafile. There is no supported way to drop an existing datafile from a tablespace without dropping the entire tablespace. The answer is, you can't without hacking the data dictionary which voids your support. You can try recreating the control file without the datafile mentioned but success with this has been spotty. Mike -Original Message- Sent: Monday, January 21, 2002 9:38 AM To: LazyDBA.com Discussion Dear gurus ! I have an "offline dropped" datafile at my database. The file was physically deleted at the OS level after "offline drop". Before dropping the file , all the objects that had extents allocated in that file (from dba_extents) were dropped. Now , V$datafile shows this file as of size=0 and status = 'RECOVER' which is fine. BUT , file$ show this file as of size 8GB, which is the file size as it used to be before being dropped. Moreover , fet$ shows 8GB as free extents residing at this file . And , after all , tables get created in that file , i.e. dba_extents show extents with FILE_ID of that file ! When a select statement tries to access a table with extents residing in that file , i get an error message , off course. So , the question is , how do i make the file's extents disappear from fet$ ? Thanks a lot. Andrey. Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms: http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Resource management
Yep. Rested. That's me. A. Thanks! -Original Message- Sent: Friday, January 18, 2002 4:11 PM To: Multiple recipients of list ORACLE-L Bambi, Boy you ARE rested!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:How to find out free space below High Water Mark in table
Check out the dbms_space package owned by system. Dick Goulet Reply Separator Author: "Daiminger; Helmut" <[EMAIL PROTECTED]> Date: 1/21/2002 7:35 AM Hi! I deleted several thousand rows from a table, but it looks like the table is still taking up the same amount of space in the tablespace. Which it indeed does, because delete does not reset the HWM. Does anybody out there have a script that gives me the free space in a table below the high water mark? This is 8.1.7 on Sun Solaris. Thanks, Helmut How to find out free space below High Water Mark in table Hi! I deleted several thousand rows from a table, but it looks like the table is still taking up the same amount of space in the tablespace. Which it indeed does, because delete does not reset the HWM. Does anybody out there have a script that gives me the free space in a table below the high water mark? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- 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: DBA Experiences with Oracle and RAID 0+1
As a cost-cutting measure: They could combine the U.S. and European conventions, all they have to do is hold them in Halifax ... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, January 21, 2002 11:56 AM To: Multiple recipients of list ORACLE-L Subject:RE: DBA Experiences with Oracle and RAID 0+1 Oracle OpenWorld in the Americas will never leave the West Coast and is highly unlikely to leave San Francisco. Too convenient to Headquarters If Miracle gave that class in Halifax, I'd go! --- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > May I suggest Halifax, Canada as a great location for this course??? > > StilL waiting for Oracle OpenWorld to come here, somehow they never > do. > > : ) > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, January 21, 2002 8:06 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: DBA Experiences with Oracle and RAID 0+1 > > you have no idea how badly most of us now want to come to that class. > Not that I'd understand most of what was said, but just to listen :) > > > --- Mogens Nørgaard <[EMAIL PROTECTED]> wrote: > > Jared, > > > > Good thought! We're running our annual Miracle Master Class (this > > year > > with Jonathan Lewis) this week and Cary Millsap (and his gang), > > Jonathan > > and James will arrive tomorrow (Monday), while Steve Adams, Lex de > > Haan, > > Stephan Haisley and a bunch of other guys will arrive on Tuesday. > > I'll > > keep this message and throw it up for discussion on the Oak Table > > (see > > Cary's wonderful article on www.Undskyld.Org)... > > > > Jared Still wrote: > > > > >Mogens, > > > > > >In regard to the number of spindles issue: James Morle has some > > >excellent discussion on that in 'Scaling Oracle 8i'. ( I think > > it's that > > >book ) > > > > > >When some of the newer larges drives are used in a given > > configuration, > > >they mabe be able to outperform older drives in a similar > > configuration with > > >a larger number of spindles. > > > > > >I say 'older' since smaller drives usually aren't using the latest > > technology > > >and the newer ones have sufficiently higher throughput to match > the > > >capability of a larger number of drives in given configuration. > > > > > >Food for thought, anyway. > > > > > >Jared > > > > > > > > >On Sunday 20 January 2002 06:50, Mogens Nørgaard wrote: > > > > > >>Diego, > > >> > > >>I agree with you 100% and didn't express myself correctly in my > > email. > > >>The more spindles the better. What I meant to say was that you > must > > >>never buy disks by taking your total needed amount of space and > > divide > > >>by the number of big disks you can get hold on :). It's the > number > > of > > >>IO's required by the disk system that matters, not the size... > > >> > > >>Thanks for making this clear to everyone. > > >> > > >>Mogens > > >> > > >>Diego Cutrone wrote: > > >> > > >>>Mogens: > > >>> Just let me disagree with you at only one point. According to > > my > > >>>experience, I think that the size of the disks in an array does > > matter > > >>>sometimes. It's not the same to have 24 9GB disks that to have > > only 3 of > > >>>73GB. You have 24 spindles againts 3, the first option (in a > well > > >>>configured system of course) will give you better performance in > > >>>enviroments where you have a lot of concurrency and many users. > > >>> However I think that what I've written above might not be > > correct (may > > >>>be it should be tested) if the 73GB outstands for a long way the > > 9GB disks > > >>>in terms of seek time and transfer rate. > > >>> Take a look at an extract of Gaja's paper "Implementing RAID > on > > >>>Oracle": > > >>> > > >>>"5) Procure the smallest drive money can buy, keeping in mind > > scalability, > > >>>limits of the host > > >>>machine, the disk array and growth projections for the database. > > This is a > > >>>tough one these > > >>>days, with 18 GB drives considered as small drives. > > >>> > > >>>6) Bigger and faster drives are not always better than smaller > > slower > > >>>drives, as the seek times > > >>>for larger and faster drives with larger form factors, may be > more > > than > > >>>their smaller and > > >>>slower counterparts. This is not that big of an issue, if your > > drives > > >>>support a built-in track > > >>>buffer cache for storing an entire track's worth of data from > read > > >>>request(s)." > > >>> > > >>> > > >>>HTH > > >>>Greeting > > >>>Diego Cutrone > > >>> > > >>>- Original Message - > > >>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >>>Sen
RE: DBA Experiences with Oracle and RAID 0+1
Let me add the official stuff here. Oracle has booked the Moscone Convention Center for the next 10 years. It makes financial sense for them to have the conference in their home area. Unfortunately, as hotel prices increase in San Francisco, the opportunity for attendance by small organizations diminishes. Don't expect to see this event outside S. F. anymore for the US. Oracle learned their lesson quite hard in Los Angeles a few years ago. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, January 21, 2002 10:56 AM To: Multiple recipients of list ORACLE-L Subject:RE: DBA Experiences with Oracle and RAID 0+1 Oracle OpenWorld in the Americas will never leave the West Coast and is highly unlikely to leave San Francisco. Too convenient to Headquarters If Miracle gave that class in Halifax, I'd go! --- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > May I suggest Halifax, Canada as a great location for this course??? > > StilL waiting for Oracle OpenWorld to come here, somehow they never > do. > > : ) > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, January 21, 2002 8:06 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: DBA Experiences with Oracle and RAID 0+1 > > you have no idea how badly most of us now want to come to that class. > Not that I'd understand most of what was said, but just to listen :) > > > --- Mogens Nørgaard <[EMAIL PROTECTED]> wrote: > > Jared, > > > > Good thought! We're running our annual Miracle Master Class (this > > year > > with Jonathan Lewis) this week and Cary Millsap (and his gang), > > Jonathan > > and James will arrive tomorrow (Monday), while Steve Adams, Lex de > > Haan, > > Stephan Haisley and a bunch of other guys will arrive on Tuesday. > > I'll > > keep this message and throw it up for discussion on the Oak Table > > (see > > Cary's wonderful article on www.Undskyld.Org)... > > > > Jared Still wrote: > > > > >Mogens, > > > > > >In regard to the number of spindles issue: James Morle has some > > >excellent discussion on that in 'Scaling Oracle 8i'. ( I think > > it's that > > >book ) > > > > > >When some of the newer larges drives are used in a given > > configuration, > > >they mabe be able to outperform older drives in a similar > > configuration with > > >a larger number of spindles. > > > > > >I say 'older' since smaller drives usually aren't using the latest > > technology > > >and the newer ones have sufficiently higher throughput to match > the > > >capability of a larger number of drives in given configuration. > > > > > >Food for thought, anyway. > > > > > >Jared > > > > > > > > >On Sunday 20 January 2002 06:50, Mogens Nørgaard wrote: > > > > > >>Diego, > > >> > > >>I agree with you 100% and didn't express myself correctly in my > > email. > > >>The more spindles the better. What I meant to say was that you > must > > >>never buy disks by taking your total needed amount of space and > > divide > > >>by the number of big disks you can get hold on :). It's the > number > > of > > >>IO's required by the disk system that matters, not the size... > > >> > > >>Thanks for making this clear to everyone. > > >> > > >>Mogens > > >> > > >>Diego Cutrone wrote: > > >> > > >>>Mogens: > > >>> Just let me disagree with you at only one point. According to > > my > > >>>experience, I think that the size of the disks in an array does > > matter > > >>>sometimes. It's not the same to have 24 9GB disks that to have > > only 3 of > > >>>73GB. You have 24 spindles againts 3, the first option (in a > well > > >>>configured system of course) will give you better performance in > > >>>enviroments where you have a lot of concurrency and many users. > > >>> However I think that what I've written above might not be > > correct (may > > >>>be it should be tested) if the 73GB outstands for a long way the > > 9GB disks > > >>>in terms of seek time and transfer rate. > > >>> Take a look at an extract of Gaja's paper "Implementing RAID > on > > >>>Oracle": > > >>> > > >>>"5) Procure the smallest drive money can buy, keeping in mind > > scalability, > > >>>limits of the host > > >>>machine, the disk array and growth projections for the database. > > This is a > > >>>tough one these > > >>>days, with 18 GB drives considered as small drives. > > >>> > > >>>6) Bigger and faster drives are not always better than smaller > > slower > > >>>drives, as the seek times > > >>>for larger and faster drives with larger form factors, may b
Re: multiple extents are OK, dagnabbit!
Hi All, Actually, in extreme cases ( >87000 in my case, and I had 12 tables like that) it can cause problems with upgrading. Not sure what, but we had to do CTAS into new tables with much larger extents to do the upgrade from 8.1.5 to 8.1.6 here. Had Oracle support and consultants baffled also I still like to keep the number of extents below 500, but I'm paranoid :) Dave Rachel wrote: Snip > There really is NO reason to worry about large numbers of extents these > days. I mean, I wouldn't want to really test the "unlimited" ability > but other than that, there is no problem. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ftp command
Good point Kevin, maybe I should read the question more thorougly next time. Apologies Roland, I believe there is a flag to run non -interactive (-i) Cheers Lee -Original Message- Sent: 21 January 2002 16:15 To: Multiple recipients of list ORACLE-L I think he's asking about the turning the "prompt" off...try typing "prompt" before using the mget/mput commands. -Original Message- Sent: Monday, January 21, 2002 10:36 AM To: Multiple recipients of list ORACLE-L Is there a reason why you don't want to use the perfectly acceptable mput/mget utilities provided with ftp ?? -Original Message- Sent: 21 January 2002 14:55 To: Multiple recipients of list ORACLE-L Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying 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 computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Subset Tool?
The tool hasn't been used against an SAP system as yet. Dale and I were actually talking this through this afternoon (we've been out on site together today), and recognise the importance of having extraction sets (you may want to call them Knowledge Modules) already defined for people to download / plug-in and use. There is one problem with these huge "canned packages" - the referential integrity enforced, actually within the database, borders on poor to absolutely dire! When you are talking about an ERP system like SAP, that has tens of thousands of objects all without any RI enforced apart from within application logic, then setting up an actual extraction set could conceivably take some time. Now, this is not so bad when you have DataBee, as you only have to set the extraction rules up once, and from then on (or until you upgrade and the schema changes) that extraction set can simply be run as a "push button operation". The problem I personally foresee with an SAP system and DataBee is more user oriented. DataBee would have no problems setting up the extraction set, running through an extraction and then a load - even with the amount of tables that an SAP typically has (as Dale mentioned DataBee deals with this on a rule by rule basis, so the actual load on the tool is no different) - the main hurdle is setting up the rules. Without RI within the database, DataBee has no way of generating the bulk of the table -> table rules within the schema automatically, so these will have to be set up by hand. To then go on to do this, the user will have to have a good understanding of the tables within the SAP system, and their relationships with each other (unless the column naming conventions are the same, then you could use the "Column Finder" tool which is a part of DataBee that pattern matches column names). As I mentioned, this is something that we are currently looking in to, and Dale and I both see the benefits of having this somewhere for other users to take advantage of (why reinvent the wheel), but we need to find a user of SAP (or any of the other apps providers canned black boxes) that is willing to spend the time with us to take up the challenge (any takers? ;P). So the question has to be Jared - if it could cut a subset of an SAP system, would you buy it? -Original Message- Sent: 20 January 2002 21:15 To: Multiple recipients of list ORACLE-L Do you know if anyone has successfully used this tool on an SAP database? That would be *truly* impressive. Jared On Sunday 20 January 2002 10:55, Dale Edgar wrote: > Hi Jared > > > I've seen some pretty ugly schemas in Oracle, from third > > party apps in particular. > > > > It would be most interesting if an automated tool could > > subset these. > > They do get ugly don't they - however, I would be very suprised if DataBee > was not able to cut a subset. > > DataBee is quite simple in concept - at its most fundamental level it > processes a list of rules which tell it which tables need which supporting > rows from other tables. The schema complexity is largely an irrelevant > issue - DataBee takes things one rule at a time and says "I have this row > in this table therefore I need these rows from this table based on this > join condition). It is very fast and implicitly eliminates duplicates. It > is also interesting to note that table size is also not super important. > Sure the extract is slower on large databases, but the extract time scales > upwards with the size in a very well behaved manner. > > Give it a try if you want. There is a fully functional evaluation version > (with sample schema) available for download on the DataBee website. > http://www.DataBee.com > > > Thanks > Dale Edgar > Net 2000 Ltd. > [EMAIL PROTECTED] -- 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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also
Guru's advise needed.Partitioned IOT. Despaired
Dear listers, Could someone share his/her experience on partitioned IOT. I am quite confused now. I have an partitioned IOT. The performance of query data from one partiton of the partitioned IOT is worse than query data from the unpartitioned IOT. Any advice would be greatly appreciared. Shu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: shuli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Subset Tool?
Hi Jared > Do you know if anyone has successfully used this tool > on an SAP database? That would be *truly* impressive. No, there has not been a SAP implementation. There is no reason why DataBee could not do it though. We would be willing to work closely with someone (and provide a free copy of DataBee) who was willing to develop such a subset cut and would place the resulting extraction rules in the public domain for anyone to use. Thanks Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dale Edgar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: HP vs SUN for a UNIX box
These threads always crack me up. Its like religious wars. We've got both in house. Most of my stuff runs on the SUN boxes, and I have had no problems with the stability. I guess administration of the HPs is easier, but the Sun SAs aren't complaining so its pretty much a non-issue for us. As far as cost, HP wasn't competitive, Sun was much cheaper. Due to the cost difference we probably wouldn't be buying any more HPs, except when a certain product is only certified on HP or when the purchase decision is made by an HP-centric manager. Jim -Original Message- Sent: Monday, January 21, 2002 10:00 AM To: Multiple recipients of list ORACLE-L I heard that they already did. Something about Sun not being stable. -Original Message- Sent: Sunday, January 20, 2002 9:55 PM To: Multiple recipients of list ORACLE-L Oracle Magazine have alot "Oracle for HP" articles, I think they are switching from Sun to HP -Original Message- [EMAIL PROTECTED] Sent: 19 January 2002 06:16 To: Multiple recipients of list ORACLE-L Sergey, I asked my SA to add his 2 cents, guess he's not inclined. Anyway, I've been on HP for the last 10 years, coming from VMS, & I love it. VERY stable, easy to use, although I don't do the admin any longer it was easy with SAM even when it was a character based tool. Rman/OmniBack integration is well documented in the OmniBack manuals & works as advertised. HP support is pretty darn good as well, especially in the middle of the night when the system won't boot. I've had HP support tech's remotely logged in to the system helping get it back online. Also if you have a problem that is not in the area of the tech you call they normally conference in the needed assistance. Problems can be resolved as fast as they occur. We also don't use disk arrays from HP, but then HP & EMC really like each other. If you want an inexpensive disk alternative look into NetAppliance. Dick Goulet Senior Oracle DBA Reply Separator Author: "Babich ; Sergey" <[EMAIL PROTECTED]> Date: 1/18/2002 1:25 PM Thank you, Paul, I'll forward it to my boss... Anyone else to add to it? Thank you very much, Sergey Babich -Original Message- Sent: Friday, January 18, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Stay with HP. It's a hell of a lot more reliable, and does not require anywhere near the # of patches, and its patches work far more often that Sun's. I've done 5 years with each, and there's no question that HP is superior. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Our shop is switching from HP to Sun. No one can tell me why. There must be a cost savings somewhere. -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Database link and inline view (permissions problem?)
I am terrible with database links. We are having a problem with a link from a 9.0.1 database to an 8.0.4 database. Following is the problem: (Embedded image moved to file: pic16827.pcx) Full Description:I am trying to run a SQL query with an inline view (see below) in EDWDEV01 using a link to DWDEV01 to access the ACCT_PAY_TYPE table. If I run the query in EDWDEV01 I get "no rows selected". If I move the query to DWDEV01 and remove the conneciton descriptions, I get 10 rows selected. Is this permissions, database versions, or what? Any suggestions, ideas? SELECT apt.acct_no, apt.pay_seq_no, apt.src_chng_batch_win_dt_key wh_date_key, 0 wh_time_key, apt.data_whse_mod_dt_tmwh_mod_dt_tm, DECODE(apt.src_chng_batch_win_dt_key, subq.maxkey,'C','H') wh_row_sts, apt.data_src_mod_dt_tm wh_row_eff_dt_tm, apt.data_src_mod_dt_tm upd_dt_tm, apt.acct_pay_desc, apt.status FROM acct_pay_type@whse_dbo_dwdev01 apt, (SELECT acct_no, data_sts, pay_seq_no, eff_dt_x, MAX(src_chng_batch_win_dt_key) maxkey FROM acct_pay_type@whse_dbo_dwdev01 GROUP BY acct_no, data_sts, pay_seq_no, eff_dt_x) subq WHERE apt.acct_no = subq.acct_no AND apt.data_sts = subq.data_sts AND apt.pay_seq_no = subq.pay_seq_no AND apt.eff_dt_x = subq.eff_dt_x ORDER BY 1, 2, 3 DESC; Following is the link information: SQL> select * from dba_db_links; OWNER DB_LINK USERNAME HOST CREATED -- --- -- -- -- PUBLIC WHSE_DBO_DWDEV0 WHSE_DBO DWDEV0121-JAN-02 1.GELCO.COM If I do a select * from acct_pay_type@whse_dbo_dwdev01 from within the remote database (not DWDEV01), I get ten rows returned. If I run this sql from the remote database, (not DWDEV01), I get no rows returned. If I run the SQL from DWDEV01 with the @whse_dbo_dwdev01 removed, I get 10 rows returned. What is my problem? Seems like I'm missing permissions somewhere or something like that. Any help is appreciated. Cherie Machler Oracle DBA Gelco Information Network pic16827.pcx Description: Binary data
RE: New user having problem using dbassist
Rene, Following on from below (can you explain more - such as any errors received) you may want to also look at upgrading your box. For a start your processor may have a little work to do with Oracle as it's only a 233, but you should first look at the memory available. I believe that Oracle recommends a minimum of 256Mb RAM with version 8>, so you may also be lacking a little on that side, depending on what you have your SGA areas set to. Is SO Mandrake a supported flavour of LINUX? Just a couple of extras to think about while we wait for more info.. Regards Mark -Original Message- Sent: 20 January 2002 09:45 To: Multiple recipients of list ORACLE-L Hello Rene Can you explain more? What exactly happened, what errors you get etc. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: MightDuck [SMTP:[EMAIL PROTECTED]] > Sent: Fri, January 18, 2002 5:20 PM > To: Multiple recipients of list ORACLE-L > Subject: New user having problem using dbassist > > I´m a brand new user in both Linux and Oracle, so far it's been a good > experience in learning both. At the moment I'm stucked up trying to create > an instance database... Had some problems installing Oracle, but it is > minor headache comparing to create a database!!! If someone could help > I ran dbassist and tried to let it create the database itself, did not > work. Next I´ve tried to create a script and execute it but nothing > happen!!! What should I do? > > My current system is MMX-233 128Mb Ram 8Gb SCSI > SO Mandrake 8.0 > Oracle 8.1.7 > > Thanks. > Rene > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =so-8859-8?Q?àãø_éçéàì? INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 8.1.7 install failure on Compaq Tru64
We are trying to install Oracle 8.1.7 on Compaq Tru64 with 0.S. 4.0F with the latest patch kit, and the EV5.6 chip set. The install just bombs off at 56% complete. No error messages, log messages, or trace files (hasn't gotten far enough to create ORACLE_HOME). The install works fine on another machine with the EV6 chip set. Compaq and Oracle say that EV5.6 should be acceptable, and haven't provided much in the way of resolution. If you are curious which chip set you have, enter the command "/usr/sbin/psrinfo -v". Any information on this would be helpful. Thank you. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Oracle select data problem...
Hi Willie, Maybe your dateformat isn't correct. You should check the NLS Parameters. regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Townsend Willie [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 21. Januar 2002 16:15 An: Multiple recipients of list ORACLE-L Betreff: Oracle select data problem... Oracle Gurus, I have a perplexing problemI recently installed Oracle 8.1.7.0 (64 bit) on an HP 11.X (64 bit) machine running a HRMS/PAyroll type application. I am having a problem with the below sql statement not returning any rows. When I look at the data, a row should be returned. Any ideas or solutions to this problem? Also, when I execute the subselect as a standalone SQL, a row of data is returned. SELECT SETID, EFFDT FROM PSTREEDEFN D WHERE D.EFF_STATUS = 'A' AND D.TREE_NAME = 'DEPT_SECURITY' AND D.EFFDT = (SELECT MAX(D1.EFFDT) FROM PSTREEDEFN D1 WHERE D1.SETID = D.SETID AND D1.TREE_NAME = D.TREE_NAME AND D1.EFFDT <= '01-JAN-2002'); Willie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Townsend Willie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dropped datafile problem
You have gone about a totally wrong way of dropping the datafile. To drop a datafile from a tablespace, u have to export the tablespace by taking a series of user exports in that tablespace, dropping the tablespace, deleting the datafile at the OS level, recreating the tablespace with the proper datafiles and importing back the contents of the tablespace. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 21 January 2002 14:40 To: Multiple recipients of list ORACLE-L Dear gurus ! I have an "offline dropped" datafile at my database. The file was physically deleted at the OS level after "offline drop". Before dropping the file , all the objects that had extents allocated in that file (from dba_extents) were dropped. Now , V$datafile shows this file as of size=0 and status = 'RECOVER' which is fine. BUT , file$ show this file as of size 8GB, which is the file size as it used to be before being dropped. Moreover , fet$ shows 8GB as free extents residing at this file . And , after all , tables get created in that file , i.e. dba_extents show extents with FILE_ID of that file ! When a select statement tries to access a table with extents residing in that file , i get an error message , off course. So , the question is , how do i make the file's extents disappear from fet$ ? Thanks a lot. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBA Experiences with Oracle and RAID 0+1
Oracle OpenWorld in the Americas will never leave the West Coast and is highly unlikely to leave San Francisco. Too convenient to Headquarters If Miracle gave that class in Halifax, I'd go! --- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > May I suggest Halifax, Canada as a great location for this course??? > > StilL waiting for Oracle OpenWorld to come here, somehow they never > do. > > : ) > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, January 21, 2002 8:06 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: DBA Experiences with Oracle and RAID 0+1 > > you have no idea how badly most of us now want to come to that class. > Not that I'd understand most of what was said, but just to listen :) > > > --- Mogens Nørgaard <[EMAIL PROTECTED]> wrote: > > Jared, > > > > Good thought! We're running our annual Miracle Master Class (this > > year > > with Jonathan Lewis) this week and Cary Millsap (and his gang), > > Jonathan > > and James will arrive tomorrow (Monday), while Steve Adams, Lex de > > Haan, > > Stephan Haisley and a bunch of other guys will arrive on Tuesday. > > I'll > > keep this message and throw it up for discussion on the Oak Table > > (see > > Cary's wonderful article on www.Undskyld.Org)... > > > > Jared Still wrote: > > > > >Mogens, > > > > > >In regard to the number of spindles issue: James Morle has some > > >excellent discussion on that in 'Scaling Oracle 8i'. ( I think > > it's that > > >book ) > > > > > >When some of the newer larges drives are used in a given > > configuration, > > >they mabe be able to outperform older drives in a similar > > configuration with > > >a larger number of spindles. > > > > > >I say 'older' since smaller drives usually aren't using the latest > > technology > > >and the newer ones have sufficiently higher throughput to match > the > > >capability of a larger number of drives in given configuration. > > > > > >Food for thought, anyway. > > > > > >Jared > > > > > > > > >On Sunday 20 January 2002 06:50, Mogens Nørgaard wrote: > > > > > >>Diego, > > >> > > >>I agree with you 100% and didn't express myself correctly in my > > email. > > >>The more spindles the better. What I meant to say was that you > must > > >>never buy disks by taking your total needed amount of space and > > divide > > >>by the number of big disks you can get hold on :). It's the > number > > of > > >>IO's required by the disk system that matters, not the size... > > >> > > >>Thanks for making this clear to everyone. > > >> > > >>Mogens > > >> > > >>Diego Cutrone wrote: > > >> > > >>>Mogens: > > >>> Just let me disagree with you at only one point. According to > > my > > >>>experience, I think that the size of the disks in an array does > > matter > > >>>sometimes. It's not the same to have 24 9GB disks that to have > > only 3 of > > >>>73GB. You have 24 spindles againts 3, the first option (in a > well > > >>>configured system of course) will give you better performance in > > >>>enviroments where you have a lot of concurrency and many users. > > >>> However I think that what I've written above might not be > > correct (may > > >>>be it should be tested) if the 73GB outstands for a long way the > > 9GB disks > > >>>in terms of seek time and transfer rate. > > >>> Take a look at an extract of Gaja's paper "Implementing RAID > on > > >>>Oracle": > > >>> > > >>>"5) Procure the smallest drive money can buy, keeping in mind > > scalability, > > >>>limits of the host > > >>>machine, the disk array and growth projections for the database. > > This is a > > >>>tough one these > > >>>days, with 18 GB drives considered as small drives. > > >>> > > >>>6) Bigger and faster drives are not always better than smaller > > slower > > >>>drives, as the seek times > > >>>for larger and faster drives with larger form factors, may be > more > > than > > >>>their smaller and > > >>>slower counterparts. This is not that big of an issue, if your > > drives > > >>>support a built-in track > > >>>buffer cache for storing an entire track's worth of data from > read > > >>>request(s)." > > >>> > > >>> > > >>>HTH > > >>>Greeting > > >>>Diego Cutrone > > >>> > > >>>- Original Message - > > >>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >>>Sent: Tuesday, January 15, 2002 10:25 PM > > >>> > > Jon, > > > > It's one of those "how many bags will I need in the > supermarket?" > > questions - it depends. > > > > Consider: > > > > - RAID 1+0 is much better than 0+1. > > - Three disks is not much w.r.t. IO capability. If you have > three > > concurrent users you'll be OK :
Re:Backend Architecture in 3 tier environment
Sundeep, The biggest problems you'll have is 1) GETTING THE DEVELOPERS TO AGREE, and 2) your having to write all those procedures. In general I prefer a mixed bag approach. If all their trying to do is select, insert, update or delete a single row in a simple statement, then who cares. But on the other hand if it requires a lot of database interaction to get to the end game then the procedure is much faster. You also have the luxury that the code gets loaded into the SGA and remains with maximum reuse, versus those one time only statements so many developers are found of. One other benefit, if more than one developer/application needs the same service, you get to write it once and reuse it. Which also means you get to modify it once and everybody is upgraded. Also you get to break it once & everybody is broken. One problem I've found is that packages can have problems if a number of processes attempt to execute the same package at the same time. This normally exhibits itself as a lock time-out error, so beware. In my application the judicious use of the DBMS_LOCK package has prevented this. Dick Goulet Reply Separator Author: sundeep maini <[EMAIL PROTECTED]> Date: 1/21/2002 7:05 AM In our current environment most database interaction is via DMLs issued from client or middle tier via embeded SQL calls. Is it always a good idea to go stored procedure (packages) route? In my opinion going with stored procedure route isolates DB design from the upper tiers (creates an API via stored procedure signatures making most DB changes transparent to client least the signature is changed). It also offers the advantage of pre-compiled, pre-tuned logic vs the JAVA/Client coders embedding SQLs of their choice whereever they want. It is also possible to use more Database facilities or features than palin SQL alone would accord. Finally, I can reverse engineer them into Designer/ERWin which allows me to know impact of cahnges on the DB. However, in many cases of small SQLs issued directly from Java the PL/SQL route may have overheads. Also, the OO programmers who are usually responsible for the app design have little experince designing DB structures much less concerened about DB tuning which makes it difficult to get a good seperation between data service layer and other layers. Can I ask the group to share their experience and/or opinion? Are there potential downsides to stored procedures route? TIA Sundeep = Sundeep Maini Consultant Currently on Assignement at Marshfield Clinic WI [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sundeep maini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ftp command
you enter the command prompt, to flip the switch, then mget *, or mget *, or *. For UNIX, using SmartTerm, I use the ftp drag & drop tool. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 9:55 AM To: Multiple recipients of list ORACLE-L Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- 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: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ftp command
This is very easy, the only one that you have tu put with the ftp session open is: ftp > prompt You will see a message : Interactive mode off. after that you write the mget or mput *.* and thats all. [EMAIL PROTECTED] wrote: > Hallo, > > anyone whom can tell me how to write the ftp command if I want to receive all files >in the unix directory to the hard drive without to need reply yes for each file. > using the command mget I suppose but ar ethere any options I might use. The same >question if i want to copy files from harddrive to the unix library, using th >ecommand mput > > Thanks in advance > > Roland S > > -- > 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). begin:vcard n:Argueta;Miguel Angel Mejía Argueta tel;work:Telcel 56253700 Ext. 1721 x-mozilla-html:FALSE org:TELCEL;Aseguramiento de Ingresos version:2.1 email;internet:[EMAIL PROTECTED] title:AUDITOR adr;quoted-printable:;;Ejercito Nacional 488=0D=0ACol. Polanco;México;D.F.;;Mexico x-mozilla-cpt:;-19616 fn:Miguel Angel Mejía Argueta end:vcard
Re: dropped datafile problem
did you drop the tablespace as well? --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > Dear gurus ! > > I have an "offline dropped" datafile at my database. The file was > physically > deleted at the OS level after "offline drop". > Before dropping the file , all the objects that had extents allocated > in > that file (from dba_extents) were dropped. > Now , V$datafile shows this file as of size=0 and status = 'RECOVER' > which > is fine. > BUT , file$ show this file as of size 8GB, which is the file size as > it used > to be before being dropped. > Moreover , fet$ shows 8GB as free extents residing at this file . > And , after all , tables get created in that file , i.e. dba_extents > show > extents with FILE_ID of that file ! > When a select statement tries to access a table with extents residing > in > that file , i get an error message , off course. > > So , the question is , how do i make the file's extents disappear > from fet$ > ? > Thanks a lot. > > Andrey. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrey Bronfin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to calculate user load on the system
Hello all, My 2 cents' worth: Far too much time is spent by a number of users in the Oracle List sending e-mail of no worth whatsoever. Half the msgs I read are what charitably might be called 'chat'. I understand that there is an off-line site for 'chat' - why not use it and stop mucking up the e-mail waves with crap. Even a small drop in aimless e-mails would be appreciated; 90%+ directed, professional queries and replies would be wonderful. Please do not reply to this e-mail; this is my one-time attempt to bring about a positive change. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 10:36 AM To: Multiple recipients of list ORACLE-L Love is all you need. --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > or, of course, the answer to life, the universe and everything is? > > --- Jared Still <[EMAIL PROTECTED]> wrote: > > > > If the question is "Which episode of Star Trek was 'The Trouble > with > > Tribbles'", then yes. ;) > > > > Jared > > > > On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: > > > Yep. And we also found logoff-triggers in 8i to be useful for the > > same > > > (and additional) purposes. > > > > > > But if I had to guess, I'm sure the answer would be 42 :-). > > > > > > Mogens > > > > > > [EMAIL PROTECTED] wrote: > > > >Raj, > > > >Maybe another option would be to "audit session" for the > database. > > For > > > >each logon/logoff you would see the logical/physical reads and > > the > > > > logical writes ( in dba_audit_session) by Oracle username (or > > > > osusername). Chaim > > > > > > > > > > > > > > > > > > > >"Aponte, Tony" <[EMAIL PROTECTED]>@fatcity.com on 01/16/2002 > > 06:15:24 PM > > > > > > > >Please respond to [EMAIL PROTECTED] > > > > > > > >Sent by:[EMAIL PROTECTED] > > > > > > > > > > > >To:Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > > >cc: > > > > > > > > > > > > > > > > > > > >Then you're in luck. I'd recommend starting with Oracle > Response > > Time > > > >Analysis from www.orapub.com. Although it won't give you > exactly > > what > > > > you need, it will help you get to the next step. Once you > > understand a > > > > session's response time components, it's a short hop to > figuring > > out the > > > > V$SESSTAT statistics that make up the CPU time, > physical/logical > > I/O > > > > operations and memory footprint. > > > > > > > >HTH > > > >Tony > > > >-Original Message- > > > >Sent: Wednesday, January 16, 2002 5:54 PM > > > >To: Aponte, Tony; [EMAIL PROTECTED] > > > > > > > > > > > >Database Load ... is the main target at this time ... > > > > > > > >Thanks Tony, > > > > > > > >Raj > > > >__ > > > > > > > >Rajendra Jamadagni MIS, ESPN Inc. > > > > > > > >Rajendra dot Jamadagni at ESPN dot com > > > > > > > >Any opinion expressed here is personal and doesn't reflect that > > of ESPN > > > >Inc. > > > > > > > >QOTD: Any clod can have facts, but having an opinion is an > art! > > > >-Original Message- > > > >Sent: Wednesday, January 16, 2002 5:53 PM > > > >To: [EMAIL PROTECTED] > > > >Cc: [EMAIL PROTECTED] > > > > > > > > > > > > > > > >Raj, sorry for me being confused. Are you trying to measure > what > > the > > > >application executable is doing outside the database (i.e.. > host > > system > > > >load) or the activity inside the database (i.e.. per > > user/program/module > > > >DB stats)? > > > > > > > >Tony > > -- > > 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). > > > __ > Do You Yahoo!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: U
RE: Ftp command
In NT there is a -i switch for ftp that will get rid of the prompts. Don't know if its available in unix. -Original Message- Sent: Monday, January 21, 2002 9:55 AM To: Multiple recipients of list ORACLE-L Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- 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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ftp command
when you connnect through ftp i always use ftp -inv servername that stop you from having to enter Y after each file -Original Message- Sent: Monday, January 21, 2002 9:55 AM To: Multiple recipients of list ORACLE-L Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- 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: david hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: max_io_size
Maybe it's because the SSTIOMAX constant. On 7.3 that value was 128k. From 8.0.5 has been raised to 1m. Regards. --- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > Ok, I successfully ran it against another database > on the same server. > > The maximum effective db_file_multiblock_read_count > for my setup is 25. > > Ironically, I had set it to 26... > > Thanks everyone! > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > > -Original Message- > Sent: Friday, January 18, 2002 6:36 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: max_io_size > > Patrice, > > You can determine this for yourself with a script: > > http://www.ixora.com.au/scripts/io_opt.htm > > The script is at the bottom of the page. > > It's a pretty simple test, you can easily do it > manually as well. > > Jared > > > > > > "Boivin, Patrice J" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 01/18/02 11:56 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:max_io_size > > > Where can I find information on this parameter on > the Tru64 UNIX platform? > > I did a scan of the manuals for Tru64 UNIX at > docs.oracle.com, but didn't > find mention of it anywhere. > > I want to set db_file_multiblock_read_count > properly... > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des > systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de > l'informatique > Maritimes Region, DFO | Région des Maritimes, > MPO > > E-Mail: [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > > -- > 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: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 select data problem...
I think that the last line is the problem and that you have to change it to
AND D1.EFFDT <= TO_DATE('01-JAN-2002', 'DD-MON-'));
I think that he is converting D1.EFFDT to char-format instead of converting
'01-JAN-2002' to date-format.
Best regards,
Marco
-Oorspronkelijk bericht-
Van: Townsend Willie [mailto:[EMAIL PROTECTED]]
Verzonden: maandag 21 januari 2002 16:15
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Oracle select data problem...
Oracle Gurus,
I have a perplexing problemI recently installed Oracle 8.1.7.0 (64 bit)
on an HP 11.X (64 bit) machine running a HRMS/PAyroll type application. I
am having a problem with the below sql statement not returning any rows.
When I look at the data, a row should be returned. Any ideas or solutions
to this problem? Also, when I execute the subselect as a standalone SQL, a
row of data is returned.
SELECT SETID,
EFFDT
FROM PSTREEDEFN D
WHERE D.EFF_STATUS = 'A'
AND D.TREE_NAME = 'DEPT_SECURITY'
AND D.EFFDT = (SELECT MAX(D1.EFFDT)
FROM PSTREEDEFN D1
WHERE D1.SETID = D.SETID
AND D1.TREE_NAME = D.TREE_NAME
AND D1.EFFDT <= '01-JAN-2002');
Willie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Townsend Willie
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Rooy van, Marco
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Ftp command
I think he's asking about the turning the "prompt" off...try typing "prompt" before using the mget/mput commands. -Original Message- Sent: Monday, January 21, 2002 10:36 AM To: Multiple recipients of list ORACLE-L Is there a reason why you don't want to use the perfectly acceptable mput/mget utilities provided with ftp ?? -Original Message- Sent: 21 January 2002 14:55 To: Multiple recipients of list ORACLE-L Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying 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 computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Oracle select data problem...
AH YES, PeopleSoft Security Trees, much fun!! I believe you may be getting a row returned, but that row is a blank. Try SELECT nvl(rtrim(SETID),'*'), EFFDT FROM PSTREEDEFN D WHERE D.EFF_STATUS = 'A' AND D.TREE_NAME = 'DEPT_SECURITY' AND D.EFFDT = (SELECT MAX(D1.EFFDT) FROM PSTREEDEFN D1 WHERE D1.SETID = D.SETID AND D1.TREE_NAME = D.TREE_NAME AND D1.EFFDT <= '01-JAN-2002'); To verify. DickG. Reply Separator Author: Townsend Willie <[EMAIL PROTECTED]> Date: 1/21/2002 7:15 AM Oracle Gurus, I have a perplexing problemI recently installed Oracle 8.1.7.0 (64 bit) on an HP 11.X (64 bit) machine running a HRMS/PAyroll type application. I am having a problem with the below sql statement not returning any rows. When I look at the data, a row should be returned. Any ideas or solutions to this problem? Also, when I execute the subselect as a standalone SQL, a row of data is returned. SELECT SETID, EFFDT FROM PSTREEDEFN D WHERE D.EFF_STATUS = 'A' AND D.TREE_NAME = 'DEPT_SECURITY' AND D.EFFDT = (SELECT MAX(D1.EFFDT) FROM PSTREEDEFN D1 WHERE D1.SETID = D.SETID AND D1.TREE_NAME = D.TREE_NAME AND D1.EFFDT <= '01-JAN-2002'); Willie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Townsend Willie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ftp command
Try to enter the ftp command named prompt, with that, you can toggle asking on and off. HTH Andreas > -- > Von: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] > Gesendet: Montag, 21. Januar 2002 15:55 > An: Multiple recipients of list ORACLE-L > Betreff: Ftp command > > Hallo, > > anyone whom can tell me how to write the ftp command if I want to receive > all files in the unix directory to the hard drive without to need reply > yes for each file. > using the command mget I suppose but ar ethere any options I might use. > The same question if i want to copy files from harddrive to the unix > library, using th ecommand mput > > Thanks in advance > > > Roland S > > -- > 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: Haunschmidt Andreas VASL.FAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Server mode
Not yet, I will do it immediately. Thank you. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, January 21, 2002 4:40 PM > Bunyamin, > > ...your second question: > > If you have 8GB of RAM, I assume you are using Windows 2000 *Advanced* > Server. Windows 2000 (Plain Old) Server does not support Micros**t's > implementation of the Intel Extended Server Memory Architecture (ESMA), > which allows Oracle to access more than 4GB of RAM. However, Win2k Advanced > Server must be configured correctly. Have you done that? > > See the chapter "Tuning Windows NT to Optimize Oracle8i" in "Oracle8i > Administrator's Guide for Windows NT". Oracle refers to Windows NT Server, > Enterprise Edition, which translates to Windows 2000 Advanced Server, as > being required for >4GB RAM. > > If you don't configure properly, Oracle can only use 2GB of RAM. > > Jack > > > Jack C. Applewhite > Database Administrator/Developer > OCP Oracle8 DBA > iNetProfit, Inc. > Austin, Texas > www.iNetProfit.com > [EMAIL PROTECTED] > (512)327-9068 > > -Original Message- > Karadeniz > Sent: Saturday, January 19, 2002 7:55 AM > To: Multiple recipients of list ORACLE-L > > > My first question is , I need a database where 1000 clients will work .Which > is better ? > Dedicated Server Mode or Shared Server Mode ? > RAM : 8 GB > CPU : 8 * 1000 MHZ > WIN 2K > > My second question is , I can not select more then 600 mb of RAM to be the > buffer cache . How can I solve this? > > Thank you . > Bunyamin > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jack C. Applewhite > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to calculate user load on the system
Love is all you need. --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > or, of course, the answer to life, the universe and everything is? > > --- Jared Still <[EMAIL PROTECTED]> wrote: > > > > If the question is "Which episode of Star Trek was 'The Trouble > with > > Tribbles'", then yes. ;) > > > > Jared > > > > On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: > > > Yep. And we also found logoff-triggers in 8i to be useful for the > > same > > > (and additional) purposes. > > > > > > But if I had to guess, I'm sure the answer would be 42 :-). > > > > > > Mogens > > > > > > [EMAIL PROTECTED] wrote: > > > >Raj, > > > >Maybe another option would be to "audit session" for the > database. > > For > > > >each logon/logoff you would see the logical/physical reads and > > the > > > > logical writes ( in dba_audit_session) by Oracle username (or > > > > osusername). Chaim > > > > > > > > > > > > > > > > > > > >"Aponte, Tony" <[EMAIL PROTECTED]>@fatcity.com on 01/16/2002 > > 06:15:24 PM > > > > > > > >Please respond to [EMAIL PROTECTED] > > > > > > > >Sent by:[EMAIL PROTECTED] > > > > > > > > > > > >To:Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > > >cc: > > > > > > > > > > > > > > > > > > > >Then you're in luck. I'd recommend starting with Oracle > Response > > Time > > > >Analysis from www.orapub.com. Although it won't give you > exactly > > what > > > > you need, it will help you get to the next step. Once you > > understand a > > > > session's response time components, it's a short hop to > figuring > > out the > > > > V$SESSTAT statistics that make up the CPU time, > physical/logical > > I/O > > > > operations and memory footprint. > > > > > > > >HTH > > > >Tony > > > >-Original Message- > > > >Sent: Wednesday, January 16, 2002 5:54 PM > > > >To: Aponte, Tony; [EMAIL PROTECTED] > > > > > > > > > > > >Database Load ... is the main target at this time ... > > > > > > > >Thanks Tony, > > > > > > > >Raj > > > >__ > > > > > > > >Rajendra Jamadagni MIS, ESPN Inc. > > > > > > > >Rajendra dot Jamadagni at ESPN dot com > > > > > > > >Any opinion expressed here is personal and doesn't reflect that > > of ESPN > > > >Inc. > > > > > > > >QOTD: Any clod can have facts, but having an opinion is an > art! > > > >-Original Message- > > > >Sent: Wednesday, January 16, 2002 5:53 PM > > > >To: [EMAIL PROTECTED] > > > >Cc: [EMAIL PROTECTED] > > > > > > > > > > > > > > > >Raj, sorry for me being confused. Are you trying to measure > what > > the > > > >application executable is doing outside the database (i.e.. > host > > system > > > >load) or the activity inside the database (i.e.. per > > user/program/module > > > >DB stats)? > > > > > > > >Tony > > -- > > 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). > > > __ > Do You Yahoo!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
Re: Ftp command
Hi, use the "-i"flag. This turns off interactive mode I believe you can also use the command "prompt" at the ftp prompt Jack [EMAIL PROTECTED]@fatcity.com on 21-01-2002 15:55:22 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- 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). === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- 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: Ftp command
At the ftp prompt, type the wordpromptin the following way : ftp> prompt Hope this helps, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 21 January 2002 14:55 To: Multiple recipients of list ORACLE-L Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL*Backtrack, semaphores, and 7264's
Has anyone seen anything similar to the following: After Installing SQL*Backtrack on a Solaris 2.6 box, one of the databases on that box started coming down with 7264 errors a couple of times a week. This is an 8.0.5.2.1 database and it is not the database being accessed by SQL*Backtrack. In an effort to debug, we issued an ipcs command prior to and after executing an export via sql*backtrack. After the export of database A, the semaphore set for database B was gone, and it came tumbling down with the 7264 error Mon Jan 21 04:05:52 2002 DBW0: terminating instance due to error 7264 07264, 0, "spwat: semop error, unable to decrement semaphore." // *Cause: Semop system call returned an error. Semaphore set may not exist. // *Action: Check errno. Semaphore ID is returned in sercose[0]. Verify // semaphore set exists. A possible cause for this error is that a // "shutdown abort" was done while this process was running. we ran the export at 4:00 and it finished at 4:01 cobra:/var/adm/sa> sar -m -f sa21 SunOS cobra 5.6 Generic_105181-29 sun4u01/21/02 00:00:01 msg/s sema/s 03:00:010.00 10.20 03:15:000.00 13.46 03:30:000.00 10.05 03:45:000.00 10.05 04:00:000.00 10.03 04:15:000.00 16116.36 04:30:000.009.94 04:45:010.00 69.34 05:00:000.00 14.37 05:15:000.009.97 05:30:000.009.97 05:45:010.009.97 Thanks Kurt Wiegand -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wiegand, Kurt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ftp command
Hi, Here is a script that will do what you want. Just fill in the appropriate values for the first 5 environment variables and it should send all your files to the appropriate place without you having to be prompted for each file. DEST=machine LOGIN=yourid PASSWD=yourpasswd FROMDIR=fromdir TODIR=todir FILES=* export DEST LOGIN PASSWD FROMDIR TODIR FILES ftp -v -n -i $DEST
How to find out free space below High Water Mark in table
Title: How to find out free space below High Water Mark in table Hi! I deleted several thousand rows from a table, but it looks like the table is still taking up the same amount of space in the tablespace. Which it indeed does, because delete does not reset the HWM. Does anybody out there have a script that gives me the free space in a table below the high water mark? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: Ftp command
Is there a reason why you don't want to use the perfectly acceptable mput/mget utilities provided with ftp ?? -Original Message- Sent: 21 January 2002 14:55 To: Multiple recipients of list ORACLE-L Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying 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 computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
