Re: Currval and buffer gets
Hello Gaja
I checked the report from YAPP and library cache load lock accounts
only to 0.75% of the wait time. 28 seconds during 6100 seconds between
snaps.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, April 24, 2002 5:03 PM
> All,
>
> I think the issue of using SYS.DUAL vs. X$DUAL is much
> beyond just "response time". It is more related to
> "easing a potential bottleneck" in your database, in a
> production environment supporting multiple sessions.
> Given that it takes 5 LIOs (upto Oracle8i) and 3 LIOs
> (in Oracle9i for every access to SYS.DUAL, the issue
> then boils down to the contention for the "cache
> buffers chains" latch to access blocks in the database
> buffer cache. So just because it is only 5(3) LIOs,
> that does not make it OK.
>
> If your application is using SYS.DUAL "like there is
> no tomorrow", the cache buffers chains latch becomes
> your single point of contention. This is true, even if
> you have _DB_BLOCK_HASH_BUCKETS set to a value higher
> than its default.
>
> As Cary has mentioned many times before, the problem
> here is "application serialization". For more on this
> subject, please read Cary's papers "Why a 99%+ buffer
> cache hit ratio is NOT Ok" on
> http://www.hotsos.com/catalog and a recent paper at
> IOUG-A Live 2002 which talks about some common
> "Misunderstandings about Oracle Internals".
>
> Best regards,
>
> Gaja
>
>
> --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:
> > Kevin and Jonathan,
> >
> > Thanks for the explanation. It's weird for me that
> > Oracle is still
> > maintaining this kind of dependency between the SQL
> > and PL/SQL engines for
> > minor sql functions. Also regarding the dual and
> > x$dual, it does not sound
> > good to me that Oracle still is implementing dual as
> > a table segment even in
> > Oracle 9i.
> >
> > I would give Gaja all the excuses to recommend using
> > something else other
> > than sys.dual to overcome this limitation.
> >
> > But on the other hand the difference in performance
> > and the over all gain is
> > too minor to use x$dual (look at the test below).
> >
> > Modifying the code and changing the design (or even
> > tuning one sql) would be
> > more promising.
> >
> > Thanks everybody,
> >
> >
> > Waleed
> >
> >
> > declare
> > nn number;
> > ss1 date;
> > ss2 date;
> > begin
> > ss1 := sysdate;
> > for i in 1..10 loop
> > select 2 into nn from sys.x_$dual;
> > end loop;
> > ss2 := sysdate;
> > dbms_output.put_line('run time using view x_$dual in
> > centiseconds='||(ss2 -
> > ss1 ) * 24 * 60 * 60 * 100);
> >
> > ---
> > ss1 := sysdate;
> > for i in 1..10 loop
> > select 2 into nn from dual;
> > end loop;
> > ss2 := sysdate;
> > dbms_output.put_line('run time using table dual in
> > centiseconds='||(ss2 -
> > ss1 ) * 24 * 60 * 60 * 100);
> > end;
> >
> > -Original Message-
> > Sent: Tuesday, April 23, 2002 6:18 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > It's a change that also made it into 8.1.7.3
> > (or possibly 8.1.7.2) - check in
> >
> > $ORACLE_HOME/rdbms/admin/standard.sql
> >
> >
> > Jonathan Lewis
> > http://www.jlcomp.demon.co.uk
> >
> > Author of:
> > Practical Oracle 8i: Building Efficient Databases
> >
> > Next Seminar - Australia - July/August
> > http://www.jlcomp.demon.co.uk/seminar.html
> >
> > Host to The Co-Operative Oracle Users' FAQ
> > http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> >
> >
> >
> > -Original Message-
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > Date: 23 April 2002 22:05
> >
> >
> > |I did in 8i (8.1.7.3) and did not see what you
> > said:
> > |
> > |alter session set sql_trace = true
> > |
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Jonathan Lewis
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>
> &g
Re: TOAD schema browser
Hello What version of toad are you using. I downloaded version 7.2 a few days ago. Connected as sys, activated schema browser and got all sys tables in the list. I also got all the users in the drop list to select user. Yechiel Adar Mehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 24, 2002 3:03 PM Subject: Re: TOAD schema browser It doesn't work as it shows no items in the list box ..I face the same problem.Thanks and RegardsAmit Nagar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/24/02 04:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: TOAD schema browserHello, You should change the schema name from the list box, which is just under the toolbar. Regards M.Emre HANCIOGLUMasterfoods Services GmbHISI Application SupportTel : +49 2162 500-576Fax: +49 2162 41497E-Mail: [EMAIL PROTECTED] Sergey V Dolgov <[EMAIL PROTECTED]> pptus.oilnet.ru Sent by: [EMAIL PROTECTED] 24.04.02 11:58 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: TOAD schema browser Hello ORACLE-L, I'm connecting to oracle using TOAD under sys account - all workswell. I can select from sys' tables and views,but when I start schema browser it shows schema for another user(not sys).Is it TOAD bug? How to fix the problem?--Best regards,Sergey mailto:[EMAIL PROTECTED]--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Sergey V DolgovINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: 9i new features, the saga continues?
Well, sitting here at 11:00 PM on Saturday night building replication for 8.1.6 DB and having a nice time catching up on the postings, I am very interested in your postings. Please keep it up. Yechiel Adar Mehish - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, April 25, 2002 3:33 PM Subject: RE: 9i new features, the saga continues? Yes, I am *still* interested Joe. 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-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 25, 2002 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: 9i new features, the saga continues? Ok life has slowed down some and i've got some free time to potentially pickup the 9i new features saga i did about 6 months ago. Anyone still interested? The next on the list was 9i data guard. joe
Re: sqlldr
Hello Stephen Thanks for the link. The article is very illuminating. As we have some loader tuning to do I thank you for sharing the knowledge. Yechiel Adar Mehish - Original Message - From: Stephen Andert To: Multiple recipients of list ORACLE-L Sent: Friday, April 26, 2002 6:43 PM Subject: Re: sqlldr Ravi, To the best of my knowledge, there is no limitation on the number of records that can be loaded at a time other than the size of your rollback segments. I have loaded 10's of millions of rows in a single sqlldr job by setting some parameters. There are defaults that work, but don't perform very well. To determine appropriate settings, you may want to read an article I wrote for O'Reilly & Associates (located at http://oracle.oreilly.com/news/oraclesqlload_0401.html) which gives the step-by-step directions on setting 2 of the key parameters (BINDSIZE and ROWS). It's a pretty easy thing to do, but without knowing you data, the only advice I could give is that DIRECT is the best quick tuning fix if you can. If you are going to be doing any serious data loading with SQL*Loader, Jonathan's book Oracle SQL*Loader: The Definitive Guide would be a good investment. HTH Stephen>>> [EMAIL PROTECTED] 04/25/02 10:13PM >>>i belive there is a limitation on the number of records that can be loadedfrom sqlldr at a time based on the bind array and rows default parameter.if i have a data file with more than 5000records(don't know the exactnumber) that needs to be imported using sqlldrwhat is the value i need to set for the "rows" and/or "bind array" for me toload the records to the table at one attempt.thanksravi-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ravindra B INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: sqlldr
Hello I do not have experience with 9i and 8i. One paper that I downloaded from OTN (I think) is: Install and Configure the Oracle 9i Platform. This paper starts with preinstall task: Remove installed oracle databases and removed all installed oracle software from the machine. I believe this is just to simplify the new install. We have a NT server with oracle 7.3.4 and 8.1.6 installed in two homes and there are no problems. Yechiel Adar Mehish - Original Message - From: Eriovaldo Andrietta To: Multiple recipients of list ORACLE-L Sent: Sunday, April 28, 2002 2:13 AM Subject: Re: sqlldr HI Yechiel : How can i to install two versions of Oracle in the same server , like : Oracle 8i and Oracle 9i, in oracle_home different. Is it possible ? Regards Eriovaldo - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Saturday, April 27, 2002 8:18 PM Subject: Re: sqlldr Hello Stephen Thanks for the link. The article is very illuminating. As we have some loader tuning to do I thank you for sharing the knowledge. Yechiel Adar Mehish - Original Message - From: Stephen Andert To: Multiple recipients of list ORACLE-L Sent: Friday, April 26, 2002 6:43 PM Subject: Re: sqlldr Ravi, To the best of my knowledge, there is no limitation on the number of records that can be loaded at a time other than the size of your rollback segments. I have loaded 10's of millions of rows in a single sqlldr job by setting some parameters. There are defaults that work, but don't perform very well. To determine appropriate settings, you may want to read an article I wrote for O'Reilly & Associates (located at http://oracle.oreilly.com/news/oraclesqlload_0401.html) which gives the step-by-step directions on setting 2 of the key parameters (BINDSIZE and ROWS). It's a pretty easy thing to do, but without knowing you data, the only advice I could give is that DIRECT is the best quick tuning fix if you can. If you are going to be doing any serious data loading with SQL*Loader, Jonathan's book Oracle SQL*Loader: The Definitive Guide would be a good investment. HTH Stephen>>> [EMAIL PROTECTED] 04/25/02 10:13PM >>>i belive there is a limitation on the number of records that can be loadedfrom sqlldr at a time based on the bind array and rows default parameter.if i have a data file with more than 5000records(don't know the exactnumber) that needs to be imported using sqlldrwhat is the value i need to set for the "rows" and/or "bind array" for me toload the records to the table at one attempt.thanksravi-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ravindra B INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Compare Schemas
Are you working with toad version 7.2? I compared 2 schemas and got a complete list of differences. Right click on the difference and you get the SQL to implement it. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, April 29, 2002 10:23 PM > I need to compare the schemas for two databases. I tried Toad, which will > tell me there are differences but it won't say what the differences are. > Does anyone have a script that will show the differences in detail? > > Ron Smith > DBA > Kerr-McGee Corp > > -- > 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Metrics
Title: Database Metrics Hello Yuval Arnon I will use three graphs: 1) Number of SQL statements executed per day. 2) Mean response time. 2) CPU usage per day. In both cases add a reference point that is the mean of the last 30-40 days so they can see any abnormal behavior. The space statistics are for you and use them only quarterly for management. If you can add a graph for important applications. Yechiel Adar Mehish - Original Message - From: Yuval Arnon To: Multiple recipients of list ORACLE-L Sent: Monday, April 29, 2002 7:23 PM Subject: Database Metrics Hi, I am looking for ideas on what kind of metrics the DBA group should provide the management on a weekly basis so they can understand how the databases are evolving over time. These metrics should be simple enough as the management is not Oracle savvy. Thanks in advance! Yuval. Sr. DBA - WWF
Re: CPU Pegged at 100%
Do you know how to see the threads in NT? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, April 29, 2002 8:24 PM > oracle.exe spawns out threads, which you will not see running in the task > manager. > Each DBWR process then will be a thread of oracle.exe. > > RF > > -Original Message- > Sent: Monday, April 29, 2002 1:40 PM > To: Multiple recipients of list ORACLE-L > > > I have 5 DBWR processes according to INIT.ORA on NT .. I see them on > V$SESSION but There is only one process ORACLE.EXE in the processes list of > NT still. > I do not understand the behaviour of ORacle on NT neither the Oracle I > think. > > > > > Bunyamin K. Karadeniz > Oracle DBA / Developer > Civilian IT Department > Havelsan A.S. Eskisehir yolu > 7.km Ankara Turkey > Phone: +90 312 2873565 / 1217 > Mobile : +90 535 3357729 > > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Monday, April 29, 2002 5:53 PM > > > > On Mon, Apr 29, 2002 at 05:59:18AM -0800, Thomas Day wrote: > > > > > > I don't think that increasing the db_writer_processes will help. NT is, > as > > > noted elsewhere, multi-threaded. Increasing the db_writer_processes > will > > > not start a new process. > > > > > > My experience with Oracle on NT is that when the CPU is pegged at 100% > it > > > is because the OS is constantly writing and fetching the contents of RAM > to > > > the swapfile. > > > > > -- > > > > If this is the case for this problem, we have found that changing > > the location of the os paging file onto another disk and controller > > can help performance. See your windows clicking friends to find > > out where to click. It is somewhere under my computer...read > > the man page on it ;) > > === > > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ray Stell > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > ---- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 about sending it just ONCE ??? - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 3:33 PM > [EMAIL PROTECTED] wrote: > > > I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. > > How can I just remove all of Oracle 9i without touching Oracle 8i? > > > > > > Thanks > > Rick > > > > > > > > how about reading the documentation that came with the damn software? > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > A computer scientist is someone who fixes things that aren't broken. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 deinstall oracle 9i and leave 8i intact
Hello Rick Of course some 9i components are still in. The installer itself is the version that come with 9i. Fun aside, What components are still installed? Yechiel Adar, Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 4:28 PM > > Tom, > > I started with using the installer. It appears it installed Oracle > software. Of course this does nothing with the registry,services,etc. When > I go back into > installer it still shows some 9i installed. When I try to uninstall it > insist on un-installing some oracle 8i software. I have been working in > Oracle since the > end of Oracle 5 and one thing is constant Oracle install/uninstall > procedures SUCKS. Ok I feel a little better now,back to the problem. I > found a Oracle > document detailing removal or oracle software and a oracle home, followed > it to the letter. Everything appears to work fine except the installer > still shows some 9i software installed when I know there is not. It mus be > stored elsewhere but do not know how to correct. This may cause problems > if I attempt to re-install 9i. Any ideas? > > Thanks > Rick > > > > "Mercadante, > Thomas F" To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > <[EMAIL PROTECTED]cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > ate.ny.us> Subject: RE: How to deinstall oracle 9i and leave 8i intact > > 04/30/2002 09:01 > AM > > > > > > > Rick, > > how about using the installer? > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Tuesday, April 30, 2002 9:23 AM > To: Multiple recipients of list ORACLE-L > > > Reposting as I forgot to include a subject line on previous post. > > I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. > How can I just remove all of Oracle 9i without touching Oracle 8i? > > > Thanks > Rick > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 & Windows
Thanks for the links. We are now in the process of tuning a database, on NT, without any option to change the application code (3rd party). I downloaded the docs and hope they will help me. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, April 29, 2002 11:53 PM > This message bounced back to me as undeliverable. Just in case it got > through, the 3rd link was bad and I have replaced it with the correct URL. > > I had copies still on my hard drive so I uploaded them. I emphasize that > these are not my work but the work of the authors whose names appear on the > papers. I had three papers that pertain to Oracle and NT. They are at: > > > This is about Oracle 9 on NT/2000 > http://www.msnusers.com/torac/Documents/SQL-Ora/Maximizing%20Productivity%20 .doc > > > This is about Oracle 8 on NT > http://www.msnusers.com/torac/Documents/SQL%2DOra/Oracle8%20on%20NT%2Edoc > > This is a pdf about configuration standards for Oracle on NT > http://www.msnusers.com/torac/Documents/SQL%2DOra%2FORACLE%5FNT%5FCONFIG.pdf > > > If you don't have hotmail userids I have also uploaded them to > > http://www.geocities.com/tomdaytwo/MaximizingProductivity.htm > http://www.geocities.com/tomdaytwo/Oracle8onNT.htm > http://www.geocities.com/tomdaytwo/ORACLE_NT_CONFIG.pdf > > You should be able to find them at one place or the other. > > HTH > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thomas Day > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 deinstall oracle 9i and leave 8i intact
Hello Rick I think that you should start with DBCA and remove your 9i DB and then follow the steps in John letter. Yechiel Adar Mehish - Original Message - From: Ora NT DBA To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 30, 2002 4:59 PM Subject: Re: How to deinstall oracle 9i and leave 8i intact Hi Rick,I would first shut down the 9i versions of the services for any database, listeners, intelligent agents, etc.Then using the installer I would deinstall all 9i software.Then using regedt32 I would remove the home key for the Oracle9i home.That should just about do it.John [EMAIL PROTECTED] wrote: What platform are you working on? Windows or Unix?-Joe--- [EMAIL PROTECTED] wrote: Reposting as I forgot to include a subject line on previous post.I have Oracle 8i with 4 instances and Oracle 9i with 1 instance.How can I just remove all of Oracle 9i without touching Oracle 8i?ThanksRick-- 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-5051San Diego, California-- Public Internet access / MailingLists To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (likesubscribing).__Do You Yahoo!?Yahoo! Health - your guide to health and wellnesshttp://health.yahoo.com
Re: Root Cause Analysis White Papers
Hello Peter A good source if the calls themselves. After each call analyze the root cause and start checking for it. This way you will be able in a short time to eliminate a lot of problems. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 6:11 PM > We have been having some heavy discussions about > system failures, root cause analysis and developing > some proactive metrics. Generally, our problems > revolve around frequently late nights for the On Call > DBA because something out of our control goes wrong. > The damagement folks want to fix the immediate problem > and consider the job done. The DBAs are asking for an > approach that will allow us to identify potential > problems before something breaks at 3:00 a.m. > > Does anyone know of a source of white papers or other > data that has been generated for systems, storage or > databases? We can always roll out own, but why > recreate someone else's work. > > > > = > Pete Barnett > Lead Database Administrator > The Regence Group > [EMAIL PROTECTED] > > __ > Do You Yahoo!? > Yahoo! Health - your guide to health and wellness > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Peter Barnett > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: CPU Pegged at 100%
Hello Igor Thank you for the info. I got the following script from one of the articals that Thomas Day point to in the message With subject Oracle & windows. It shows the threads that oracle is using. The first column has a call to some function that probably did some formating but I deleted it. create or replace view NT_threads as select p.spid "ID_THREAD", p.background "BACKGROUND", b.name "NAME", s.sid "SID", s.serial# "SERIAL#", s.username "USERNAME", s.status "STATUS", s.osuser "OSUSER", s.program "PROGRAM" from v$process p, v$bgprocess b, v$session s where s.paddr = p.addr and b.paddr(+) = p.addr; - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 9:21 PM > You can see process threads in NT Performance Monitor. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: pl/sql is INTERPRETED?
You THINK that you are kidding. I submit to you that in a few years there will be a great demand for Cobol programmers as the current old crop goes into retirement and all the newbe's are learning Java and perl. Start writing those books. They will be needed by the time that you finish them. Just my 2$ (inflation, you know) Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 7:48 PM > Whatever happend to COBOL anyway?? That was so easy to code, along with > Fortran, BASIC, Pascal was a lot of fun. What's wrong with storing your > data in VSAM files??? > > I think I hear my pasture calling me...35, and retired...that would be nice. > I can write COBOL books to fund my retirement... > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SIMPLE QUESTION
Dave I checked this out and it depends on the oracle version. Editing the listener.log of 8.1.6.3.4 on NT failed as: Another process is using the file. The same for 9.0.1.3 on NT. Editing not problem. Marked the whole text except for the last day and deleted it and then I saved the file. Size down to 9k from about 10,000k. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 7:58 PM If you are running Oracle on Windoze, you have to stop the listener service, then rename the listener.log, then start the listener service again. I don't know how on Unix. Dave -Original Message- Sent: Wednesday, May 01, 2002 12:18 PM To: Multiple recipients of list ORACLE-L HI AGAIN, JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING BY ORACLE. HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY DELETE IT OR NOT? THANKS FOR HELP. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === 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. = End Confidentiality Statement = -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Correcting user sql inside the database
Hello list This time I need your help on how to implement a weird idea. We have a third party application that fire wasteful SQL's to the database. (Remember the discussion on using x$dual Vs dual some days ago?) I am wondering: Is there a way to change the SQL that the user send? In ADABAS on the mainframe I can activate a user exit that gets the command that the user send to the database and change it (Not only can, but we are doing it!). Is there a way to do the same with SQL in Oracle? In the server (preferably) or in the client. Thanks Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Changing SQL statements inside the database
Hello list This time I need your help on how to implement a weird idea. We have a third party application that fire wasteful SQL's to the database. (Remember the discussion on using x$dual Vs dual some days ago?) I am wondering: Is there a way to change the SQL that the user send? In ADABAS on the mainframe I can activate a user exit that gets the command that the user send to the database and change it (Not only can, but we are doing it!). Is there a way to do the same with SQL in Oracle? In the server (preferably) or in the client. Thanks Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i new features update
Hello Joe Just took a peek. Looks illuminating. Keep up the good work. Yechiel Adar Mehish - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Thursday, May 02, 2002 3:48 PM Subject: 9i new features update I finally got the website updated. For those of you who lost, never saw, would like to review, all of the past editions of the 9i new features series is at http://www.oracle-dba.com click on the 9i link. joe
Re: Changing SQL statements inside the database
Thanks for the idea Tim but I am thinking about adding hints to the sql or changing the FROM table. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 4:48 PM > The Virtual Private Database (VPD) facility (a.k.a. "fine-grain" or > "row-level" security) can be used to alter SQL on the server, regardless of > origin. I implemented an access control list (ACL) feature for a system two > years ago, complete with recursion inside PL/SQL for navigating the > (implied) double-dimensioned linked-lists that typical ACL functionality > requires. > > Navigating linked-lists is naturally something that you wouldn't want to > code in a SQL statement, but VPDs did it quite nicely by allowing me to run > a custom PL/SQL packaged function during the PARSE phase of a SQL statement. > The packaged function is supposed to return a string which is tacked onto > the SQL statement, so you cannot "modify" existing text in the SQL, but you > can add additional SQL text to the WHERE clause, including subqueries. > There are other little useful twists and tricks and gotchas involved, but > that's the general idea... > > But, be *very* careful! You can just imagine how badly you can harm > performance and accessibility through casual use of this feature... :-) > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 7:18 AM > > > > Hello list > > > > This time I need your help on how to implement a weird idea. > > We have a third party application that fire wasteful SQL's to the > database. > > (Remember the discussion on using x$dual Vs dual some days ago?) > > > > I am wondering: Is there a way to change the SQL that the user send? > > > > In ADABAS on the mainframe I can activate a user exit that gets the > command > > that > > the user send to the database and change it (Not only can, but we are > doing > > it!). > > > > Is there a way to do the same with SQL in Oracle? > > > > In the server (preferably) or in the client. > > > > Thanks > > > > Yechiel Adar > > Mehish > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Yechiel Adar > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tim Gorman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Correcting user sql inside the database
Hello Anjo If you know of a way to change the SQL at the client side I would LOVE to know it. We where thinking about changing the connections string on the fly (not this fly) And this can help a lot. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:43 PM > Outlines is one way, but there is another sneaky way, but that involves a > lot of programming depending on what you want to change. > And it also depends on where the client runs and how it is linked > > Anjo. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 2:48 PM > > > > Hello list > > > > This time I need your help on how to implement a weird idea. > > We have a third party application that fire wasteful SQL's to the > database. > > (Remember the discussion on using x$dual Vs dual some days ago?) > > > > I am wondering: Is there a way to change the SQL that the user send? > > > > In ADABAS on the mainframe I can activate a user exit that gets the > command > > that > > the user send to the database and change it (Not only can, but we are > doing > > it!). > > > > Is there a way to do the same with SQL in Oracle? > > > > In the server (preferably) or in the client. > > > > Thanks > > > > Yechiel Adar > > Mehish > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Yechiel Adar > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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: Anjo Kolk > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OTN service
Hello Ray I think that the intent is for you to burn the gz file and expand it on the target system. I installed today upgrade 9.0.1.3 for NT that came in the same way. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 4:53 PM > > I mentioned that the 32 bit solaris gz file for 8.1.7 > that I downloaded from otn provided one disk image on the order > of 900MB. What technology do I need to move to in order > to burn this onto plastic? Are we talking dvd burner here? > > I asked oracle what the intent was with this, the answer is > a classic: > > The OTN Service Network is specifically designed for customers who need > support on software downloaded via OTN. The OTN Service Network offers > pay-per-incident support provided by Oracle certified professionals. > Support is available on Oracle Database Server, Oracle9I Application > Server and Oracle Tools products. Pricing is $50, $75 or $100 based on > the complexity of the issue. > > By intent, I ment what technology was targeted. Anybody know? > === > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ray Stell > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ERD generation tool
Hello Ron I was just looking at Joe new oracle 9i features at http://www.oracle-dba.com I saw that log miner gives you something like: update "SCOTT"."TEST_LOG" set "C2" = '10' What happens if you extract this info and erd tool moved a column? Inquiring minds wants to know Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:58 PM Moving the columns should not be a problem for anyone, heck you should be able to alphabetize them and everything be okay. If you take the output and use it to create tables that should not cause a problem except for the developer that codes for columns to appear in a specific order. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 05/01/02 06:56PM >>> No, no Paul is stating it as a bug. This has happend to me, where on occasion ERwin decides to move columns around for no reason when it creates the table in the database. I have looked at every single option and I can't find anything, so I am assuming it's a bug. But if anyone knows otherwise...please do share... * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ERD generation tool
Ron wrote: > Did you use the changed ERD to create a table and then use old archives to > mine the data changes? NO. I did not started to work with log miner yet. I just saw the article that Joe published and thought about this point. I have enough experience to know that you can not teach old data new tricks (or new structure). Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 8:48 PM Yechiel, In the instance that you refer to it could present a problem if you use the "changed" table description to build a different instance and then used the "mined" info to update the table in the new instance. This would be a case where the source and target databases are not the same and then I don't think that any form of data replication should be blindly trusted. Remember, the OS, and database have to match to work properly. It is a good point that you brought out and it should be a warning to make sure the source and target are the same. Another item that could be overlooked in this case is father time. Did you use the changed ERD to create a table and then use old archives to mine the data changes?. It goes along with the changing of a column on a table and then trying to use old data to updates it or perform a calculation on it. There could be problems. That is why we document everything we do to the data. It gives us a reference to a point in time we can restore to if we need it. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 05/02/02 01:23PM >>> Hello Ron I was just looking at Joe new oracle 9i features at http://www.oracle-dba.com I saw that log miner gives you something like: update "SCOTT"."TEST_LOG" set "C2" = '10' What happens if you extract this info and erd tool moved a column? Inquiring minds wants to know Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:58 PM Moving the columns should not be a problem for anyone, heck you should be able to alphabetize them and everything be okay. If you take the output and use it to create tables that should not cause a problem except for the developer that codes for columns to appear in a specific order. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 05/01/02 06:56PM >>> No, no Paul is stating it as a bug. This has happend to me, where on occasion ERwin decides to move columns around for no reason when it creates the table in the database. I have looked at every single option and I can't find anything, so I am assuming it's a bug. But if anyone knows otherwise...please do share... * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /
Re: ERD generation tool - Active SCM
Well Keith Our solution to the is: Do not grant they rights to do any DDL either in test nor in prod. The dab stuff does all the DDL work. Sure it is an added chore, but after tracking down, a few times, tables that were dropped inadvertently by users (their tool did it by itself) we now use the following policy: Every application has two user id's: Owner, with password known only to the DBA group. User with rights for select, insert, update, delete ONLY. It works. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 7:54 PM > Lisa, > There is only so much you can control via a model, > since it remains a process away from the DB, and > cannot be enforced via privileges, etc. So, we are > always in the hands of Dom Phoc (and their siblings), > who can do "stuff" even in the production database > with SQLPLus/TOAD/... Under this schenario, do you > sleep well at night? > > So, we said lets work with our Dom Phoc's. On > production databases, we will STRIP them off of the > Oracle database passwords. No password, no change. > ENFORCED! Now, I can sleep well at night. > > How? Not via models. Via a solution involving the > following, and it seems to be working for us well: > ActiveDesigner/ActiveChangeManager/ActiveCompare/A+ > White Paper: > http://www.iraje.com/docs/ActiveSecureDesigner.htm > > Take charge of the "Dom Phocs" in your org! > > Keith > > > > > > > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, > "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Date: Wed, 1 May 2002 16:06:00 -0500 > > > > > > Well, for one thing, if your developer, Dom Phoc, > starts changing crap > in > your database (as has happened to me in the past) a > compare to the dev > model > would be great because my development changes would be > in the model, > not in > the test or production databases. In that specific > case I had to TRUST > him > (what? trust him after what he just did?) to change > everything back, > or > restore from a backup, which would have been very time > consuming. > > I was one large ball of raging hormones that day and I > took it all out > on > him. We don't work on the same projects anymore. > > Lisa Koivu > Oracle Database Administrator > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > > > > -Original Message- > > From: Keith Peterson [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, May 01, 2002 5:50 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: ERD generation tool - Active > Comparisons > > > > Am I speaking to the wind > > > > For Compares, why would you compare the MODEL with > the > > DATABASE...like going from US to London via Tokyo... > > ... and you get to pay more, like... you pay not for > > distance, but for "time in the air"... If a tool > takes > > longer to do something, makes more mistakes, is > bumpy > > and complex... you get to pay more. > > > > For compares, someone tell me what beats > > ActiveCompare: > > http://www.iraje.com/compare-diff.htm > > > > http://www.iraje.com/ActiveCompare_viewlet.html > > > > > > ...and I will switch my tool. > > > > Keith > > > > __ > Do You Yahoo!? > Yahoo! Health - your guide to health and wellness > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Keith Peterson > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: pl/sql is INTERPRETED?
Yea It contain one page with the instructions: Take a clean cup. Put in one teaspoon of sugar. Add one teaspoon of JAVA. Fill the cup with boiling water up to half an inch from the rim. Use the teaspoon to mix. WAIT - let it cool some. The FDA rules that drinking boiling beverages is not good to your health. Drink. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 9:53 PM > I think there is a book called Java for Dummies. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > -- > 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Datawarehousing help
Hello Dennis SAS has progressed a little in the last years and now offer a complete DW solution, including ETL tools. You can use their tools also to populate and query oracle. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Saturday, May 04, 2002 2:48 AM > Rachel - I always find it helpful to understand something if I know the > origins. I worked with SAS several years ago. At that time it was a > statistical analysis package. A scientist or engineer could load a set of > test data into it and perform various arithmetic and statistical analyses. > Today most of that can be done with Oracle or MS Excel. My point is that I > would expect it to be heavily biased toward mathematical capabilities. Like > Data Mining, which is all statistics. Learn what that term means. > To learn Data Warehousing, I would encourage you to just do some > "Googling" and find good tutorials. An excellent newslist is dwlist. > Instructions: > > For help with list commands, send a message > to <mailto:[EMAIL PROTECTED]> with the > word "help" in the body of the message. > > The magazine http://www.intelligententerprise.com/ has some excellent > information. I would search for "Ralph Kimball". He is one of the leading > figures in the DW arena. Look for some of his earliest columns on the > magazine site. He also answers questions on dwlist from time to time. > > The main change you need yourself is to forget normalization. DBAs that > can't get past that point don't last long in the DW field. In the early days > the DW people would patiently explain the reasons to a DBA, but today there > are enough DBAs that have made the leap that a hard-headed normalization > bigot just isn't tolerated. It is much easier to just ask for a replacement > DBA. > The reason normalization isn't adhered to in DW is that users will > be creating their own queries and they can't understand 10-table joins with > outer joins, etc. A DW is usually loaded and then queried. Our DW is loaded > each weekend and then queried all week. So a DW is deliberately denormalized > and contains redundant data for ease of use. > OLTP databases have no concept of "time". A DW is all about time. To > reconstruct what the situation is at various points of time, the DW has > loads of historical data. For example, marketing people need to be able to > reconstruct the amount of business they did with a customer over a period of > time last year and compare it with the same period this year. > So between denormalization and tons of detailed historical data, DWs > are normally BIG! Fortunately they are usually read-only. > For Oracle, you want Enterprise Edition with the partitioning > option. And study Oracle Materialized Views. > In schema, a DW is usually a central fact table and 4-6 dimension > tables. Less than 4 dimensions and you don't need a DW. More than 6 and > marketing people can't understand the model. Normally the fact table is much > larger than the others, but not always. One of Wal-Mart's dimension tables > is each person in the U.S. Just size each of those tables, and you've got > your size. Growth is easy to predict. Ralph Kimball warns that often people > will get the grain wrong. They will size it for data summarized at the > weekly level, then after it is built they will realize that isn't going to > cut it and need a daily level. You must start almost from scratch and get 7 > times the disk capacity. That is the fun side of being a DW DBA. Your > cynical instincts will still serve you well, just get them away from > normalization and worry about getting the grain right. > Okay, I've rambled along here too long. Hope that gets you off on > the right foot. > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 03, 2002 5:08 PM > To: Multiple recipients of list ORACLE-L > > > > > Okay, my background is OLTP, but we are looking at a data warehousing > project > here > > any and all help appreciated! Specifically: > > 1) does anyone have any experience with a product called "SAS > Datawarehousing > Administrator" (or SAS)? > 2) how do I go about doing rough estimates of sizing needs, assuming I will > get > rough numbers of information being collected, growth rates, length of > history to > keep, etc. > > help? > > Rachel > > > -- > 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 List
Re: ERD generation tool - Active SCM
Well , just to keep things jumping. Last week I deviated from our rule and gave a responsible user that needed truncate on tables the password for the owner of the schema. Guess what? Today he comes to me to recreate 2 tables that he dropped. Go figure. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 5:53 PM > Yechiel, > Yes, I have been there, done that, over and over... > But then, there is a "Toyota Corolla" solution and > maybe a "Ferrari Testarosa" solution. > > If we can control "Dom Phoc" without tieing his hands > behind the back, wouldn't that would be the best: > white paper: > http://www.iraje.com/docs/ActiveSecureDesigner.htm > > > Keith > > > Date: Thu, 02 May 2002 11:48:38 -0800 > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Reply-to: [EMAIL PROTECTED] > Organization: Fat City Network Services, San Diego, > California > > > > Well Keith > > Our solution to the > is: > > Do not grant they rights to do any DDL either in test > nor in prod. > > The dab stuff does all the DDL work. > Sure it is an added chore, but after tracking down, a > few times, tables > that > were dropped > inadvertently by users (their tool did it by itself) > we now use the > following policy: > > Every application has two user id's: > Owner, with password known only to the DBA group. > User with rights for select, insert, update, delete > ONLY. > > It works. > > Yechiel Adar > Mehish > > - Original Message - > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 7:54 PM > > > > Lisa, > > There is only so much you can control via a model, > > since it remains a process away from the DB, and > > cannot be enforced via privileges, etc. So, we are > > always in the hands of Dom Phoc (and their > siblings), > > who can do "stuff" even in the production database > > with SQLPLus/TOAD/... Under this schenario, do you > > sleep well at night? > > > > So, we said lets work with our Dom Phoc's. On > > production databases, we will STRIP them off of the > > Oracle database passwords. No password, no change. > > ENFORCED! Now, I can sleep well at night. > > > > How? Not via models. Via a solution involving the > > following, and it seems to be working for us well: > > ActiveDesigner/ActiveChangeManager/ActiveCompare/A+ > > White Paper: > > http://www.iraje.com/docs/ActiveSecureDesigner.htm > > > > Take charge of the "Dom Phocs" in your org! > > > > Keith > > > > > > > > > > > > > > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, > > "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > > Date: Wed, 1 May 2002 16:06:00 -0500 > > > > > > > > > > > > Well, for one thing, if your developer, Dom Phoc, > > starts changing crap > > in > > your database (as has happened to me in the past) a > > compare to the dev > > model > > would be great because my development changes would > be > > in the model, > > not in > > the test or production databases. In that specific > > case I had to TRUST > > him > > (what? trust him after what he just did?) to change > > everything back, > > or > > restore from a backup, which would have been very > time > > consuming. > > > > I was one large ball of raging hormones that day and > I > > took it all out > > on > > him. We don't work on the same projects anymore. > > > > Lisa Koivu > > Oracle Database Administrator > > Fairfield Resorts, Inc. > > 5259 Coconut Creek Parkway > > Ft. Lauderdale, FL, USA 33063 > > > > > > > -Original Message- > > > From: Keith Peterson [SMTP:[EMAIL PROTECTED]] > > > Sent: Wednesday, May 01, 2002 5:50 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: ERD generation tool - Active > > Comparisons > > > > > > Am I speaking to the wind > > > > > > For Compares, why would you compare the MODEL with > > the > > > DATABASE...like going from US to London via > Tokyo... > > > ... and you get to pay more, like... you pay not > for > > > distance, but for "time in the air"... If a tool > > takes > > > longer
Re: IN() question
Hello Lisa
I think that using :
SQL> SELECT COUNT(*)
2 from leisure_plan_master_temp
3 where membership_class = 'D'
4 AND (pay_METHOD NOT IN ('C','P')
5 or pay_method is null)
will give you the correct result.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Saturday, May 04, 2002 1:43 AM
> Slap me if this is a dumb question.
>
> Here's my pay methods
>
> SQL> SELECT ASCII(PAY_METHOD), PAY_METHOD, COUNT(*)
> 2 FROM LEISURE_PLAN_MASTER_TEMP
> 3 WHERE MEMBERSHIP_CLASS = 'D'
> 4 GROUP BY PAY_METHOD;
>
> ASCII(PAY_METHOD) P COUNT(*)
> - - --
>67 C 42955
>80 P 34373
> 11786
>
> I expected this statement to return the 11,786 records that have null
> values. However, it doesn't:
>
> SQL> SELECT COUNT(*)
> 2 from leisure_plan_master_temp
> 3 where membership_class = 'D'
> 4 AND pay_METHOD NOT IN ('C','P');
>
> COUNT(*)
> --
> 0
>
> But when I do this, I get the answer I expect.
>
> SQL> SELECT COUNT(*)
> 2 from leisure_plan_master_temp
> 3 where membership_class = 'D'
> 4 AND PAY_METHOD IS NULL;
>
> COUNT(*)
> --
> 11786
>
> This isn't exactly correct. There may be other values in this field, and
if
> they show up I need to include them, not just records where this field is
> null. What am I missing? Is it because the value is NULL that Oracle
> excludes it from the IN() statement, because of the classic definition of
> NULL (can't be defined, therefore can't be sure it's not a C or a P)?
>
> This is easy enough to fix, I'll change my data load to populate the null
> values with my own code. But still? Have I got the WHY correct?
>
> Thanks for any light someone can shed on this stupid question.
>
> Lisa Koivu
> Oracle Database Monkey Mama
> Fairfield Resorts, Inc.
> 5259 Coconut Creek Parkway
> Ft. Lauderdale, FL, USA 33063
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Koivu, Lisa
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: DB Version upgrade with CreateDB/Import "Risky"???
Hello James In the last 2 years I did about 5-6 migrations from 7.3.4 to 8.1.6.0 and 10-12 from 8.1.6.0 to 8.1.6.3.4. All done on NT with upgrades. No scratch and rebuild. No problems at all. Sorry to disappoint you. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Sunday, May 05, 2002 6:23 PM > Hello fellow Oracle DBAs, > > I really need your opinion on this matter: > > I routinely do upgrades of Oracle software and databases on all types of > systems: Compaq Unix, Netware, Linux, etc. (as do we all from time to time). > On one Windows/NT 4 system where I am presently doing an upgrade from a > lower version of Oracle 8 to 8.1.7, I am dealing with a particular System > Administrator for the NT box who knows a little about Oracle, but that is > obviously laboring under some misconceptions. > > He strongly believes that the ONLY way one should upgrade a database (once > the software has been upgraded) is to do a "migration" (presumably as > detailed in the Oracle Migration manual) and he is URGING me to do it this > way. > > On small databases (i.e. less than 10G) where downtime is not an issue, the > way I have always done it and the way I intend to do it this case is: > > (1) Take a full database "export" under the old version > (2) Install the Version 8.1.7 software > (3) Recreate from scratch the database under the new software > (4) Do a full database "import" to the new database. > > For our systems, I as the DBA believe and have found this to be a fully > reliable, quick, and clean method and the preferable way to do it, rather > than go through the migration procedure. He on the other hand believes that > NOT doing it via the "migration" route is very "risky". > > Without going into a long spiel with him about what an upgrade IS as far as > the database itself is concerned (i.e. the data dictionary objects being > brought up to the new version), and why the way I intend to do it with a > full import is perfectly acceptable to accomplish this, I'd like to just > offer this person the opinions of some of you out there in ORACLE-L List > Land where the Oracle DBA expertise is highly respected for its stature, > I.E. so he doesn't have to believe me. > > In other words, I don't want to try to convince him against his > will..I'd rather have impartial competent experts give him unbiased > testimony. Thus I humbly solicit your opinion on this matter. I believe that > my above procedure is a simple and fully reliable way of bringing the > database up to the new software level..or perhaps it is ***I*** that am > laboring under the misconception??? May I please have your take on > this. > > Much appreciate, > > JDamiano > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James Damiano > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Datawarehousing help
Hello Rachel I am working with SAS on the mainframe (os390) and it works fine. We published a RFP for ETL tool and they are one of the candidates. Their tool looks good on paper but we are still evaluating papers and do not have hands on experience. We do have a SAS/oracle application on NT but I was not involved in the programming side. I checked with the programmer and he told me that in the little testing he did ( system still in test) SAS worked quickly and nicely with oracle, including graphs. SAS has a nice graph generating option. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, May 06, 2002 4:13 PM > > > Yechiel, > > have you used their tools? We are trying to decide whether or not to use them, > so if anyone has had recent experience with them, I'd appreciate your thoughts > on ease of use, understandability, quality of the product, etc > > Thanks > > Rachel > > > |+---> > || | > || | > || adaryechiel@h| > || otmail.com | > || | > || 05/05/2002 | > || 07:23 AM | > || Please | > || respond to | > || ORACLE-L | > || | > |+---> > >| > || > | To: [EMAIL PROTECTED] | > | cc: (bcc: Rachel Carmichael) | > | Subject: Re: Datawarehousing help| > >| > > > > > Hello Dennis > > SAS has progressed a little in the last years and now offer a complete > DW solution, including ETL tools. > > You can use their tools also to populate and query oracle. > > Yechiel Adar > Mehish > > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Saturday, May 04, 2002 2:48 AM > > > > Rachel - I always find it helpful to understand something if I know the > > origins. I worked with SAS several years ago. At that time it was a > > statistical analysis package. A scientist or engineer could load a set of > > test data into it and perform various arithmetic and statistical analyses. > > Today most of that can be done with Oracle or MS Excel. My point is that I > > would expect it to be heavily biased toward mathematical capabilities. > Like > > Data Mining, which is all statistics. Learn what that term means. > > To learn Data Warehousing, I would encourage you to just do some > > "Googling" and find good tutorials. An excellent newslist is dwlist. > > Instructions: > > > > For help with list commands, send a message > > to <mailto:[EMAIL PROTECTED]> with the > > word "help" in the body of the message. > > > > The magazine http://www.intelligententerprise.com/ has some excellent > > information. I would search for "Ralph Kimball". He is one of the leading > > figures in the DW arena. Look for some of his earliest columns on the > > magazine site. He also answers questions on dwlist from time to time. > > > > The main change you need yourself is to forget normalization. DBAs that > > can't get past that point don't last long in the DW field. In the early > days > > the DW people would patiently explain the reasons to a DBA, but today > there > > are enough DBAs that have made the leap that a hard-headed normalization > > bigot just isn't tolerated. It is much easier to just ask for a > replacement > > DBA. > > The reason normalization isn't adhered to in DW is that users will > > be creating their own queries and they can't understand 10-table joins > with > > outer joins, etc. A DW is usually loaded and then queried. Our DW is > loaded > > each weekend and then queried all week. So a DW is deliberately > denormalized > > and contains redundant data for ease of use. > > OLTP databases have no concept of "time". A DW is all about time. To > > reconstruct what the situation is at various points of time, the DW has > > loads of historical data. For example, marketing people need to be able to > > reconstruct the amount of business they did with a customer over a period > of > > time last year and compare it with the same period this year. > > So between denormalization and tons o
Re: ERD generation tool - Active SCM
Hello Kieth you wrote: It would have been better to give your developer "truncate" only privileges, You mean: grant truncate on owner.table to user. No such grant. The closest I could find is: Create procedure that truncate the table as the owner and grant execute on the procedure to the user. Any better ideas? BTW - I did not wrote that he dropped the tables using some developing tool called magic because he forgot to switch back to the regular user after the truncate. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, May 06, 2002 5:53 PM > this is exactly my point. > > It would have been better to give your developer > "truncate" only privileges, and that too only on a few > tables... but NEVER the Oracle schema owner password! > NEVER. > > But, you too gave it away! you too Brutus! Even > though you are quite averse to doing so. > > Think about it, this happens everyday. Whether you > like it or not, you have MASTER, TEST, PRODUCTION, > DEVELOPMENT, STAGING... instances, and your schema > passwords are floating around, and you have no > control. And, you promise that you will never give > the schema password out ever again, but you know you > will... you will be forced to... your director will > make you... and if you fight it any win, your > developer productivity will be seriously compromised. > > You need to have a means of giving the schema access > without giving away the full house. And the solution > is NOT via a read-only user. A read-only user is > useless. You cannot do any serious work in a read > only user. Been there done that. Giving Oracle > privileges, to users, as a case-by-case request, is > IMPOSSIBLE for you to manage, UNREASONABLE and NOT > FEASIBLE. > > Anyway, NEVER give the ORACLE PASSWORD away. Only > encrypted access. And, let Dom Phoc work right in the > owner schema. There will be no problem, if you can > GUARANTEE limited access, full audits on everything > Dom does via this access, including select statements. > Dom Phoc will not be viewing the Salaries, and Credit > Card numbers now... not if its being audited. > > At the expense of sounding like a sales person, let me > point this out again for the benefit of the group: > And, you certainly need to look at it: > http://www.iraje.com/docs/ActiveSecureDesigner.htm > > I will find forward you some more info. > > Keith > > > > Date: Sun, 05 May 2002 03:48:18 -0800 > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Reply-to: [EMAIL PROTECTED] > Organization: Fat City Network Services, San Diego, > California > > > Well , just to keep things jumping. > > Last week I deviated from our rule and gave a > responsible user > that needed truncate on tables the password for the > owner of the > schema. > > Guess what? Today he comes to me to recreate 2 tables > that he dropped. > > Go figure. > > Yechiel Adar > Mehish > > - Original Message - > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > Sent: Friday, May 03, 2002 5:53 PM > > > > Yechiel, > > Yes, I have been there, done that, over and over... > > But then, there is a "Toyota Corolla" solution and > > maybe a "Ferrari Testarosa" solution. > > > > If we can control "Dom Phoc" without tieing his > hands > > behind the back, wouldn't that would be the best: > > white paper: > > http://www.iraje.com/docs/ActiveSecureDesigner.htm > > > > > > Keith > > > > > > Date: Thu, 02 May 2002 11:48:38 -0800 > > To: "Multiple recipients of list ORACLE-L" > > <[EMAIL PROTECTED]> > > Reply-to: [EMAIL PROTECTED] > > Organization: Fat City Network Services, San Diego, > > California > > > > > > > > Well Keith > > > > Our solution to the > > is: > > > > Do not grant they rights to do any DDL either in > test > > nor in prod. > > > > The dab stuff does all the DDL work. > > Sure it is an added chore, but after tracking down, > a > > few times, tables > > that > > were dropped > > inadvertently by users (their tool did it by itself) > > we now use the > > following policy: > > > > Every application has two user id's: > > Owner, with password known only to the DBA group. > > User with rights for select, insert, update, delete > > ONLY. > > > > It works. > > > > Yechiel Adar > > Mehish > > > > - Original Message - > &g
Re: I need to change the instance name (to Dennis)
Right BUT: make sure you do not use any option that does not exist in the standard edition but existed in the enterprise edition. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 12:18 PM > > Dennis : > > Thanks for your answer. > Well, I need to downgrade my database, changing EE for SE, so ... > The most problem is that the v$instance is used in the aplication. > I saw in the metalink a document that helps to change the db_name and not > the instance_name, understand.. > so ... > I thought to create the new one, with the new name and migrate to it and > after it to change the name to the old one... > Like that, i shouldn't change the application . > > But i hope that the best way is : > > Deinstall and install the new version. > And to migrate it fully. > > Right ? > > Regards > Eriovaldo > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, May 06, 2002 11:53 AM > > > > Eriovaldo - Often the lot of a DBA is to balance value and risk. Here, you > > must ask yourself - what is the value of retaining the same instance name, > > and what are the risks to my production environment? If you perceive the > > value to be high and the risks low, then go for it. But often (especially > > after you've been stung a few times) it seems that the value wasn't so > great > > after all. How long can you have your production site down? What happens > if > > something goes wrong and you have them down quite a bit longer than you > > estimated? You can lower the risk to your production site by creating the > > new instance (different name), and getting it all prepared before you take > > the production site down for the export. If most of your users access the > > instance via SQL*Net (Net8), you can put an alias there, so they don't > have > > to change a thing. > > Of course, if your boss says "do it or else", then the value/risk > > equation changes dramatically. > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > > > -Original Message- > > Sent: Sunday, May 05, 2002 5:18 AM > > To: Multiple recipients of list ORACLE-L > > > > > > > > Actualy, I am confused, because this is my production environment and I > > need to get sucess in this operation. > > > > It is necessary, and i would like to keep the old name of instance, > because > > i will change the BD version. > > I think the best way is : > > > > 1.) backup the software and datafiles > > 2.) Export all the database > > 3.) Deinstanll the old software > > 4.) Install the new version > > 5.) Create the instance with the old name > > 6.) Import the database > > > > but it will take a while. > > I am looking for a fast way , > > > > Understand ? > > > > Thanks > > > > Regards > > > > Eriovaldo > > > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Saturday, May 04, 2002 8:03 PM > > > > > > > Its actually the easiest part. However, I don't want to miss a step > > > so you best running off to Metalink. They actually have a note out > > > there on how to do it. Not quite up to date for 9i but close. > > > > > > You need to shutdown your database, change your oracle sid, rename your > > > init, if using an i version change the instance name and if desired the > > > service > > > name. Hum, me thinks that's it. I may be missing something though. > > > I feel like I am missing something. > > > > > > However, the moral of the story is that its quite easy and I have > > > done it a couple of times. You need to make a decision on what to > > > do with your directories structures if you are using the > > > $ORACLE_BASE/admin/ > > > structure. There is no technical reason to change it except for > > > your own sanity. > > > > > > -Original Message- > > > Andrietta > > > Sent: Saturday, May 04, 2002 12:23 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Friends : > > > > > > I need to change the instance name. > > > For example it is : DEVELOP and I need to put DEVELOPER. > > > > > > I know how to change the database name , b
Re: ERD generation tool - Active SCM
Sorry to disappoint you all. I gave him the password so he can connect as the owner and then he can do truncate. I scanned the list later and found the discussion on the subject and I am going to replace that with a procedure that he will be granted execute. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 2:38 PM I thought that there was a way via schema level triggers? I vaguely remember discussion on this last year > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "Kimberly Smith" <[EMAIL PROTECTED]> > Sent: Monday, May 06, 2002 10:28 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: ERD generation tool - Active SCM > > Hey, how do you give that truncate only privilege > > > -- 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: I need to change the instance name
Sorry I meant to say partitioning is not available in SE - not replication. Yechiel Adar Mehish - Original Message - To: <[EMAIL PROTECTED]> Sent: Thursday, May 09, 2002 3:21 PM Yechiel - Do you have more information (9i and replication)? Previously there was a document on Oracle's website that showed SE had basic replication and EE had advanced replication. I don't see that document any more. Our company is looking at placing Oracle servers at several remote sites. Originally they wanted to use MS SQL, but Oracle SE pricing looked okay, and I figured that basic replication would do what they need. If I am wrong, do you know of any job openings? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 09, 2002 6:48 AM To: Multiple recipients of list ORACLE-L I looked at 9i options and I see that replication is not available with SE, only with EE. So, if you use replication you can not downgrade to SE from EE. ( replication is just an example). So you need to take a good look on the options difference between SE and EE to make sure you CAN downgrade. 9i option link: http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingandopt ions.html Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 08, 2002 11:28 PM > Yeachiel : > > We have 8.1.7 EE. > > Regards > > > Cópia Yechiel Adar <[EMAIL PROTECTED]>: > > > 8.1.6 SE or EE ? > > > > I meant that there are differences inside the same version between SE > > and > > EE. > > > > Yechiel Adar > > Mehish > > - Original Message - > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Sent: Wednesday, May 08, 2002 3:38 AM > > > > > > > > > > I am almost 100% sure. > > > Because i have the application also running in the 8.1.6. > > > > > > Thanks Friends > > > > > > Eriovaldo > > > > > > > > > - Original Message - > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Yechiel Adar > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > > > > - > Esta mensagem foi enviada por Siteplanet WebMail. > http://webmail.siteplanet.com.br > -- > 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 upgrade NT4 -> W2K Oracle implications
1) Oracle uses the registry also to register some staff in other places except the oracle entry. 2) Oracle also use c:\program files\oracle for some stuff (install log etc.). Why do not upgrade the machine without recreating C partition. (I know that upgrade is more work then ghosting a new C drive). Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, May 10, 2002 12:47 AM We have an 8.1.7 SE database on a server which is currently NT4 SP6. The System Admin group wish to upgrade the server to W2K and propose doing so by recreating the C: partitition. Our Oracle software resides on E: (same physical disk) and database files on other disks/partitions. Are there any implications for the Oracle software and database for this upgrade. Are there any steps I need to take pre or post OS upgrade?. In particular I'm wondering about implications for the registry. Any advice/help would be appreciated. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Diagnostic and Tuning Packs
Hello Peter We did a comparison between quest tools and OEM. The bottom line was that all these tools gives you about the same functionality and there is no BIG difference between them. Our manager got a better deal from Oracle so we bought these packs. We hope to start implementing them this quarter. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, May 10, 2002 5:58 PM > Are these addons to OEM worth buying? > > Thanks > Peter Schauss > Northrop Grumman Corporation > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Schauss, Peter > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: A trigger vs. "default value" in a table
Hello Andrey KISS - Why write code to do what oracle does for you? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, May 13, 2002 6:23 PM > Dear list ! > I need a very simple thing : each time a certain field is null during an > insert, to substitiute a string "AAA" instead. > What is better : to write a trigger to do so or to define a default value > for that column in the table ? > Thanks ! > > > DBAndrey > > * 03-9254520 > * 058-548133 > * 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: A trigger vs. "default value" in a table
Hello Andrey KISS - Why write code to do what oracle does for you? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, May 13, 2002 6:23 PM > Dear list ! > I need a very simple thing : each time a certain field is null during an > insert, to substitiute a string "AAA" instead. > What is better : to write a trigger to do so or to define a default value > for that column in the table ? > Thanks ! > > > DBAndrey > > * 03-9254520 > * 058-548133 > * 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: A trigger vs. "default value" in a table
Peter thanks. I forgot that null insert is not converted to the default. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, May 13, 2002 11:03 PM > Hello Andrey > > The correct answer depends on what you want ! > if you can live with null values in the column then > a default for the column is OK, but if you want to > handle a insert with a null then you need a trigger. > Se the little example : > > SQL> create table t (a number, b number default 10); > > Table created. > > SQL> insert into t (a) values (10); > > 1 row created. > > SQL> commit; > > Commit complete. > > SQL> select * from t; > > A B > -- -- > 10 10 > > SQL> insert into t (a,b) values (10, null); > > 1 row created. > > SQL> commit; > > Commit complete. > > SQL> select * from t; > > A B > -- -- > 10 10 > 10 > > > > Yechiel Adar wrote: > > >Hello Andrey > > > >KISS - Why write code to do what oracle does for you? > > > >Yechiel Adar > >Mehish > >- Original Message - > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Sent: Monday, May 13, 2002 6:23 PM > > > > > >>Dear list ! > >>I need a very simple thing : each time a certain field is null during an > >>insert, to substitiute a string "AAA" instead. > >>What is better : to write a trigger to do so or to define a default value > >>for that column in the table ? > >>Thanks ! > >> > >> > >>DBAndrey > >> > >>* 03-9254520 > >>* 058-548133 > >>* 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). > >> > > -- > > /regards > > Peter Gram > > Mobil : +45 2527 7107 > Fax : +45 4466 8856 > > Miracle A/S > Kratvej 2 > 2760 Ma*l?v > http://miracleas.dk > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Peter Gram > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: {9i New Features: Online Reorg or DBMS_REDEFINITION Package}
Got Oracle Update from Xephon today (May
2002).
The lead article is about online redefinition by Sameer
Wadhwa
from NuGenesis Technologies.
His article agrees with you.
Yechiel AdarMehish
- Original Message -
From:
JOE
TESTA
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, May 14, 2002 8:58 PM
Subject: {9i New Features: Online Reorg
or DBMS_REDEFINITION Package}
Welcome to the next installment of 9i New Features, today's topic is
Online changes of objects, specifically we'll cover the new package called
DBMS_REDEFINITION.
The spec for this package is located where all of the other package
sources are:
ORACLE_HOME/rdbms/admin. The file is dbmshord.sql
So what does this package give us? Well it gives the capability to
do online reorganization of a table. Ok so now if you're not confused,
you should be :)
In easy to understand terms, in the past when you wanted to move a
table to a new tablespace, drop a column, add a column, change a column
datatype, it require a exclusive lock on the table during the operation(which
if it was a large table could lock it up for a long time). Well that is
no longer the case, those kinds of changes can be done while DML is still
being applied to the object.
Let's take for an example something that all of us have been asking for
YEARS, the rename of a column.
Look at this code, I've included comments within it so its pretty much
self-explanatory and you can run it against your 9i database to see what if it
really works.
-- BEGINNING OF SCRIPT
---
set serveroutput on size 10;
-- let's drop a couple of tables so if we re-run we won't get
errorsdrop table sales;drop table sales_temp;
-- create a new table, handful of columns with the last one named
incorrectly.
create table sales(sales_id number not null, sales_amount
number(10,2) not null, salesman_id number(5) not
null, tax_amount number(5,2) not null, bad_column_name
varchar2(20) not null);
-- add a PK since for online reorg it's required
alter table sales add primary key(sales_id)
-- insert some data
insert into sales values(1,20,4,5.70,'bogus');insert into sales
values(2,30,6,6.70,'no way');insert into sales values(3,40,7,7.70,'XX
way');insert into sales values(4,50,8,8.70,'YY way');insert into sales
values(5,60,9,9.70,'ZZ way');insert into sales values(6,70,1,0.70,'AA
way');insert into sales values(7,80,2,1.70,'BB way');insert into sales
values(8,90,3,2.70,'CC way');insert into sales values(9,10,4,3.70,'DD
way');insert into sales values(10,25,5,4.70,'EE way');
-- commit the data
commit;
-- run the proc to see if this table can be reorganized online, if we
get an error,-- then its not possible, otherwise we're
good to go.
execute dbms_redefinition.can_redef_table(USER,'SALES');
-- we must create the temp table for this reorg to happen manually,
either with a -- create table statement or via a create
table as select(no rows please to be copied)-- this exercise is
going to be to do a rename on the column, so we need to
create-- the table making sure we have the new column
name
create table sales_temp(sales_id number not
null, sales_amount number(10,2) not null, salesman_id
number(5) not null, tax_amount number(5,2) not
null, good_column_name varchar2(20) not null);
-- have to have a PK on the temp table also.
alter table sales_temp add primary key(sales_id);
-- lets desc the original to see what it looks like before
prompt this is the sales desc before the changedesc sales;
-- ok lets fire up the redefinition, the parms are(SCHEMA, OLD_TBL,
TEMP_TBL,-- then column mapping, notice we're mapping
bad_column_name to good_column_name).
execute
dbms_redefinition.start_redef_table(USER,'SALES','SALES_TEMP',
-'sales_id sales_id, sales_amount sales_amount, salesman_id salesman_id,
-tax_amount tax_amount, bad_column_name good_column_name');
-- at this point its YOUR responsiblity to put the triggers, other FK
constraints(disabled)-- and indexes on the "temp" table before
calling the next part to do the "switch".
-- DO THE OTHER INDEXES, ETC HERE
-- ok time to finish up
execute
dbms_redefinition.finish_redef_table(USER,'SALES','SALES_TEMP');
prompt this is the definition of sales AFTER the changedesc
sales;select * from sales;
--- END OF SCRIPT
---
So what you think, pretty kewl(geek kids spelling)?
Check out the docs on dbms_redefinition for limitations, etc, don't want
to give you allthe answers.
Until next time all hate mail to /dev/null , all good stuff
to [EMAIL PROTECTED]
Re: calling a stored procedure from a sitescope monitor
Chris You wrote "I just want to call it and get the one value it returns." I think that procedure does not return values, functions does. If you want to get value from a procedure you have to pass a parameter that the procedure will return the value in. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 6:33 AM > Has anyone done this? Let's say I have a procedure named foo and want to > call it in a Sitescope monitor. There are no arguments to foo. I just want > to call it and get the one value it returns. Freshwater doesn't have any doc > for this and they've been sitting on my request for information for a week. > > They do have a document with an example for SQL Server but nothing for > Oracle. If Oracle were like SQL Server, you'd just put the name of the > procedure in the query line on a typical database monitor, but I tried that > and it doesn't work. > > We're using the jdbc thin driver to a version 8.1.7.2 instance if it makes > any difference. > > Thanks. > > -Chris > > _ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Chris McGrail > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 drop a datafile from a tablespace quickly
you wrote: < there to claim his 42 virgins in Paradise?> This is a common mistake. Read the following to know the truth: Humor . . . bin Laden's fate? After getting nailed by a Daisy Cutter, Osama made his way to the Pearly Gates. There, he is greeted by George Washington. "How dare you attack the nation I helped conceive!" yells Mr.Washington, slapping Osama in the face. Patrick Henry comes up from behind. "You wanted to end America's liberty, so they gave you death." Henry punches Osama in the face. James Madison comes up next and says, "This is why we allowed the federal Government to provide for the common defense" and kicks Osama in the groin. Osama is the subject to similar beatings from John Randolph of Roanoke, James Monroe and 67 other people who have the same love for liberty and America. As Osama writhes in pain on the ground, Thomas Jefferson picks him up and hurls him back to the gate to be judged. As Osama awaits his journey to his final very hot destination, he screams "This is not what I was promised!" An angel replies "I told you there would be 72 Virginians waiting for you. What did you think I said?" Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 11:13 PM > I did not know that. > > Didn't Douglas Adams recently adjourn to the right hand of Hubble, there to > claim his 42 virgins in Paradise? > > Scott Shafer > San Antonio, TX > 210-581-6217 > > > > -Original Message- > > From: Tim Gorman [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, May 15, 2002 3:38 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: How to drop a datafile from a tablespace quickly > > > > Scott, > > > > Did you hear that Douglas Adams was asked recently (i.e. a few years ago) > > how he knew the "Hubble Constant" was (roughly) 42, back when he wrote the > > "Hitchhiker's Guide To The Galaxy" series back in the 60s and 70s? The > > Hubble Constant (having to do with the rate of expansion of the universe, > > I > > think) had just been discovered to be 42, sometime in the mid-90s, I > > believe... > > > > His response was something along the lines of "Well, actually I didn't > > know, > > of course. It's just that I needed an answer to the question 'What is the > > meaning of life, the universe, and everything?' and 42 seemed like an > > appropriate answer. Just an ordinary, sort of smallish number"... > > > > I have to go back and re-read those... > > > > -Tim > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, May 15, 2002 2:03 PM > > > > > > > Exactly my point. The answer is 42. > > > -- > 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ORA-2085
At last something that I have experience in. Just do the following: On the target database issue the following: Alter database rename global_name to donot_trigger; We had the same problem. This solves it. The global name has no other influence. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 6:08 PM > Yes, I "inherited" this, and I am setting up Multimaster > Advanced Replication, setting global_names=false isn't an > option. I have suggested moving the donotfiretrigger logic > into the trigger, which has some initial support. For the > moment, we are changing the code to point to a link with the > same name as the service name (which has obvious limitations, > so hopefully a real fix will get done). > > I was really hoping there might be another workaround bandaid > though, as I really don't want the "fix" to end up permanent. > > Thanks, > > John P Weatherman > Database Administrator > Replacements Ltd. > > > > -Original Message- > Sent: Tuesday, May 21, 2002 11:23 AM > To: Multiple recipients of list ORACLE-L > > > My guess is that you "inherited" an environment > where the DB-Link was setup that way [link-name different > from DB-name] . and then, sometime later, > you set GLOBAL_NAMES=TRUE > > Well you have no choice : > "// *Action: create a database link with the same name as the database it > > // connects to, or set global_names=false." > > Are you setting up Advanced Replication [MultiMaster] > or Simple Replication [Snapshots] ? I believe that > Simple Replication does not mandate GLOBAL_NAMES=TRUE. > > > Hemant K Chitale > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, 21 May, 2002 9:23 PM > > > > Hi all. > > > > I have recently had to enable global_names in order to set up a > > replicated environment. The application uses a database link to > > reconnect to the database under a differant user id (I inheirited > > this, I had nothing to do with the design!). Appearantly, > > global_names has a prblem with this... > > > > SQL> select * from [EMAIL PROTECTED]; > > select * from [EMAIL PROTECTED] > >* > > ERROR at line 1: > > ORA-02085: database link DONOT_TRIGGER.WORLD connects to DRL2.WORLD > > > > SQL> !oerr ORA 2085 > > 02085, 0, "database link %s connects to %s" > > // *Cause: a database link connected to a database with a different name. > > // The connection is rejected. > > // *Action: create a database link with the same name as the database it > > // connects to, or set global_names=false. > > > > So, does anybody have any work arounds or ideas how I can get this > > thing working again? > > > > TIA, > > > > John P Weatherman > > Database Administrator > > Replacements Ltd. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: John Weatherman > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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: Hemant K Chitale > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Weatherman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 5
Re: partitioning
Title: Message None It is an option (Means you pay). Yechiel AdarMehish - Original Message - From: Cunningham, Gerald To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 22, 2002 6:38 PM Subject: partitioning Hi all, Does anybody know with what version of Oracle partitioning was included at no extra cost? Thanks! - Jerry
Re: ORA-2085
Hello Dennis It DOES. We rebuilt our databases number of times during system test. We are using vendor supplied scripts to build the database from an export file. We run the exactly same script on both machines and got two databases that are exactly the same. However on the backup machine we run this command after building because you can not have two databases having the same global name when working with global_names = true (of course, that the whole point of the parameter). After this we rebuild master to master replication - no problems. Also as part of the system test we moved the users ( parameter in the application) to the backup machine and they worked without problems, although the global name was different. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 22, 2002 7:28 PM > Yechiel - If this does what I think it does, your value to postings ratio > just soared! > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Wednesday, May 22, 2002 11:49 AM > To: Multiple recipients of list ORACLE-L > > > At last something that I have experience in. > > Just do the following: > > On the target database issue the following: > Alter database rename global_name to donot_trigger; > > We had the same problem. This solves it. > The global name has no other influence. > > Yechiel Adar > Mehish > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 6:08 PM > > > > Yes, I "inherited" this, and I am setting up Multimaster > > Advanced Replication, setting global_names=false isn't an > > option. I have suggested moving the donotfiretrigger logic > > into the trigger, which has some initial support. For the > > moment, we are changing the code to point to a link with the > > same name as the service name (which has obvious limitations, > > so hopefully a real fix will get done). > > > > I was really hoping there might be another workaround bandaid > > though, as I really don't want the "fix" to end up permanent. > > > > Thanks, > > > > John P Weatherman > > Database Administrator > > Replacements Ltd. > > > > > > > > -Original Message- > > Sent: Tuesday, May 21, 2002 11:23 AM > > To: Multiple recipients of list ORACLE-L > > > > > > My guess is that you "inherited" an environment > > where the DB-Link was setup that way [link-name different > > from DB-name] . and then, sometime later, > > you set GLOBAL_NAMES=TRUE > > > > Well you have no choice : > > "// *Action: create a database link with the same name as the database it > > > // connects to, or set global_names=false." > > > > Are you setting up Advanced Replication [MultiMaster] > > or Simple Replication [Snapshots] ? I believe that > > Simple Replication does not mandate GLOBAL_NAMES=TRUE. > > > > > > Hemant K Chitale > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Tuesday, 21 May, 2002 9:23 PM > > > > > > > Hi all. > > > > > > I have recently had to enable global_names in order to set up a > > > replicated environment. The application uses a database link to > > > reconnect to the database under a differant user id (I inheirited > > > this, I had nothing to do with the design!). Appearantly, > > > global_names has a prblem with this... > > > > > > SQL> select * from [EMAIL PROTECTED]; > > > select * from [EMAIL PROTECTED] > > >* > > > ERROR at line 1: > > > ORA-02085: database link DONOT_TRIGGER.WORLD connects to DRL2.WORLD > > > > > > SQL> !oerr ORA 2085 > > > 02085, 0, "database link %s connects to %s" > > > // *Cause: a database link connected to a database with a different > name. > > > // The connection is rejected. > > > // *Action: create a database link with the same name as the database it > > > // connects to, or set global_names=false. > > > > > > So, does anybody have any work arounds or ideas how I can get this > > > thing working again? > > > > > > TIA, > > > > > > John P Weatherman > > > Database Administrator > > > Replacements Ltd. > > > -- > > > Please see the official ORACLE-L FAQ: http://www.ora
Re: patching 8.1.7
I think that this db will be among the last to upgrade. Any bugs and (wolla) no more OEM or no more backups and restore. ! Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Loader
How about using external table? You define the table as external having one field. I think that select * from such table will bring you the lines in order and then you can do whatever you want with the data. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:33 PM > Client is not accepting to use the utl_file for reading data from the file. > i have to fetch each line from the file and process it for storing the > information in various tables. so apart from sql loader can u suggest other > method (excluding utl_file) for doing the same operation. > > Best Regards, > Shankar > > -Original Message- > Sent: Thursday, May 16, 2002 3:23 PM > To: Multiple recipients of list ORACLE-L > > > >Hi friends, > > I have to load a input file into a oracle > >table . The table has only > >one field which will store each line as a single > >row . The order of the file > >is very important for my further process. > > Perhaps you should re-read a paper published in 1970 in 'Communications of > the ACM' by an Edward Codd. IMHO you do not need a relational database at > this stage of your process. > > Regards, > > Stephane Faroult > Oriole > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroul > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Warehouse Hardware Recommendations
IBM mainframe. Nothing beats these dinosaurs. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 6:08 AM > Our data warehouse box is nearing it's max capacity so we are looking for > options for an upgrade. The current box is maxed out so it will be a > forklift upgrade. Since we are less than satisfied with our current vendor > we are open to changing platforms. I don't want to mention the current > vendor so as not to prejudice any suggestions. What I would like to know is > what hardware (server and storage) folks are using for their data warehouse. > We are projecting our system to be around 10TB by the end of this year with > continued growth (3-5yr) projected at 70TB. > > Thanks > > MB > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Brooks > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rename Column in 9iR2
Upgrade to 9iR2 today. Rename column does not work in 9.0.1. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 22, 2002 9:30 PM > If those times are right... its a functionality you > should not live without, its a direct money saver. > Upgrade to 9i today! > > hats off to Oracle marketing... "if and when the > database sales lose traction... we will release RENAME > COLUMN"... and 20 years later... here it is. > > Keith > > Date: Wed, 22 May 2002 10:41:32 -0800 > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Reply-to: [EMAIL PROTECTED] > Organization: Fat City Network Services, San Diego, > California > > > Kevin, > I appreciate your testing efforts. Now to convince > the bean-counters > to upgrate to 9i. > Ron > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 05/22/02 02:08PM >>> > I reran my test. with 250,000 rows in the table. It > took a whopping > 0.25 > seconds to complete. > > -Original Message- > Sent: Wednesday, May 22, 2002 12:59 PM > To: Multiple recipients of list ORACLE-L > > > Kevin, > Yes but does it work with data in the column?, I do > not have 9i set > up > yet. If it works as you describe with data in the > column it will > really > help with the multi million row tables that "they" > want to rename a > column after a release of a new lotto game. > thanks, > for the test and update. > Ron > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 05/22/02 10:38AM >>> > Summary: it works! > > SQL> SELECT * FROM v$version; > > BANNER > > Oracle9i Enterprise Edition Release 9.2.0.1.0 - > Production > PL/SQL Release 9.2.0.1.0 - Production > CORE9.2.0.1.0 Production > TNS for Solaris: Version 9.2.0.1.0 - Production > NLSRTL Version 9.2.0.1.0 - Production > > SQL> create table test_table (wrong_name > VARCHAR2(40)); > > Table created. > > SQL> alter table test_table rename column wrong_name > to right_name; > > Table altered. > > SQL> desc test_table; > Name Null? > Type > - > > RIGHT_NAME > VARCHAR2(40) > > SQL> > > Kevin Toepke > [EMAIL PROTECTED] > > > > __ > Do You Yahoo!? > LAUNCH - Your Yahoo! Music Experience > http://launch.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Keith Peterson > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
news server
I am looking for the address of oracle news server. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ORA-2085
Been there, Done that, Works in production. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 3:33 PM > > I'd never have thought that this was possible > in Advanced Replication > > Hemant K Chitale > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, 23 May, 2002 12:48 AM > > > > At last something that I have experience in. > > > > Just do the following: > > > > On the target database issue the following: > > Alter database rename global_name to donot_trigger; > > > > We had the same problem. This solves it. > > The global name has no other influence. > > > > Yechiel Adar > > Mehish > > - Original Message - > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Sent: Tuesday, May 21, 2002 6:08 PM > > > > > > > Yes, I "inherited" this, and I am setting up Multimaster > > > Advanced Replication, setting global_names=false isn't an > > > option. I have suggested moving the donotfiretrigger logic > > > into the trigger, which has some initial support. For the > > > moment, we are changing the code to point to a link with the > > > same name as the service name (which has obvious limitations, > > > so hopefully a real fix will get done). > > > > > > I was really hoping there might be another workaround bandaid > > > though, as I really don't want the "fix" to end up permanent. > > > > > > Thanks, > > > > > > John P Weatherman > > > Database Administrator > > > Replacements Ltd. > > > > > > > > > > > > -Original Message- > > > Sent: Tuesday, May 21, 2002 11:23 AM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > My guess is that you "inherited" an environment > > > where the DB-Link was setup that way [link-name different > > > from DB-name] . and then, sometime later, > > > you set GLOBAL_NAMES=TRUE > > > > > > Well you have no choice : > > > "// *Action: create a database link with the same name as the database > it > > > > // connects to, or set global_names=false." > > > > > > Are you setting up Advanced Replication [MultiMaster] > > > or Simple Replication [Snapshots] ? I believe that > > > Simple Replication does not mandate GLOBAL_NAMES=TRUE. > > > > > > > > > Hemant K Chitale > > > > > > - Original Message - > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > Sent: Tuesday, 21 May, 2002 9:23 PM > > > > > > > > > > Hi all. > > > > > > > > I have recently had to enable global_names in order to set up a > > > > replicated environment. The application uses a database link to > > > > reconnect to the database under a differant user id (I inheirited > > > > this, I had nothing to do with the design!). Appearantly, > > > > global_names has a prblem with this... > > > > > > > > SQL> select * from [EMAIL PROTECTED]; > > > > select * from [EMAIL PROTECTED] > > > >* > > > > ERROR at line 1: > > > > ORA-02085: database link DONOT_TRIGGER.WORLD connects to DRL2.WORLD > > > > > > > > SQL> !oerr ORA 2085 > > > > 02085, 0, "database link %s connects to %s" > > > > // *Cause: a database link connected to a database with a different > > name. > > > > // The connection is rejected. > > > > // *Action: create a database link with the same name as the database > it > > > > // connects to, or set global_names=false. > > > > > > > > So, does anybody have any work arounds or ideas how I can get this > > > > thing working again? > > > > > > > > TIA, > > > > > > > > John P Weatherman > > > > Database Administrator > > > > Replacements Ltd. > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > -- > > > > Author: John Weatherman > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > &g
Re: Data Warehouse experts, a simple question for you| Outdated?
That's not panicking, just common sense. Too many data warehouse projects went down the drain so you need to learn all you can before starting such project. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 3:13 PM > Dennis, > > I have on my desk, all in varying stages of being read: > Inmon's book Building the Data Warehouse (very understandable) > > Kimball's articles from his site and from the Intelligententerprise.com > site (somewhat understandable, I think you need a base from which to > read his articles). His books are on order and should arrive today > > Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't > started, as Tim tells me to read it AFTER I have a basic understanding > of data warehousing) > > The Oracle8i Data Warehousing documentation (actually pretty readable > and understandable) > > Ya think I might be over-researching this stuff and panicking a bit? > > Rachel > > --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > > Ian, > > > > - In the beginning was the data warehouse and yeah it was good. It > > would > > solve all corporate problems and would encompass all corporate data > > so all > > corporate minions would see the same data. > > - But yeah it took so long to create the corporate data warehouse > > that > > management despaired and canceled the project. Or by the time the > > monster > > data warehouse came blinking and straining into the daylight all the > > users > > said that the company had evolved in the meanwhile and the warehouse > > was > > obsolete. > > - So data warehouses gained a bad rep from corporate managers and > > yeah > > none would fain to propose the conception of a data warehouse for > > fear of > > castigation. > > - Then some marketing interns bribed a DBA to send them data > > weekly. And > > they stored this data in a database and lo, their superiors were > > impressed. > > - Everyone was in awe of the marketing database, but none dared > > tarnish it > > by speaking the name which shall not be mentioned, so it was > > christened a > > "data mart". > > - And lo, the data marts multiplied and were fruitful. And the DBA > > cursed > > the day she was weak and did give data to the marketing interns. > > - Then another prophet did arise and did challenge the prophet > > Kimball. > > His name was Inmon. And he did claim to be the progenitor of data > > warehouses. And therefore all should do data warehousing his way and > > use his > > terms. > > - And great confusion arose over the land. And many debates ensued, > > including some face to face between Inmon and Kimball. And terms such > > as > > Operational Data Store (ODS) were bandied about. > > - And some said that queries against the ODS were acceptable and > > others > > deemed them forbidden. And some said that if it looks like a data > > warehouse > > and smells like a data warehouse it verily indeed is a data > > warehouse. > > - And consultants warred against consultants and did call the other > > consultants ignoramuses in front of management such that nobody knew > > what > > anybody was talking about. > > - And the DBAs said that creating a data warehouse or data mart was > > not > > nearly as hard as figuring out what to call it. > > > > The moral of the story is to figure out what you need to do and be > > aware > > that different authors use the same terms for different purposes and > > coin > > their own terms. Personally, I have understood everything that > > Kimball has > > written and have never been able to read one of Inmon's articles to > > the end. > > But maybe that is just me. > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > > > -Original Message- > > Sent: Wednesday, May 22, 2002 2:38 PM > > To: Multiple recipients of list ORACLE-L > > Outdated? > > > > > > Ian, > > > > Good question. I think that I've seen more recenct references in > > articles > > that state the current thinking of DW/DM. I'm sure that I've seen > > Inmon > > refer to them that way, or maybe it was Richard Winter? > > > > Anyway, I guess that part is a bit dated. There is so much good > > information > > in that book though, that it's still worth its weight in gold.
Re: so when did you switch from NT to unix for oracle
Hello Joe I think that the main reason is response time. An NT machine can get only 4 CPUs. If you have all the CPUs and memory and the NT does not carry the load then it is time to consider a change. A change can be to Unix or to clustering. If you are all NT shop then I would consider clustering. In a mixed shop the move to Unix is easier, otherwise you will also need system administrator and have learning curve. Just my 0.02$ Yechiel AdarMehish - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Thursday, May 23, 2002 3:48 PM Subject: so when did you switch from NT to unix for oracle A question has been posed to me, when to switch from NT to unix for oracle. Is it when the NT box starts getting out of memory issues, number of transactions, size of db? just looking for some ball park answers. thanks, joe
Re: news server
Sorry, I wish that e-mails had a way to attach what I wanted to say. I meant news group on the subject of oracle. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 3:53 PM > > On 2002.05.23 07:08 Yechiel Adar wrote: > > I am looking for the address of oracle news server. > metalink.oracle.com > -- > Mladen Gogala > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: news server
Thanks Joe Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 6:23 PM > comp.databases.oracle.server > comp.databases.oracle.tools > comp.databases.oracle.misc > comp.databases.oracle.marketplace > > I access these via groups.google.com > > -Joe > > --- Yechiel Adar <[EMAIL PROTECTED]> wrote: > > Sorry, I wish that e-mails had a way to attach what I wanted > > to say. > > > > I meant news group on the subject of oracle. > > > > Yechiel Adar > > Mehish > > - Original Message - > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Sent: Thursday, May 23, 2002 3:53 PM > > > > > > > > > > On 2002.05.23 07:08 Yechiel Adar wrote: > > > > I am looking for the address of oracle news server. > > > metalink.oracle.com > > > -- > > > Mladen Gogala > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Mladen Gogala > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) > > 538-5051 > > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > > in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (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: Yechiel Adar > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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!? > LAUNCH - Your Yahoo! Music Experience > http://launch.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe Raube > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 backup question.
Title: RE: Database backup question. You missed the last one. He is PHB again. Yechiel AdarMehish - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Friday, May 24, 2002 11:43 PM Subject: RE: Database backup question. Paul, There's a comic strip about office life called Dilbert. PHB stands for Pointy-Hair Boss. You can check it out at the site below. This week the PHB has been demoted back to worker-bee. http://www.dilbert.com/ Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Sherman, Paul R. [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 3:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Database backup question. Jared, What in the W is a PHB ? Inquiring minds want to know. Thank you, Paul Sherman DBA Elcom, Inc. email - [EMAIL PROTECTED]
Covert tnsnames.ora to OID
Hello All How can I covert all the names from tnsnames.ora to OID? I do not feel like entering all this data again, by hand, one by one. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Financials Client question
Hello Maria I got a call just yesterday about 8.1.6 on NT not installing on P4 machine. I researched metalink and they have some points. (BTW, we did DLL upgrade. Problem solved). However, all the fixes are upgrading a DLL or the JInitiator. So, I do not think that the fix will prevent you from working with machines that are less then P4. Make them prove their point. !!! Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, May 27, 2002 10:18 AM > We have outsourced implementation and setup of a scaled down Oracle > Applications 11i (rel 11.5.5) for Suse Linux... > I have received a memo from the implementation team's application DBAs > and they > have informed me of a certain limitation for the specs of the client > PC's. > I was informed that the clients must either be Pentium 3s and below or > all Pentium 4s. > Mixed network of Pentium 3 and 4s will not work. I was told it was > because of the JInitiator being invoked from the server. > > to quote: > "Let us further clarify that, through our proven installation/setup > experience, the Shooman Application works on a network environment of > "mixed" Pentium 3s and earlier computers. As of this writing, we have > yet > to prove that Shooman works properly in a network of Pentium 3 (or > older) > workstations mixed with Pentium 4s. However, we have proven that the > application works if ALL workstations are Pentium 4s. It therefore > follows > that, should you purchase the latest Pentium 4 computers, you must issue > > ALL your Shooman users with this model in order for the system to work > properly." (Shooman refers to the Oracle Application residing on a > server named Shooman) > > I am completely ignorant of Oracle Applications as I have 0 experience > in managing it. > I'd really appreciate your opinion if we are being fooled or not. > I am very concerned about this because as we all know PCs become > obsolete in months... > time will come we will have to change PCs...maybe move on to Pentium > 5/6... > This can pose a problem for us. > > Thanks a lot! > -- > Maria Aurora VT de la Vega OCP > Database Specialist > Philippine Stock Exchange, Inc. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Maria Aurora VT de la Vega > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora-918
Hello list I need help in solving ORA-918: Ambiguous field reference. All the fields are schema.tablename.fieldname. The SQL has 3 inline queries that are the same but with different months in the where clause. Simplified version: select acct . from tab1, tab2, where ... and acct in (select acct from tab1 where balance > 7000 and month = 2) and acct in (select acct from tab1 where balance > 7000 and month = 3) and acct in (select acct from tab1 where balance > 7000 and month = 4) group by acct; Now the query runs OK with only one sub query. Oracle 8.1.6.3.4 on NT. I already replaced the three IN with 3 = select count() where month in (2,3,4) and it works, but I would like to know why the original didn't. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: is my table analyzed with compute/estimate
Hello Very simple. Select sample_size from all_tables. The field contain NULL for unanalyzed tables, 0 (zero) for compute statistics and sample size from estimate statistics. Oracle 8.1.6.3.4 Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 29, 2002 10:13 AM > Hello All, > > Can somebody help me on this how to know whether my > table was analyzed last time with COMPUTE / ESTIMATE. > > what I guess is , if the num_rows (dba_tables) are > equivalent to count of the rows in my table, I guess > it was analyzed with compute statistics. > > I think it is not accurate to find it. > > Can somebody through somelight on this how to know > that. > > Regards, > Srinivas > > __ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: kommareddy sreenivasa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ad-hoc update check
Hello Dennis 1) Fight! Do not let developers into production. 2) Offer to build semi production DB and copy data daily/weekly to this DB. The developers can see production data but can not hurt production. 3) I all else fails (RTFM :-) ) grant them only READ access to the database and put them on low resource group so one Cartesian select will not bring the production to halt. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 29, 2002 12:25 AM > Hi folks - > I have received a stream of requests from developers/production support ( > yep, same group, dont ask ) to do ad-hoc data massaging in the production > databases. Since I don't know the applications that well, it's hard for me > to push back these requests when told that if the script don't get run > today, marketing department won't be able to use the system etc. I wonder > if other people on the list have the same problem and I am thinking about > coming up with a document for the developers to fill out making sure the > request won't hose up the database. I wonder how other shops deal with > issues like these and can you let me know what you can do to check for > potential issues with a sql script. > > TIA > > Dennis Meng > Database Administrator > Focal Communications Corp. > > -- > 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ora-918
Title: RE: ora-918 Thank Jerry, but month represents field named ia_validity_month. The sql in my message is just to give you an idea what the problematic sql looks like. Yechiel AdarMehish - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 29, 2002 5:18 PM Subject: RE: ora-918 Yechiel, "MONTH" is a reserved word in PL SQL and you have a field name "month". Could that be the problem? Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message----- From: Yechiel Adar [SMTP:[EMAIL PROTECTED]] Hello list I need help in solving ORA-918: Ambiguous field reference. All the fields are schema.tablename.fieldname. The SQL has 3 inline queries that are the same but with different months in the where clause. Simplified version: select acct . from tab1, tab2, where ... and acct in (select acct from tab1 where balance > 7000 and month = 2) and acct in (select acct from tab1 where balance > 7000 and month = 3) and acct in (select acct from tab1 where balance > 7000 and month = 4) group by acct; Now the query runs OK with only one sub query. Oracle 8.1.6.3.4 on NT. I already replaced the three IN with 3 = select count() where month in (2,3,4) and it works, but I would like to know why the original didn't. Yechiel Adar Mehish
For real Gurus only
Hello Gurus I got this link through SAG-L. Have a try. www.quest-pipelines.com/newsletter-v3/Crossword_Puzzles/puzzle0502.html Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: updated rows count
before the update: Select count(*) from table where ... Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 3:48 PM Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this big update. Thanks. update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how can listener list on two ports for the same db?
Title: how can listener list on two ports for the same db? Hello Helmut You need to configure the listener to listen on ONE host with 2 ports. The machine name is the same. You separate the connections via tnsnames.ora on the client side. I got a call today that one of our application server can not connect to a database after tech people move an application server to another place. Connected to the database from my PC - OK. I activated tnsping from the server itself and could not get response. I changed the tnsnames, on the application server, to access a second network card and all is well. I accessed the database via another NIC without any change to the database server. Yechiel AdarMehish - Original Message - From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 29, 2002 11:28 AM Subject: how can listener list on two ports for the same db? Hi! We have a db server (in a cluster) with two NICs and two IP-Adresses (i.e. logical names in the cluster). How do I configure the listener so that it listenes for both logical names of the machine? LISTCMDB = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = kfplcmdb)(PORT = 1522)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = kfalcmdb)(PORT = 1522)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_CMDB)) ) ) ) SID_LIST_LISTCMDB = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc_CMDB) (ORACLE_HOME = /cmdb/u0x/u01/app/oracle/product/8.1.7) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = CMDB) (ORACLE_HOME = /cmdb/u0x/u01/app/oracle/product/8.1.7) (SID_NAME = CMDB) ) ) Sitting on our RMAN database machine, pinging kfplcmdb does not work but pinging kfalcmdb works fine. On th emachine to be backed up: why can't I use kfalcmdb in the listener.ora file? The listener works fine when using kfplcmdb. This is 8.1.7 on Solaris 8. Thanks, Helmut
Re: So, What is a 'Production DBA'?
Hello Dennis My path: Computer operator, duveloper, system programmer, DBA. About developers: they do not see the whole picture, do not understand limitations etc.. I had a call from the guy who is charge of a project. The database creates about 10 MB of archive logs every 3-4 minutes, and is on remote site. He come over to discuss the possibility of implementing a stand by database at our main site. When I asked him the bank width to the remote site he told me: fast, 256KBps. A simple calculation was enough to explain to him that he creates much more data then the pipe line can carry. Boy was he suprised. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 6:51 PM Gene - C'mon ya gotta give us more details. I have heard that most DBAs either come from developers or sys admins, but I can't recall a former sys admin, or maybe they just didn't mention it. I am curious about your observations on the best and worst qualities of each variety. I feel that a former developer might make a better development DBA because he/she might understand things from the developer's perspective. I could see where it might take a developer turned production DBA awhile to understand a systems perspective. If the developer only created code on a PC, it might take awhile to really get a system-wide perspective (or never). Maybe you'll give me a better appreciation for my sys admin. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 11:11 AM To: Multiple recipients of list ORACLE-L Actually some of the worst DBA's come from the development track. IMHO, the best DBAs are from the systems world :). Of course this doesn't mean all systems ppl make good dba's or all developers make bad dba's. This is only from my experience. Gene *Let the Wars begin, NOT* >>> [EMAIL PROTECTED] 05/30/02 11:08AM >>> I feel that it is hard to draw the lines between Application and Production DBA's. For example where would you place the DBA that "maintains" SAP? Without the application knowledge he/she/it wouldn't get very far. Also I have been wondering something and this thread seems a good place to ask. Is there a historical feud between DBA's and Developers? Coming from a consulting/software house I find some of the comments funny but can't believe that there is that quantity of bad developers. Most of the DBA's we deal with have come up through the ranks and started as developers. >From: "Ron Rogers" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: So, What is a 'Production DBA'? >Date: Thu, 30 May 2002 04:48:29 -0800 > >Rachel, > I agree with your short list of the areas of responsibilities but I >would change the word "application" to "development". An application >DBA, from the people I have talked to, is quite busy performing the >upgrades and patches that accompany the Oracle Applications. The >applications database generally has many, many tables, triggers and >constraints and is constantly the target for upgrades and patches from >Oracle. It is a time consuming task as the majority of the different >applications (financial, HR, Purchase Order, etc) have "hooks" into each >different package and are so intertwined that any small fix in one >involves patches for the others. There are only a few user defined >tables as each package has their own named tables that are partially >shared between packages. There is very little if any work you can do on >the application code because it is so intertwined and customized when it >is installed. Any upgrades require that the "customization" be reworked >to make it fit into the new version of the application package. > It takes a longer time to install than a standard database, on the >magnitude of days, and requires a dedicated and investigative mind set >to maintain. > >To the list you created I would add: >Help desk call recipient, >network support, >client support, >software and hardware evaluation, >"whipping" post, >IT team member (possibly team leader), >self driven, >office coffee maker, >consumer of various liquids. > >Ron >ROR mª¿ªm > > >>> [EMAIL PROTECTED] 05/29/02 04:50PM >>> >that's not a bad definition :) > >seriously, everyone will have their own definition, mine is: > >production dba -- responsible for all databases that are considered >"production". this includes but is not limited to: > >backups >recovery testing >contingency testing >production performance tuning (sho
Re: undeliverable email - Yo Jared
Dave I do not get these. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 4:43 PM Jared, I have been getting these for a few weeks now on all of my posts. It is only for the name listed below. If anyone else is getting these could this name be removed from this list. These undeliverable emails clutter up my Off-Topic emails. ;o) Thanks, Dave > -Original Message- > From: System Administrator > Sent: Thursday, May 30, 2002 8:36 AM > To: [EMAIL PROTECTED] > Subject: Undeliverable: Adding processor to Oracle server > > Your message did not reach some or all of the intended recipients. > > Subject: Adding processor to Oracle server > Sent: 5/30/2002 8:54 AM > > The following recipient(s) could not be reached: > > [EMAIL PROTECTED] on 5/30/2002 9:36 AM > The e-mail account does not exist at the organization this message was sent to. Check the e-mail address, or contact the recipient directly to find out the correct address. > < mx1.xnet.com #5.1.1> > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Using DUAL
I am the one that started it. I saw that each select from dual cost about 4-5 buffer gets. Define view on x$dual and select from that view, no buffer gets. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 7:48 PM > Dan: > The discussion was recent, but I cannot find reference to it. > I kinda thought Kirti was involved in the thread, and it had something to do > with creating an x$dual table as a workround to hammering dual. > > Sorry I can't remember any more . . . > > Barb > > > > -- > > From: Fink, Dan[SMTP:[EMAIL PROTECTED]] > > Reply To: [EMAIL PROTECTED] > > Sent: Thursday, May 30, 2002 10:23 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Using DUAL > > > > The developers here have a fondness for using DUAL for simple operations > > (select count(*) from dual is executed 1+ times per day). I recall a > > passing comment somewhere/sometime that there are performance issues with > > accessing DUAL. Of course, now that I need to provide some information to > > the developers, I can't recall the comment or find documentation. > > > > Any assistance is greatly appreciated. > > > > Daniel W. Fink > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Baker, Barbara > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: updated rows count
OPS, sorry I thought that you mean one update that updates about 20,000 rows. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 5:04 PM > before the update: > Select count(*) from table where ... > > Yechiel Adar > Mehish > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Thursday, May 30, 2002 3:48 PM > > > Hi All! > My client run big update 20,000 statements. I need to know how many rows was > updated (it's could be any number). > I thinking about triggers , but this table can be updated not only with this > big update. Other users can update rows too. > I need to know updated rows number just for this big update. > Thanks. > > update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', > atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where > ataltnbr='000'; > update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= > 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where > ataltnbr=''; > update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', > atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where > ataltnbr='0296'; > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Greg Faktor > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jr.DBA, Mid level DBA, Sr.DBA
Salary ! Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 8:08 PM > Hello: > Out of curiosity how would you classify a Jr. DBA, a Mid Level DBA, and a > Sr. DBA? I know how our HR department makes the division but would be > interested in knowing how other people might classify the differences. > > Regards, > Jay > > > _ > Join the worlds largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jay Wade > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jr.DBA, Mid level DBA, Sr.DBA
Title: RE: Jr.DBA, Mid level DBA, Sr.DBA We Since I live in Israel I do not know the salaries ranges. Senior DBA lives in Spain Junior DAB lives in England Midlevel DAB lived 200 years ago in Europe. Yechiel AdarMehish - Original Message - From: Richard Huntley To: Multiple recipients of list ORACLE-L Sent: Thursday, May 30, 2002 10:07 PM Subject: RE: Jr.DBA, Mid level DBA, Sr.DBA Yechiel...now I'm curious...where would you say (or anyone else reading this) salary ranges should fall for each (jr, mid-level and senior DBA's), other than senior DBA's maxing out at infinity? :) -Original Message- From: Yechiel Adar [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: Jr.DBA, Mid level DBA, Sr.DBA Salary !!!!! Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 8:08 PM > Hello: > Out of curiosity how would you classify a Jr. DBA, a Mid Level DBA, and a > Sr. DBA? I know how our HR department makes the division but would be > interested in knowing how other people might classify the differences. > > Regards, > Jay > > > _ > Join the worlds largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jay Wade > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: * Certified Oracle DBAs Needed in the Dallas area..
So, If I am working a long time why should I now quit and move to work with them? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, May 31, 2002 4:19 PM > Great Company located in Greater Dallas, Texas area (Richardson) needs 2 > CERTIFIED (OCP) > Oracle DBAs for full time staff positions. > > PLEASE Do Not send your resume for this position UNLESS you are fully > certified and > have the skills outlined below for this position. > > Please Do Not send your resume unless you have a stable work history. > Candidates whose work history includes frequent job changes cannot be > considered. > If you are employed by a consulting company you should have a long term > project history. > > These are full time staff positions so no sub-contractors or third parties > please. > > No H-1B candidates please. > > Position #1- Oracle OCP DBA > Salary: 75-90K/yr > Start Date: immediately > > Position # 2- Oracle OCP DBA Consultant..permanent position > Salary: 75-90K/yr > Start Date: immediately > * This position will be up to 100% travel (limited to TX, OK, LA, and Arkansas > only). All expenses will be reimbursable. > > The overview of qualifications for both of the above listed OCP's are as > follows: > > REQUIRED: Oracle OCP certification, 3+ yrs. OCP DBA experience, Oracle > Database 8.x, 8I > > DESIRED: Oracle PL/SQL, SQL, JDeveloper, Developer 6I, OEM, Java, C++, > Windows NT/2000, Unix, HP > > JOB DESCRIPTION: This technical consultant position will be required to > support many clients, with a broad range of disciplines. Must be a > self-starter, excellent communication skills along with a strong technical > expertise. This position requires strong consulting skills (i.e. some > project management, technical leadership, background with multiple > methodologies), complete development life cycle experience as well as a > proven expert level in the following Oracle disciplines: > > Database Administration, Performance Tuning, Backup/Recovery Strategies, > Installation/Upgrades, PL/SQL development (stored procedures, packages, > database triggers, etc..), Oracle Networking (SQL*Net, Net8) > > For immediate consideration, please send your resume as a Word attachment to: > OraStaff, Inc. > Email: [EMAIL PROTECTED] > Please use job code: One/Dallas/OCP DBA/B. Law (along with the # of the > position interested in) > ph: 1-800 -549-8502 > > All Submissions are handled in confidence. > > *We pay referral fees. > So please contact me if you know of anyone who would be qualified/interested > in the posiition described above- if it is not a match for your skills. > Thanks, > Bill Law > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: OraStaff > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jr.DBA, Mid level DBA, Sr.DBA
Hello Itiu You wrote: We have a saying: zillions flies can not be wrong, eat shit. BTW - We use NT servers. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Sunday, June 02, 2002 2:43 AM > What's wrong with M$FT. Most people use it : > The majority cannot be wrong. > What's wrong with you guys. If it works, then use it. If you can make it > work, then use it. If you can pretend that it works, then use it too. > > ltiu > > On Saturday 01 June 2002 14:53, you wrote: > > I beg to differ. > > > > All Real DBA's should be "platform independent". > > (and if that platform comes from M$FT, they should probably be undergoing > > intense therapy). > > > > -- James > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ltiu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Archiver process in 7.3.4
Look in v$database column log_mode. Tested on 7.3.4 on NT. Work also in 8.1.6 and 9.0.1 Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 7:13 PM > Anybody knows how to get status of archiver process programmatically in > Oracle 7.3.4? > This information is available from v$instance in Oracle 8+. > > Alex Hillman > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Alex Hillman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: I/O contention with external process reading the oracle logs (online redo logs)
Hello All I just had a meeting today about replication. The situations is: One master db that is currently replicated (master to master synchronous replication) to a second DB. Both machines are NT and the is a direct cable connection between the network cards on both machines. However, this solves the problem of machine failure but does not cover the full disaster recovery as both machines are in the same room. In case of fire both machines will be destroyed. We are thinking about adding asynchronous replication to replicate the changes across wan to a remote site. The problem is that this will load the production system and the network link (wan is expensive), as the system generates during peek time 10MB of archive logs every 2-3 minutes. I saw that some of you are using Quest Shareplex. Can you share your reasons, success stories etc? Benchmarks results will be very welcome. TIA Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, June 06, 2002 4:32 PM (online redo logs) NB_ RESENDING in plain text - sorry, Outlook keeps seinding in html no matter what default i set! Hi lists, I am using Quest Shareplex product for Oracle to Oracle one way replication. I have two systems (source and target) and two environments (dev, demo). On system one, the environments are setup as schemas within one oracle instance (therefore each schema will be a SOURCE in the replication). My other system has each environment set up a separate Orace Instances (therefore each instance will become a TARGET in the replication). I am trying to configure 2 separate replication streams (ie so that each replication process is SEPARATE from the other - one for DEV and one for DEMO). I will accomplish this by setting up Shareplex to use mulitple processes. HOWEVER, Quest technical support has told me that this will cause contention. However, I dont see why is would from an os/oracle point of view. Basically Shareplex has a process which reads the online redo logs. tech support is suggesting that is there a two processes trying to access the same block in the logs that contention can occur. This does not make sense to me. Below is the blurb from techincal support when I questioned their initial repsonse: * The reason you might run into a contention is because multiple captue processes may be reading the same data block in the redo log. Since there is only one process that can access a single block, the other process may have to wait. Contention is a possibilty, and you will need to run some bench marks to find out how much, if any, contention you will have. * I would find it HARD to believe that only ONE process can read a block at a time. If this were true, then OLTP system would FAIL miserably! Anyone have any ideas/comments regarding the OS and Oracle interaction I mean are not the logs at this pointa UNIX file? and can't multiple processes read a single unix file without bringing the whole system to its knees? Also, I am NOT knocking the techincal support, but I believe that the opinion was formulated on an incorrect assumption on the operating system and Oracle. Thoughts/comments? Thanks in advance. Hannah -- 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 you stop an export?
In NT use task manager and kill it. In Win95/8 do Alt-Ctrl-Del and kill the dos session. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, June 10, 2002 7:08 PM > how do you stop an command-line export? press CTL-C countless times and > ususally just stops the current table . . . usually end up killing the > entire session. > > was hoping there's a different way? > > thx > bill > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Magaliff, Bill > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: I/O contention with external process reading the oracle logs (online redo logs)
Hello Tim and Rachel There is band width problem. The line is 256K (we are checking upgrade to 512k). The database, during peek time produce 10MB of logs every 2-3 minutes. On this line it will take 7-8 minutes to pass 10MB if the line was dedicate and it is not dedicated. Upgrading the line to more then 512K need E1 at least and it is expansive. Since replication will need less band width we are checking it. To return to my original question: Quest Shareplex - Any success stories? Why use this and not replication? Ant performance tests between Shareplex and Oracle replication? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, June 10, 2002 4:33 AM (online redo logs) > and if you need the remote site to support users, you could use the > logical standby feature of 9iR2, which generates SQL statements to be > applied and allows the database to be open and active. > > --- Tim Gorman <[EMAIL PROTECTED]> wrote: > > why wouldn't you consider simply using the standby database feature? > > > > do you need the remote site to support users also? > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Sunday, June 09, 2002 11:43 AM > > (online redo logs) > > > > > > > Hello All > > > > > > I just had a meeting today about replication. > > > The situations is: One master db that is currently replicated > > > (master to master synchronous replication) to a second DB. > > > Both machines are NT and the is a direct cable connection > > > between the network cards on both machines. > > > > > > However, this solves the problem of machine failure but does not > > cover > > > the full disaster recovery as both machines are in the same room. > > > In case of fire both machines will be destroyed. > > > > > > We are thinking about adding asynchronous replication to replicate > > the > > > changes > > > across wan to a remote site. The problem is that this will load the > > > production system and the network link (wan is expensive), as the > > system > > > generates during peek time 10MB of archive logs every 2-3 minutes. > > > > > > I saw that some of you are using Quest Shareplex. > > > Can you share your reasons, success stories etc? > > > Benchmarks results will be very welcome. > > > > > > TIA > > > > > > Yechiel Adar > > > Mehish > > > - Original Message - > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > Sent: Thursday, June 06, 2002 4:32 PM > > > (online redo logs) > > > > > > > > > NB_ RESENDING in plain text - sorry, Outlook keeps seinding in html > > no > > > matter what default i set! > > > Hi lists, > > > > > > I am using Quest Shareplex product for Oracle to Oracle one way > > > replication. I have two systems (source and target) and two > > environments > > > (dev, demo). On system one, the environments are setup as schemas > > within > > > one oracle instance (therefore each schema will be a SOURCE in the > > > replication). My other system has each environment set up a > > separate > > Orace > > > Instances (therefore each instance will become a TARGET in the > > replication). > > > > > > I am trying to configure 2 separate replication streams (ie so > > that > > each > > > replication process is SEPARATE from the other - one for DEV and > > one for > > > DEMO). I will accomplish this by setting up Shareplex to use > > mulitple > > > processes. > > > > > > HOWEVER, Quest technical support has told me that this will > > cause > > > contention. However, I dont see why is would from an os/oracle > > point of > > > view. Basically Shareplex has a process which reads the online > > redo > > > logs. tech support is suggesting that is there a two > > processes > > > trying to access the same block in the logs that contention can > > occur. > > This > > > does not make sense to me. Below is the blurb from techincal > > support when > > I > > > questioned their initial repsonse: > > > > > > > > > > > > * > > > The reason you might r
Re: Newline char in oracle files
Title: Newline char in oracle files Hello Beth Had the same problem after upgrading from 81600 to 81634. I downloaded textpad from the internet and it solved the problem. It is also much nicer then wordpad. Yechiel AdarMehish - Original Message - From: Seefelt, Beth To: Multiple recipients of list ORACLE-L Sent: Friday, June 07, 2002 5:38 PM Subject: Newline char in oracle files Hi everybody, I have a very odd problem I hope someone can help me with. I've installed Oracle, OEM and OWB on a couple of NT 4.0 servers in the UK. The text files that Oracle generates during the install - the .config, .ora and the .ctl files from OWB - are generated using a lf as the newline character instead of a cr. The result is that in notepad they all appear as one run-on line with embedded control characters (line feeds). I have not had this problem on any of the servers in the US. I'm using the same installation media in both places. Is there UK specific media I should be using? Or is there is something in the regional settings on the servers that would determine what newline character is used? I've checked the Oracle and Microsoft support sites and even opened a tar but am still stumped, so any suggestions will be appreciated. I've tried contacting our sysadmin about it but I don't expect any response until the England/Argentina match is over :-) TIA, Beth
Re: ORA-00604 and ORA-01578
Hello Since the tablespace looks like RBS you may be able to drop that tablespace and recreate it again, assuming that your update transaction finished ok and the select use the RBS to get old values since an update is in progress. I think that you should run also an OS disk checking utility to verify that the problem is not a bad block/sector on the disk itself. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 7:28 PM > I have a system when I issued a select statement, I get the following error. > > ORA-00604 Error Occur at recursive level 1 > > ORA-01578 Oracle Datablock corrupted. File 6 Block 2853 > > ORA-01110 Datafile 6 E:\ORANT\DATABASE\RBS1.DBS > > We have an export that we may be able to restore. The database is running > in non-archive mode. Any idea on how to resolve this problem? > > Thank you in advance > -- > 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i installation
First I second Mladen recommendation to install 9.2. IIRC there is one KIT file on the installation disk that you need to rename for the installation to succeed. Also you can use lsnrctl to install the listener service. do: lsnrctl start listener and it will install the service for you (if the service does not exist, at least in 9i). Yechiel AdarMehish - Original Message - From: Mohamed Kamal To: Multiple recipients of list ORACLE-L Sent: Sunday, November 23, 2003 10:44 AM Subject: Oracle 8i installation Hi Group, I'm trying to install Oracle 8i in my computer (Windows 2000),after installtion it gives me this error jrew.exe has generated errors and will be close by woindows java.exe has generated errors and will be close by woindows and i can't found listener service in services so i can't conect to the database can you help me ? thanks M.Kamal
Re: Oracle 8i installation
OOPs - It is JIT file. Yechiel AdarMehish - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Sunday, November 23, 2003 5:49 PM Subject: Re: Oracle 8i installation First I second Mladen recommendation to install 9.2. IIRC there is one KIT file on the installation disk that you need to rename for the installation to succeed. Also you can use lsnrctl to install the listener service. do: lsnrctl start listener and it will install the service for you (if the service does not exist, at least in 9i). Yechiel AdarMehish - Original Message - From: Mohamed Kamal To: Multiple recipients of list ORACLE-L Sent: Sunday, November 23, 2003 10:44 AM Subject: Oracle 8i installation Hi Group, I'm trying to install Oracle 8i in my computer (Windows 2000),after installtion it gives me this error jrew.exe has generated errors and will be close by woindows java.exe has generated errors and will be close by woindows and i can't found listener service in services so i can't conect to the database can you help me ? thanks M.Kamal
Re:
You need SMTP server and it is a different kind of server from the e-mail server. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 24, 2003 11:24 AM > Hello! > It's me else one :) > > When I setup Email Notifications to sysman (sender's email, smtp server, > etc) it cannon send report to me cause of VD-4280 error: The SMTP Server > could not be connected to. Email server is working properly, configured too. > Mail client from the same machine works fine. Alert logs are clean. Where am > I wrong? > > -- > Oracle 9i DBA beginner > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: VirVit > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8i installation
There is a problem installing oracle 8i on P4 machines. Copy the installation CD to the hard disk. Search for file named symcjit.DLL and rename to symcjit.old. Run the installation from the hard disk. Yechiel AdarMehish - Original Message - From: Mohamed Kamal To: Multiple recipients of list ORACLE-L Sent: Monday, November 24, 2003 1:59 PM Subject: Re: Oracle 8i installation what do you mean by JIT file?? how can i solve my problem? - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Monday, November 24, 2003 12:14 PM Subject: Re: Oracle 8i installation OOPs - It is JIT file. Yechiel AdarMehish - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Sunday, November 23, 2003 5:49 PM Subject: Re: Oracle 8i installation First I second Mladen recommendation to install 9.2. IIRC there is one KIT file on the installation disk that you need to rename for the installation to succeed. Also you can use lsnrctl to install the listener service. do: lsnrctl start listener and it will install the service for you (if the service does not exist, at least in 9i). Yechiel AdarMehish - Original Message - From: Mohamed Kamal To: Multiple recipients of list ORACLE-L Sent: Sunday, November 23, 2003 10:44 AM Subject: Oracle 8i installation Hi Group, I'm trying to install Oracle 8i in my computer (Windows 2000),after installtion it gives me this error jrew.exe has generated errors and will be close by woindows java.exe has generated errors and will be close by woindows and i can't found listener service in services so i can't conect to the database can you help me ? thanks M.Kamal
Re: Active Directory and ORACLE passwords
Title: Active Directory and ORACLE passwords There is a product called MIIS ( Microsoft Integration Information Server) that synchronize between Ad and Oracle LDAP. One of the companies in Israel is checking it out now. Yechiel AdarMehish - Original Message - From: Bartolo, David To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 25, 2003 8:19 PM Subject: Active Directory and ORACLE passwords Hi all, Has anyone heard of or seen any information on using Active Directory for password rules and authentication to an ORACLE database. An example would be that Active Directory would set up the rules for the password and the time that the password would be valid and then pass off to the ORACLE database that password. Any information would help. Thanks in advance David
Re: .NET, connection pooling and security .
We are going the OID way because of these problems. Anyway here is a wild idea: Tell the web guys to use the user userid (he probably logged to the web application) with a standard password that is common to all of them and is supplied by the web application, the user does not see it. If you have an information security guy, teach him how to add users and grant the application user role. The schema owner password need to be a closely held secret of the dba group. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, November 30, 2003 5:49 AM > I hope somebody on the list can help me out with this. > > All of our 3-tier apps are architected with a schema owner (owns all objects > used by an application) and application user (no create privs, but it does > have full dml privs to the schema owner objects). > On the web side, connection pooling is setup with 10 connections logged in > (all as the application user). > When users connect, the application reads some active directory keys that > tell if the user is a reader, dml user or admin user (all privs). > > I don't feel the application should be managing security and I'd like to > take that responsibility away. > The 10 identical connections logged into the database bothers me too. > > I'd like to make it work similar to our 2-tier apps where we use roles, > assign them to a user and they connect individually. We don't have OID setup > and I imagine that would solve this. Short of that, is there any other way > to work around having the 10 identical connections logging in and having the > application maintaining security? Is there another way of assigning the > security? > > I don't have any web development experience and I thought I'd check here > first to see how others deal with this. I hope somebody else has worked > this out at their shop. > > I'm not sure if the answers will change, but it's an all M$ shop, except for > Oracle. > > Any help would be appreciated. > Steve > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Steve Perry > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cobol redefine in SQL
I think there are two solutions to this problems: 1) Load the data into varchar and use views with substr to preset the data in orderly manner to the users. 2) Create a table that contain all the available fields. For each redefine populate only the relevant fields, with views for each redefine. You can use the multiple into table format of SQLLDR and load into the same table, each time with different fields. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 26, 2003 11:34 PM > Hi all, > > We'll do a conversion from IMS to Oracle (817). > The conversion team wants to move data on Oracle then processed it. > > Off course, in the file format, the cobol redefine command is used on a filler field (20 times). There is also a redefine command in a redefine command. > > For the younger ones, it means a zone (50 caracters) that can be defined in many ways depending on a key : 2 fields of 25 char or 5 fields of 10 char or > > The programmers can always use substring to death to work this out but I was wandering if there was a more elegant and a less error prone solution, maybe using a record type or a function ... > > > > Stephane Paquette > Administrateur de bases de donnees > Database Administrator > Standard Life > www.standardlife.ca > Tel. (514) 499-7999 poste 7470 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephane Paquette > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FRM-41072
Hello John From you description of the problem I suspect that you use 7.3 client. See note 172179.1 on metalink about which client connect to which server. Yechiel AdarMehish - Original Message - From: John To: Multiple recipients of list ORACLE-L Sent: Saturday, November 29, 2003 8:14 PM Subject: FRM-41072 Do you know how to overcome this problem? Currently my forms work good with a 7.3.3 Database Server. While i get connected to the 9.2.0.1 database i receive this error "Cannot create the Group" My forms have been created by the Developer/2000 which i don;t own. I feel that i have something missed to migrate to the new DB Server. Could you help me a little? John
Re: FRM-41072
That is your problem. From the doc in metalink: Oracle client version 9.2.x is not certified and cannot connect to Oracle RDBMS version 7.3.x. Yechiel AdarMehish - Original Message - From: John To: Multiple recipients of list ORACLE-L Sent: Sunday, November 30, 2003 2:09 PM Subject: Re: FRM-41072 I have no access to metalink. So far, i had no problem get connected to the Oracle 9i R2 with a 7.3.3. client (ORANT). If i try to connect with an Oracle Client 9i r2 to an Oracle 7.3.3. then it fails - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Sunday, November 30, 2003 1:04 PM Subject: Re: FRM-41072 Hello John From you description of the problem I suspect that you use 7.3 client. See note 172179.1 on metalink about which client connect to which server. Yechiel AdarMehish - Original Message - From: John To: Multiple recipients of list ORACLE-L Sent: Saturday, November 29, 2003 8:14 PM Subject: FRM-41072 Do you know how to overcome this problem? Currently my forms work good with a 7.3.3 Database Server. While i get connected to the 9.2.0.1 database i receive this error "Cannot create the Group" My forms have been created by the Developer/2000 which i don;t own. I feel that i have something missed to migrate to the new DB Server. Could you help me a little? John
Re: Add/Drop partition and CBO statistics
If we are talking about two sql only, maybe you can use stored outline. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 02, 2003 8:34 AM > Hi, list friends: > We are using partition to archive history data in our production OLTP database. We get great performance gains(Far less disk io), but we also hit performance trouble sometimes. So I am here ask for your experience. > > We used local index on all partitioned tables.We add/drop partition monthly to archive the history data. > > But the trouble is, when add/drop partition is being done on the partitioned table, CBO sometimes changed SQL execution path.We implemented partition 2 monthes ago, and in the first time, add/drop partition went on quite smoothly, but in the second time we add/drop partition, two SQL (just TWO SQL) get bad execution path and server load rushed to 10 times(from 2 to 20 in uptime), all waiting for latch free event. It severely affected our application. We are an online system and we do not have scheduled time every month so we have to add/drop partition while db is still running. > > So, with system still up and running, how do you add/drop partition without changing the SQL execution path? We do not have the time to reanalyze/dbms_stats the tables ,analyze takes hours and if SQL execution path changed, during these time, system is nearly unusable. > > I tried to import old statistics(dbms_stats.import_table_stats), but did not fix the problem. > So, can you share your experience on managing partitioned table? > > Regards > > Zhu Chao > www.cnoug.org > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: zhu chao > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbms_support on 8i
I checked for 8.1.6.3.4 and 8.1.7.0 on windows. Not there. Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 03, 2003 12:19 AM Subject: dbms_support on 8i Does anyone know which patch level of 8i includes the dbmssupp.sql and .plb files? I have databases here that are at 8.1.7.4, but the files are not there. 9i has them, but none of the 8i databases. Thanks, Jared PS. Metalink was no help for this. Neither was google.
Re: Oracle and Active Directory
1) I also heard that OID is not good before 9.2.0.4. You can however install 9.2.0.4 with OID and use it for authenticating users that are connecting to 8.1.6 (and probably 8.1.7 but I did not tested it). 2) MS has a product called MIIS. It should update the OID with any changes done in AD. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 02, 2003 3:04 PM > Hello List, > > The Company I work for is planning to go the Active Directory route. Does > anyone know of any issues with the following versions of Oracle 7.3.x.x and > 8.1.7.x.x? > > Regards > Denham Eva > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Denham Eva > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
decrease initial extent
Is there any way to decrease the initial extent allocated to a table. It is one of the system tables, so I do not want to drop and recreate it. I can not export/import as it appear in noexp$. It has long field so I can not do alter table move. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: decrease initial extent
Thank you. OK. Another 130MB down the drain. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 03, 2003 8:49 PM > You can move it after you convert the long field to LOB. As it is one > of the system tables which appears in noexp$, it's not guaranteed that > your database will work afterward. OK, let me restate it: it's guaranteed > that it will not work. Other then that, it's only exp/imp of the full > database, and after editing sql.bsq (not for fainthearted) > > On 12/03/2003 01:09:28 PM, Yechiel Adar wrote: > > Is there any way to decrease the initial extent allocated to a table. > > It is one of the system tables, so I do not want to drop and recreate it. > > I can not export/import as it appear in noexp$. > > It has long field so I can not do alter table move. > > > > Yechiel Adar > > Mehish > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Yechiel Adar > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > Mladen Gogala > Oracle DBA > > > > Note: > This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. > Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
select via dblink does not use index
I did a select like: select name from local_table , remote_table where local_table.account = remote_table.account. Remote table is a view with dblink. I select about 100 records out of about 1M records at the remote db. I found out that oracle does full table scan at the remote site. I will welcome ideas how to make oracle use the index on the remote side. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: decrease initial extent
Thanks to all who replied. Alter table/index deallocate keep 64k worked like a charm. I did not checked it in depth but I think that it keep 64k from the actual end of the data, not the high water mark. When I read the manual about keep nk I was sure that it means above the high water mark. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 04, 2003 12:19 AM > I don't understand. Here is what manual says: > > deallocate_unused_clause > > Use the deallocate_unused_clause to explicitly deallocate unused space at the end of the table, > partition or subpartition, overflow data segment, LOB data segment, or LOB index and make the > space available for other segments in the tablespace. > > It's not supposed to change the characteristics of the initial extent. Funny. I'll test it > at home. > > > On 12/03/2003 04:44:27 PM, [EMAIL PROTECTED] wrote: > > Since I agreed with Mladen that it wouldn't work, I just had to test this. > > > > On 8.1.7.3 on OpenVMS the "deallocate unused keep # " shrinks the initial > > extent. > > It shrank a test table from 1m to 8k. I'm not sure why it chose 8k. > > (db_block_size=4k, default initial_extent for the tablespace=64k) > > > > I assume it would work on SYS tables as well. > > (No sacrificial database that I'm willing to try it on.) > > > > Nelson > > > > -Original Message- > > [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, December 03, 2003 4:09 PM > > To: Multiple recipients of list ORACLE-L > > > > > > > > If you use "keep " it will. > > > > Alex. > > > > > > -Original Message- > > <mailto:[EMAIL PROTECTED]> ] > > Sent: Wednesday, December 03, 2003 12:59 PM > > To: Multiple recipients of list ORACLE-L > > > > > > That will not do anything for the initial extent. > > You may try with > > > > alter table pray intensely for the desired change; > > > > > > On 12/03/2003 03:34:25 PM, [EMAIL PROTECTED] wrote: > > > alter table deallocate unused keep 1; > > > > > > Alex. > > > > > > > > > -Original Message- > > > Sent: Wednesday, December 03, 2003 10:09 AM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Is there any way to decrease the initial extent allocated to a table. > > > It is one of the system tables, so I do not want to drop and recreate > > > it. I can not export/import as it appear in noexp$. It has long field > > > so I can not do alter table move. > > > > > > Yechiel Adar > > > Mehish > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > <http://www.orafaq.net> > > > -- > > > Author: Yechiel Adar > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > <http://www.fatcity.com> > > > San Diego, California-- Mailing list and web hosting services > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > > name of mailing list you want to be removed from). You may also send > > > the HELP command for other information (like subscribing). > > > > > > > Mladen Gogala > > Oracle DBA > > > > > > > > Note: > > This message is for the named person's use only. It may contain > > confidential, proprietary or legally privileged information. No > > confidentiality or privilege is waived or lost by any mistransmission. If > > you receive this message in error, please immediately delete it and all > > copies of it from your system, destroy any hard copies of it and notify the > > sender. You must not, directly or indirectly, use, disclose, distribute, > > print, or copy any part of this message if you are not the intended > > recipient. Wang Trading LLC and any of its subsidiaries each reserve the > > right to monitor all e-mail communications through its networks. Any views > > expressed in this message are those of the individual sender, except where > > the message states otherwise and the sender is authorized to state them to > > be the views of any suc
Re: select via dblink does not use index
Here are all the details: Source database 9.2.0.4 (upgrade from 8.1.6.3.4). Target database 8.1.6.3.4. View definition: create view my_view as select * from [EMAIL PROTECTED] Sql: select * from local_table , my_view where local_table.branch = 1 and my_view.customer = 200 + local_table.branch * 1 + local_table.customer; All tables are analyzed. There are about 300 records in local_table and 1M records in remote_table. My_view.customer is primary key of target_table. Where branch =1 is a set of 65 records. Optimizer_mode=choose in both databases. Explain plan: Hash join between FTS on local table and remote (in/out = serial). Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How windows manage memory: oracle
What about session UGA memory? Do where name like 'session %ga%'); Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 04, 2003 3:24 PM > Hi, friends: > Several months ago there is a thread talking about choosing the proper memory size for windows server running oracle. > And today I logon to one of my small oracle on NT and found something I cannot understand. It is a small application running Oracle 817/win2k. > SGA is 970M and PGA(maxsize) is 40M. Connection is 20.But from task manager, Oracle is using 1005M physical Memory and 1013M virtual memory(you can view the data from here: > http://www.cnoug.org/html/ut/attach/2003/12/04/12516-oramem2-embed.gif). > > > > SQL> show sga > > > > Total System Global Area 971040796 bytes > > Fixed Size75804 bytes > > Variable Size 299798528 bytes > > Database Buffers 671088640 bytes > > Redo Buffers 77824 byte > > SQL> select count(*) from v$session; > > > > COUNT(*) > > -- > > 18 > > SQL> select sum(value) from v$sesstat where statistic#=(select statistic# from v$statname where name='session pga memory max'); > > > > SUM(VALUE) > > -- > > 39526196 > > And I looked at another server running SAP/oracle, get similiar data: > > http://www.cnoug.org/html/ut/attach/2003/12/04/12518-sap-embed.gif > > (780M sga,33 connection and 25M pga). > > > > Can someone explain it? > > > > Regards > > > > Zhu Chao. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: zhu chao > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How windows manage memory: oracle
I do not see the problem. SGA is 970M + PGA (20*40) 800 MB + executables and you got about 2GB which is the upper limit on NT, unless you used special startup parameter. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 04, 2003 3:24 PM > Hi, friends: > Several months ago there is a thread talking about choosing the proper memory size for windows server running oracle. > And today I logon to one of my small oracle on NT and found something I cannot understand. It is a small application running Oracle 817/win2k. > SGA is 970M and PGA(maxsize) is 40M. Connection is 20.But from task manager, Oracle is using 1005M physical Memory and 1013M virtual memory(you can view the data from here: > http://www.cnoug.org/html/ut/attach/2003/12/04/12516-oramem2-embed.gif). > > > > SQL> show sga > > > > Total System Global Area 971040796 bytes > > Fixed Size75804 bytes > > Variable Size 299798528 bytes > > Database Buffers 671088640 bytes > > Redo Buffers 77824 byte > > SQL> select count(*) from v$session; > > > > COUNT(*) > > -- > > 18 > > SQL> select sum(value) from v$sesstat where statistic#=(select statistic# from v$statname where name='session pga memory max'); > > > > SUM(VALUE) > > -- > > 39526196 > > And I looked at another server running SAP/oracle, get similiar data: > > http://www.cnoug.org/html/ut/attach/2003/12/04/12518-sap-embed.gif > > (780M sga,33 connection and 25M pga). > > > > Can someone explain it? > > > > Regards > > > > Zhu Chao. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: zhu chao > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: decrease initial extent
Title: RE: decrease initial extent You are right, but: In 8.1.6 doc the line next to the KEEP parameter say: KEEP: specify the number of bytes above the high water mark the table will have after deallocation. This let me to believe the deallocate will not shrink the first extent. The text you found is in sub paragraph 3 under it. Yechiel AdarMehish - Original Message - From: Adams, Matthew (GECP, MABG, 088130) To: Multiple recipients of list ORACLE-L Sent: Thursday, December 04, 2003 5:04 PM Subject: RE: decrease initial extent Mladen, Keep reading, it's further down. From the 8.1.7 SQL Reference Manual, under the ALTER TABLE entry (top of page 8-36): "If you specify KEEP, then the specified amount of space is kept and the remaining space is freed. When the remaining number of extents is less than MINEXTENTS, then MINEXTENTS is adjusted to the new number of extents. If the initial extent becomes smaller than INITIAL, then INITIAL is adjusted to the new size." Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 03, 2003 5:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: decrease initial extent I don't understand. Here is what manual says: deallocate_unused_clause Use the deallocate_unused_clause to explicitly deallocate unused space at the end of the table, partition or subpartition, overflow data segment, LOB data segment, or LOB index and make the space available for other segments in the tablespace. It's not supposed to change the characteristics of the initial extent. Funny. I'll test it at home. On 12/03/2003 04:44:27 PM, [EMAIL PROTECTED] wrote: > Since I agreed with Mladen that it wouldn't work, I just had to test this. > > On 8.1.7.3 on OpenVMS the "deallocate unused keep # " shrinks the initial > extent. > It shrank a test table from 1m to 8k. I'm not sure why it chose 8k. > (db_block_size=4k, default initial_extent for the tablespace=64k) > > I assume it would work on SYS tables as well. > (No sacrificial database that I'm willing to try it on.) > > Nelson > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 03, 2003 4:09 PM > To: Multiple recipients of list ORACLE-L > > > > If you use "keep " it will. > > Alex. > > > -Original Message- > <mailto:[EMAIL PROTECTED]> ] > Sent: Wednesday, December 03, 2003 12:59 PM > To: Multiple recipients of list ORACLE-L > > > That will not do anything for the initial extent. > You may try with > > alter table pray intensely for the desired change; > > > On 12/03/2003 03:34:25 PM, [EMAIL PROTECTED] wrote: > > alter table deallocate unused keep 1; > > > > Alex. > > > > > > -Original Message- > > Sent: Wednesday, December 03, 2003 10:09 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Is there any way to decrease the initial extent allocated to a table. > > It is one of the system tables, so I do not want to drop and recreate > > it. I can not export/import as it appear in noexp$. It has long field > > so I can not do alter table move. > > > > Yechiel Adar > > Mehish > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > <http://www.orafaq.net> > > -- > > Author: Yechiel Adar > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > <http://www.fatcity.com> > > San Diego, California -- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > name of mailing list you want to be removed from). You may also send > > the HELP command for other information (like subscribing). > > > > Mladen Gogala > Oracle DBA > > > > Note: > This message is for the named person's use only. It may contain > confidential, proprietary or legally privileged information. No > confidentiality or privilege is waived or lost by any mist
