RE: Some of you may find this useful

2003-01-12 Thread Andrey Bronfin
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:

Re: Some of you may find this useful

2003-01-12 Thread Stephane Faroult
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,

Re: Oracle CD's

2003-01-12 Thread faisal ahmad
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

RE: Some of you may find this useful

2003-01-12 Thread Naveen Nahata
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

RE: Some of you may find this useful

2003-01-12 Thread Andrey Bronfin
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

Re: Some of you may find this useful

2003-01-12 Thread Stephane Faroult
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

Re: Some of you may find this useful

2003-01-12 Thread Rachel Carmichael
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:

Re: BCHR Tuning

2003-01-12 Thread Jared Still
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

Re: BCHR Tuning

2003-01-12 Thread Jared Still
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

Re: RE : RMAN Repository

2003-01-12 Thread Jared Still
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

Re: RMAN new version myths

2003-01-12 Thread Jared Still
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 *

Re: Statspack performance problem

2003-01-12 Thread Jared Still
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

Re: BCHR Tuning

2003-01-12 Thread Rachel Carmichael
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

Re: BCHR Tuning

2003-01-12 Thread Anjo Kolk
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

Re: Some of you may find this useful

2003-01-12 Thread Anjo Kolk
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

RE: Daramtically improve BCHR with a single statement

2003-01-12 Thread mantfield
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

RE: Some of you may find this useful

2003-01-12 Thread Naveen Nahata
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

DB Triggers vs Stored Procedures

2003-01-12 Thread Sathyanaryanan_K/VGIL
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:

Re: BCHR Tuning

2003-01-12 Thread Jared Still
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

RE: DB Triggers vs Stored Procedures

2003-01-12 Thread mantfield
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

rsh on Unix hangs - OT

2003-01-12 Thread VIVEK_SHARMA
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'