RE: Some of you may find this useful
And what does KGL stand for ? Thanks ! -Original Message- Sent: ? 10 ? 2003 19:45 To: Multiple recipients of list ORACLE-L Read Only Dependencies in the KGL. Best Regards, K Gopalakrishnan -Original Message- Mike (NESL-IT) Sent: Friday, January 10, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Ron, that's a bit of a puzzle because it should have been available since 7.3.2. Which user are you using to query it? Also, anyone, I know what x$kglrd does but anyone have any idea what the RD in the table name means? Read? Row? Data? Dependency? I'm open to suggestions. Regards, Mike Hately -Original Message- Sent: 10 January 2003 15:50 To: Multiple recipients of list ORACLE-L Stephane, My creativity has been stumulated, simulated, and mutated. What version of Oracle are you using? x$kglrd ...table or view does no exist on 8.1.7 rel 3 Ron [EMAIL PROTECTED] 01/10/03 05:03AM break on proc column QUERY format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM QUERY from x$kglrd where KGLNAOWN != 'SYS' order by 1, kgldepno / If it doesn't stimulate your creativity I can do nothing for you :-). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Some of you may find this useful
Andrey Bronfin wrote: And what does KGL stand for ? Thanks ! [K]ernel layer [G]eneric layer [L]ibrary cache manager. Feeling better :-) ? -Original Message- Sent: ? 10 ? 2003 19:45 To: Multiple recipients of list ORACLE-L Read Only Dependencies in the KGL. Best Regards, K Gopalakrishnan -Original Message- Mike (NESL-IT) Sent: Friday, January 10, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Ron, that's a bit of a puzzle because it should have been available since 7.3.2. Which user are you using to query it? Also, anyone, I know what x$kglrd does but anyone have any idea what the RD in the table name means? Read? Row? Data? Dependency? I'm open to suggestions. Regards, Mike Hately -Original Message- Sent: 10 January 2003 15:50 To: Multiple recipients of list ORACLE-L Stephane, My creativity has been stumulated, simulated, and mutated. What version of Oracle are you using? x$kglrd ...table or view does no exist on 8.1.7 rel 3 Ron [EMAIL PROTECTED] 01/10/03 05:03AM break on proc column QUERY format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM QUERY from x$kglrd where KGLNAOWN != 'SYS' order by 1, kgldepno / If it doesn't stimulate your creativity I can do nothing for you :-). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle CD's
thay are also sending oracle database release 2 on this link From: "Nicolai Tufar" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Oracle CD's Date: Sat, 11 Jan 2003 21:43:55 -0800 http://otn.oracle.com/software/products/ias/htdocs/winsoft.html#j2ee Click on TryOnline icon and fill in the form. But they are not sending Oracle Database these days. Ony Application Server, JDeveloper and Oracle Lite. Nick - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, January 12, 2003 6:48 AM One of my friend who has subscribed to oracle OTN has got three CD's free(Oracle 9i Database CD's)...Can any one tell me how to get it... I am also registered in OTN but i am getting magazines only..No CD's like that... Regards, [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: guess who INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nicolai Tufar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MSN 8: advanced junk mail protection and 2 months FREE* -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: faisal ahmad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Some of you may find this useful
And how does one find out more information about such cryptic, undocumented tables?? experience? RD? be in company of more experienced people? wat else? Regards Naveen -Original Message- Sent: Sunday, January 12, 2003 5:29 PM To: Multiple recipients of list ORACLE-L Andrey Bronfin wrote: And what does KGL stand for ? Thanks ! [K]ernel layer [G]eneric layer [L]ibrary cache manager. Feeling better :-) ? -Original Message- Sent: ? 10 ? 2003 19:45 To: Multiple recipients of list ORACLE-L Read Only Dependencies in the KGL. Best Regards, K Gopalakrishnan -Original Message- Mike (NESL-IT) Sent: Friday, January 10, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Ron, that's a bit of a puzzle because it should have been available since 7.3.2. Which user are you using to query it? Also, anyone, I know what x$kglrd does but anyone have any idea what the RD in the table name means? Read? Row? Data? Dependency? I'm open to suggestions. Regards, Mike Hately -Original Message- Sent: 10 January 2003 15:50 To: Multiple recipients of list ORACLE-L Stephane, My creativity has been stumulated, simulated, and mutated. What version of Oracle are you using? x$kglrd ...table or view does no exist on 8.1.7 rel 3 Ron [EMAIL PROTECTED] 01/10/03 05:03AM break on proc column QUERY format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM QUERY from x$kglrd where KGLNAOWN != 'SYS' order by 1, kgldepno / If it doesn't stimulate your creativity I can do nothing for you :-). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Some of you may find this useful
THANKS ;-) -Original Message- Sent: ? 12 ? 2003 13:59 To: Multiple recipients of list ORACLE-L Andrey Bronfin wrote: And what does KGL stand for ? Thanks ! [K]ernel layer [G]eneric layer [L]ibrary cache manager. Feeling better :-) ? -Original Message- Sent: ? 10 ? 2003 19:45 To: Multiple recipients of list ORACLE-L Read Only Dependencies in the KGL. Best Regards, K Gopalakrishnan -Original Message- Mike (NESL-IT) Sent: Friday, January 10, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Ron, that's a bit of a puzzle because it should have been available since 7.3.2. Which user are you using to query it? Also, anyone, I know what x$kglrd does but anyone have any idea what the RD in the table name means? Read? Row? Data? Dependency? I'm open to suggestions. Regards, Mike Hately -Original Message- Sent: 10 January 2003 15:50 To: Multiple recipients of list ORACLE-L Stephane, My creativity has been stumulated, simulated, and mutated. What version of Oracle are you using? x$kglrd ...table or view does no exist on 8.1.7 rel 3 Ron [EMAIL PROTECTED] 01/10/03 05:03AM break on proc column QUERY format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM QUERY from x$kglrd where KGLNAOWN != 'SYS' order by 1, kgldepno / If it doesn't stimulate your creativity I can do nothing for you :-). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Some of you may find this useful
Naveen Nahata wrote: And how does one find out more information about such cryptic, undocumented tables?? experience? RD? be in company of more experienced people? wat else? Regards Naveen Doc which should not have left Oracle? In practice, the meaning of names you cannot guess but by grabbing information which leaks from Oracle. But the really useful stuff you get by trial and error. Call it RD if you want, but I have a higher opinion of RD. Typically, if you query V$FIXED_VIEW_DEFINITION you can get, by checking how GV$ views are defined, a good number of relationships between (G)V$ and X$ views. It can help document say around 40% of all the X$ columns. This unfortunately lets out in the cold a good number of X$ which are listed in V$FIXED_TABLE without seemingly being used anywhere. Just to tell you about X$KGLRD I have for some time being looking for how to relate commands of type 47 (PL/SQL stuff) which appear in V$SQL and V$SQLAREA to the regular SELECTs, INSERTs, UPDATEs, DELETEs they perform and which _also_ appear in the stats - for one thing, in order to interpret figures correctly, and also in order to be able to spot rotten algorithms, which I see as the next frontier in terms of SQL tuning. When you check V$FIXED_VIEW_DEFINITION you notice that V$SQL, V$SQLTEXT and family revolve around mostly X$KGL views - X$KGLOB, X$KGLNA and the like. I have therefore queried V$FIXED_TABLE for all X$KGL tables and described them. VARCHAR columns are rare enough for my eye to have been caught immediately by X$KGLRD (unreferenced by any V$), hence my post. Continuing my work afterwards, I have turned my attention to RAW columns and found that (kglrdhdl, kglnadhv) in this view were indeed the (address, hash_value) of the statement (I usually generate brute force joins on the RAW columns and see what returns something). Which means a) that you can get the full text from V$SQLTEXT when it is longer than 512 characters b) that when you spot a really ugly query in V$SQL, or a query which is executed an insane number of times, you can work out from X$KGLRD which procedure(s) call(s) it, which is not always easy otherwise (bar the LIKE of death on DBA_SOURCE, which will not work if say the query is dynamically built) - moreover it may also work with wrapped procedures. My aim, remember, was to relate a PL/SQL block to the statements it issues, so X$KGLRD is not the final answer. But I am still working on it and closing in ... X$KGLDP seems promising ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Some of you may find this useful
Stephane you have WAY too much free time :) seriously, I let you guys muck around the internals and I learn from your postings. Me, I'm busy enough just trying to keep my developers from designing tables without thought to how Oracle handles things. --- Stephane Faroult [EMAIL PROTECTED] wrote: Naveen Nahata wrote: And how does one find out more information about such cryptic, undocumented tables?? experience? RD? be in company of more experienced people? wat else? Regards Naveen Doc which should not have left Oracle? In practice, the meaning of names you cannot guess but by grabbing information which leaks from Oracle. But the really useful stuff you get by trial and error. Call it RD if you want, but I have a higher opinion of RD. Typically, if you query V$FIXED_VIEW_DEFINITION you can get, by checking how GV$ views are defined, a good number of relationships between (G)V$ and X$ views. It can help document say around 40% of all the X$ columns. This unfortunately lets out in the cold a good number of X$ which are listed in V$FIXED_TABLE without seemingly being used anywhere. Just to tell you about X$KGLRD I have for some time being looking for how to relate commands of type 47 (PL/SQL stuff) which appear in V$SQL and V$SQLAREA to the regular SELECTs, INSERTs, UPDATEs, DELETEs they perform and which _also_ appear in the stats - for one thing, in order to interpret figures correctly, and also in order to be able to spot rotten algorithms, which I see as the next frontier in terms of SQL tuning. When you check V$FIXED_VIEW_DEFINITION you notice that V$SQL, V$SQLTEXT and family revolve around mostly X$KGL views - X$KGLOB, X$KGLNA and the like. I have therefore queried V$FIXED_TABLE for all X$KGL tables and described them. VARCHAR columns are rare enough for my eye to have been caught immediately by X$KGLRD (unreferenced by any V$), hence my post. Continuing my work afterwards, I have turned my attention to RAW columns and found that (kglrdhdl, kglnadhv) in this view were indeed the (address, hash_value) of the statement (I usually generate brute force joins on the RAW columns and see what returns something). Which means a) that you can get the full text from V$SQLTEXT when it is longer than 512 characters b) that when you spot a really ugly query in V$SQL, or a query which is executed an insane number of times, you can work out from X$KGLRD which procedure(s) call(s) it, which is not always easy otherwise (bar the LIKE of death on DBA_SOURCE, which will not work if say the query is dynamically built) - moreover it may also work with wrapped procedures. My aim, remember, was to relate a PL/SQL block to the statements it issues, so X$KGLRD is not the final answer. But I am still working on it and closing in ... X$KGLDP seems promising ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BCHR Tuning
Jonathan, Since you've mentioned it, how about summarizing those mistakes for the rest of us? This goes for you too, Mogens. :) A few things didn't sound right to me, but I don't often spend time doing actual tuning of the database. My tuning usually involves fixing or working around development errrors. When I have to actually tune the database, I just pick the worst offenders from the wait stats, and then figure out how to fix them by reading everyone else's research and/or experimenting. Which is a long winded way of saying this stuff doesn't last long in my internal LIFO buffer. :) Jared On Saturday 11 January 2003 01:16, Jonathan Lewis wrote: A brilliant solution. I knew that the real Steve Adams couldn't have edited it when I say the line starting: quote Latches are low-level queuing mechanisms end quote The man who wrote THE book about latches in Oracle couldn't possibly have made the mistake of thinking that latching was a queueing mechanism. In fact, there is a bit in Steve's chapter on latches which says quite specifically: latches do not support request queueing latch requests are not necessarily serviced in order. Having said that, I thought the article was far better than usual. There was still plenty of scope for criticism, but it seemed to convey more useful information than usual, even though presentation and ordering were somewhat garbled in places, and there were several small errors and misunderstandings. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 11 January 2003 06:51 Undskyld! But you assumed that the Steve Adams mentioned at the bottom of that article is the one you know ;)) They should have mentioned Steve's Web site. They did not miss tusc and ioug URLs. Ummm. wonder why not ;) ;) I say poor Copy Editing on part of the publishers. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BCHR Tuning
On Friday 10 January 2003 14:48, Mogens Nørgaard wrote: Obviously, we don't know what we're talking about. I can see there's a presentation by Rich Niemich at IOUG-A where he'll address all those idiots who are saying you should ignore the Cash Hit Ratio (and who are all just after making big money on their products - I loved that one). Or modify the set up of these tools to take action when BCHR falls.. Here's the session info: Date: Mon, Apr 28, 2003 @ 11:45 AM - 12:15 PM Venue: Southern Hemisphere 2, Walt Disney World Dolphin, Lake Buena Vista, FL Abstract: Lately, there has been a big push to ignore your hit ratio with claims that it is meaningless. This shallow minded view (usually by people who sell a tuning tool) ignores why people look at hit ratios and what they are looking for. This quick tip talk will show you what to look for and why. You will definitely know when, where why to look at your hit ratio in the future. Show you why your hit ratio matters. How to analyze the hit ratio. Fallacies by those who want to sell you products and tools instead. Shallow Minded ?! Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE : RMAN Repository
Geez Tom, I didn't realize it was so simple. ;) On Friday 10 January 2003 11:04, Mercadante, Thomas F wrote: separate and simplify the issues. develop a bullet-proof backup and recovery plan for the Rman repository *first*. then develop plans for production databases. trying to do both at the same time is a fools-errand. waste of time. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 10, 2003 1:24 PM To: Multiple recipients of list ORACLE-L ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN new version myths
Find, but someone else can admin them. ;) Jared On Friday 10 January 2003 11:30, Rachel Carmichael wrote: couldn't hurt on the last two at least :) --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Rachel, do you think we need following lists created ... * oracle-l-overheard * oracle-l-debunking-myths * oracle-l-help-idiot 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: Friday, January 10, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Okay, from a friend within Oracle University (someone whose knowledge I trust).. 1. There are NO plans to eliminate the use of the RMAN Repository! As has been correctly surmised by some readers Oracle is attempting to make it easier to use rman without a repository but it is not going away. It is expected that large shops with a heavy Oracle investment would continue to use the Repository, but smaller shops may consider the complexity a burden. The Oracle instructor that said the RMAN repository was going away was either a. misunderstood b. wrong. c. both of the above 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 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Statspack performance problem
Thanks Mogen. Let's see if something comes of it. In the meantime, I only collect lvl 0 in that database. Jared On Friday 10 January 2003 13:29, Mogens Nørgaard wrote: Juan Loaize and the guys in ST (Server Technologies) in Oracle Development added some index structures to certain x$-things (and thereby v$-things) in 7.3 and onwards, I think. However, v$sqlarea still has to do a group by, which sucks. v$sql is faster, but has more data, of course. I've CC'ed Bjorn Engsig from Miracle on this - he worked on some optimisations on StatsPack at Oracle before quitting. He (or maybe Graham Wood) could perhaps help here. Mogens [EMAIL PROTECTED] wrote: That seems to have been the problem. The snap ran in 2 seconds after setting the level to 0. This database has 50k+ SQL statements cached, usually. Setting it back to 5 is taking a very long time. Apparently there is a lot going on behind the scenes when changing the snap level. In checking v$session_wait I find a lot of waits on latch free and direct path write. This session has not done any sorts to disk, so I'm not sure why there are direct path writes. Maybe there are LOB's in Perfstat schema? Dunno, have not looked. Thanks, Jared John Kanagaraj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/08/2003 01:55 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Statspack performance problem Jared, Did you snap with the default value of 5? If so, then the SNAP proceduer will have to scan / sort V$SQLAREA and that can be very time-consuming. If you are CPU starved or have very high shared_pool access or issues in that area, then this could explain it Try this with a snap level of 0 and let us know if this solves the issue. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Subject: Statspack performance problem List, Is anyone aware of performance problems with statspack on 8.1.6.3 on Windoze? By performance problem, I mean that statspack.snap runs for several minutes before I eventually kill it. Trying to check on MetaLink, but it isn't responding at the moment. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BCHR Tuning
and those people sell a tuning tool hm, I hadn't noticed any selling going on here. Or perhaps it's been subliminal? --- Jared Still [EMAIL PROTECTED] wrote: On Friday 10 January 2003 14:48, Mogens Nørgaard wrote: Obviously, we don't know what we're talking about. I can see there's a presentation by Rich Niemich at IOUG-A where he'll address all those idiots who are saying you should ignore the Cash Hit Ratio (and who are all just after making big money on their products - I loved that one). Or modify the set up of these tools to take action when BCHR falls.. Here's the session info: Date: Mon, Apr 28, 2003 @ 11:45 AM - 12:15 PM Venue: Southern Hemisphere 2, Walt Disney World Dolphin, Lake Buena Vista, FL Abstract: Lately, there has been a big push to ignore your hit ratio with claims that it is meaningless. This shallow minded view (usually by people who sell a tuning tool) ignores why people look at hit ratios and what they are looking for. This quick tip talk will show you what to look for and why. You will definitely know when, where why to look at your hit ratio in the future. Show you why your hit ratio matters. How to analyze the hit ratio. Fallacies by those who want to sell you products and tools instead. Shallow Minded ?! Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BCHR Tuning
Hmm, Lately? That actually started publicly in 1998 as far as I am concerned ;-) And acutally long before that. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, January 12, 2003 11:43 PM On Friday 10 January 2003 14:48, Mogens Nørgaard wrote: Obviously, we don't know what we're talking about. I can see there's a presentation by Rich Niemich at IOUG-A where he'll address all those idiots who are saying you should ignore the Cash Hit Ratio (and who are all just after making big money on their products - I loved that one). Or modify the set up of these tools to take action when BCHR falls.. Here's the session info: Date: Mon, Apr 28, 2003 @ 11:45 AM - 12:15 PM Venue: Southern Hemisphere 2, Walt Disney World Dolphin, Lake Buena Vista, FL Abstract: Lately, there has been a big push to ignore your hit ratio with claims that it is meaningless. This shallow minded view (usually by people who sell a tuning tool) ignores why people look at hit ratios and what they are looking for. This quick tip talk will show you what to look for and why. You will definitely know when, where why to look at your hit ratio in the future. Show you why your hit ratio matters. How to analyze the hit ratio. Fallacies by those who want to sell you products and tools instead. Shallow Minded ?! Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Some of you may find this useful
Precise Indepth for Oracle relates SQL statements to PL/SQL procedures without quering any X$ tables. So may you should buy that, but that may not be an option for you ;-) Anjo. Stephane Faroult wrote: . My aim, remember, was to relate a PL/SQL block to the statements it issues, so X$KGLRD is not the final answer. But I am still working on it and closing in ... X$KGLDP seems promising ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Daramtically improve BCHR with a single statement
To add an example of what Anjo, Morgens and everyone else is talking about, here is a perfect illustration of why focusing on BCHR is like concentrating intensely on how fast your tyres rotate in a Tour de France, instead of looking of where you are going (probably a lot more useful). Another example: If I raced (100M sprint) against Maurice Green, and he went off in the wrong direction, despite the fact that he is so much faster than me (duh !) , I could lightly jog (as if I have anything else to offer) the 100M in the right direction and beat him. Well, focusing on BCHR alone is like going at full tilt with no direction. Also, I have realized that cars have been around for 100 years now, so why exactly would I want to sprint again ? :-) Check out this example: run any number of scripts to look at BCHR. Then run the following anonymous PL/SQL block: declare jackass number; begin for jackass in 1..1000 loop execute immediate 'select count (*) from solvit.solvit_lic ' ; -- replace this table with any single row table you like. end loop; end; / Check your BCHR again. Wow, amazing ! How much better your BCHR looks now. This must be magic. If you would like to purchase other such tools, please feel free to drop me a line, I could also sell you a large iceberg, which would end your personal water restriction problems. Another advantage to the above code is that it eliminates idle capacity from my CPU's (I paid for the thing, it should be put to work, right ? ) as my laptop has been at 100% CPU utilization for the last 8 minutes as I let this piece of crap run before I killed it (Oracle 9 on XP with 512 MB RAM [SGA 120 MB], with a bunch of other starved stuff running concurrently). Reduction of logical I/O : Now THERE is the holy grail worth pursuing ! I am sure we could have a VERY interesting discussion on that one ! Feel free to use the above example to prove for once and for all that concetration on tuning BCHR alone is a fruitless exercise. Regards : Ferenc Mantfeld -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Subject:Re: BCHR Tuning and those people sell a tuning tool hm, I hadn't noticed any selling going on here. Or perhaps it's been subliminal? --- Jared Still [EMAIL PROTECTED] wrote: On Friday 10 January 2003 14:48, Mogens Norgaard wrote: Obviously, we don't know what we're talking about. I can see there's a presentation by Rich Niemich at IOUG-A where he'll address all those idiots who are saying you should ignore the Cash Hit Ratio (and who are all just after making big money on their products - I loved that one). Or modify the set up of these tools to take action when BCHR falls.. Here's the session info: Date: Mon, Apr 28, 2003 @ 11:45 AM - 12:15 PM Venue: Southern Hemisphere 2, Walt Disney World Dolphin, Lake Buena Vista, FL Abstract: Lately, there has been a big push to ignore your hit ratio with claims that it is meaningless. This shallow minded view (usually by people who sell a tuning tool) ignores why people look at hit ratios and what they are looking for. This quick tip talk will show you what to look for and why. You will definitely know when, where why to look at your hit ratio in the future. Show you why your hit ratio matters. How to analyze the hit ratio. Fallacies by those who want to sell you products and tools instead. Shallow Minded ?! Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
RE: Some of you may find this useful
Thanx a lot for a very comprehensive answer. More than the result, I learnt the method. thanx a lot Regards Naveen -Original Message- Sent: Sunday, January 12, 2003 9:04 PM To: Multiple recipients of list ORACLE-L Naveen Nahata wrote: And how does one find out more information about such cryptic, undocumented tables?? experience? RD? be in company of more experienced people? wat else? Regards Naveen Doc which should not have left Oracle? In practice, the meaning of names you cannot guess but by grabbing information which leaks from Oracle. But the really useful stuff you get by trial and error. Call it RD if you want, but I have a higher opinion of RD. Typically, if you query V$FIXED_VIEW_DEFINITION you can get, by checking how GV$ views are defined, a good number of relationships between (G)V$ and X$ views. It can help document say around 40% of all the X$ columns. This unfortunately lets out in the cold a good number of X$ which are listed in V$FIXED_TABLE without seemingly being used anywhere. Just to tell you about X$KGLRD I have for some time being looking for how to relate commands of type 47 (PL/SQL stuff) which appear in V$SQL and V$SQLAREA to the regular SELECTs, INSERTs, UPDATEs, DELETEs they perform and which _also_ appear in the stats - for one thing, in order to interpret figures correctly, and also in order to be able to spot rotten algorithms, which I see as the next frontier in terms of SQL tuning. When you check V$FIXED_VIEW_DEFINITION you notice that V$SQL, V$SQLTEXT and family revolve around mostly X$KGL views - X$KGLOB, X$KGLNA and the like. I have therefore queried V$FIXED_TABLE for all X$KGL tables and described them. VARCHAR columns are rare enough for my eye to have been caught immediately by X$KGLRD (unreferenced by any V$), hence my post. Continuing my work afterwards, I have turned my attention to RAW columns and found that (kglrdhdl, kglnadhv) in this view were indeed the (address, hash_value) of the statement (I usually generate brute force joins on the RAW columns and see what returns something). Which means a) that you can get the full text from V$SQLTEXT when it is longer than 512 characters b) that when you spot a really ugly query in V$SQL, or a query which is executed an insane number of times, you can work out from X$KGLRD which procedure(s) call(s) it, which is not always easy otherwise (bar the LIKE of death on DBA_SOURCE, which will not work if say the query is dynamically built) - moreover it may also work with wrapped procedures. My aim, remember, was to relate a PL/SQL block to the statements it issues, so X$KGLRD is not the final answer. But I am still working on it and closing in ... X$KGLDP seems promising ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DB Triggers vs Stored Procedures
Hi All I would like to know the difference between using the Stored procedures in DB Triggers and writing the code directly in the DB Trigger. Which would be better to use and what r the advantages. Rgds Sathya -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BCHR Tuning
And quite a number of folks were making use of the v$ stats quite some time before that with little regard for the BCHR, though maybe not officially yet ignoring the BCHR Jared On Sunday 12 January 2003 17:03, Anjo Kolk wrote: Hmm, Lately? That actually started publicly in 1998 as far as I am concerned ;-) And acutally long before that. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, January 12, 2003 11:43 PM On Friday 10 January 2003 14:48, Mogens Nørgaard wrote: Obviously, we don't know what we're talking about. I can see there's a presentation by Rich Niemich at IOUG-A where he'll address all those idiots who are saying you should ignore the Cash Hit Ratio (and who are all just after making big money on their products - I loved that one). Or modify the set up of these tools to take action when BCHR falls.. Here's the session info: Date: Mon, Apr 28, 2003 @ 11:45 AM - 12:15 PM Venue: Southern Hemisphere 2, Walt Disney World Dolphin, Lake Buena Vista, FL Abstract: Lately, there has been a big push to ignore your hit ratio with claims that it is meaningless. This shallow minded view (usually by people who sell a tuning tool) ignores why people look at hit ratios and what they are looking for. This quick tip talk will show you what to look for and why. You will definitely know when, where why to look at your hit ratio in the future. Show you why your hit ratio matters. How to analyze the hit ratio. Fallacies by those who want to sell you products and tools instead. Shallow Minded ?! Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB Triggers vs Stored Procedures
Read THIS fabulous manual: http://www.bookpool.com/.x/pbsr99hds8/sm/0596003811 Ferenc Mantfeld -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Subject:DB Triggers vs Stored Procedures Hi All I would like to know the difference between using the Stored procedures in DB Triggers and writing the code directly in the DB Trigger. Which would be better to use and what r the advantages. Rgds Sathya -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mantfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
rsh on Unix hangs - OT
The problem with rsh is as follows. The actual script is as follows. echo subbu su finacle -c '. /etc/b2k/ncb/com/commonenv.com;cd /finacle/ncb/b2kcomp1/3.0/bin;./stops' echo After stops sleep 5 su finacle -c '. /etc/b2k/ncb/com/commonenv.com;cd /finacle/ncb/b2kcomp1/3.0/bin;./runs' echo after runs echo subbu When I execute this script from a remote machine as rsh archie /finacle/services/failover/back110102/subbu.com The output is as follows subbu After stops after runs subbu After that that the rsh command is hanging. Actually it is running all the commands of remote script and then it is hanging. Any pointers to solve this problem. This is required as a part of failover between two machines. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).