Re: I/O EVENTS
> So just looking at v$system_event is dangerous. > Looking v$system_event and v$sysstat > is much better but still not perfect. The third > way is ... (mail me ;-)) Anjo, Jared has an even hand on the tiller. Go ahead an post an informative example of how the v$ views don't allow you to diagnose a specific problem, and how Precise products do. We wanna know, and I don't imagine he'll mind. These little hints, and half sentences that end with an ellipsis, are getting on my nerves! ;-) - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: calling a stored procedure from a sitescope monitor
Sitescope is monitoring software produced by Freshwater software. It has many different types of templates for monitors for OS, web servers, databases, etc. You're right that I could probably do what I want here with a function and not a procedure. This is really a prototype for more complicated things I want to do, so I made it a procedure. But this one is really just a wrapper for a function that does all the work. If I say desc foo in sqlplus, it returns PROCEDURE foo and that is it. The Freshwater support guy I talked to suggested that I try call foo and that did not work, but I just noticed that it doesn't work in sqlplus either -- but call foo() does. Tried to redo the monitor to use that but it didn't work there either. Gives an ora-900 invalid sql error. Let's say bar is the one function in procedure foo. I actually can just say select bar from dual in the monitor, and it runs, but I want to keep at it until I can call procedures too. BTW, desc bar returns FUNCTION bar RETURNS NUMBER -Chris >From: "Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >CC: <[EMAIL PROTECTED]> >Subject: RE: calling a stored procedure from a sitescope monitor >Date: Tue, 21 May 2002 14:42:45 +1000 > >Chris, > >I don't know what Sitescope is and I haven't used JDBC but can perhaps >offer a suggestion. > >You say foo doesn't have any arguments and that it returns a value. >I take it that foo is actually a function then? > >From sqlplusw, what does "desc foo" show? > >Consider the following: >SQL> create or replace function foo return varchar is > 2 begin > 3 return 'a'; > 4 end; > 5 / > >Function created. > >SQL> desc foo >FUNCTION foo RETURNS VARCHAR2 > >SQL> select foo from dual; > >FOO >--- >a > >SQL> > > >So, can you just do "select foo from dual" via JDBC? > >If I've misunderstood, what is sitescope and how would you execute your foo >from SQLPlus? > >Regards, >Bruce Reardon > >-Original Message- >From: Chris McGrail [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, 21 May 2002 14:33 > >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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: calling a stored procedure from a sitescope monitor
Chris, I don't know what Sitescope is and I haven't used JDBC but can perhaps offer a suggestion. You say foo doesn't have any arguments and that it returns a value. I take it that foo is actually a function then? >From sqlplusw, what does "desc foo" show? Consider the following: SQL> create or replace function foo return varchar is 2 begin 3 return 'a'; 4 end; 5 / Function created. SQL> desc foo FUNCTION foo RETURNS VARCHAR2 SQL> select foo from dual; FOO --- a SQL> So, can you just do "select foo from dual" via JDBC? If I've misunderstood, what is sitescope and how would you execute your foo from SQLPlus? Regards, Bruce Reardon -Original Message- Sent: Tuesday, 21 May 2002 14:33 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 web application
Thank you, I would contact again for other questions if you don't mind. (One step at a time, right now I have to learn PHP, right?) Aida (Keith is my husband) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 1:18 AM > > On Sat, 18 May 2002, Keith Carney wrote: > > > I am a beginner in Oracle and I need help. > > I need to implement a interactive connection of oracle with web. I need to > > save data from web to database, make a kind of processing and send a > > response to the web. I have no idea even how to make the implementation. Can > > somebody help me ? > > Keith: > > I would consider PHP (http://www.php.net). It is very powerful, and very > fast. It is low overhead as compared to Java, and stored PL/SQL, as well > as many other web development solutions. Basically you have PHP scripts > embedded in HTML pages or templates which get executed by Apache in a > similar way that CGI's used to. Actually PHP is compiled into the Apache > server, or as a dynamically loaded module. My biz site runs on it: > http://www.iheavy.com. > > HTH, > Sean > > -- > 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: Keith Carney INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 r2
On Mon, 20 May 2002 [EMAIL PROTECTED] wrote: > as wget no longer works with -http-user and -http-password from this site. > > So, you get to do it from a browser. What fun. Yeah, I just noticed that too. Gotta make sure you're not from Cuba, Sudan, Iraq, Libya, NKorea, or Syria. Then again, what's to stop someone from any of those places lying on the license. Seemingly pointless... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle web application
Dennis, thanks for your answer Have you ever used before PHP and done anything of this kind of application that I want to accomplish? I need to dig out everything myself this summer. If you know someone that has done somthing alike please let me know. Thanks again. Star wars, right? Can you guess about me? Aida - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 10:38 AM > Aida - Now that you have described your situation more clearly, I would > second the advice you received from Sean - use PHP if you can. While this > task can be accomplished with just about any language, with some choices you > will spend a lot of time getting everything set up. And you probably would > have to use more than one language to accomplish some aspects. PHP was > pretty much designed for quick Web pages and database interactivity. Some > people here have been very successful with it. As a bonus, it sounds like > you are already pretty accomplished in PHP. May the force be with you! > (guess which movie I saw this weekend). > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, May 20, 2002 10:29 AM > To: Multiple recipients of list ORACLE-L > > > Hi Dennis, my name is Aida, (my fault about this) > > Keith is my husband (I love to bother him). > > Thank you for answering to me, I really appreciate it. > > Let me explain more clear the situation. > > I am a graduate student at Stephen F. Austin State University in computer > science department. > > I will graduate next summer. As part of my graduation the department has > assigned me the project > > of Computer Science Programming Contest that is done every year. The way the > contest is organized > > is this: There is a web site in which the student can register in teams of 3 > or 4, they need to give their info > > (first name, last name, phone, class, address, for each member, the name of > the team) and a user name > > and password is assigned to each team so they can come back and change it at > any time. > > At the contest day, to each time is given their account on TITANS and > password and directions how > > they can send their answers back by mail form their account to the jury. > Every team-member can program in > > C, C++ or COBOL (languages that are taught at our university). After the > e-mail is sent, the judge sends > > back the result of the answer. > > The way that is done until last time is this. A faculty member used the PHP > to make the registration and > > humans do all the other part. (this is what they want to avoid mainly and > this time I think they are > > going to use also UNIX accounts for students) > > I took an oracle class (is the first time that is offered) this spring and > they assigned me to do this project using oracle. > > I have learned SQL and PL/SQL and some of the basics of Oracle. I have > designed some web sites before > > with forms, but never any one in interaction with the user and a database. > That's why I need help for basically > > everything. (even for the general concept). Should I still use PHP or is > there any better choice? This is my first > > big question right now but to tell you the truth I have everything under > question mark. But one thing at a time > > and I am hunting around to get more comfortable with this problem. > > Thank you very much for your time > > AIDA > > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Sunday, May 19, 2002 9:03 PM > > > > Keith - Usually you need to create some sort of application that will > > respond to user requests, extract data from Oracle, and format an HTML > page > > to send back to the user. That is basically what you described in your > > email. How that program interfaces to Oracle will depend on what > programming > > language you choose. Usually your program is executed by a software called > a > > "web server" or an "application server". Before you need to worry about > > Oracle, you need to learn a lot more about Web programming. If by "web" > you > > mean the Internet, then you also need to learn about Web security. If your > > application is within your company intranet, then this concern isn't so > > significant. > > Suggestions: Find someone in your company that is an experienced Web > > programmer, and discuss your situation with them. That will teach you a > lot > > quicker. > > Go to http://www.google.com, and type terms like "HTML Tutorial". A > > good site I found was http://www.mcli.dist.maricopa.edu/tut/. This won't > > teach you about connecting to a database, but you've got learn the basics > > before you progress on to advanced topics. > > http://www.computerworld.com/departments/technology/quickstudies offers > > explanations of some of the important concepts so simple even a manager > can > > understand. > > If you encounter more specific questions, write back > > Dennis W
Re: Oracle web application
On Mon, 20 May 2002, Keith Carney wrote: > Have you ever used before PHP and done anything of this kind of application > that I want to accomplish? I need to dig out everything myself this summer. > If you know someone that has done somthing alike please let me know. Thanks > again. Keith: Keith, I've built exactly the type of content site you're working on. Download a copy of PHP, Apache, MySQL, and phpWebSite. Build a plugin for phpWebSite for these customizations. This combination will provide about 90% of the solution to start with. You'll just need to do a little programming for your specific needs. http://phpwebsite.appstate.edu/ Here's another site dedicated to this software combo: http://www.onlamp.com/ Take half the money you saved a buy a new house, take 1/4 and send divide it among these projects, and send the other 1/4 to me! :-) Seriously, Oracle would probably be overkill for something like this. HTH, Sean -- 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).
calling a stored procedure from a sitescope monitor
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).
Re: ANY IDEA?
Hello Hamid,
I think you should balance your shared_pool and db_block_buffers
(decrease db_block buffers or increase shared_pool_size)
Tuesday, May 21, 2002, 5:38:21 AM, you wrote:
HA> Hello List,
HA> I got the following error today(Oracle 8.1.7.0 Sun Solaris)
HA> ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
HA> pool","unknown object","sga heap","state objects")
HA> At the moment my shared_pool size is 30M
HA> Thanks for your help
HA> Hamid Alavi
HA> Office 818 737-0526
HA> Cell818 402-1987
HA> === Confidentiality Statement ===
HA> The information contained in this message and any attachments is
HA> intended only for the use of the individual or entity to which it is
HA> addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
HA> and exempt from disclosure under applicable law. If you have received
HA> this message in error, you are prohibited from copying, distributing, or
HA> using the information. Please contact the sender immediately by return
HA> e-mail and delete the original message from your system.
HA> = End Confidentiality Statement =
--
Best regards,
Sergeymailto:[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sergey V Dolgov
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Wait Event - Slave
Everything I've read tells me that slave wait events are non-issues, that I shouldn't worry about them. I'm wondering if they may be pointers to some issues I think we are facing. We are using Compaq WildFire boxes with multiple QBB's running Tru64 Unix. These boxes use NUMA architecture and the os has not yet been patched so that NUMA and Oracle will work well together (layman's terms :) Can anyone tell me if the excessive slave waits (they are always in my top 5 and usually the top one by several orders of magnitude) might be related to this? TIA for comments. Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ANY IDEA?
You might like to take a look at the following 2 links and work through the
information contained within them.
diagnosing ora-4031_errors on Metalink at
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=146599.1
Also see http://www.zoftware.org/tuning/tune_shared_pool.html#fixed_table (Tim Gorman
pointed this out on 16-May when he found it using the very good search facilities at
www.ixora.com.au)
You may also want to search the list archives - there are numerous ways:
http://www.fatcity.com/ListGuru/my.php
http://faqchest.dynhost.com/prgm/oracle-l/
http://www.mail-archive.com/oracle-l%40fatcity.com/<-- this has them
threaded and is a nice web interface to viewing the messages as well
Regards,
Bruce Reardon
-Original Message-
Sent: Tuesday, 21 May 2002 10:38
There is not a single segment of memory large enough for you to grab. The
way I see it, you have two options, increase your shared pool or flush your
shared pool.
Regards,
Melanie Burns
-Original Message-
Sent: Monday, May 20, 2002 5:38 PM
Hello List,
I got the following error today(Oracle 8.1.7.0 Sun Solaris)
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","unknown object","sga heap","state objects")
At the moment my shared_pool size is 30M
Thanks for your help
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Statspack Problem
Have you connected via BEQ or Net8 initially? Have you got oracle_sid set as an environment variable, as it looks like the connect perfstat/perfstat uses a BEQ connection. After connecting as sys, can you now do a "connect perfstat/perfstat" (though maybe the scripts cleaned up on error and deleted the perfstat user. HTH, Bruce Reardon -Original Message- Sent: Tuesday, 21 May 2002 11:39 I am running 8.1.6 on a Win2000 SP2 machine. When I try running 'statscre.sql' as SYS, the first script completes fine, but when the second script tries to connect perfstat/perfstat , I get the error, "You are no longer connected to Oracle TNS:ORA-12154". Of course the system then proceeds to attempt to run the other two scripts returning about a hundred "not connected" error messages. The Perfstat user was created and I did not have the chance to intervene and change its password. Any ideas as to why the script would fail to connect? I connected as internal in the first place to run the script, so I don't think its TNS. Tom Schruefer - [EMAIL PROTECTED] 410-313-6825 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 EVENTS
In short: Oracle is either using CPU or is waiting on a resource. If oracle is waiting on a resource, it could be an Oracle event (v$system_event/v$session_event), BUT what about waits that are not registered there . like waiting for CPU, waiting for a memory page to be paged in .. So just looking at v$system_event is dangerous. Looking v$system_event and v$sysstat is much better but still not perfect. The third way is ... (mail me ;-)) Anjo. S B wrote: > Hi > > Can anybody explain the events like > SQL*Net message from client,rdbms ipc message > PX Idle Wait ,slave wait ... > > Can I assume a i/o bottleneck from the following > statistics as most of the i/o events are having high > wait time. > > select * from v$system_event > order by TIME_WAITED; > > The last few entries are as follows. > > EVENT TOTAL_WAITS > TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT > --- > SQL*Net more data to client 888137 0 12365 > 0.013922402 > db file parallel write 24450 17606 > 7.200818 > db file scattered read 78230 18336 > 2.34385786 > db file sequential read 27779 0 55490 > 1.99755211 > control file parallel write 27194 0 70593 > 2.59590351 > log file sync 29700 1 145295 > 4.89208754 > log file parallel write 30511 2 146311 > 4.7953525 > io done 35551 567 270796 > 7.61711344 > smon timer 278 273 8404285 > 30231.241 > pmon timer 27350 27349 > 8413237 307.613784 > SQL*Net message from client 498526 0 17655561 > 35.415527 > rdbms ipc message 112693 80775 > 33193981294.552288 > PX Idle Wait164145 164139 > 33650049205.001974 > slave wait 433146 392872 > 4083965194.2861091 > > Regards > Bhulu > > __ > Do You Yahoo!? > LAUNCH - Your Yahoo! Music Experience > http://launch.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: S B > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Re: I/O EVENTS
Download the YAPP paper ;-) Anjo. John Kanagaraj wrote: > Greg, > > > > Can I assume a i/o bottleneck from the following > > > > > > select * from v$system_event > > > order by TIME_WAITED; > > > > No. Wait events may only make up a small amount of > > processing that Oracle > > is doing for you. > > Hmm I wouldn't think so. If there were just _one_ overall view that I > could check to determine an Oracle bottleneck, it would be this view. A > rollup of V$SESSION_WAIT is also effective in determining the _current_ > bottleneck. > > As to the original question: (And as with many other questions) It depends! > The average_wait times displayed by V$SYSTEM_EVENT against specific events > is a good indication of the 'bottleneck'. Just yesterday, I was debugging > 'slow response' from a test database. The top wait events were for 'direct > path read' and 'direct path write', with inordinate values for AV_WAIT (upto > 932 CS or 9 secs!). This clearly pointed to some misconfigured Async I/O (It > was on a Sun box where async_io default to TRUE). I then had the SA look at > the Async config and it turns out that the Veritas layer was misconfigured - > hopefully this has been sorted out. There have been numerous other examples > - and I am not alone here - where DBAs have used V$SYSTEM_EVENT to determine > the bottleneck. If I were 'S B', I would look at the avarage wait values for > I/O and compare them to the manufacturer's claims. If they don't match or or > not close, then it _may_ be an I/O bottleneck. > > I would recommend purchasing (or even stoop to the level of purloining a > copy from a friend!) the most excellent 'Oracle Performance Tuning 101' book > written by Gaja and Kirti from this list. This question is dealt in great > detail therein, and I am sure they would be happy to answer any further > queries. > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > The manuals for Oracle are here: http://tahiti.oracle.com > The manual for Life is here: http://www.gospelcom.net > > ** The opinions and statements above are entirely my own and not those of my > employer or clients ** > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Statspack Problem
I am running 8.1.6 on a Win2000 SP2 machine. When I try running 'statscre.sql' as SYS, the first script completes fine, but when the second script tries to connect perfstat/perfstat , I get the error, "You are no longer connected to Oracle TNS:ORA-12154". Of course the system then proceeds to attempt to run the other two scripts returning about a hundred "not connected" error messages. The Perfstat user was created and I did not have the chance to intervene and change its password. Any ideas as to why the script would fail to connect? I connected as internal in the first place to run the script, so I don't think its TNS. _ Tom Schruefer - [EMAIL PROTECTED] 410-313-6825 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What makes Export slow ?
If an expert is done with consistent = 'N' it still must preserve some information. In the beginning export runs some selects against the data dictionary and needs that data to be consistent throughout the export. If that data changes then it needs to be reconstructed from the undo generated when the data was changed. The undo is generated not by the export program, but by the programs which changed the data dictionary that export needs to keep consistent. Besides this undo data there is that being generated by normal transaction processing. Tables which are changing while an "export" select is being run are dependent on this rollback information for consistency. Consistent = 'N' does not stop this requirement on individual tables. It means that consistency between different tables is not enforced. There are selects being run against changing tables which are not related to the export and they too are dependent on undo information for consistent reads. What separates the needs for rollback information outlined in the second paragraph from the first is how long it must be maintained. The selects done by the export program against the data dictionary it must be maintained for the duration of the export. If your rollback segments are too small there Oracle will not be able to do so, and produce an error. How assigning a particular rollback segment would work in this case is beyond me. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 2:06 PM To: Multiple recipients of list ORACLE-L On Mon, 20 May 2002, Reddy, Madhusudana wrote: > The idea of huge rollback segment is just to eliminate the contention the > rollback segment. Well its not always applicable ( possible make sure all > the other applications are not used), but we can create a big rollback > segment and bring it on line and make other rollback segments offline, and > run the export . So definitely the big rollback segment will be used. Used for what? Are you talking about constructing consistent reads? If so, then that shouldn't be necessary on any significant scale if we, as you suggest, "make sure all the other applications are not used." Even if concurrent access is allowed (as it should be) during export, why would constructing consistent reads from a variety of rollback segments cause "contention" conpared to constructing the same consistent reads from one big rollback segment? What are you trying to accomplish with the big rollback segment? What do you think the rollback segments are being used for by an export? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > Sent: Monday, May 20, 2002 1:04 PM > To: Multiple recipients of list ORACLE-L > > > On Mon, 20 May 2002, Reddy, Madhusudana wrote: > > > Huge Buffer, commit=y, direct=y, assigning the big rollback segment > > should help you to have faster export , > > What do you mean "assigning the big rollback segment?" How do you do > that to an export and what does it accomplish? > > What does COMMIT=Y do in an export? > > If I were the original poster, I'd just look at v$session_event for > the export session after several minutes of slowness. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > > -Original Message- > > Sent: Monday, May 20, 2002 3:43 AM > > To: Multiple recipients of list ORACLE-L > > > > I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster > > processors and more memory space) > > > > I create the database with the same script that I used to for my database > in > > the older machine, > > > > When I export my database from the older machine it was very fast and when > I > > import to newer machine it was fast too, > > > > and when I export from new machine it is really slow (very slow), (I am > > using same export parameters in both servers) > > Can someone help with tuning tips or anything you have... : ( > > > > > > - The no of records are the same for both machines > > - v$session_wait.seconds_in_wait is more than 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Califo
RE: ANY IDEA?
There is not a single segment of memory large enough for you to grab. The
way I see it, you have two options, increase your shared pool or flush your
shared pool.
Regards,
Melanie Burns
-Original Message-
Sent: Monday, May 20, 2002 5:38 PM
To: Multiple recipients of list ORACLE-L
Hello List,
I got the following error today(Oracle 8.1.7.0 Sun Solaris)
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","unknown object","sga heap","state objects")
At the moment my shared_pool size is 30M
Thanks for your 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: Root, Melanie
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 experts, a simple question for you
looks like published aug of 98 for that book?, like $60?
joe
[EMAIL PROTECTED] wrote:
>Joe,
>
>Add a generated PK to the time dimension. The PK is stored
>as an FK in the fact table.
>
>That way you can select from the time dimension by year, day, qtr,
>whatever,
>and easily pick out the correct fact table rows.
>
>"The Data Warehouse Lifecycle Toolkit" includes a spreadsheet to generate
>the DDL/DML for a very robust time dimension. I think it has about 20
>columns.
>
>Very good book, can't recommend it enough.
>
>Jared
>
>
>
>
>
>
>Joe Testa <[EMAIL PROTECTED]>
>Sent by: [EMAIL PROTECTED]
>05/20/2002 04:08 PM
>Please respond to ORACLE-L
>
>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>cc:
>Subject:Data Warehouse experts, a simple question for you
>
>
>Ok i'm messing with dimensions.
>
>dm_time to be exact:
>
>create table dm_time
>( calendar_date date not null,
> calendar_month number(2) not null,
> calendar_qtr number(1) not null,
> calendar_year number(4) not null);
>
>insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002);
>insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003);
>
> 2 rows nice and simple
>
> trying to validate the dimension comes up with an error, my guess is
>because of the design of the table
>
> where basically calendar_date is child of
> calendar_month is child of calendar_qtr is child of calendar_year,
>wont validate.
>
>- the question i have is this, should month really be like 2002-01 with
>the year included, likewise with qtr, then it
>will validate ok.
>
>Was the design of dm_time just dont wrong or am i missing something here.
>
>thanks, joe
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Data Warehouse experts, a simple question for you
Joe,
Add a generated PK to the time dimension. The PK is stored
as an FK in the fact table.
That way you can select from the time dimension by year, day, qtr,
whatever,
and easily pick out the correct fact table rows.
"The Data Warehouse Lifecycle Toolkit" includes a spreadsheet to generate
the DDL/DML for a very robust time dimension. I think it has about 20
columns.
Very good book, can't recommend it enough.
Jared
Joe Testa <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/20/2002 04:08 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Data Warehouse experts, a simple question for you
Ok i'm messing with dimensions.
dm_time to be exact:
create table dm_time
( calendar_date date not null,
calendar_month number(2) not null,
calendar_qtr number(1) not null,
calendar_year number(4) not null);
insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002);
insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003);
2 rows nice and simple
trying to validate the dimension comes up with an error, my guess is
because of the design of the table
where basically calendar_date is child of
calendar_month is child of calendar_qtr is child of calendar_year,
wont validate.
- the question i have is this, should month really be like 2002-01 with
the year included, likewise with qtr, then it
will validate ok.
Was the design of dm_time just dont wrong or am i missing something here.
thanks, joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Anyone using 8.1.7.4
Ron, We currently use 8.1.7.1.4 on NT and have been considering testing an upgrade to 8.1.7.4 However, to my knowledge, 8174 isn't yet out for Windows. I can find it on Metalink for Solaris (ID:1697372 Patchset::2376472) but have not found it for Windows. Do you know where 8.1.7.4 for Windows is available from? (I haven't been able to try ftp://updates.oracle.com/ due to problems with my browser (IE) not prompting me for a username). Thanks, Bruce Reardon -Original Message- Sent: Tuesday, 21 May 2002 1:43 I have an upgrade of Oracle 7.3.4 on NT. I hear 8.1.7.3 had a lot of bugs. Should I go with 8.1.7.4? Any experience with 8.1.7.4? Ron Smith [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 experts, a simple question for you
calendar_date calendar_month calendar_qtrcalendar_year
200201011 1 2002
200301011 1 2003
Mh...
The calendar_date(or changed to calendar_day) should be just the day of the
month since you already have calendar_year. It seems that you are storing
everyday's day.
Or get rid of calendar_year and calendar_month since calendar_date contains
month, and year?
-Original Message-
Sent: Monday, May 20, 2002 4:08 PM
To: Multiple recipients of list ORACLE-L
Ok i'm messing with dimensions.
dm_time to be exact:
create table dm_time
( calendar_date date not null,
calendar_month number(2) not null,
calendar_qtr number(1) not null,
calendar_year number(4) not null);
insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002);
insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003);
2 rows nice and simple
trying to validate the dimension comes up with an error, my guess is
because of the design of the table
where basically calendar_date is child of
calendar_month is child of calendar_qtr is child of calendar_year,
wont validate.
- the question i have is this, should month really be like 2002-01 with
the year included, likewise with qtr, then it
will validate ok.
Was the design of dm_time just dont wrong or am i missing something here.
thanks, joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wong, Bing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: ANY IDEA?
check all the parameters that make up
your SGA not just the shared_pool,
eg. block size, block_buffers ,etc.
If you need more O/S allocated memory
, which is what it appears to be,
talk to the SA and then will adjust
otherwise you are going to have to reduce
some things.
Peace !
Mike
-Original Message-
Sent: Monday, May 20, 2002 3:38 PM
To: Multiple recipients of list ORACLE-L
Hello List,
I got the following error today(Oracle 8.1.7.0 Sun Solaris)
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","unknown object","sga heap","state objects")
At the moment my shared_pool size is 30M
Thanks for your 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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 EVENTS
Hi Greg, > Maybe not one, but what about two? At the same time v$system_event is > checked a couple of times, so you can see a time slice, > v$sysstat can be > checked, focusing on CPU used by this session, parse time cpu > and recursive > cpu usage. One view gives wait time, one gives CPU time. There is a lot to be said about using V$SYSSTAT too. The point is that the CHR is derived out of V$SYSSTAT and hence one needs to be careful. Also, some of the values in V$SYSSTAT have meaning only in V$SESSTAT A lot can be deduced from sesstat, and the real interesting ones such as V$ROWCACHE haven't been explored to their fullest depths yet. I think the point I was trying to get across was that V$SYSTEM_EVENT is a good place to start, not neccessarily the only view John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to find current ORACLE_HOME programmatically
Hi, guys. I need to find current value of ORACLE_HOME on the client from VB program, running on that client. I understand that it is in the registry somewhere. I have 2 client installations - one is 8.1.7 and another is 9 on the same client. Apparently EM from 9 installation knows that needed tsnames.ora is in 9 ORACLE_HOME and 8.1.7 EM knows that tsnames.ora in 8.1.7. installation. And my VB program select tsnames.ora from 8.1.7 installation Any ideas? 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).
The results are in ... re: not thinking on a deserted nude beach
I ran the query over again and here are the results. It appears the anti join solution is the one. suit yourself. I like Jareds / Larrys solution note : Not Exists produced the same result as Not In as the index remained suppressed ! Original Query Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=15 Card=106 Bytes=19 398) 10 FILTER 21 TABLE ACCESS (FULL) OF 'table2' (Cost=15 Card=106 Bytes=19398) 31 INDEX (RANGE SCAN) OF 'table1_PK' (UNIQUE) ( Cost=2 Card=2 Bytes=18) Statistics -- 0 recursive calls 2 db block gets 6468 consistent gets 0 physical reads 0 redo size 322140 bytes sent via SQL*Net to client 2498 bytes received via SQL*Net from client 97 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1410 rows processed ** the Anti Join (+) solution Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=50 Card=2739 Bytes=5 50539) 10 FILTER 21 HASH JOIN (OUTER) 32 TABLE ACCESS (FULL) OF 'Table2' (Cost=15 Card=2 103 Bytes=384849) 42 TABLE ACCESS (FULL) OF 'Table1' (Cost=14 C ard=3361 Bytes=60498) Statistics -- 0 recursive calls 4 db block gets 450 consistent gets 0 physical reads 0 redo size 322140 bytes sent via SQL*Net to client 2489 bytes received via SQL*Net from client 97 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1410 rows processed the inline view using minus solution Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=173 Card=7037 Bytes= 1351104) 10 HASH JOIN (Cost=173 Card=7037 Bytes=1351104) 21 VIEW (Cost=145 Card=5464 Bytes=49176) 32 MINUS 43 SORT (UNIQUE) 54 TABLE ACCESS (FULL) OF 'Table2' (Cost=15 Ca rd=2103 Bytes=18927) 63 SORT (UNIQUE) 76 TABLE ACCESS (FULL) OF 'Table1' (Cost= 14 Card=3361 Bytes=30249) 81 TABLE ACCESS (FULL) OF 'Table2' (Cost=15 Card=210 3 Bytes=384849) Statistics -- 0 recursive calls 6 db block gets 779 consistent gets 0 physical reads 0 redo size 322140 bytes sent via SQL*Net to client 2389 bytes received via SQL*Net from client 97 SQL*Net roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 1410 rows processed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Data Warehouse experts, a simple question for you
Ok i'm messing with dimensions.
dm_time to be exact:
create table dm_time
( calendar_date date not null,
calendar_month number(2) not null,
calendar_qtr number(1) not null,
calendar_year number(4) not null);
insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002);
insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003);
2 rows nice and simple
trying to validate the dimension comes up with an error, my guess is
because of the design of the table
where basically calendar_date is child of
calendar_month is child of calendar_qtr is child of calendar_year,
wont validate.
- the question i have is this, should month really be like 2002-01 with
the year included, likewise with qtr, then it
will validate ok.
Was the design of dm_time just dont wrong or am i missing something here.
thanks, joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: SHARED POOL SIZE
Title: RE: SHARED POOL SIZE sorry I goofed...I meant.. yes, it could be changed. -Original Message-From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 3:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SHARED POOL SIZE The value of IMMEDIATE in the ISSYS_MODIFIABLE column means that it IS modifiable and takes effect immediately. Matt Adams - GE Appliances - [EMAIL PROTECTED] Chaos! Panic! Disaster! (My work here is done) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: SHARED POOL SIZE No, it is NOT. Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production 1 select name, ISSES_MODIFIABLE, ISSYS_MODIFIABLE from v$parameter 2* where name like'shared_pool_size%' SQL> / NAME ISSES ISSYS_MOD - - shared_pool_size FALSE IMMEDIATE Sunil Nookala Dell Corp. -Original Message- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Only on 9.0.1 and above -Original Message- [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:24 PM To: Multiple recipients of list ORACLE-L No. Jared Hamid Alavi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: SHARED POOL SIZE HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell 818 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: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: raja INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --
RE: How to drop a datafile from a tablespace quickly
> Umm.. couple of things to verify... > > First, yes, it is me again! > Second, the U-Turn was done on a yellow light (at least that > is what I see that > night!) > Third, that is just a LA street, not a highway! :P > Forth, this is not wild... just LA type of driving! Hey Welcome back Winnie! John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ANY IDEA?
Hello List,
I got the following error today(Oracle 8.1.7.0 Sun Solaris)
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","unknown object","sga heap","state objects")
At the moment my shared_pool size is 30M
Thanks for your 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).
Re: Microsoft Transaction Server & Standby database problem
Sorry, I've never used MS-MTS... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 3:48 PM > Thanks, > > We tried this syntax in our test environment and it worked very well but of > course had no way of knowing if it solved our problem since that didn't show > up in the test environment even in normal circumstances. > Have you actually had experience using this when Microsoft Transaction > Server wasn't switching the way it should and this resolved the issue? > > Thanks! > Jay > > -Original Message- > Sent: Friday, May 17, 2002 8:43 PM > To: Multiple recipients of list ORACLE-L > > > prod = (description= > (address_list= > (failover=ON) > (load_balance=OFF) > (address=...) <= points to primary db > (address=...) <= points to standby db > ) > (connect_data=(service_name=prod) > ) > ) > > The "ADDRESS_LIST=" stuff has worked since the 7.2 time-frame, though I > think the "FAILOVER=" and "LOAD_BALANCE=" syntax was added with 8.0; it was > just for failover functionality originally. Of course, the "SERVICE_NAME=" > stuff didn't happen until Oracle8i; before that it was "SID=" only... > > The key to the FAILOVER=ON functionality working correctly is the death of > the SQL*Net listener at the specified port, not the death of the database. > Make sure that when the database dies, the SQL*Net listener dies too. > Create a "sniper" process that monitors the database instance and > automatically stops the listener if necessary. Or, calls the UNIX "halt" > command... :-) Whatever works... > > Otherwise, if the database instance is dead but the SQL*Net listener is > still running, then this TNS syntax will timeout waiting for a connection > rather than just failing over to the next "ADDRESS=" entry... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, May 17, 2002 10:33 AM > > > > When we switch between production and standby databases our procedure is > to > > change the DNS Name to point to the new ip address. > > This works perfectly for all our old Powerbuilder client/server apps. > > > > However, our connections that go through Microsoft Transaction Server as a > > middle tier apparently continue to try and connect to the old database > until > > all the services are recycled or the NT boxes are rebooted. This > > unfortunately adds about a half hour to our downtime as well as requiring > > several more people to be present when we're doing the switch. > > > > Microsoft and Oracle are unanimous in saying it's the other one's fault. > > Our developers say there's no way of monitoring what's going on in MTS. > > > > To make matters more difficult we've been unable to replicate the problem > in > > our test environment. We have someone developing a loadrunner script now > in > > the hopes that a much higher load will cause the problem to show up. > There > > are several things (such as TAF) that we'd like to test to see if it helps > > but we can't do that until we can replicate the problem. > > > > So has anyone else seen this behaviour or (even better!) have a proven > > solution for it? > > > > Thanks, > > Jay Miller > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Miller, Jay > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > 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: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California
RE: oracle job question
Yes, if it's different jobs. If the same job was scheduled to run at 2:15 , 2:30 , 3:00, then oracle will run only one job. Igor Neyman -Original Message- Sent: Monday, May 20, 2002 3:48 PM To: Multiple recipients of list ORACLE-L What if I have jobs scheduled at 2:15 , 2:30 , 3:00 . Will oracle run them all at once if database is up at 4:00 . -Ajay - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:17 PM > > BigP wrote: > > > > Hi List , > > I have a question regarding oracle database job . I have a database > > job which runs everyday at 3pm . Due to some reason database was > > shutdown between 2-4 pm . What will happen to that job . Will oracle > > run this job after restaring database ? > > > > Thanks in advace for your answers > > Bp > > Yes. Can be a big problem if you have a dozen jobs which were > carefully scheduled restarting all at once. > -- > Regards, > > Stephane Faroult > Oriole Software > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORACLE-L Digest -- Volume 2002, Number 138
good, now we don't have to worry quite so much about that "the poo" thing. On 18 May 2002 at 2:05, Oracle RDBMS Community Forum wrote: Date sent: Sat, 18 May 2002 02:05:17 -0800 To: Multiple recipients of list ORACLE-L Send reply to: [EMAIL PROTECTED] Forum) > From: [EMAIL PROTECTED] > Date: Fri, 17 May 2002 09:54:39 -0700 > Subject: RE: How to drop a datafile from a tablespace quickly > > Umm.. couple of things to verify... > > First, yes, it is me again! > ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB Clone from RMAN backups
No, but I recommend you take a look at the book "Oracle Backup & Recovery 101" by Kenny Smith and Stephan Haisley (Oracle Press). About half the book is devoted to RMAN. It has lots of hands-on exercises, and I have performed most of them. DUPLICATE (Chapter 15) is on my to-do list. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 4:48 PM To: Multiple recipients of list ORACLE-L Thanks for the info. I have not but I will. Have you tried it? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB Clone from RMAN backups
Thanks for the info. I have not but I will. Have you tried it? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: wait event trace file formatter?
Thanks for all the replies. I was hoping to find a simple user-written script that didn't require signing up for a fee-based service, though. I guess there aren't any available. --- K Gopalakrishnan <[EMAIL PROTECTED]> wrote: > Hi: > > Check 'itprof' at http://www.ubtools.com > or > 'Sparky' at http://www.hotsos.com > > I have used the first one found very good. > __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Microsoft Transaction Server & Standby database problem
Thanks, We tried this syntax in our test environment and it worked very well but of course had no way of knowing if it solved our problem since that didn't show up in the test environment even in normal circumstances. Have you actually had experience using this when Microsoft Transaction Server wasn't switching the way it should and this resolved the issue? Thanks! Jay -Original Message- Sent: Friday, May 17, 2002 8:43 PM To: Multiple recipients of list ORACLE-L prod = (description= (address_list= (failover=ON) (load_balance=OFF) (address=...) <= points to primary db (address=...) <= points to standby db ) (connect_data=(service_name=prod) ) ) The "ADDRESS_LIST=" stuff has worked since the 7.2 time-frame, though I think the "FAILOVER=" and "LOAD_BALANCE=" syntax was added with 8.0; it was just for failover functionality originally. Of course, the "SERVICE_NAME=" stuff didn't happen until Oracle8i; before that it was "SID=" only... The key to the FAILOVER=ON functionality working correctly is the death of the SQL*Net listener at the specified port, not the death of the database. Make sure that when the database dies, the SQL*Net listener dies too. Create a "sniper" process that monitors the database instance and automatically stops the listener if necessary. Or, calls the UNIX "halt" command... :-) Whatever works... Otherwise, if the database instance is dead but the SQL*Net listener is still running, then this TNS syntax will timeout waiting for a connection rather than just failing over to the next "ADDRESS=" entry... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 10:33 AM > When we switch between production and standby databases our procedure is to > change the DNS Name to point to the new ip address. > This works perfectly for all our old Powerbuilder client/server apps. > > However, our connections that go through Microsoft Transaction Server as a > middle tier apparently continue to try and connect to the old database until > all the services are recycled or the NT boxes are rebooted. This > unfortunately adds about a half hour to our downtime as well as requiring > several more people to be present when we're doing the switch. > > Microsoft and Oracle are unanimous in saying it's the other one's fault. > Our developers say there's no way of monitoring what's going on in MTS. > > To make matters more difficult we've been unable to replicate the problem in > our test environment. We have someone developing a loadrunner script now in > the hopes that a much higher load will cause the problem to show up. There > are several things (such as TAF) that we'd like to test to see if it helps > but we can't do that until we can replicate the problem. > > So has anyone else seen this behaviour or (even better!) have a proven > solution for it? > > Thanks, > Jay Miller > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
FW: DECODE HELP
Something like this would work. SELECT GREATEST(FIRST_DATE, NVL(SEC_DATE,THIRD_DATE),NVL(THIRD_DATE,SEC_DATE)) FROM ; Just an idea, you can explore it further.. -Original Message- Sent: Monday, May 20, 2002 3:48 PM To: Multiple recipients of list ORACLE-L Hello all, This has probably been discussed here before and I'm sorry if I'm repeating this. But I'd very much appreciate if someone could show me how to use DECODE to select a MAX date where records are like this: PRIM. KEY FIRST_DATE SEC_DATE THIRD_DATE JO001599O 12/14/2000 03/23/2001 05/21/2001 JO001620L12/27/2000 05/16/2001 The first_date, sec_date and third_date may or may not exist; either one of the dates will be there. I need to come up with another column LATEST_DATE which will show the latest date of the 3. Thanks very much in advance! __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyuda Hoska INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DECODE HELP
Why use decode. Look up the "greatest" sql function. select prim_key, greatest(first_date,sec_date,third_date) from your_table. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] "The problem with some people is that when they aren't drunk, they're sober." --William Butler Yeats. [EMAIL PROTECTED] mTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: DECODE HELP 05/20/02 01:48 PM Please respond to ORACLE-L Hello all, This has probably been discussed here before and I'm sorry if I'm repeating this. But I'd very much appreciate if someone could show me how to use DECODE to select a MAX date where records are like this: PRIM. KEY FIRST_DATE SEC_DATE THIRD_DATE JO001599O 12/14/2000 03/23/2001 05/21/2001 JO001620L12/27/2000 05/16/2001 The first_date, sec_date and third_date may or may not exist; either one of the dates will be there. I need to come up with another column LATEST_DATE which will show the latest date of the 3. Thanks very much in advance! __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wait event trace file formatter?
Resend -Original Message- Sent: Monday, May 20, 2002 2:57 PM To: '[EMAIL PROTECTED]' Paul - We had this discussion last week, so you can probably search the archives and get answers. What I received from the discussion is that it is probably simple to create a simple trace file formatter, but that won't account for all the nuances in the trace files. The people that have developed the trace file formatters have devoted an enormous amount of time learning the subtleties and understanding the inconsistencies in the files. Obviously, they deserve to be compensated for their effort, and I don't think they are asking for large amounts of money by any means. But I expect that you can do some experimenting on your own, learning the basics, and it will probably give you a better appreciation for what Cary has gone through. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 3:35 PM To: Multiple recipients of list ORACLE-L Thanks for all the replies. I was hoping to find a simple user-written script that didn't require signing up for a fee-based service, though. I guess there aren't any available. --- K Gopalakrishnan <[EMAIL PROTECTED]> wrote: > Hi: > > Check 'itprof' at http://www.ubtools.com > or > 'Sparky' at http://www.hotsos.com > > I have used the first one found very good. > __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What makes Export slow ?
On Mon, 20 May 2002, Reddy, Madhusudana wrote: > The idea of huge rollback segment is just to eliminate the contention the > rollback segment. Well its not always applicable ( possible make sure all > the other applications are not used), but we can create a big rollback > segment and bring it on line and make other rollback segments offline, and > run the export . So definitely the big rollback segment will be used. Used for what? Are you talking about constructing consistent reads? If so, then that shouldn't be necessary on any significant scale if we, as you suggest, "make sure all the other applications are not used." Even if concurrent access is allowed (as it should be) during export, why would constructing consistent reads from a variety of rollback segments cause "contention" conpared to constructing the same consistent reads from one big rollback segment? What are you trying to accomplish with the big rollback segment? What do you think the rollback segments are being used for by an export? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > Sent: Monday, May 20, 2002 1:04 PM > To: Multiple recipients of list ORACLE-L > > > On Mon, 20 May 2002, Reddy, Madhusudana wrote: > > > Huge Buffer, commit=y, direct=y, assigning the big rollback segment > > should help you to have faster export , > > What do you mean "assigning the big rollback segment?" How do you do > that to an export and what does it accomplish? > > What does COMMIT=Y do in an export? > > If I were the original poster, I'd just look at v$session_event for > the export session after several minutes of slowness. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > > -Original Message- > > Sent: Monday, May 20, 2002 3:43 AM > > To: Multiple recipients of list ORACLE-L > > > > I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster > > processors and more memory space) > > > > I create the database with the same script that I used to for my database > in > > the older machine, > > > > When I export my database from the older machine it was very fast and when > I > > import to newer machine it was fast too, > > > > and when I export from new machine it is really slow (very slow), (I am > > using same export parameters in both servers) > > Can someone help with tuning tips or anything you have... : ( > > > > > > - The no of records are the same for both machines > > - v$session_wait.seconds_in_wait is more than 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i r2
Someone at Oracle has modified the login procedures for download.oracle.com, as wget no longer works with -http-user and -http-password from this site. So, you get to do it from a browser. What fun. Jared "JOE TESTA" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/20/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:9i r2 2 of the files downloaded, will be loading it up today,. woohoo, can anyone say crash and burn, bwahahahahahaha joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle job question
What if I have jobs scheduled at 2:15 , 2:30 , 3:00 . Will oracle run them all at once if database is up at 4:00 . -Ajay - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:17 PM > > BigP wrote: > > > > Hi List , > > I have a question regarding oracle database job . I have a database > > job which runs everyday at 3pm . Due to some reason database was > > shutdown between 2-4 pm . What will happen to that job . Will oracle > > run this job after restaring database ? > > > > Thanks in advace for your answers > > Bp > > Yes. Can be a big problem if you have a dozen jobs which were carefully > scheduled restarting all at once. > -- > Regards, > > Stephane Faroult > Oriole Software > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DECODE HELP
Hello all, This has probably been discussed here before and I'm sorry if I'm repeating this. But I'd very much appreciate if someone could show me how to use DECODE to select a MAX date where records are like this: PRIM. KEY FIRST_DATE SEC_DATE THIRD_DATE JO001599O 12/14/2000 03/23/2001 05/21/2001 JO001620L12/27/2000 05/16/2001 The first_date, sec_date and third_date may or may not exist; either one of the dates will be there. I need to come up with another column LATEST_DATE which will show the latest date of the 3. Thanks very much in advance! __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
Try sending message to: [EMAIL PROTECTED] On Mon, 2002-05-20 at 11:33, Freeman, Robert wrote: How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider "honorary men"? :) What I do want to know is how you determine what the criteria are for being an "honorary man". Inquiring minds want to know :) Rachel |+---> || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+---> >| || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | >| Larry Elkins wrote: > > The beach part sounds great, though I don't care to see naked men running > around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
RE: SHARED POOL SIZE
Title: RE: SHARED POOL SIZE The value of IMMEDIATE in the ISSYS_MODIFIABLE column means that it IS modifiable and takes effect immediately. Matt Adams - GE Appliances - [EMAIL PROTECTED] Chaos! Panic! Disaster! (My work here is done) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: SHARED POOL SIZE No, it is NOT. Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production 1 select name, ISSES_MODIFIABLE, ISSYS_MODIFIABLE from v$parameter 2* where name like'shared_pool_size%' SQL> / NAME ISSES ISSYS_MOD - - shared_pool_size FALSE IMMEDIATE Sunil Nookala Dell Corp. -Original Message- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Only on 9.0.1 and above -Original Message- [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:24 PM To: Multiple recipients of list ORACLE-L No. Jared Hamid Alavi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: SHARED POOL SIZE HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell 818 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: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: raja INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wait event trace file formatter?
Paul: I think you are talking about the support tool TRCSUMMARY. IT is a perl script from oracle Support. You can get it externally if you have some friends in Oracle Support ;) --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > Unfortunately this is 8.1.7 (sorry I didn't specify). > > A note on Metalink makes reference to a formatting utility but, of > course, neither includes nor specifies where to find said utility. > > = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Korn Shell & Sqlplus
"Hand, Michael T" wrote: > > > Maybe one of you has some inspiration. > > > Environment: Compaq Tru64 5.1; Oracle 8.1.7.3 > > > The concept is for a parent Korn shell to spawn a sqlplus child in > > background (which will validate table structure via a PL/SQL Block) then > > wait for a fixed time period before stopping/killing the sqlplus child. > > After the sqlplus child is stopped some follow-up processing is needed to > > "bookmark" where the sqlplus processing has stopped. > > > > My quick test script so far look like: > > #!/bin/ksh > > echo "Starting val_asc, spawning at " $(date) >> val_asc.out > > sqlplus x/ @val_asc3.pls >> val_asc3.log & > valpid=$! > > sleep 240 > > kill -KILL %1 > > echo "Leaving val_asc at " $(date) >> val_asc.out > > exit > > > When the sqlplus line runs it starts 2 processes: > > oragdv 169035 167185 0.0 10:00:20 pts/10:00.18 sqlplus > > oragdv 169652 169035 0.0 10:00:22 ?? 0:00.13 oracleGDV > > (DESCRIPTION=(LOCAL=YES). . . > > > The problem is when the kill command executes, only the first of these 2 > processes is killed immediately. The 2nd (with the PPID at 1) continues > processing until the PL/SQL Block completes (including database updates) > before it terminates. > > > Here's the question. Is there a straightforward way to terminate that 2nd > > process before starting post processing? > > > > Any suggestions would be appreciated as I have been bashing my head > > against the proverbial wall for several days now ;) > I have used the $! parameter to id the sqlplus PID and have been fiddling > with ps & awk to try and obtain the 2nd process's PID but have yet to be > successful > > > Michael Hand > Polaroid Corp > Michael, Killing Oracle server processes is definitely bad manners. Especially if you are using MTS. Even if you are not, the proper way to kill an Oracle process is to use ALTER SYSTEM KILL SESSION. I think that you should use the DBMS_APPLICATION_INFO package to set something like 'Hey! Shoot me!' in your CLIENT_INFO column in V$PROCESS - it would make it easier to another process to log as DBA, spot the process and bang. Another thing that you might want to explore are profiles - you can define and set a profile with limits to suit your needs, and let Oracle do the dirty work. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB Clone from RMAN backups
Michele - Have you looked at the RMAN DUPLICATE command? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Hi all, I am trying to speed up refreshes of QA databases and am familiar with cloning databases using user managed backups (hot and cold). The problem is the organization I am currently with uses RMAN to manage the backups. The perform a level 0 once a month, level 1 once a week, level 2 daily. How/could I use these backups to clone the database to another environment? One of the db's that needs to be refreshed is approx. 40gb and takes about 5 hours to import. The other db is 200+ gb and takes about 24 hours to import. Any suggestions / strategies. Also, its a 24 x 7 environment. TIA, Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Korn Shell & Sqlplus
Michael - I have noticed the same issue you describe - ie. after the sqlplus process terminates, the shadow process continues to completion (assuming there is a COMMIT in the script). We are also on Compaq Tru64, but Oracle 8.1.6. I have only noticed it, not had a reason to dig in and investigate. I suspect that the shadow process is getting reparented to root. You might consider changing your kill to a kill -9. Or locate the shadow process and kill it, maybe first. Just some ideas, hopefully someone has more direct experience. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L > Maybe one of you has some inspiration. > Environment: Compaq Tru64 5.1; Oracle 8.1.7.3 > The concept is for a parent Korn shell to spawn a sqlplus child in > background (which will validate table structure via a PL/SQL Block) then > wait for a fixed time period before stopping/killing the sqlplus child. > After the sqlplus child is stopped some follow-up processing is needed to > "bookmark" where the sqlplus processing has stopped. > > My quick test script so far look like: > #!/bin/ksh > echo "Starting val_asc, spawning at " $(date) >> val_asc.out > sqlplus x/ @val_asc3.pls >> val_asc3.log & valpid=$! > sleep 240 > kill -KILL %1 > echo "Leaving val_asc at " $(date) >> val_asc.out > exit > When the sqlplus line runs it starts 2 processes: > oragdv 169035 167185 0.0 10:00:20 pts/10:00.18 sqlplus > oragdv 169652 169035 0.0 10:00:22 ?? 0:00.13 oracleGDV > (DESCRIPTION=(LOCAL=YES). . . > The problem is when the kill command executes, only the first of these 2 processes is killed immediately. The 2nd (with the PPID at 1) continues processing until the PL/SQL Block completes (including database updates) before it terminates. > Here's the question. Is there a straightforward way to terminate that 2nd > process before starting post processing? > > Any suggestions would be appreciated as I have been bashing my head > against the proverbial wall for several days now ;) I have used the $! parameter to id the sqlplus PID and have been fiddling with ps & awk to try and obtain the 2nd process's PID but have yet to be successful > Michael Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHARED POOL SIZE
No, it is NOT. Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production 1 select name, ISSES_MODIFIABLE, ISSYS_MODIFIABLE from v$parameter 2* where name like'shared_pool_size%' SQL> / NAME ISSES ISSYS_MOD - - shared_pool_size FALSE IMMEDIATE Sunil Nookala Dell Corp. -Original Message- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Only on 9.0.1 and above -Original Message- [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:24 PM To: Multiple recipients of list ORACLE-L No. Jared Hamid Alavi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:SHARED POOL SIZE HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Patch: 1951929
Title: RE: Patch: 1951929 This pretty much boilerplate text I've seen on LOTS of patches from Oracle. Matt Adams - GE Appliances - [EMAIL PROTECTED] Chaos! Panic! Disaster! (My work here is done) -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Subject: Patch: 1951929 Has anyone applied this? The last sentence from support, copied below, gives me the creeps: Please go to the Oracle MetaLink ( http://metalink.oracle.com/ ) site to download the patch referenced below. Patch: 1951929 - RECIEVING MANY ORA-07445 [KQRGCU()+244]ERRORS Customers are reminded that one-off Oracle Server patches are not subject to the same rigorous level of testing as done for Oracle Server patch sets. Customers are encouraged to install and test this patch in a test environment prior to full production implementation. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^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).
Re: Do you ever have days where you dont want to think ?
My favorite Shakespearean (sp?) play and yes, I think we should move this to the OT list :) --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > "Sherman, Paul R." wrote: > > > > Sigh no more, ladies, sigh nor more; > > Men were deceivers ever; > > One foot in sea and one on shore, > > To one thing constant never; > > Then sigh not so, > > But let them go, > > And be you blithe and bonny; > > Converting all your sounds of woe > > Into. Hey nonny, nonny. > > > > Sing no more ditties, sing no mo, > > Or dumps so dull and heavy; > > The fraud of men was ever so, > > Since summer first was leavy. > > Then sigh not so, > > But let them go, > > And be you blithe and bonny, > > Converting all your sounds of woe > > Into. Hey, nonny, nonny. > > > > Thank you, > > > > Paul Sherman > > DBAElcom, Inc. > > email - [EMAIL PROTECTED] > > > > One woman is fair, yet I am well; another is wise, yet I am well; > another virtuous, yet I am well; but till all graces be in one woman, > one woman shall not come in my grace. Rich she shall be, that's > certain; > wise, or I'll none; virtuous, or I'll never cheapen her; fair, or > I'll > never look on her; mild, or come not near me; noble, or not I for an > angel; of good discourse, an excellent musician, and her hair shall > be > of what colour it please God. > > Time to move to the OT list, perhaps. > -- > Regards, > > Stephane Faroult > Oriole Software > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHARED POOL SIZE
Only on 9.0.1 and above -Original Message- [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:24 PM To: Multiple recipients of list ORACLE-L No. Jared Hamid Alavi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:SHARED POOL SIZE HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What makes Export slow ?
The idea of huge rollback segment is just to eliminate the contention the rollback segment. Well its not always applicable ( possible make sure all the other applications are not used), but we can create a big rollback segment and bring it on line and make other rollback segments offline, and run the export . So definitely the big rollback segment will be used. COMMIT=Y is not a parameter for export , instead good for import , its my mistake. Somewhere I have read that NFS Mounted file system will make the export slower . Thanks for your correction, Madhu -Original Message- Sent: Monday, May 20, 2002 1:04 PM To: Multiple recipients of list ORACLE-L On Mon, 20 May 2002, Reddy, Madhusudana wrote: > Huge Buffer, commit=y, direct=y, assigning the big rollback segment > should help you to have faster export , What do you mean "assigning the big rollback segment?" How do you do that to an export and what does it accomplish? What does COMMIT=Y do in an export? If I were the original poster, I'd just look at v$session_event for the export session after several minutes of slowness. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > Sent: Monday, May 20, 2002 3:43 AM > To: Multiple recipients of list ORACLE-L > > I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster > processors and more memory space) > > I create the database with the same script that I used to for my database in > the older machine, > > When I export my database from the older machine it was very fast and when I > import to newer machine it was fast too, > > and when I export from new machine it is really slow (very slow), (I am > using same export parameters in both servers) > Can someone help with tuning tips or anything you have... : ( > > > - The no of records are the same for both machines > - v$session_wait.seconds_in_wait is more than 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What makes Export slow ?
--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote: > On Mon, 20 May 2002, Reddy, Madhusudana wrote: > > > Huge Buffer, commit=y, direct=y, assigning the big rollback segment > > should help you to have faster export , > > What does COMMIT=Y do in an export? it causes an error message! __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DB Clone from RMAN backups
Hi all, I am trying to speed up refreshes of QA databases and am familiar with cloning databases using user managed backups (hot and cold). The problem is the organization I am currently with uses RMAN to manage the backups. The perform a level 0 once a month, level 1 once a week, level 2 daily. How/could I use these backups to clone the database to another environment? One of the db's that needs to be refreshed is approx. 40gb and takes about 5 hours to import. The other db is 200+ gb and takes about 24 hours to import. Any suggestions / strategies. Also, its a 24 x 7 environment. TIA, Michele -- 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).
Korn Shell & Sqlplus
> Maybe one of you has some inspiration. > Environment: Compaq Tru64 5.1; Oracle 8.1.7.3 > The concept is for a parent Korn shell to spawn a sqlplus child in > background (which will validate table structure via a PL/SQL Block) then > wait for a fixed time period before stopping/killing the sqlplus child. > After the sqlplus child is stopped some follow-up processing is needed to > "bookmark" where the sqlplus processing has stopped. > > My quick test script so far look like: > #!/bin/ksh > echo "Starting val_asc, spawning at " $(date) >> val_asc.out > sqlplus x/ @val_asc3.pls >> val_asc3.log & valpid=$! > sleep 240 > kill -KILL %1 > echo "Leaving val_asc at " $(date) >> val_asc.out > exit > When the sqlplus line runs it starts 2 processes: > oragdv 169035 167185 0.0 10:00:20 pts/10:00.18 sqlplus > oragdv 169652 169035 0.0 10:00:22 ?? 0:00.13 oracleGDV > (DESCRIPTION=(LOCAL=YES). . . > The problem is when the kill command executes, only the first of these 2 processes is killed immediately. The 2nd (with the PPID at 1) continues processing until the PL/SQL Block completes (including database updates) before it terminates. > Here's the question. Is there a straightforward way to terminate that 2nd > process before starting post processing? > > Any suggestions would be appreciated as I have been bashing my head > against the proverbial wall for several days now ;) I have used the $! parameter to id the sqlplus PID and have been fiddling with ps & awk to try and obtain the 2nd process's PID but have yet to be successful > Michael Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wait event trace file formatter?
Unfortunately this is 8.1.7 (sorry I didn't specify). A note on Metalink makes reference to a formatting utility but, of course, neither includes nor specifies where to find said utility. --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > Tkprof ?? > > I was just reading 9iR2 notes and it seems there is a new parameter > for > tkprof 'wait events' that will list waits (if available) in the file > per > cursor, very useful feature. > > Raj > __ > Rajendra JamadagniMIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of > ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion is an art! > > > -Original Message- > Sent: Monday, May 20, 2002 1:03 PM > To: Multiple recipients of list ORACLE-L > > > I'm looking for a way to format a trace file produced by "event 10046 > trace name context forever,level 8" (this dumps all wait events to a > file). Has anyone written such a formatter, or have information on > one? Thanks. > > > > = > Paul Baumgartel, Adept Computer Associates, Inc. > [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: Paul Baumgartel > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > ***1 > > This e-mail message is confidential, intended only for the named > recipient(s) above and may contain information that is privileged, > attorney work product or exempt from disclosure under applicable law. > If you have received this message in error, or are not the named > recipient(s), please immediately notify ESPN at (860) 766-2000 and > delete this e-mail message from your computer, Thank you. > > ***1 > __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Server to Oracle DB
All this coding stuff is fine if there is a one-to-one correlation between the SQL Server tables and the Oracle tables. If not, then the first thing that needs to be accomplished is mapping the SQL Server tables to Oracle. This can be a fun job especially if data is required in Oracle that doesn't exist in the old tables. Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 2:13 PM > The code to do this in Perl is trivial, and you get the bonus of complete > control, > as well as the ability to generate sqlloader control and paramters files > on the fly. > > Jared Still > Oracle DBA and Part Time Perl Evangelist ( feels like full time lately ) > > > > > > > "Tim Gorman" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/20/2002 10:43 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: SQL Server to Oracle DB > > > ...speaking of $0.02, make sure that the utility from SQL Server that > produces the "flat" file does not perform unsolicited rounding of > numerics. I was recently burned on a Sybase->Oracle conversion when the > BCP (a.k.a. "bulk copy") and ISQL (a.k.a. SQL*Plus in Sybase) utilities > each implicitly round numeric data to the 2nd digit to the right of the > decimal. Since SQL Server comes from Sybase, beware... > > In ISQL, I could just divide everything by 1. to get the true > precision, but BCP doesn't provide that option. Instead, I wrote a shell > script to query the Sybase data dictionary to generate the "C" program > sources for each table. The Sybase APIs were perfectly capable of > handling numeric precision, but the %&^&#* Sybase developers who wrote > ISQL and BCP were too lazy to use them correctly. Since the ODBC driver > from MS-Access seemed to use the API correctly (i.e. no implicit rounding > seen), then maybe the MS folks are more diligent... > > Just FYI... > - Original Message - > To: Multiple recipients of list ORACLE-L > Sent: Monday, May 20, 2002 9:08 AM > > Richard: > > Yes. The way I've done it in the past is to generate tilde (~) delimited > flat files and then load the data into Oracle via SQL*Loader. You have to > do a mapping first before using SQL*Loader. Then you have to write scripts > for each table you are loading. I recommend the O'Reilly book Oracle > SQL*Loader, The Definitive Guide. This is a process that can take time > especially if the Oracle application needs data that the old legacy DB > doesn't provide. > > My $0.02 worth, > Ken Janusz, CPIM > - Original Message - > To: Multiple recipients of list ORACLE-L > Sent: Monday, May 20, 2002 9:03 AM > > Anyone know of an easy way to grab data from tables in an SQL Server DB > and insert into tables in an Oracle DB? > Thanks. > > > -- > 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: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do you ever have days where you dont want to think ?
"Sherman, Paul R." wrote: > > Sigh no more, ladies, sigh nor more; > Men were deceivers ever; > One foot in sea and one on shore, > To one thing constant never; > Then sigh not so, > But let them go, > And be you blithe and bonny; > Converting all your sounds of woe > Into. Hey nonny, nonny. > > Sing no more ditties, sing no mo, > Or dumps so dull and heavy; > The fraud of men was ever so, > Since summer first was leavy. > Then sigh not so, > But let them go, > And be you blithe and bonny, > Converting all your sounds of woe > Into. Hey, nonny, nonny. > > Thank you, > > Paul Sherman > DBAElcom, Inc. > email - [EMAIL PROTECTED] > One woman is fair, yet I am well; another is wise, yet I am well; another virtuous, yet I am well; but till all graces be in one woman, one woman shall not come in my grace. Rich she shall be, that's certain; wise, or I'll none; virtuous, or I'll never cheapen her; fair, or I'll never look on her; mild, or come not near me; noble, or not I for an angel; of good discourse, an excellent musician, and her hair shall be of what colour it please God. Time to move to the OT list, perhaps. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Patch: 1951929
Has anyone applied this? The last sentence from support, copied below, gives me the creeps: Please go to the Oracle MetaLink ( http://metalink.oracle.com/ ) site to download the patch referenced below. Patch: 1951929 - RECIEVING MANY ORA-07445 [KQRGCU()+244]ERRORS Customers are reminded that one-off Oracle Server patches are not subject to the same rigorous level of testing as done for Oracle Server patch sets. Customers are encouraged to install and test this patch in a test environment prior to full production implementation. === 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).
Re: SHARED POOL SIZE
No. Jared Hamid Alavi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:SHARED POOL SIZE HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AQ using a trigger?
My limited knowledge of AQ would lead me to believe that you're trying to reinvent the wheel. Maybe you should spend more time on the AQ docs? Jared YTTRI Lisa <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/17/2002 02:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:AQ using a trigger? Does anyone have experience with AQ tables? I would like to put a trigger on my AQ table so that when a message comes in, it will automatically fire off a job to dequeue the message. I opened a TAR and was told that I can put a trigger on the table, but it's not recommended. When I asked why, they said 'it just wasn't recommended'. I'm curious if anyone actually knows why I shouldn't or if I really can. It really seems to be a slick way to handle the messages, but if it will cause problems, I'd like to know that upfront. Thank you - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Server to Oracle DB
The code to do this in Perl is trivial, and you get the bonus of complete control, as well as the ability to generate sqlloader control and paramters files on the fly. Jared Still Oracle DBA and Part Time Perl Evangelist ( feels like full time lately ) "Tim Gorman" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/20/2002 10:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: SQL Server to Oracle DB ...speaking of $0.02, make sure that the utility from SQL Server that produces the "flat" file does not perform unsolicited rounding of numerics. I was recently burned on a Sybase->Oracle conversion when the BCP (a.k.a. "bulk copy") and ISQL (a.k.a. SQL*Plus in Sybase) utilities each implicitly round numeric data to the 2nd digit to the right of the decimal. Since SQL Server comes from Sybase, beware... In ISQL, I could just divide everything by 1. to get the true precision, but BCP doesn't provide that option. Instead, I wrote a shell script to query the Sybase data dictionary to generate the "C" program sources for each table. The Sybase APIs were perfectly capable of handling numeric precision, but the %&^&#* Sybase developers who wrote ISQL and BCP were too lazy to use them correctly. Since the ODBC driver from MS-Access seemed to use the API correctly (i.e. no implicit rounding seen), then maybe the MS folks are more diligent... Just FYI... - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:08 AM Richard: Yes. The way I've done it in the past is to generate tilde (~) delimited flat files and then load the data into Oracle via SQL*Loader. You have to do a mapping first before using SQL*Loader. Then you have to write scripts for each table you are loading. I recommend the O'Reilly book Oracle SQL*Loader, The Definitive Guide. This is a process that can take time especially if the Oracle application needs data that the old legacy DB doesn't provide. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:03 AM Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHARED POOL SIZE
No. This is not one of the parameters that can be set on the fly... Regards, Melanie Burns -Original Message- Sent: Monday, May 20, 2002 2:06 PM To: Multiple recipients of list ORACLE-L HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) 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: Root, Melanie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHARED POOL SIZE
Hamid, Check v$parameter table and it will tell you if a given parameter that is used and/or defaulted, is system or session modifiable. Whether or not to modify, if a given parameter is session or system modifiable, is left up to the discretion and experience of the DBA. By the way, the example I sent to you on TEMP tblspace - it should have been in K, not MB; thus, change to 512K then back to 1024K, not MB. Sorry about that! Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 3:06 PM To: Multiple recipients of list ORACLE-L HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) 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: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHARED POOL SIZE
Yes, upgrade to 9.0.1. Oops, you'll also have to shut down to do that. Well, I guess the answer comes down to . . . . no. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 2:06 PM To: Multiple recipients of list ORACLE-L HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
ROFL -- this whole thread has kept me cracking up all morning !!! -- (Mrs.) JoJo :D -Original Message- Paul R. Sent: Monday, May 20, 2002 11:35 AM To: Multiple recipients of list ORACLE-L Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing constant never; Then sigh not so, But let them go, And be you blithe and bonny; Converting all your sounds of woe Into. Hey nonny, nonny. Sing no more ditties, sing no mo, Or dumps so dull and heavy; The fraud of men was ever so, Since summer first was leavy. Then sigh not so, But let them go, And be you blithe and bonny, Converting all your sounds of woe Into. Hey, nonny, nonny. Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Al-Zawawi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TEMP TABLESPACE
Hamid, 1) Do not let TEMP tablespace have autoextend set to on - my .02 is to never have this set to on for any tablespace, but to monitor and expand as necessary. Other DBAs like autoextend, so you may want that for other tablespaces, but not for TEMP. 2) A nice trick to get TEMP cleared of allocated-but-no-longer-used space is to set the next extent to, say 512MB (from say, 1024MB). This will cause all space but what is being currently used to be wiped out. The set next extent back to 1024 (or whatever it was before). Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Hi List, I have two data files for my TEMP tablespace, & i just find out one of the data file "AUTO EXTEND" is set to on is it right?? I beleive for TEMP tablespace autoextend shoudn't be ON, AM I RIGHT or NOT? Now my data file almost full for TEMP tablespace how can I Clean it up, I run ALTER TABLESPACE TEMP COALESCE BUT STILL DATA FILE IS FULL ORACLE 8.1.7.0 ON SUN SOLARIS \THANKS ALLOT 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: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SHARED POOL SIZE
HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) 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).
Re: Do you ever have days where you dont want to think ?
ah but who says Henry Higgins was right? --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > > > as one of the women in this profession, do I want to know who you > consider > > "honorary men"? :) > > > > What I do want to know is how you determine what the criteria are > for being an > > "honorary man". > > > > Inquiring minds want to know :) > > > > Rachel > > > > Well, coming from me 'honorary man' is almost a compliment (also > perhaps > not totally in the context of nude sunbathing - I would not be > totally > opposed to chador in some cases on French beaches). What summarizes > my > thought best, and in a better way than I am able to put it, is > probably > this : > > http://www.geocities.com/Broadway/Stage/4575/mflaudrey7.html#A > > Now I think I'd better run for cover, even if the trouble-and-strife > is > not on the list ... > > You asked for it ;-). > > -- > Regards, > > Stephane Faroult > Oriole Software > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
Yeah, so. I would think for the right amount of money, he would put on a wig and dress... -Original Message- Sent: Monday, May 20, 2002 1:54 PM To: Multiple recipients of list ORACLE-L it's joe's list --- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote: > One makes a large cash offering to the Oracle Goddess... > > -Original Message- > Sent: Monday, May 20, 2002 12:34 PM > To: Multiple recipients of list ORACLE-L > > > How does one get on the OT list??? > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 20, 2002 10:23 AM > To: Multiple recipients of list ORACLE-L > > > > > as one of the women in this profession, do I want to know who you > consider > "honorary men"? :) > > What I do want to know is how you determine what the criteria are for > being > an > "honorary man". > > Inquiring minds want to know :) > > Rachel > > > > |+---> > || | > || | > || sfaroult@orio| > || le.com | > || | > || 05/18/2002 | > || 11:13 AM | > || Please | > || respond to | > || ORACLE-L | > || | > |+---> > >| > || > | To: [EMAIL PROTECTED] | > | cc: (bcc: Rachel Carmichael) | > | Subject: Re: Do you ever have days where | > | you dont want to think ? | > >| > > > > > Larry Elkins wrote: > > > > The beach part sounds great, though I don't care to see naked men > running > > around ;-) > > That's the problem in this job. Too many men. And among women, too > many > are like honorary men. > > > Still preaching the gospel, as you can see :-). In fact, I would be > curious to compare the join on the inline-view with a MINUS to the > hash > anti-join. Assuming all correct indexes, it is comparing two index > fast > full scans plus sort plus index search to two table full scans (more > or > less). I am almost certain that many costs could be put into > equations. > The problem is if you have too many values (number of rows, number of > rows returned, storage, selectivity, etc...) to feed into your > equations > or have trouble deriving these it is not of much use. > Wanted to do some tests on reverse indexes, following your posts, but > I > have not had time. Not much progress on the book PL/SQL chapter > either. > Currently working on real-time, home-made replication (which works on > the standard edition, BTW). Still revolving around the same topics > because one of my concerns is to minimize overhead when logging > (trigger-happy replication, I am suspicious of the Shareplex approach > and anyway as I want to be able to replicate between France, Japan > and > the US, I cannot afford to transfer full redo logs and transactions I > shall have to rollback). I log into several tables (enough info to > rebuild statements, and values separately - with additional problems > when we reach the 4,000 characters mark), IOTs are the obvious choice > but I am not sure it is available with all licenses. Degradation of > my > logs over timeis also something I have to watch. This is for the > days. > Evenings are spent improving an intelligent loader able to take into > account complex FK relationships. I have prepared two 5,000,000 row > tables, one in my 8.1.7 database and one in my 9.0.1 database, but I > have not tested anything yet. > I had a flash of idiocy and subscribed to the OT list (out of the > blues). I doubt I will stay long here. Some people seems to be paid > doing nothing but e-mailing. Is this where you got the details about > Pierce? Pretty active there. > > Cheers, > > Stephane Faroult > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > -- > 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 Intern
Re: wait event trace file formatter?
ITRPROF from http://www.ubtools.com/products/itrprof/itrprof.html and I believe that www.hotsos.com has a new 10046 trace analyzer as well... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 11:03 AM > I'm looking for a way to format a trace file produced by "event 10046 > trace name context forever,level 8" (this dumps all wait events to a > file). Has anyone written such a formatter, or have information on > one? Thanks. > > > > = > Paul Baumgartel, Adept Computer Associates, Inc. > [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: Paul Baumgartel > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). 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).
RE: Do you ever have days where you dont want to think ?
Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing constant never; Then sigh not so, But let them go, And be you blithe and bonny; Converting all your sounds of woe Into. Hey nonny, nonny. Sing no more ditties, sing no mo, Or dumps so dull and heavy; The fraud of men was ever so, Since summer first was leavy. Then sigh not so, But let them go, And be you blithe and bonny, Converting all your sounds of woe Into. Hey, nonny, nonny. Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 1:34 PM To: Multiple recipients of list ORACLE-L oh I never said it was an honor to be considered a man. --- Ruth Gramolini <[EMAIL PROTECTED]> wrote: > This inquiring mind want's to know, what is honorary about being > thought of > as a man instead of the women you are? > Ruth. > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, May 20, 2002 10:23 AM > > > > > > > > as one of the women in this profession, do I want to know who you > consider > > "honorary men"? :) > > > > What I do want to know is how you determine what the criteria are > for > being an > > "honorary man". > > > > Inquiring minds want to know :) > > > > Rachel > > > > > > > > |+---> > > || | > > || | > > || sfaroult@orio| > > || le.com | > > || | > > || 05/18/2002 | > > || 11:13 AM | > > || Please | > > || respond to | > > || ORACLE-L | > > || | > > |+---> > > >| > > || > > | To: [EMAIL PROTECTED] | > > | cc: (bcc: Rachel Carmichael) | > > | Subject: Re: Do you ever have days where | > > | you dont want to think ? | > > >| > > > > > > > > > > Larry Elkins wrote: > > > > > > The beach part sounds great, though I don't care to see naked men > running > > > around ;-) > > > > That's the problem in this job. Too many men. And among women, too > many > > are like honorary men. > > > > > > Still preaching the gospel, as you can see :-). In fact, I would be > > curious to compare the join on the inline-view with a MINUS to the > hash > > anti-join. Assuming all correct indexes, it is comparing two index > fast > > full scans plus sort plus index search to two table full scans > (more or > > less). I am almost certain that many costs could be put into > equations. > > The problem is if you have too many values (number of rows, number > of > > rows returned, storage, selectivity, etc...) to feed into your > equations > > or have trouble deriving these it is not of much use. > > Wanted to do some tests on reverse indexes, following your posts, > but I > > have not had time. Not much progress on the book PL/SQL chapter > either. > > Currently working on real-time, home-made replication (which works > on > > the standard edition, BTW). Still revolving around the same topics > > because one of my concerns is to minimize overhead when logging > > (trigger-happy replication, I am suspicious of the Shareplex > approach > > and anyway as I want to be able to replicate between France, Japan > and > > the US, I cannot afford to transfer full redo logs and transactions > I > > shall have to rollback). I log into several tables (enough info to > > rebuild statements, and values separately - with additional > problems > > when we reach the 4,000 characters mark), IOTs are the obvious > choice > > but I am not sure it is available with all licenses. Degradation of > my > > logs over timeis also something I have to watch. This is for the > days. > > Evenings are spent improving an intelligent loader able to take > into > > account complex FK relationships. I have prepared two 5,000,000 row > > tables, one in my 8.1.7 database and one in my 9.0.1 database, but > I > > have not tested anything yet. > > I had a flash of idiocy and subscribed to the OT list (out of the > > blues). I doubt I will stay long here. Some people seems to be paid > > doing nothing but e-mailing. Is this where you got the details > about > > Pierce? Pretty active there. > > > > Cheers, > > > > Stephane Faroult > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Stephane Faroult > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailin
RE: wait event trace file formatter?
If you are on 9i, tkprof now includes that functionality. Otherwise hotsos.com is one of the source for such a tool. Mohammed Ahsanuddin Oracle DBA -Original Message- Sent: Monday, May 20, 2002 1:04 PM To: Multiple recipients of list ORACLE-L I'm looking for a way to format a trace file produced by "event 10046 trace name context forever,level 8" (this dumps all wait events to a file). Has anyone written such a formatter, or have information on one? Thanks. = Paul Baumgartel, Adept Computer Associates, Inc. [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: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wait event trace file formatter?
Tkprof ?? I was just reading 9iR2 notes and it seems there is a new parameter for tkprof 'wait events' that will list waits (if available) in the file per cursor, very useful feature. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, May 20, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I'm looking for a way to format a trace file produced by "event 10046 trace name context forever,level 8" (this dumps all wait events to a file). Has anyone written such a formatter, or have information on one? Thanks. = Paul Baumgartel, Adept Computer Associates, Inc. [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: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
Re: Errors on Alert file
"It was Abby something." " Abby who?" " Abby...Abby Normal that's it." On Mon, May 20, 2002 at 06:38:25AM -0800, Nirmal Kumar Muthu Kumaran wrote: > ORA-00602 > ORA-00602internal programming exception > Cause:An internal programming exception has occurred. > Action:Report this error as a program bug to Worldwide Customer Support. > > > nirmal. > > > -Original Message- > > From: GL2Z/ INF DBA BENLATRECHE [SMTP:[EMAIL PROTECTED]] > > Sent: 09 ÑÈíÚ ÇáÇæá, 1423 02:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Errors on Alert file > > > > Hi All, > > > > Is it normal that after a shutdown immediate of a database (Oracle > > 8.1.7), Errors (Ora-602) are still generated on the Instance Alert file ? > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: GL2Z/ INF DBA BENLATRECHE > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). -- === 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).
off topic list
send an email to [EMAIL PROTECTED] be prepared for a LOT of chatter it's being used more like a chat room than a bulletin board/email list. We started it on Sept 13 last year and are over 20,000 messages already. on the other hand, the chatter tends to be either funny, informative or thought-provoking. And in general, a short break from the insanity of work. the only rules on the list are: 1) no spewing hatred, unless it is hate mail directed towards a large purple dinosaur named Barney. 2) no Oracle discussions, that's what this list is for. Joe owns it, I moderate it, and we tend to let people say what they want. Discussions have shown that people have very diverse opinions on a number of subjects, but the discussion remains polite. Rachel --- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote: > One makes a large cash offering to the Oracle Goddess... > > -Original Message- > Sent: Monday, May 20, 2002 12:34 PM > To: Multiple recipients of list ORACLE-L > > > How does one get on the OT list??? > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 20, 2002 10:23 AM > To: Multiple recipients of list ORACLE-L > > > > > as one of the women in this profession, do I want to know who you > consider > "honorary men"? :) > > What I do want to know is how you determine what the criteria are for > being > an > "honorary man". > > Inquiring minds want to know :) > > Rachel > > > > |+---> > || | > || | > || sfaroult@orio| > || le.com | > || | > || 05/18/2002 | > || 11:13 AM | > || Please | > || respond to | > || ORACLE-L | > || | > |+---> > >| > || > | To: [EMAIL PROTECTED] | > | cc: (bcc: Rachel Carmichael) | > | Subject: Re: Do you ever have days where | > | you dont want to think ? | > >| > > > > > Larry Elkins wrote: > > > > The beach part sounds great, though I don't care to see naked men > running > > around ;-) > > That's the problem in this job. Too many men. And among women, too > many > are like honorary men. > > > Still preaching the gospel, as you can see :-). In fact, I would be > curious to compare the join on the inline-view with a MINUS to the > hash > anti-join. Assuming all correct indexes, it is comparing two index > fast > full scans plus sort plus index search to two table full scans (more > or > less). I am almost certain that many costs could be put into > equations. > The problem is if you have too many values (number of rows, number of > rows returned, storage, selectivity, etc...) to feed into your > equations > or have trouble deriving these it is not of much use. > Wanted to do some tests on reverse indexes, following your posts, but > I > have not had time. Not much progress on the book PL/SQL chapter > either. > Currently working on real-time, home-made replication (which works on > the standard edition, BTW). Still revolving around the same topics > because one of my concerns is to minimize overhead when logging > (trigger-happy replication, I am suspicious of the Shareplex approach > and anyway as I want to be able to replicate between France, Japan > and > the US, I cannot afford to transfer full redo logs and transactions I > shall have to rollback). I log into several tables (enough info to > rebuild statements, and values separately - with additional problems > when we reach the 4,000 characters mark), IOTs are the obvious choice > but I am not sure it is available with all licenses. Degradation of > my > logs over timeis also something I have to watch. This is for the > days. > Evenings are spent improving an intelligent loader able to take into > account complex FK relationships. I have prepared two 5,000,000 row > tables, one in my 8.1.7 database and one in my 9.0.1 database, but I > have not tested anything yet. > I had a flash of idiocy and subscribed to the OT list (out of the > blues). I doubt I will stay long here. Some people seems to be paid > doing nothing but e-mailing. Is this where you got the details about > Pierce? Pretty active there. > > Cheers, > > Stephane Faroult > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this ma
OT: Ray Lane sighting
Check out http://www.dominionpost.com Denise Gwinn [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
What is 'get out more'? -Original Message- Sent: Monday, May 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L All you men on this list really need to get out more!! ;-) -Original Message- Sent: Monday, May 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L we want jpegs !!! :-) -Original Message- Sent: 20 May 2002 17:03 To: Multiple recipients of list ORACLE-L Hehe... I was thinking the same thing and decided not to pursue! Thanks for stepping up to make that request. I don't look like a man, I don't feel like a man, have never been called one of the guys Just curious too... This is interesting! Melanie Burns -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider "honorary men"? :) What I do want to know is how you determine what the criteria are for being an "honorary man". Inquiring minds want to know :) Rachel |+---> || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+---> >| || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | >| Larry Elkins wrote: > > The beach part sounds great, though I don't care to see naked men running > around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---
Re: Do you ever have days where you dont want to think ?
But the original poster and some of the others seem to think that this would be an honor...RBG - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 1:33 PM > oh I never said it was an honor to be considered a man. > > > --- Ruth Gramolini <[EMAIL PROTECTED]> wrote: > > This inquiring mind want's to know, what is honorary about being > > thought of > > as a man instead of the women you are? > > Ruth. > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Monday, May 20, 2002 10:23 AM > > > > > > > > > > > > > as one of the women in this profession, do I want to know who you > > consider > > > "honorary men"? :) > > > > > > What I do want to know is how you determine what the criteria are > > for > > being an > > > "honorary man". > > > > > > Inquiring minds want to know :) > > > > > > Rachel > > > > > > > > > > > > |+---> > > > || | > > > || | > > > || sfaroult@orio| > > > || le.com | > > > || | > > > || 05/18/2002 | > > > || 11:13 AM | > > > || Please | > > > || respond to | > > > || ORACLE-L | > > > || | > > > |+---> > > > >| > > > || > > > | To: [EMAIL PROTECTED] | > > > | cc: (bcc: Rachel Carmichael) | > > > | Subject: Re: Do you ever have days where | > > > | you dont want to think ? | > > > >| > > > > > > > > > > > > > > > Larry Elkins wrote: > > > > > > > > The beach part sounds great, though I don't care to see naked men > > running > > > > around ;-) > > > > > > That's the problem in this job. Too many men. And among women, too > > many > > > are like honorary men. > > > > > > > > > Still preaching the gospel, as you can see :-). In fact, I would be > > > curious to compare the join on the inline-view with a MINUS to the > > hash > > > anti-join. Assuming all correct indexes, it is comparing two index > > fast > > > full scans plus sort plus index search to two table full scans > > (more or > > > less). I am almost certain that many costs could be put into > > equations. > > > The problem is if you have too many values (number of rows, number > > of > > > rows returned, storage, selectivity, etc...) to feed into your > > equations > > > or have trouble deriving these it is not of much use. > > > Wanted to do some tests on reverse indexes, following your posts, > > but I > > > have not had time. Not much progress on the book PL/SQL chapter > > either. > > > Currently working on real-time, home-made replication (which works > > on > > > the standard edition, BTW). Still revolving around the same topics > > > because one of my concerns is to minimize overhead when logging > > > (trigger-happy replication, I am suspicious of the Shareplex > > approach > > > and anyway as I want to be able to replicate between France, Japan > > and > > > the US, I cannot afford to transfer full redo logs and transactions > > I > > > shall have to rollback). I log into several tables (enough info to > > > rebuild statements, and values separately - with additional > > problems > > > when we reach the 4,000 characters mark), IOTs are the obvious > > choice > > > but I am not sure it is available with all licenses. Degradation of > > my > > > logs over timeis also something I have to watch. This is for the > > days. > > > Evenings are spent improving an intelligent loader able to take > > into > > > account complex FK relationships. I have prepared two 5,000,000 row > > > tables, one in my 8.1.7 database and one in my 9.0.1 database, but > > I > > > have not tested anything yet. > > > I had a flash of idiocy and subscribed to the OT list (out of the > > > blues). I doubt I will stay long here. Some people seems to be paid > > > doing nothing but e-mailing. Is this where you got the details > > about > > > Pierce? Pretty active there. > > > > > > Cheers, > > > > > > Stephane Faroult > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Stephane Faroult > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include
TEMP TABLESPACE
Hi List, I have two data files for my TEMP tablespace, & i just find out one of the data file "AUTO EXTEND" is set to on is it right?? I beleive for TEMP tablespace autoextend shoudn't be ON, AM I RIGHT or NOT? Now my data file almost full for TEMP tablespace how can I Clean it up, I run ALTER TABLESPACE TEMP COALESCE BUT STILL DATA FILE IS FULL ORACLE 8.1.7.0 ON SUN SOLARIS \THANKS ALLOT 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).
RE: What makes Export slow ?
On Mon, 20 May 2002, Reddy, Madhusudana wrote: > Huge Buffer, commit=y, direct=y, assigning the big rollback segment > should help you to have faster export , What do you mean "assigning the big rollback segment?" How do you do that to an export and what does it accomplish? What does COMMIT=Y do in an export? If I were the original poster, I'd just look at v$session_event for the export session after several minutes of slowness. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > Sent: Monday, May 20, 2002 3:43 AM > To: Multiple recipients of list ORACLE-L > > I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster > processors and more memory space) > > I create the database with the same script that I used to for my database in > the older machine, > > When I export my database from the older machine it was very fast and when I > import to newer machine it was fast too, > > and when I export from new machine it is really slow (very slow), (I am > using same export parameters in both servers) > Can someone help with tuning tips or anything you have... : ( > > > - The no of records are the same for both machines > - v$session_wait.seconds_in_wait is more than 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-01722 Error after DBA changes
Hi,
Not sure about exact reason. But I am also having similar condition like
yours. One of my customers was running 8.1.5 with Forms5. I upgraded his DB
to 8.1.7. And I started facing problem with some reports. I got answer from
Oracle saying - this combination is not certified. Oracle has done lots of
changes in Timestamp in 8.1.7 DB.
Not very sure, but just check whether Forms 6i is certified on 8.1.6 and
7.3.4 or not.
Recompilation of all forms and reports can be done by using project builder.
But I'll prefer some DOS BATCH script.
Create a file with .bat extension and put following line & run it
FOR %%I IN (*.FMB) DO {YOUR ORACLE HOME}\BIN\ifcmp60 %%I username/password
End of script*
Same logic you can apply for recompiling reports.
HTH,
Sandeep.
-Original Message-
Sent: Monday, May 20, 2002 7:14 PM
To: Multiple recipients of list ORACLE-L
Subject:ORA-01722 Error after DBA changes
I have been getting a "FRM-40735 WHEN-BUTTON-PRESSED trigger raised
unhandled exception ORA-01722" error. The button calls a procedure in
the form. Whenever this happens, I open up the form in Developer,
recompile it, generate a new .fmx file and everything works fine. In
other words, no changes, just recompilling. Do you have any idea why
this might be happening?
It seems to have started happening after I made some changes to the
database. I was dropping and recreating some tables in order to change
size parameters and also change privileges. Could this have had
anything do with the ORA-1722 error?
Right now, I know the fix but I am curious why I have to recompile
everything. This is with Developer 6i (6.0.8.10.3) and Oracle 7.3.4.
but it also happens against my Oracle 8.1.6 test database.
When I asked this question to Oracle support, they replied that it was
because by changing the database objects, the timestamp gets changed.
But this does not make sense to me since these forms are not being
stored in the database. It also seems to me that of the forms that are
dependant of the tables that I changed, some have problems and others
do not. Also, I suppose if this is true, I will have to recomplile
all of my reports also. Anyone have hints or scripts that I might run
to help me narrow down so that I do not have to recompile ALL forms
and reports?
TIA, Wayne
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: McGill, Wayne 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: Sandeep Kurliye
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: wait event trace file formatter?
Hi: Check 'itprof' at http://www.ubtools.com or 'Sparky' at http://www.hotsos.com I have used the first one found very good. --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > I'm looking for a way to format a trace file produced by "event 10046 > trace name context forever,level 8" (this dumps all wait events to a > file). Has anyone written such a formatter, or have information on > one? Thanks. > > > = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
All you men on this list really need to get out more!! ;-) -Original Message- Sent: Monday, May 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L we want jpegs !!! :-) -Original Message- Sent: 20 May 2002 17:03 To: Multiple recipients of list ORACLE-L Hehe... I was thinking the same thing and decided not to pursue! Thanks for stepping up to make that request. I don't look like a man, I don't feel like a man, have never been called one of the guys Just curious too... This is interesting! Melanie Burns -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider "honorary men"? :) What I do want to know is how you determine what the criteria are for being an "honorary man". Inquiring minds want to know :) Rachel |+---> || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+---> >| || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | >| Larry Elkins wrote: > > The beach part sounds great, though I don't care to see naked men running > around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
RE: Oracle web application
Aida - Now that you have described your situation more clearly, I would second the advice you received from Sean - use PHP if you can. While this task can be accomplished with just about any language, with some choices you will spend a lot of time getting everything set up. And you probably would have to use more than one language to accomplish some aspects. PHP was pretty much designed for quick Web pages and database interactivity. Some people here have been very successful with it. As a bonus, it sounds like you are already pretty accomplished in PHP. May the force be with you! (guess which movie I saw this weekend). Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 10:29 AM To: Multiple recipients of list ORACLE-L Hi Dennis, my name is Aida, (my fault about this) Keith is my husband (I love to bother him). Thank you for answering to me, I really appreciate it. Let me explain more clear the situation. I am a graduate student at Stephen F. Austin State University in computer science department. I will graduate next summer. As part of my graduation the department has assigned me the project of Computer Science Programming Contest that is done every year. The way the contest is organized is this: There is a web site in which the student can register in teams of 3 or 4, they need to give their info (first name, last name, phone, class, address, for each member, the name of the team) and a user name and password is assigned to each team so they can come back and change it at any time. At the contest day, to each time is given their account on TITANS and password and directions how they can send their answers back by mail form their account to the jury. Every team-member can program in C, C++ or COBOL (languages that are taught at our university). After the e-mail is sent, the judge sends back the result of the answer. The way that is done until last time is this. A faculty member used the PHP to make the registration and humans do all the other part. (this is what they want to avoid mainly and this time I think they are going to use also UNIX accounts for students) I took an oracle class (is the first time that is offered) this spring and they assigned me to do this project using oracle. I have learned SQL and PL/SQL and some of the basics of Oracle. I have designed some web sites before with forms, but never any one in interaction with the user and a database. That's why I need help for basically everything. (even for the general concept). Should I still use PHP or is there any better choice? This is my first big question right now but to tell you the truth I have everything under question mark. But one thing at a time and I am hunting around to get more comfortable with this problem. Thank you very much for your time AIDA - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, May 19, 2002 9:03 PM > Keith - Usually you need to create some sort of application that will > respond to user requests, extract data from Oracle, and format an HTML page > to send back to the user. That is basically what you described in your > email. How that program interfaces to Oracle will depend on what programming > language you choose. Usually your program is executed by a software called a > "web server" or an "application server". Before you need to worry about > Oracle, you need to learn a lot more about Web programming. If by "web" you > mean the Internet, then you also need to learn about Web security. If your > application is within your company intranet, then this concern isn't so > significant. > Suggestions: Find someone in your company that is an experienced Web > programmer, and discuss your situation with them. That will teach you a lot > quicker. > Go to http://www.google.com, and type terms like "HTML Tutorial". A > good site I found was http://www.mcli.dist.maricopa.edu/tut/. This won't > teach you about connecting to a database, but you've got learn the basics > before you progress on to advanced topics. > http://www.computerworld.com/departments/technology/quickstudies offers > explanations of some of the important concepts so simple even a manager can > understand. > If you encounter more specific questions, write back > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Saturday, May 18, 2002 11:43 AM > To: Multiple recipients of list ORACLE-L > > > hi, > I am a beginner in Oracle and I need help. > I need to implement a interactive connection of oracle with web. I need to > save data from web to database, make a kind of processing and send a > response to the web. I have no idea even how to make the implementation. Can > somebody help me ? > > Thanks > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Keith Carney > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 5
Re: SQL Server to Oracle DB
Title: SQL Server to Oracle DB ...speaking of $0.02, make sure that the utility from SQL Server that produces the "flat" file does not perform unsolicited rounding of numerics. I was recently burned on a Sybase->Oracle conversion when the BCP (a.k.a. "bulk copy") and ISQL (a.k.a. SQL*Plus in Sybase) utilities each implicitly round numeric data to the 2nd digit to the right of the decimal. Since SQL Server comes from Sybase, beware... In ISQL, I could just divide everything by 1. to get the true precision, but BCP doesn't provide that option. Instead, I wrote a shell script to query the Sybase data dictionary to generate the "C" program sources for each table. The Sybase APIs were perfectly capable of handling numeric precision, but the %&^&#* Sybase developers who wrote ISQL and BCP were too lazy to use them correctly. Since the ODBC driver from MS-Access seemed to use the API correctly (i.e. no implicit rounding seen), then maybe the MS folks are more diligent... Just FYI... - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:08 AM Subject: Re: SQL Server to Oracle DB Richard: Yes. The way I've done it in the past is to generate tilde (~) delimited flat files and then load the data into Oracle via SQL*Loader. You have to do a mapping first before using SQL*Loader. Then you have to write scripts for each table you are loading. I recommend the O'Reilly book Oracle SQL*Loader, The Definitive Guide. This is a process that can take time especially if the Oracle application needs data that the old legacy DB doesn't provide. My $0.02 worth, Ken Janusz, CPIM - Original Message - From: Richard Huntley To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:03 AM Subject: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.
RE: Do you ever have days where you dont want to think ?
it's joe's list --- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote: > One makes a large cash offering to the Oracle Goddess... > > -Original Message- > Sent: Monday, May 20, 2002 12:34 PM > To: Multiple recipients of list ORACLE-L > > > How does one get on the OT list??? > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 20, 2002 10:23 AM > To: Multiple recipients of list ORACLE-L > > > > > as one of the women in this profession, do I want to know who you > consider > "honorary men"? :) > > What I do want to know is how you determine what the criteria are for > being > an > "honorary man". > > Inquiring minds want to know :) > > Rachel > > > > |+---> > || | > || | > || sfaroult@orio| > || le.com | > || | > || 05/18/2002 | > || 11:13 AM | > || Please | > || respond to | > || ORACLE-L | > || | > |+---> > >| > || > | To: [EMAIL PROTECTED] | > | cc: (bcc: Rachel Carmichael) | > | Subject: Re: Do you ever have days where | > | you dont want to think ? | > >| > > > > > Larry Elkins wrote: > > > > The beach part sounds great, though I don't care to see naked men > running > > around ;-) > > That's the problem in this job. Too many men. And among women, too > many > are like honorary men. > > > Still preaching the gospel, as you can see :-). In fact, I would be > curious to compare the join on the inline-view with a MINUS to the > hash > anti-join. Assuming all correct indexes, it is comparing two index > fast > full scans plus sort plus index search to two table full scans (more > or > less). I am almost certain that many costs could be put into > equations. > The problem is if you have too many values (number of rows, number of > rows returned, storage, selectivity, etc...) to feed into your > equations > or have trouble deriving these it is not of much use. > Wanted to do some tests on reverse indexes, following your posts, but > I > have not had time. Not much progress on the book PL/SQL chapter > either. > Currently working on real-time, home-made replication (which works on > the standard edition, BTW). Still revolving around the same topics > because one of my concerns is to minimize overhead when logging > (trigger-happy replication, I am suspicious of the Shareplex approach > and anyway as I want to be able to replicate between France, Japan > and > the US, I cannot afford to transfer full redo logs and transactions I > shall have to rollback). I log into several tables (enough info to > rebuild statements, and values separately - with additional problems > when we reach the 4,000 characters mark), IOTs are the obvious choice > but I am not sure it is available with all licenses. Degradation of > my > logs over timeis also something I have to watch. This is for the > days. > Evenings are spent improving an intelligent loader able to take into > account complex FK relationships. I have prepared two 5,000,000 row > tables, one in my 8.1.7 database and one in my 9.0.1 database, but I > have not tested anything yet. > I had a flash of idiocy and subscribed to the OT list (out of the > blues). I doubt I will stay long here. Some people seems to be paid > doing nothing but e-mailing. Is this where you got the details about > Pierce? Pretty active there. > > Cheers, > > Stephane Faroult > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > -- > 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
wait event trace file formatter?
I'm looking for a way to format a trace file produced by "event 10046 trace name context forever,level 8" (this dumps all wait events to a file). Has anyone written such a formatter, or have information on one? Thanks. = Paul Baumgartel, Adept Computer Associates, Inc. [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: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do you ever have days where you dont want to think ?
oh I never said it was an honor to be considered a man. --- Ruth Gramolini <[EMAIL PROTECTED]> wrote: > This inquiring mind want's to know, what is honorary about being > thought of > as a man instead of the women you are? > Ruth. > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, May 20, 2002 10:23 AM > > > > > > > > as one of the women in this profession, do I want to know who you > consider > > "honorary men"? :) > > > > What I do want to know is how you determine what the criteria are > for > being an > > "honorary man". > > > > Inquiring minds want to know :) > > > > Rachel > > > > > > > > |+---> > > || | > > || | > > || sfaroult@orio| > > || le.com | > > || | > > || 05/18/2002 | > > || 11:13 AM | > > || Please | > > || respond to | > > || ORACLE-L | > > || | > > |+---> > > >| > > || > > | To: [EMAIL PROTECTED] | > > | cc: (bcc: Rachel Carmichael) | > > | Subject: Re: Do you ever have days where | > > | you dont want to think ? | > > >| > > > > > > > > > > Larry Elkins wrote: > > > > > > The beach part sounds great, though I don't care to see naked men > running > > > around ;-) > > > > That's the problem in this job. Too many men. And among women, too > many > > are like honorary men. > > > > > > Still preaching the gospel, as you can see :-). In fact, I would be > > curious to compare the join on the inline-view with a MINUS to the > hash > > anti-join. Assuming all correct indexes, it is comparing two index > fast > > full scans plus sort plus index search to two table full scans > (more or > > less). I am almost certain that many costs could be put into > equations. > > The problem is if you have too many values (number of rows, number > of > > rows returned, storage, selectivity, etc...) to feed into your > equations > > or have trouble deriving these it is not of much use. > > Wanted to do some tests on reverse indexes, following your posts, > but I > > have not had time. Not much progress on the book PL/SQL chapter > either. > > Currently working on real-time, home-made replication (which works > on > > the standard edition, BTW). Still revolving around the same topics > > because one of my concerns is to minimize overhead when logging > > (trigger-happy replication, I am suspicious of the Shareplex > approach > > and anyway as I want to be able to replicate between France, Japan > and > > the US, I cannot afford to transfer full redo logs and transactions > I > > shall have to rollback). I log into several tables (enough info to > > rebuild statements, and values separately - with additional > problems > > when we reach the 4,000 characters mark), IOTs are the obvious > choice > > but I am not sure it is available with all licenses. Degradation of > my > > logs over timeis also something I have to watch. This is for the > days. > > Evenings are spent improving an intelligent loader able to take > into > > account complex FK relationships. I have prepared two 5,000,000 row > > tables, one in my 8.1.7 database and one in my 9.0.1 database, but > I > > have not tested anything yet. > > I had a flash of idiocy and subscribed to the OT list (out of the > > blues). I doubt I will stay long here. Some people seems to be paid > > doing nothing but e-mailing. Is this where you got the details > about > > Pierce? Pretty active there. > > > > Cheers, > > > > Stephane Faroult > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Stephane Faroult > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > Lists > > > --
RE: What makes Export slow ?
Would you post the parameter file ?? Huge Buffer, commit=y, direct=y, assigning the big rollback segment should help you to have faster export , and also you can have a look at the DISK I/O stats ( verify the OFA is same on both the boxes ). Thanks, Madhu -Original Message- Sent: Monday, May 20, 2002 3:43 AM To: Multiple recipients of list ORACLE-L Hi guys, I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster processors and more memory space) I create the database with the same script that I used to for my database in the older machine, When I export my database from the older machine it was very fast and when I import to newer machine it was fast too, and when I export from new machine it is really slow (very slow), (I am using same export parameters in both servers) Can someone help with tuning tips or anything you have... : ( - The no of records are the same for both machines - v$session_wait.seconds_in_wait is more than 1 Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Upgrade and it says it doesn't need it
log a tar... sorry... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 8:58 AM > Unfortunately - this is what I'm having a problem with. I did install with > OUI. The log files from that installation are in the "oraInventory" > directory. Subsequently, I installed some client software (precompilers) on > the machine. The oraInventory only shows the client installation, not the > real server. > > And...I have confirmed - the oraInst.loc file does correctly point to > the oraInventory directory. > > It just looks as though the installer process didn't update the oraInventory > correctly. Now I'm afraid I'm Screwed on the upgrade! > > -Original Message- > Sent: Saturday, May 18, 2002 9:58 AM > To: Multiple recipients of list ORACLE-L > > > I'm guessing that the 9.0.1.0 server software was not installed using the > Oracle installer? Did you "tar" it over from somewhere else? > > For a server installed using the installer, you'll find a file in > "/var/opt/oracle" named "oraInst.loc", which contains the name of the > directory containing the Oracle Universal Installer's "oraInventory" > directory. > > Your installer running the 9.0.1.2 patch is checking for that file in > "/var/opt/oracle" and probably not finding it. Or, it is finding it and the > "oraInventory" directory, but the inventory says that only the client has > been installed... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, May 17, 2002 3:38 PM > > > > HI - > > > > I'm trying to upgrade my database from 9.0.1.0 to 9.0.1.2 (Sun Solaris). > > The installer tells me there are no files that need to be applied. When I > > click on installed products, under 9i it only show the client install, not > > the enterprise edition server. Does anyone know what I can do to get the > > installer to realize that I do have the server installed? > > > > Thank you - > > Lisa > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: YTTRI 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: 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: YTTRI 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: 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).
Re:Numeric comparison in DECODE statement
You can do numeric logic by using the SIGN() function. Here is the
solution I think he was looking for:
SQL@sandbox:test:8.1.7:OPS$ORACLE:12,34570>r
1 select ltrim(decode(sign(minutes - 59), 1, to_char(minutes/60, '9.99')
||' hours',
2 to_char(minutes)||'
minutes'
3 )
4 ) TIME
5from bart
6* order by minutes
TIME
13 minutes
55 minutes
1.08 hours
3.50 hours
SQL@sandbox:test:8.1.7:OPS$ORACLE:12,34570>select * from bart order by 1;
MINUTES
-
13
55
65
210
Brian P. MacLean
Oracle DBA, OCP8i
[EMAIL PROTECTED]
Sent by: To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
[EMAIL PROTECTED] cc:
Subject: Re:Numeric comparison in
DECODE statement
05/20/02 08:38 AM
Please respond to
ORACLE-L
Robert,
That won't work. Decode works like a switch statement. If condition 1
then
value 1. You can't imbed logic operators therein.
DickG.
Reply Separator
Author: Yexley Robert D Contr Det 1 AFRL/WSI <[EMAIL PROTECTED]>
Date: 5/20/2002 7:08 AM
I was wondering if anyone might have tried this before, because I can't
seem to
get it to work. I'd like to be able to determine which unit of measure to
concatenate to a value by using a decode statement in the query. I have a
column in the database that stores time in minutes, and I'd like to be able
to
show the output in minutes if the value is less than 60, but in hours (such
as
3.27 hours) if the value is greater than 60. So far I've tried the
following
statement, but it seems to be blowing up on the first comparison operator:
SELECT decode(in_value, to_char(to_number(in_value) <= to_number('60')),
to_char(in_value)||' minutes', to_char(to_number(in_value) > to_number
('60')),
to_char(in_value/60, '9.99')||' hours')
FROM dual
/
I'm selecting from dual just until I can get the query working at all. Is
what
I'm trying to do even possible? Any help or ideas would be greatly
appreciated.
Thanks in advance.
_YEX_
/*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Easylink Services Corporation
|| Professional Services
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| [EMAIL PROTECTED]
|| <)))><
*/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yexley Robert D Contr Det 1 AFRL/WSI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). 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).
--
Plea
RE: Do you ever have days where you dont want to think ?
One makes a large cash offering to the Oracle Goddess... -Original Message- Sent: Monday, May 20, 2002 12:34 PM To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider "honorary men"? :) What I do want to know is how you determine what the criteria are for being an "honorary man". Inquiring minds want to know :) Rachel |+---> || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+---> >| || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | >| Larry Elkins wrote: > > The beach part sounds great, though I don't care to see naked men running > around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Freeman, Robert INET: [EMAIL PROTE
RE: Numeric comparison in DECODE statement
You can also implement your logic as SELECT DECODE(SIGN(in_value-60), -1, TO_CHAR(in_value)||' minutes', TO_CHAR(in_value/60, '9.99')||' hours') FROM dual / HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, May 20, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Robert, That won't work. Decode works like a switch statement. If condition 1 then value 1. You can't imbed logic operators therein. DickG. *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Anyone using 8.1.7.4
I have an upgrade of Oracle 7.3.4 on NT. I hear 8.1.7.3 had a lot of bugs. Should I go with 8.1.7.4? Any experience with 8.1.7.4? Ron Smith [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
If we told you, we would have to kill you ;P You will need to be a registered "user" of Yahoo (have a Yahoo logon/password). Go to: http://groups.yahoo.com/group/oracle-l-ot And click "join this group". You will then be prompted for info such as how you want to receive the messages etc.. HTH Mark a.k.a Dorothy a.k.a Mutant Metabolism Boy -Original Message- Robert Sent: 20 May 2002 17:34 To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider "honorary men"? :) What I do want to know is how you determine what the criteria are for being an "honorary man". Inquiring minds want to know :) Rachel |+---> || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+---> >| || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | >| Larry Elkins wrote: > > The beach part sounds great, though I don't care to see naked men running > around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 l
Complementary ODTUG 2002 Registrations
as customers, we just received this. Should be open to all: https://www.odtug.com/ssl/2002_reg_iraje.asp Keith __ 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).
RE: SQL Server to Oracle DB
Title: SQL Server to Oracle DB Use the SQLServer DTS package. Under the SQLServer program menu, choose the import/export option, and it will start a Data Transformation Service wizard type thing for you. You can also do SQL transformations and alike as well, by opening the SQL Server Enterprise Manager console, expanding the server that you would like to export the data from, and under the Data Transformations folder, right click on Local Packages and create a new one.. All sorts of options in there, and probably best to hit whilst on the screen.. HTHMark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Richard HuntleySent: 20 May 2002 15:03To: Multiple recipients of list ORACLE-LSubject: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.
