Re: ANALYZE question
Thanks all for your advice. Will check an option to do estimate. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 7:23 PM At the last Open World I attended a couple of sessions where the general advice for 9i DB is to use ANALYZE ESTIMATE without specifying ANY value. A few brief comparision tests did show that it got better results than the alternatives tested. As always, YMMV HTH HAND! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: where should i start to learn to become a DBA?
Shuan,
Welcome. Being a DBA is not rocket science neither is it childs play.
Reading, testing, experimenting on a dev instance is the way to go.
We all started out at some point like you.
We all do it and will continue to do so cos:
we tend to forget,
newer versions/ patches come out,
diferent books and papers have different useful ideas,
My advice is dont try to grasp too much too quickly although we all like to do
that sometimes. Read and understand what you doing properly before you
advance to the next chapter. And start with the B A S I C S.
I would not sugest to u buying any books or taking any courses right away.
Learn on your own first and then take courses later so u have a more clearer
picture when u take the classes.
A good place to start is the Oracle Concepts Guide and then move on to the
Oracle Administrators Guide. Also ask questions to clear any doubts.
Just my thoughts. Let see what the others have to say.
Cheers
Suhen
On Thu, 25 Jul 2002 16:53, you wrote:
Hi DBAs!
I'm working as a System Programmer for only one year.
And i'm interested to Oracle, wish to become DBA like you guys.
I did read some Oracle reference books, searching the web to find more
about Oracle,
and of course, here in this list, reading you guys' experiences for
already few months.
I've keep trying to learn the Oracle by myself(good or bad?).
When face problems, trying to play around myself here and there in
Oracle,
RTFM, FAQs...anything that can find the similar problem.
To be honest, i don't think i learn much.
Maybe it's because i don't know the proper way to learn it.
Well...i don't read books page by page,
i only read those i'm curious at the beginning.
But i feel i'm getting confusing. I don't know whether i'm going in the
correct way.
It's so many times that i have to reinstall the Oracle.
('Cos i dun know how to make it running again, a lot of errors.)
So, can you guys give me some advices of
which section should i start as a beginner?
What's the next? and so on...and so on...
Or any links to point to?
mm...I'm playing with Oracle 8.1.6 in Win2000 on my PC.
Sometimes...play around with Oracle 8.0.5 on Linux(Which is corporate DB
Server, shh...)
Thanks for any advices.
Have a nice day!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suhen Pather
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Cursor Sharing| Soft Parsing
On Wednesday 24 July 2002 22:08, MacGregor, Ian A. wrote: Please define soft parsing. Oracle needs to check that the user submitting a SQL statement has permissions to run it. It has to do this every time a statement is run, bind variables or not. No, code that uses bind variables need only parse SQL statements once if session_cached_cursors is set. Further executions of the same SQL don't require a hard or soft parse. Jared When cursor-sharing converts a statement to use bind variables it would save on hard parsing, if a match were found the pool; also, it could lessen the number of statements present in the pool. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Mike, Kirti, Try page 441 CURSOR_SHARING=FORCE does improve badly written applications that use lots of literals. However coding should be done using bind variables in almost all occasions. CURSOR_SHARING=FORCE reduces the hard parsing. What CURSOR_SHARING=FORCE does is rewrites all queries to use bind variables before parsing. eg. select ename from emp where empno = 10; rewritten as select ename from emp where empno =:SYS_B_0 or in 8.1.6 , 8.1.7 select name from emp where empno =:SYS_B_0 So it substitutes the literal with bind variables but incurs the cost of soft parsing the statement. Soft Parsing too frequently limits the scalability of applications and sacrifices optimal performance which could have been achieved in the first place if written using bind variables. Parse once and execute as many times as we like. Also check out Bjorn's paper on bind variables and cursor sharing at http://technet.oracle.com/deploy/performance/pdf/cursor.pdf So CURSOR sharing is not the silver bullet as one may expect. Regards Suhen On Thu, 25 Jul 2002 10:23, you wrote: Mike, What is the version of the database? Some versions of 8.1.7 had a few bugs when this parameter was set to FORCE. I suggest searching Metalink. But it does work as advertised in later releases. I would also recommend reviewing Tom Kytes' book to read about his views in using this parameter at the instance level (my boss is reading my copy, so I can't give you page #s). - Kirti -Original Message- Sent: Wednesday, July 24, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Has anyone set Cursor Sharing to Force ? I have a new system that we have to support and there is alot literals filling up the pool.I have never changed this parameter from the default as many seemed to think the jury was still out on it. However, due to my situation, I figured I would try it out. If anyone has any experience with this one I would be curious to know what happened. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: (memes) not making much headway with critiquing elitist dba
Life is full of paradoxes. On 24 Jul 2002 at 10:33, [EMAIL PROTECTED] wrote: What I cannot understand is why you left the fertilizer industry. Based on your commentary and the state of the economy I suspect demand could not keep up with your supply. Just kidding your posts are quite amusing. -- 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: Rman duplicating failing when setting redo logs
Hi, U don't give much info,but... Could it be that you are duplicating without untill clause.. If so you may hit bug 2329702. (I did when testing all sorts of RMAN scenarios) There is a workaround but no fix yet *** 05/10/02 04:54 pm *** FOr those who find problematic to know what is the latest archive log and plug it in the script, the following permanent workaround is available: set until scn 281474976710655; Jack Peter.McLarty@min com.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Rman duplicating failing when setting redo logs 24-07-2002 01:23 Please respond to ORACLE-L One for the rman smarties I am duplicating a database with rman and it get to the section where it does an alter database open reset logs and it fails as there appears to be a path error. I then go into server manager and do the same and the path is '/u01/oracle/product/8.1.7/dbs/ /u07/oracle/oradata/mimstrn/log1a.log' If I do a backup control file to trace on this now created database the path for the logs is like above for all log files If I now edit that and use it to generate a new control file I am able to open the database with a resetlogs. Question is there something I have wrong with rman or am I doing something wrong with my setup Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not
Re: Is Statspack a Security Problem?
Thanks Ian. Have a beer on me, you earned it with this info. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 11:51 PM Ian, You are likely to win the wager on this one. I discovered the public when i was trying to secure my database. There are grants to public all over the place. I would be very interested to know and understand why Oracle did grant so much to public and what can be safely revoked. Ron ROR mô¿ôm [EMAIL PROTECTED] 07/24/02 04:20PM I'm not saying it's not fixable. The creation of dba level accounts such as dbsnmp and outln by Oracle is fixable as well. But I'll wager there are folks out there who didn't know the grants on the statspack tables were to public. Of course none of our developers or ad hoc query writers would ever write a statement that doesn't use bind variables. I have it on good authority that the same holds true for all Oracle sites everywhere. :) Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 11:56 AM To: Multiple recipients of list ORACLE-L Why not just backup the spctab.sql script and then in vi do a g:/PUBLIC/s//DBA or whatever role you choose to play with statspack before running. Although bind vars are still appropriate too. Rodd Holman On Wed, 2002-07-24 at 12:23, kkennedy wrote: Sounds like yet another good reason for using bind variables 8-) Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Wednesday, July 24, 2002 8:23 AM To: Multiple recipients of list ORACLE-L To wit: $grep -i grant spctab.sql snip grant select onSTATS$SQLTEXT to PUBLIC; grant select onSTATS$SQL_STATISTICS to PUBLIC; grant select onSTATS$LEVEL_DESCRIPTION to PUBLIC; grant select onSTATS$IDLE_EVENT to PUBLIC; grant select onSTATS$PARAMETER to PUBLIC; grant select onSTATS$STATSPACK_PARAMETER to PUBLIC; --- Notice the grants on stats$sqltext and stats$sql_summary. Should anyone who logs into the database be able to see nearly SQL run against it. Oracle appears to truncate alter user statements so that one cannot find 'alter user blatz identified by password;' but one may stumble on update sal_table set sal = 100 where empoyee_id = 5;' or something to that effect. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
I'm not saying that the shutdown abort *caused* the redo log corruption, but the code that writes redo logs is, like any other software, prone to bugs. Redo logs are only ever read during a recovery of one sort or another, so the code only really gets tested then, and if it fails, there is no fallback. The code that reads and writes to datafiles, on the other hand, is tested all the time, and if *it* fails, you've always got the redo logs. We use a script that tries to do a shutdown immediate and if that fails to complete in a reasonable time, does a checkpoint/abort/startup restrict/shutdown immediate. In a perfect world, the latter wouldn't be necessary because I would have investigated and cured every possible cause for shutdown immediate to hang, but a) debugging these problems is difficult and b) the effort involved upgrading to a sensible version of Oracle is not worth the (supposedly) limited lifetime of this database. Regards David Lord -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: 24 July 2002 23:44 To: Multiple recipients of list ORACLE-L Subject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm But if you are concerned that shutdown abort could corrupt your redo logs, then that is equivalent to mandating that all servers (that run oracle) must be on an infinite uninterruptible power supply. An instance failure (eg loss of power) is effectively a shutdown abort - so the only way to avoid that would be to have power available all the time. You couldn't have a UPS that is good for (say) 12 hours - because we can never guarantee that a shutdown immediate would finish in this amount of time - and you could not speed up the job with a shutdown abort because that is the cause of all the consternation in the first place If you're getting corrupt redo logs with shutdown abort, then you're exposed to corrupt redo logs anyway. Its not a shutdown abort problem, its a bug in either the oracle or OS layer. hth connor --- April Wells [EMAIL PROTECTED] wrote: That is EXACTLY what happened a week and a half ago. We had to do a shutdown abort because it wouldn't go down, and when we tried to restart it, it wouldn't come back... redo log corruption... and this being test... it isn't in archive log mode (another valid solution but no longer really an option in our case). After we can get back in to the building after the teeny little fire and vandalism thing we have going this morning and I can get all concerned parties in the same place (sans smoke and water) my suggestion is going to be that since we don't know why, and there isn't much of a work around yet, that test and development (at least for now) go into archive log mode, as well. ajw -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/24/02 4:09 AM Couldn't agree with you more. I recently had a database fail to restart after a shutdown abort because the redo log got corrupted somewhere along the line. Ended up doing a full restore and roll forward. Admittedly, this was on 7.1.4 (don't ask;-) David Lord -Original Message- Sent: 24 July 2002 01:33 To: Multiple recipients of list ORACLE-L imm I have steel belted radial tires on my car that are supposed to be puncture resistant. Is this a good reason for me to go out of my way to drive by a construction site every morning? By my way of thinking, no. If my regular road is blocked and I have no alternative, then I will drive by the construction site reasonably confident that the debris will not puncture my tires. If I'm in a big hurry and driving by the construction site is significantly quicker, then I will consider it. But, I don't go out of my way looking for trouble. Does anyone have a better argument than I've been doing this for years and it has always worked? Kevin Kennedy First Point Energy Corporation ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. **
RE: Discoverer 9i: Export data to PDF gives internal error
Hi there! Here is the solution: I wrote there is a new connect window in the background - navigable but not editable. Some light on this ;-) ... I have five Oracle Homes on my PC, because I am testing new releases of Oracle software (e.g. Discoverer 9.0.2). The database connect is well defined in the tnsnames.ora in the oracle home for 9i tools but not defined in the oracle home for 6i tools (a newbie error - annoyingly, but there is no qualified error message from Discoverer ...). So Reports (6i!) is not able to connect to the target database. But if you wish to export to PDF you need reports 6i. Thanks again! Best regards! Henrik -Ursprüngliche Nachricht- Von: Peck, David [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 24. Juli 2002 19:24 An: Multiple recipients of list ODTUG-DISC2K-L Betreff: RE: Discoverer 9i: Export data to PDF gives internal error The oracle rep told me to hard code the path and capitalize the first letter: c:\orant\bin\Rwbld60.exe David Peck Baker Hughes Inc. BHBSS-BASIS (713) 625-6649 -Original Message- Sent: Wednesday, July 24, 2002 11:04 AM To: Multiple recipients of list ODTUG-DISC2K-L Hi, thanks for your answer. The registry keys are as follows: HKEY_CURRENT_USER\Software\ORACLE\Discoverer 902\Reports\BuilderExe = rwbld60.exe HKEY_CURRENT_USER\Software\ORACLE\Discoverer 902\Reports\RuntimeExe = rwrun60.exe These binaries are correct installed (path). But when the internal Discoverer error occurs there is a new connect window in the background - navigable but not editable. It seems to be a report connect window?! Any further hints appreciated. Best regards Henrik -Ursprüngliche Nachricht- Von: Peck, David [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 24. Juli 2002 16:29 An: Multiple recipients of list ODTUG-DISC2K-L Betreff: RE: Discoverer 9i: Export data to PDF gives internal error I opened a TAR on this. ORACLE told me that export to report and PDF only works with Dev 6i. Make sure registry keys point to rwbld60.exe and rwrun60.exe. See metalink doc # 119193.1 and bug 2448099. David Peck Baker Hughes Inc. BHBSS-BASIS (713) 625-6649 -Original Message- Sent: Tuesday, July 23, 2002 6:48 AM To: Multiple recipients of list ODTUG-DISC2K-L Hi there! In discoverer 9.0.2.39.01 (desktop edition), EUL 5.0.0.0.0.0 the export data option to PDF gives the following error: Internal Error in generating report Export failed. In MetaLink you can find bug 780474 for Discoverer 3! It seems to be the same bug?! If there is a workaround please send a hint to the list. Anybody out there who can give me a hint? Best regards! Henrik Henrik Bachmann mailto:[EMAIL PROTECTED] B.I.M.-Consulting Magdeburghttp://www.bim-consulting.de/ D-39108 Magdeburg Thanks to everyone for making ODTUG 2002 a great success! Plan now for next year's conference: Loews Miami Beach, Florida, June 22-27, 2003. -- Author: Bachmann, Henrik INET: [EMAIL PROTECTED] Thanks to everyone for making ODTUG 2002 a great success! Plan now for next year's conference: Loews Miami Beach, Florida, June 22-27, 2003. -- Author: Bachmann, Henrik INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bachmann, Henrik INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: where should i start to learn to become a DBA?
very well said Shuan...
u have precisely said what and how ppl should go about the learning
process...and as u have mentioned it does not apply to just beginners but
experience ppl also..
as knowledge has no endwe have to keep learning and upgrading
ourselves...
In fact the practical aspect of learning is most important...
rgds,
Ams.
|-Original Message-
|From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Suhen
|Pather
|Sent: Thursday, July 25, 2002 11:43 AM
|To: Multiple recipients of list ORACLE-L
|Subject: Re: where should i start to learn to become a DBA?
|
|
|Shuan,
|
|Welcome. Being a DBA is not rocket science neither is it childs play.
|Reading, testing, experimenting on a dev instance is the way to go.
|
|We all started out at some point like you.
|
|We all do it and will continue to do so cos:
|we tend to forget,
|newer versions/ patches come out,
|diferent books and papers have different useful ideas,
|
|My advice is dont try to grasp too much too quickly although
|we all like to do
|that sometimes. Read and understand what you doing properly
|before you
|advance to the next chapter. And start with the B A S I C S.
|
|I would not sugest to u buying any books or taking any courses
|right away.
|Learn on your own first and then take courses later so u have
|a more clearer
|picture when u take the classes.
|
|A good place to start is the Oracle Concepts Guide and then
|move on to the
|Oracle Administrators Guide. Also ask questions to clear any doubts.
|
|Just my thoughts. Let see what the others have to say.
|
|Cheers
|Suhen
|
|
|On Thu, 25 Jul 2002 16:53, you wrote:
| Hi DBAs!
|
| I'm working as a System Programmer for only one year.
| And i'm interested to Oracle, wish to become DBA like you guys.
| I did read some Oracle reference books, searching the web to
|find more
| about Oracle,
| and of course, here in this list, reading you guys' experiences for
| already few months.
|
| I've keep trying to learn the Oracle by myself(good or bad?).
| When face problems, trying to play around myself here and there in
| Oracle,
| RTFM, FAQs...anything that can find the similar problem.
|
| To be honest, i don't think i learn much.
| Maybe it's because i don't know the proper way to learn it.
| Well...i don't read books page by page,
| i only read those i'm curious at the beginning.
| But i feel i'm getting confusing. I don't know whether i'm
|going in the
| correct way.
| It's so many times that i have to reinstall the Oracle.
| ('Cos i dun know how to make it running again, a lot of errors.)
| So, can you guys give me some advices of
| which section should i start as a beginner?
| What's the next? and so on...and so on...
| Or any links to point to?
|
| mm...I'm playing with Oracle 8.1.6 in Win2000 on my PC.
| Sometimes...play around with Oracle 8.0.5 on Linux(Which is
|corporate DB
| Server, shh...)
|
| Thanks for any advices.
| Have a nice day!
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Suhen Pather
| INET: [EMAIL PROTECTED]
|
|Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
|San Diego, California-- Public Internet access / Mailing Lists
|
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|the message BODY, include a line containing: UNSUB ORACLE-L
|(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: Amjad Saiyed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Problem with Oracle manager for MTS
Hello, We are on Intel pentium 4 windows 2000 SP2 server. We tried to install oracle 8.1.6 client and no thing happened where we clicked on the SETUP button. We applied the patch 1507768 and every thing was okay, we could connect to the database (8.1.7.0 in AIX) via sqlplus. Now when we try to create a service for Microsoft transaction server we got this warning (in french) that we don't get on any other server : Le chiffrement des mots de passe n'est pas pris en charge lorsque la variable locale est la France. Le motde passe sera stocké en toutes lettres dans la de registre. In english : The encryption of the password isn't supported where environment variable is set to France. The password will be written into the register's base without encryption. We can then create the service but the database ID isn't shown in the service's property and there isn't any enregistrement in the table MTS_PROXY_INFO. We've opened an Itar since last week but they don't find any thing and I find nothing in the internet. Any help will be appreciated. Best regards, Thanh-truc Nguyen Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 /mn) ; tél : 08 92 68 13 50 (0,34/mn) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Thanh-truc_Nguyen? INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
script related query
Hi all ! I am a Delphi programmer. In our application we can modifying the design of reports at run time, we canput controls etc at run time. Now when we saved the report the setting of controls(includingdatawareness of controls) is saved as CLOB field in database. Next time when report section is loaded in my application all the settings for controls are read from database(clob field). Now the problem is that I want to write the script which will contain the data of my database and will populate the database of our client so that report can be generated there also. Basically the script should have data from the table wherecontrols setting are saved. Now I want when my clients run the script it should copy those data in their data base. If record with same id is already there then it should not overwrite rather a new id should be generated and data should get copied. The reporting tool i am using is Report Builder (Iguess which has no significance with this problem). Any idea :( Thanks in advance ... Shishir Kumar MishraAgni Software (P) Ltd.www.agnisoft.com--Vidya Dadaati Viniyam--
RE: SMP on windows2000
Thanks. I was thinking of the Oracle executable on Windows2000. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 7:29 PM To: Multiple recipients of list ORACLE-L Subject:Re: SMP on windows2000 File: Card for Don Jerman My understanding is according to design it should do it automatically. My experience is it does, sort of. But the app has to be multi-threaded (by the OS definition, not just context-mapped like Java green threads) for it to ever use more than one processor at the same time. If your single-threaded then for obvious reasons NT will tend to give the next time-slice to the same processor if it's not busy, so it looks like you're stuck on the same one much of the time. With the task manager you can set processor affinity on MP machines from the right-click menu of the process. This limits which of the N processors will be used to schedule your process. So you can limit one processor hog to 1 or 2 processors and let the well behaved programs run freely on the others. I don't know how to do this using non-gui tools or to set it up at start time, and your userid has to have permission to do it (essentially you have to be running as the process owner). But it's a starting point for research :). Boivin, Patrice J wrote: I am probably just complaining now, I think I know the answer already. Is it possible to force Windows2000 to spread the load for one application to 2 or more CPUs, from the OS side? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-03113: end-of-file on communication channel. HELP !
Hi, We have a Unix user dcclive ( oracle database user ops$dcclive - os authentication ). I am able to connect my database using TNS Alias but not directly. when i start the database in the following way : After logging in as dcclive ( C Shell ), su -u oracle ( Korn Shell ) and started the database, exit from oracle login , connect from dcclive login using os authentication ( using / in sqlplus ), it connects to the database. But when i logging in as dcclive ( C Shell ), su oracle and started the database, exit from oracle login , connect from dcclive login using os authentication ( using / in sqlplus ), it DOES NOT connects to the database. To connect now, i have to use TNS Alias as seen below. uid=1037(dcclive) gid=101(dba) kitchen% sqlplus / SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 25 12:07:36 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-03113: end-of-file on communication channel Enter user-name: / @dcclive Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Why ? Please note that Oracle login has Korn shell. Does the change of shell matters ? or am i missing something ? I have checked all the necessary env. variables. All r set properly. How exactly su -u and su matters to oracle ? Thanks in advance. Arul. -- 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).
Hot tables
Title: Message How is everyone identifying hot tables? In my tool box I have the following two scripts but I am looking for other options. How do you track frequently accessed tables? Script #1 - Author unknown: select obj_name, sum(decode(action_name,'SELECT',1,0)) sel ,sum(decode(action_name,'INSERT',1,0)) inserts, sum(decode(action_name,'UPDATE',1,0)) updates, sum(decode(action_name,'DELETE',1,0)) deletes from dba_audit_trail having sum(decode(action_name,'SELECT' , 1, 'INSERT',1, 'DELETE',1,'UPDATE',1,0)) 0 group by obj_name; Script #2 - Dave Ensor (BMC):set verify off col CTYP heading 'Command Type' col OBJ format a32 wrap heading 'Table' col EXES format 999,990 heading 'Execs' col GETS format 99,999,990 heading 'Buff Gets' col ROWP format 99,999,990 heading 'Rows Proc' select CTYP , OBJ , 0 - EXEM EXES , GETS , ROWP from (select distinct EXEM, CTYP, OBJ, GETS, ROWP from ( select decode (S.COMMAND_TYPE , 2, 'Insert into ' , 3, 'Select from ' , 6, 'Update of ' , 7, 'Delete from ' , 26, 'Lock of ') CTYP , O.OWNER || '.' || O.NAME OBJ , sum(0 - S.EXECUTIONS) EXEM , sum(S.BUFFER_GETS) GETS , sum(S.ROWS_PROCESSED) ROWP from V$SQL S , V$OBJECT_DEPENDENCY D , V$DB_OBJECT_CACHE O where S.COMMAND_TYPE in (2,3,6,7,26) and D.FROM_ADDRESS = S.ADDRESS and D.TO_OWNER = O.OWNER and D.TO_NAME = O.NAME and O.TYPE = 'TABLE' group by S.COMMAND_TYPE , O.OWNER , O.NAME ) ) where ROWNUM = 1 /
Re: where should i start to learn to become a DBA?
In my case, I was invited to a meeting attended by 6 people. The meeting
room had 5 chairs. When the new CIO asked who wants to be the DBA?, I was
the only one standing.
P.S. I really wanted to be the systems programmer.
From: shuan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: where should i start to learn to become a DBA?
Date: Wed, 24 Jul 2002 22:53:19 -0800
Hi DBAs!
I'm working as a System Programmer for only one year.
And i'm interested to Oracle, wish to become DBA like you guys.
I did read some Oracle reference books, searching the web to find more
about Oracle,
and of course, here in this list, reading you guys' experiences for already
few months.
I've keep trying to learn the Oracle by myself(good or bad?).
When face problems, trying to play around myself here and there in Oracle,
RTFM, FAQs...anything that can find the similar problem.
To be honest, i don't think i learn much.
Maybe it's because i don't know the proper way to learn it.
Well...i don't read books page by page,
i only read those i'm curious at the beginning.
But i feel i'm getting confusing. I don't know whether i'm going in the
correct way.
It's so many times that i have to reinstall the Oracle.
('Cos i dun know how to make it running again, a lot of errors.)
So, can you guys give me some advices of
which section should i start as a beginner?
What's the next? and so on...and so on...
Or any links to point to?
mm...I'm playing with Oracle 8.1.6 in Win2000 on my PC.
Sometimes...play around with Oracle 8.0.5 on Linux(Which is corporate DB
Server, shh...)
Thanks for any advices.
Have a nice day!
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Martin Brown
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Cursor Sharing
Don, Sounds like you have a VP there who is willing to suffer pain to cure the disease. Many places don't have high-level people like that. Last place I worked I used CURSOR_SHARING=FORCE because the programmers didn't want to code prepared statements (most of the statements were select... where username = 'literal string'. I PROVED to them that they were the cause of the shared pool allocation errors by pulling the statements out of the sql area. Didn't matter, it would have put them behind schedule. VP agreed with the programmers, I put cursor sharing on. Solved the problem Of course, the complicated stuff the DBAs wrote worked slower but no one seemed to care Rachel --- Don Granaman [EMAIL PROTECTED] wrote: Actually, CURSOR_SHARING=FORCE is in the index. ;-) The short (?) story is that it is a crutch. It can provide some relief from applications that pour out tons of nearly identical SQL -varying only in literal values, but it can also cause some significant problems. Also, there are a lot of bugs with it in all the versions I've used it in (8.1.6.x and 8.1.7.x). My experience is that it (a) works and (b) helps significantly in about 30% of the system where I've tried it. Bugs include things like: 1) ... where col1='X'and col2='Y' (in 8.1.6.x, it substitutes wrong and generates an error. Fixed in 8.1.7) 2) If the first value in a bind list is a null, it can generate a process crash with an ORA-07445 (in 8.1.7.1.? at least) 3) Java thin clients can return wrong results (hearsay - from Stan Yelliot) --- Moral of the story - test it *very thoroughly*! It can also cause some significant problems, even when it works correctly. For example: *) It cures the most obvious symptoms, but not the disease. Developers often like to think otherwise and simply continue bad coding practices. CURSOR_SHARING still doesn't avoid a soft parse. Applications with lots of literals typically don't reuse cursors either. Partially masking serious design and coding flaws with magic bullets like CURSOR_SHARING=FORCE doesn't actually solve the much larger systemic problems. It is likely to buy you some time and fewer headaches with thrashing in the shared pool, but it still isn't very scalable in the long run. *) *ALL* literals get substituted. This can throw the optimizer off. Examples: (1) where ... and 1 = 2 (Oh! I don't really need to fetch any rows! isn't obvious.) (2) When a literal causes the optimizer to use histograms well. STATUS_CODE has possible values of 'OPEN and 'CLOSED'. 99% of all records have 'CLOSED', but 99% of all queries are for 'OPEN'. DBAs would gladly suffer an extra statement with literals rather than suffer a poor execution plan for 99% of the executions. I consider using CURSOR_SHARING=FORCE like I would consider using a tourniquet - its preferrable to sudden death, but it isn't applicable in every case and is rarely a great long term solution. About three days ago, I had this discussion with a (very technical) VP. *Everything* is written with literals. Every literal statement is prepare()ed. I explained the basic issues to him and his preference was not to use it. He wants to force a resolution of the deeper issues by letting the situation become so bad soon that it forces a better, more permanent solution - before the rapidly increasing transaction volume REALLY hits the fan. The CURSOR_SHARING=FORCE safety valve is something we are reserving as a last, temporary resort. Don Granaman [OraSaurus] BTW: Hi Mike! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 7:23 PM Mike, What is the version of the database? Some versions of 8.1.7 had a few bugs when this parameter was set to FORCE. I suggest searching Metalink. But it does work as advertised in later releases. I would also recommend reviewing Tom Kytes' book to read about his views in using this parameter at the instance level (my boss is reading my copy, so I can't give you page #s). - Kirti -Original Message- Sent: Wednesday, July 24, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Has anyone set Cursor Sharing to Force ? I have a new system that we have to support and there is alot literals filling up the pool.I have never changed this parameter from the default as many seemed to think the jury was still out on it. However, due to my situation, I figured I would try it out. If anyone has any experience with this one I would be curious to know what happened. Mike -- 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
Listener Configuration - Oracle 7.3.4.5.2 on Windows 2000
Title: Listener Configuration - Oracle 7.3.4.5.2 on Windows 2000 Hello Guru's, Any ideas? I have installed Oracle 7.3.4.5.2 (7.3.4.0.0 + patchset 7.3.4.5.2) workgroup onto Windows 2000. Everything appears to have gone well, except that the Listener Service was not created automatically as it is usually done on NT. When I tried starting the listerner from command line the exe execs for what appears like a few seconds and returns to prompt. There is no listener.log file generated at all. Anyone got any ideas? Rgds Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: where should i start to learn to become a DBA?
Well you started off in the best position for a DBA Martin,
looking down on the rest of them :)
John
-Original Message-
Sent: 25 July 2002 14:04
To: Multiple recipients of list ORACLE-L
In my case, I was invited to a meeting attended by 6 people. The meeting
room had 5 chairs. When the new CIO asked who wants to be the DBA?, I was
the only one standing.
P.S. I really wanted to be the systems programmer.
From: shuan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: where should i start to learn to become a DBA?
Date: Wed, 24 Jul 2002 22:53:19 -0800
Hi DBAs!
I'm working as a System Programmer for only one year.
And i'm interested to Oracle, wish to become DBA like you guys.
I did read some Oracle reference books, searching the web to find more
about Oracle,
and of course, here in this list, reading you guys' experiences for already
few months.
I've keep trying to learn the Oracle by myself(good or bad?).
When face problems, trying to play around myself here and there in Oracle,
RTFM, FAQs...anything that can find the similar problem.
To be honest, i don't think i learn much.
Maybe it's because i don't know the proper way to learn it.
Well...i don't read books page by page,
i only read those i'm curious at the beginning.
But i feel i'm getting confusing. I don't know whether i'm going in the
correct way.
It's so many times that i have to reinstall the Oracle.
('Cos i dun know how to make it running again, a lot of errors.)
So, can you guys give me some advices of
which section should i start as a beginner?
What's the next? and so on...and so on...
Or any links to point to?
mm...I'm playing with Oracle 8.1.6 in Win2000 on my PC.
Sometimes...play around with Oracle 8.0.5 on Linux(Which is corporate DB
Server, shh...)
Thanks for any advices.
Have a nice day!
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Martin Brown
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Hot tables
Title: Message FROM METALINK: some quick starters: select disk_reads, sql_text from v$sqlarea where disk_reads 1 order by disk_reads desc; select buffer_gets, sql_text from v$sqlarea where buffer_gets 20 order by buffer_gets desc; Also, look at the following links: http://www.jlcomp.demon.co.uk/ http://www.jlcomp.demon.co.uk/sqlarea.html HTH -Original Message-From: Terrian, Tom [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 25, 2002 8:48 AMTo: Multiple recipients of list ORACLE-LSubject: Hot tables How is everyone identifying hot tables? In my tool box I have the following two scripts but I am looking for other options. How do you track frequently accessed tables? Script #1 - Author unknown: select obj_name, sum(decode(action_name,'SELECT',1,0)) sel ,sum(decode(action_name,'INSERT',1,0)) inserts, sum(decode(action_name,'UPDATE',1,0)) updates, sum(decode(action_name,'DELETE',1,0)) deletes from dba_audit_trail having sum(decode(action_name,'SELECT' , 1, 'INSERT',1, 'DELETE',1,'UPDATE',1,0)) 0 group by obj_name; Script #2 - Dave Ensor (BMC):set verify off col CTYP heading 'Command Type' col OBJ format a32 wrap heading 'Table' col EXES format 999,990 heading 'Execs' col GETS format 99,999,990 heading 'Buff Gets' col ROWP format 99,999,990 heading 'Rows Proc' select CTYP , OBJ , 0 - EXEM EXES , GETS , ROWP from (select distinct EXEM, CTYP, OBJ, GETS, ROWP from ( select decode (S.COMMAND_TYPE , 2, 'Insert into ' , 3, 'Select from ' , 6, 'Update of ' , 7, 'Delete from ' , 26, 'Lock of ') CTYP , O.OWNER || '.' || O.NAME OBJ , sum(0 - S.EXECUTIONS) EXEM , sum(S.BUFFER_GETS) GETS , sum(S.ROWS_PROCESSED) ROWP from V$SQL S , V$OBJECT_DEPENDENCY D , V$DB_OBJECT_CACHE O where S.COMMAND_TYPE in (2,3,6,7,26) and D.FROM_ADDRESS = S.ADDRESS and D.TO_OWNER = O.OWNER and D.TO_NAME = O.NAME and O.TYPE = 'TABLE' group by S.COMMAND_TYPE , O.OWNER , O.NAME ) ) where ROWNUM = 1 /
RE: Cursor Sharing| Soft Parsing
Well, three times, right? I think it takes three parse calls before session_cached_cursors begins to help. But 3 is still O(1). Once per call is O(#executions). Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 23-25 Chicago - Miracle Database Forum, Sep 20-22 Middlefart Denmark - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- Still Sent: Thursday, July 25, 2002 2:38 AM To: Multiple recipients of list ORACLE-L On Wednesday 24 July 2002 22:08, MacGregor, Ian A. wrote: Please define soft parsing. Oracle needs to check that the user submitting a SQL statement has permissions to run it. It has to do this every time a statement is run, bind variables or not. No, code that uses bind variables need only parse SQL statements once if session_cached_cursors is set. Further executions of the same SQL don't require a hard or soft parse. Jared When cursor-sharing converts a statement to use bind variables it would save on hard parsing, if a match were found the pool; also, it could lessen the number of statements present in the pool. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Mike, Kirti, Try page 441 CURSOR_SHARING=FORCE does improve badly written applications that use lots of literals. However coding should be done using bind variables in almost all occasions. CURSOR_SHARING=FORCE reduces the hard parsing. What CURSOR_SHARING=FORCE does is rewrites all queries to use bind variables before parsing. eg. select ename from emp where empno = 10; rewritten as select ename from emp where empno =:SYS_B_0 or in 8.1.6 , 8.1.7 select name from emp where empno =:SYS_B_0 So it substitutes the literal with bind variables but incurs the cost of soft parsing the statement. Soft Parsing too frequently limits the scalability of applications and sacrifices optimal performance which could have been achieved in the first place if written using bind variables. Parse once and execute as many times as we like. Also check out Bjorn's paper on bind variables and cursor sharing at http://technet.oracle.com/deploy/performance/pdf/cursor.pdf So CURSOR sharing is not the silver bullet as one may expect. Regards Suhen On Thu, 25 Jul 2002 10:23, you wrote: Mike, What is the version of the database? Some versions of 8.1.7 had a few bugs when this parameter was set to FORCE. I suggest searching Metalink. But it does work as advertised in later releases. I would also recommend reviewing Tom Kytes' book to read about his views in using this parameter at the instance level (my boss is reading my copy, so I can't give you page #s). - Kirti -Original Message- Sent: Wednesday, July 24, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Has anyone set Cursor Sharing to Force ? I have a new system that we have to support and there is alot literals filling up the pool.I have never changed this parameter from the default as many seemed to think the jury was still out on it. However, due to my situation, I figured I would try it out. If anyone has any experience with this one I would be curious to know what happened. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
oracle 9i
Hi All! We will use Oracle 9i db and I would like to know if Oracle8i client works fine with 9i database? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: where should i start to learn to become a DBA?
Hi
Lesson learned: Always bring camping chairs to meetings.
Regards,
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto:[EMAIL PROTECTED]
visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
Behalten Sie den Ueberblick - mit dem neuen BasicOverView, unserer
Seminaruebersicht fuer das 2. Halbjahr 2002. Sie haben noch kein Exemplar?
Schreiben Sie eine E-Mail an mailto:[EMAIL PROTECTED] oder rufen Sie uns
an unter 0 18 03 / 73 64 62 73!
Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.
As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.
-Ursprüngliche Nachricht-
Von: Martin Brown [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 25. Juli 2002 15:04
An: Multiple recipients of list ORACLE-L
Betreff: Re: where should i start to learn to become a DBA?
In my case, I was invited to a meeting attended by 6 people. The meeting
room had 5 chairs. When the new CIO asked who wants to be the DBA?, I was
the only one standing.
P.S. I really wanted to be the systems programmer.
From: shuan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: where should i start to learn to become a DBA?
Date: Wed, 24 Jul 2002 22:53:19 -0800
Hi DBAs!
I'm working as a System Programmer for only one year.
And i'm interested to Oracle, wish to become DBA like you guys.
I did read some Oracle reference books, searching the web to find more
about Oracle,
and of course, here in this list, reading you guys' experiences for already
few months.
I've keep trying to learn the Oracle by myself(good or bad?).
When face problems, trying to play around myself here and there in Oracle,
RTFM, FAQs...anything that can find the similar problem.
To be honest, i don't think i learn much.
Maybe it's because i don't know the proper way to learn it.
Well...i don't read books page by page,
i only read those i'm curious at the beginning.
But i feel i'm getting confusing. I don't know whether i'm going in the
correct way.
It's so many times that i have to reinstall the Oracle.
('Cos i dun know how to make it running again, a lot of errors.)
So, can you guys give me some advices of
which section should i start as a beginner?
What's the next? and so on...and so on...
Or any links to point to?
mm...I'm playing with Oracle 8.1.6 in Win2000 on my PC.
Sometimes...play around with Oracle 8.0.5 on Linux(Which is corporate DB
Server, shh...)
Thanks for any advices.
Have a nice day!
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Martin Brown
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Stefan Jahnke
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
BR solutions
Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Installer not launching in NT
Hi List, I saw a similar post to this in the last 2 weeks, but deleted it (oops) as I am in a unix shop. But I now have a client who is trying to install the oracle client on his nt box in order to demo our *product*. However, he can't get the installer to even launch. He thinks its a Java VM conflict. Any ideas? I need this rather quick so please also reply direct to me and in the meantime I will hit the internet. Thanks, Hannah
NLS questions
Title: NLS questions Hi everybody, Ive been asked to incorporate the data from our remote sites in France, Portugal, Switzerland and Sweden into our existing data warehouse in the UK. I expect I'll have characterset and currency issues to deal with, but I've done very little with NLS. Are there other things I should be thinking about ahead of time? Can I or should I even attempt to put all of the data into 1 database and handle the NLS settings on the client, or should I keep it in separate databases? I appreciate your comments, Beth
RE: Oracle Installer not launching in NT
I had this problem last week. There is a bug when installing Oracle client 8.1.* onto a Pentium 4machine with a processor that is 1500mhz or faster. The workaround is to copy the client cd onto the machine, rename symcjit.dll to something else and then run the setup program from the pc. Cheers, Barry. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 25 July 2002 16:04To: Multiple recipients of list ORACLE-LSubject: Oracle Installer not launching in NT Hi List, I saw a similar post to this in the last 2 weeks, but deleted it (oops) as I am in a unix shop. But I now have a client who is trying to install the oracle client on his nt box in order to demo our *product*. However, he can't get the installer to even launch. He thinks its a Java VM conflict. Any ideas? I need this rather quick so please also reply direct to me and in the meantime I will hit the internet. Thanks, Hannah
RE: oracle 9i
We're doing that and haven't had any problems. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Subject:oracle 9i Hi All! We will use Oracle 9i db and I would like to know if Oracle8i client works fine with 9i database? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle failsafe
Looking for some white papers on this subject.
RE: Oracle Installer not launching in NT - RESOLVED
Title: RE: Oracle Installer not launching in NT - RESOLVED Everyone Thanks so much! Looks like you all just saved me a client! Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NLS questions
Title: NLS questions Oracle*Net will handle all the data conversions for you. You don't have much to worry about. -Original Message-From: Seefelt, Beth [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 25, 2002 10:28 AMTo: Multiple recipients of list ORACLE-LSubject: NLS questions Hi everybody, Ive been asked to incorporate the data from our remote sites in France, Portugal, Switzerland and Sweden into our existing data warehouse in the UK. I expect I'll have characterset and currency issues to deal with, but I've done very little with NLS. Are there other things I should be thinking about ahead of time? Can I or should I even attempt to put all of the data into 1 database and handle the NLS settings on the client, or should I keep it in separate databases? I appreciate your comments, Beth
RE: Oracle Installer not launching in NT
Hannah, Get them to copy the contents of the install CDs to their HD, and search for a file called symcjit.dll. Replace the files found (around 3 of them) with the following one: http://www.cool-tools.co.uk/products/downloads/symcjit.dll Then run the install from the HD, or re-burn the CD's with the new dll, and run from there. HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- [EMAIL PROTECTED] Sent: 25 July 2002 16:04 To: Multiple recipients of list ORACLE-L Hi List, I saw a similar post to this in the last 2 weeks, but deleted it (oops) as I am in a unix shop. But I now have a client who is trying to install the oracle client on his nt box in order to demo our *product*. However, he can't get the installer to even launch. He thinks its a Java VM conflict. Any ideas? I need this rather quick so please also reply direct to me and in the meantime I will hit the internet. Thanks, Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problem with Oracle manager for MTS
Have you checked the regional settings on the server. Make sure you install the client with language=English USA. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 1:08 PM Hello, We are on Intel pentium 4 windows 2000 SP2 server. We tried to install oracle 8.1.6 client and no thing happened where we clicked on the SETUP button. We applied the patch 1507768 and every thing was okay, we could connect to the database (8.1.7.0 in AIX) via sqlplus. Now when we try to create a service for Microsoft transaction server we got this warning (in french) that we don't get on any other server : Le chiffrement des mots de passe n'est pas pris en charge lorsque la variable locale est la France. Le motde passe sera stocké en toutes lettres dans la de registre. In english : The encryption of the password isn't supported where environment variable is set to France. The password will be written into the register's base without encryption. We can then create the service but the database ID isn't shown in the service's property and there isn't any enregistrement in the table MTS_PROXY_INFO. We've opened an Itar since last week but they don't find any thing and I find nothing in the internet. Any help will be appreciated. Best regards, Thanh-truc Nguyen Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 ?/mn) ; tél : 08 92 68 13 50 (0,34?/mn) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =so-8859-1?Q?Thanh-truc_Nguyen? INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i RMAN configuration setting
RMAN doesn't allow you to configure a different default value for maxsetsize for each channel. You can configure maximum piece sizes for each channel as seen here: CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'D:\oracle\oradata\testing\1\%U' MAXPIECESIZE 100 M; CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT 'D:\oracle\oradata\testing\2\%U' MAXPIECESIZE 400 M; CONFIGURE MAXSETSIZE TO UNLIMITED; # default However this doesn't restrict RMAN from putting 2 100MB backup set pieces on channel 1 and 2 400mb backup pieces on channel 2. The bottom line is that I don't think there is a way to limit a channel so that only x amount of data is going to go to it during a given backup. Of course, I've been wrong before so someone correct me if I am this time! :-) RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Tuesday, July 23, 2002 7:04 PM To: Multiple recipients of list ORACLE-L Hi, Does anyone know how I can specify in RMAN the size of the backup data files to be copied to each channel? For eg. if I have a 500MB database and would like to backup 100MB to channel 1 and 400MB to channel 2, how can I configure that? Thanks. elain RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 2; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'D:\oracle\oradata\testing\1\%U' MAXPIECESIZE 50 M; CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT 'D:\oracle\oradata\testing\2\%U' MAXPIECESIZE 50 M; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\ORA92\DATABASE\SNCFTEST.ORA'; # default _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: elain he INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to see howmany transactions commit per min?
Hi Gurus, Greetings. How to see howmany transactions commit per minute? Thanks, Jonny Get a bigger mailbox -- choose a size that fits your needs.http://uk.docs.yahoo.com/mail_storage.html
RE: oracle 9i
I've had no problems with an 8i client talking to a 9i database. There *are* some problems with mixing and matching 7, 8i and 9i databases on the same listener version if you are = 9.0.1.3. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Thursday, July 25, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Hi All! We will use Oracle 9i db and I would like to know if Oracle8i client works fine with 9i database? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BR solutions
I have used rman since O804 and it's just gotten better and better. I have never tried anything else. It's free so the State likes that. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 11:08 AM Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Installer not launching in NT
If it's a Pentium 4, it's a known bug. See MetaLink note 131299.1. The patch is 1507768. Dennis [EMAIL PROTECTED] wrote: Hi List, I saw a similar post to this in the last 2 weeks, but deleted it (oops) as I am in a unix shop. But I now have a client who is trying to install the oracle client on his nt box in order to demo our *product*. However, he can't get the installer to even launch. He thinks its a Java VM conflict. Any ideas? I need this rather quick so please also reply direct to me and in the meantime I will hit the internet. Thanks, Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cursor Sharing| Soft Parsing
One thing is for sure . I will not be telling any developers about the Cursor_sharing parameter and I will continue to insist that they rewrite their application properly with bind variables. Sometimes these developers piss me off though. They are like lazy kids whose parents always bail them out. FWIW. Mike -Original Message- Sent: Thursday, July 25, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Well, three times, right? I think it takes three parse calls before session_cached_cursors begins to help. But 3 is still O(1). Once per call is O(#executions). Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 23-25 Chicago - Miracle Database Forum, Sep 20-22 Middlefart Denmark - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- Still Sent: Thursday, July 25, 2002 2:38 AM To: Multiple recipients of list ORACLE-L On Wednesday 24 July 2002 22:08, MacGregor, Ian A. wrote: Please define soft parsing. Oracle needs to check that the user submitting a SQL statement has permissions to run it. It has to do this every time a statement is run, bind variables or not. No, code that uses bind variables need only parse SQL statements once if session_cached_cursors is set. Further executions of the same SQL don't require a hard or soft parse. Jared When cursor-sharing converts a statement to use bind variables it would save on hard parsing, if a match were found the pool; also, it could lessen the number of statements present in the pool. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Mike, Kirti, Try page 441 CURSOR_SHARING=FORCE does improve badly written applications that use lots of literals. However coding should be done using bind variables in almost all occasions. CURSOR_SHARING=FORCE reduces the hard parsing. What CURSOR_SHARING=FORCE does is rewrites all queries to use bind variables before parsing. eg. select ename from emp where empno = 10; rewritten as select ename from emp where empno =:SYS_B_0 or in 8.1.6 , 8.1.7 select name from emp where empno =:SYS_B_0 So it substitutes the literal with bind variables but incurs the cost of soft parsing the statement. Soft Parsing too frequently limits the scalability of applications and sacrifices optimal performance which could have been achieved in the first place if written using bind variables. Parse once and execute as many times as we like. Also check out Bjorn's paper on bind variables and cursor sharing at http://technet.oracle.com/deploy/performance/pdf/cursor.pdf So CURSOR sharing is not the silver bullet as one may expect. Regards Suhen On Thu, 25 Jul 2002 10:23, you wrote: Mike, What is the version of the database? Some versions of 8.1.7 had a few bugs when this parameter was set to FORCE. I suggest searching Metalink. But it does work as advertised in later releases. I would also recommend reviewing Tom Kytes' book to read about his views in using this parameter at the instance level (my boss is reading my copy, so I can't give you page #s). - Kirti -Original Message- Sent: Wednesday, July 24, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Has anyone set Cursor Sharing to Force ? I have a new system that we have to support and there is alot literals filling up the pool.I have never changed this parameter from the default as many seemed to think the jury was still out on it. However, due to my situation, I figured I would try it out. If anyone has any experience with this one I would be curious to know what happened. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or
RE: Hot tables
Some nice things coming in 9.2... V$SEGMENT_STATISTICS V$SEGSTAT V$SEGSTAT_NAME hth connor --- Richard Huntley [EMAIL PROTECTED] wrote: FROM METALINK: some quick starters: select disk_reads, sql_text from v$sqlarea where disk_reads 1 order by disk_reads desc; select buffer_gets, sql_text from v$sqlarea where buffer_gets 20 order by buffer_gets desc; Also, look at the following links: http://www.jlcomp.demon.co.uk/ http://www.jlcomp.demon.co.uk/sqlarea.html http://www.jlcomp.demon.co.uk/sqlarea.html HTH -Original Message- Sent: Thursday, July 25, 2002 8:48 AM To: Multiple recipients of list ORACLE-L How is everyone identifying hot tables? In my tool box I have the following two scripts but I am looking for other options. How do you track frequently accessed tables? Script #1 - Author unknown: select obj_name, sum(decode(action_name,'SELECT',1,0)) sel ,sum(decode(action_name,'INSERT',1,0)) inserts, sum(decode(action_name,'UPDATE',1,0)) updates, sum(decode(action_name,'DELETE',1,0)) deletes from dba_audit_trail having sum(decode(action_name,'SELECT' , 1, 'INSERT',1, 'DELETE',1,'UPDATE',1,0)) 0 group by obj_name; Script #2 - Dave Ensor (BMC): set verify off col CTYP heading 'Command Type' col OBJ format a32 wrap heading 'Table' col EXES format 999,990heading 'Execs' col GETS format 99,999,990 heading 'Buff Gets' col ROWP format 99,999,990 heading 'Rows Proc' select CTYP , OBJ , 0 - EXEM EXES , GETS , ROWP from (select distinct EXEM, CTYP, OBJ, GETS, ROWP from ( select decode (S.COMMAND_TYPE , 2, 'Insert into ' , 3, 'Select from ' , 6, 'Update of ' , 7, 'Delete from ' , 26, 'Lockof ') CTYP , O.OWNER || '.' || O.NAME OBJ , sum(0 - S.EXECUTIONS) EXEM , sum(S.BUFFER_GETS) GETS , sum(S.ROWS_PROCESSED) ROWP from V$SQL S , V$OBJECT_DEPENDENCY D , V$DB_OBJECT_CACHE O where S.COMMAND_TYPE in (2,3,6,7,26) and D.FROM_ADDRESS = S.ADDRESS and D.TO_OWNER = O.OWNER and D.TO_NAME = O.NAME and O.TYPE = 'TABLE' group by S.COMMAND_TYPE , O.OWNER , O.NAME ) ) where ROWNUM = 1 / = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to see howmany transactions commit per minute?
Hi Gurus, Greetings. How to see howmany transactions commit per minute? v$sysstat does not help me. Thanks, JonnyGet a bigger mailbox -- choose a size that fits your needs.http://uk.docs.yahoo.com/mail_storage.html
Re: shutdown abort / startup restrict / shutdown vs. shutdown imm
Let me share with you the reason that shutdown abort is not a good practice: One day, along time ago, a database on the mainframe (ADABAS in this case) come up after a power failure (don't ask, the UPS and the generators that are the backup power supply also failed) with a message that the power failure occurred while writing a block to the disk and the database is corrupted. SOP, restore and roll forward. The roll forward abended and we finished up restoring to the morning backup after 20 hours work. Net loss to the bank about 1/2 million dollars in lost revenues. My luck was that during the postmortem the supplier technical expert said I did the right thing. Anyway NOBODY assure you that the recovery process after abort will not fail and leave you with the need to restore and roll forward. As Tom said in the discussion about moving the clock back If I will suggest to my client to stop the DB for 1.25 hours So the 2-20 minutes savings can become a lengthy process. I will use abort in the rare cases where there is no other option but not as everyday practice. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 10:53 AM I'm not saying that the shutdown abort *caused* the redo log corruption, but the code that writes redo logs is, like any other software, prone to bugs. Redo logs are only ever read during a recovery of one sort or another, so the code only really gets tested then, and if it fails, there is no fallback. The code that reads and writes to datafiles, on the other hand, is tested all the time, and if *it* fails, you've always got the redo logs. We use a script that tries to do a shutdown immediate and if that fails to complete in a reasonable time, does a checkpoint/abort/startup restrict/shutdown immediate. In a perfect world, the latter wouldn't be necessary because I would have investigated and cured every possible cause for shutdown immediate to hang, but a) debugging these problems is difficult and b) the effort involved upgrading to a sensible version of Oracle is not worth the (supposedly) limited lifetime of this database. Regards David Lord -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: 24 July 2002 23:44 To: Multiple recipients of list ORACLE-L Subject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm But if you are concerned that shutdown abort could corrupt your redo logs, then that is equivalent to mandating that all servers (that run oracle) must be on an infinite uninterruptible power supply. An instance failure (eg loss of power) is effectively a shutdown abort - so the only way to avoid that would be to have power available all the time. You couldn't have a UPS that is good for (say) 12 hours - because we can never guarantee that a shutdown immediate would finish in this amount of time - and you could not speed up the job with a shutdown abort because that is the cause of all the consternation in the first place If you're getting corrupt redo logs with shutdown abort, then you're exposed to corrupt redo logs anyway. Its not a shutdown abort problem, its a bug in either the oracle or OS layer. hth connor --- April Wells [EMAIL PROTECTED] wrote: That is EXACTLY what happened a week and a half ago. We had to do a shutdown abort because it wouldn't go down, and when we tried to restart it, it wouldn't come back... redo log corruption... and this being test... it isn't in archive log mode (another valid solution but no longer really an option in our case). After we can get back in to the building after the teeny little fire and vandalism thing we have going this morning and I can get all concerned parties in the same place (sans smoke and water) my suggestion is going to be that since we don't know why, and there isn't much of a work around yet, that test and development (at least for now) go into archive log mode, as well. ajw -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/24/02 4:09 AM Couldn't agree with you more. I recently had a database fail to restart after a shutdown abort because the redo log got corrupted somewhere along the line. Ended up doing a full restore and roll forward. Admittedly, this was on 7.1.4 (don't ask;-) David Lord -Original Message- Sent: 24 July 2002 01:33 To: Multiple recipients of list ORACLE-L imm I have steel belted radial tires on my car that are supposed to be puncture resistant. Is this a good reason for me to go out of my way to drive by a construction site every morning? By my way of thinking, no. If my regular road is blocked and I have no alternative, then I will drive by the construction site reasonably confident
RE: BR solutions
Sean Well, everything depends on your situation. RMAN is definitely the future. It is getting really popular, but many sites have the traditional operating-system based methods working fine so have little inducement to change. Do you have many servers or anticipate adding servers in the future? RMAN is good at managing BR for many servers, so that will return your investment in time learning it. If you anticipate being a DBA for a long time, then learning it can add to your resume. Can't help you with Galaxy CommVault. Someone this list recommended starting by backing RMAN to disk as a way to get familiar with it, and that is what I am doing. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 10:08 AM To: Multiple recipients of list ORACLE-L Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Cursor Sharing| Soft Parsing
Possibly burying myself deeper: Parsing is done at the open call. If a cursor needs to be re-opened, Oracle will check for permissions whether cursors are cached or not. Some experiments. First just using bind variables in the statement. SQL alter session set session_cached_cursors = 10; Session altered. SQL VARIABLE V_EMPNO NUMBER BEGIN :V_EMPNO := 7934; END; / SQL select ename from scott.emp where empno = :v_empno; ENAME -- MILL As this is the first statement. I would expect hard and soft parsing to be taking place. SQL BEGIN 2 :V_EMPNO := 7782; 3 END; 4 / PL/SQL procedure successfully completed. SQL select ename from scott.emp where empno = :v_empno; ENAME -- CLARK What type of parsing is done here. The statement is in the buffer pool - If scott revokes privileges and the above statement is rerun SQL / select ename from scott.emp where empno = :v_empno * ERROR at line 1: ORA-01031: insufficient privileges -- Scott restores privileges ... SQL variable my_select refcursor; SQL BEGIN 2 OPEN :my_select FOR SELECT ename from s 3 END; 4 / PL/SQL procedure successfully completed. SQL print my_select ENAME -- SMITH ALLEN WARD JONES MARTIN BLAKE SCOTT KING TURNER ADAMS JAMES FORD MILL CLARK 14 rows selected. -- Print closes the cursor. If scott revokes permisssions at this point. SQL BEGIN 2 OPEN :my_select FOR SELECT ename from scott.emp; 3 END; 4 / OPEN :my_select FOR SELECT ename from scott.emp; * ERROR at line 2: ORA-06550: line 2, column 45: PLS-00904: insufficient privilege to access object SCOTT.EMP ORA-06550: line 2, column 21: PL/SQL: SQL Statement ignored --- However if scott restores permissions SQL BEGIN 2 OPEN :my_select FOR SELECT ename from scott.emp; 3 END; 4 / PL/SQL procedure successfully completed. and now revokes them here. The print statement will still work SQL print my_sele ENAME -- SMITH ALLEN WARD JONES MARTIN BLAKE SCOTT KING TURNER ADAMS JAMES FORD MILL CLARK 14 rows selected. So how does one keep such cursors open. Given a cursor such as BEGIN OPEN :my_select FOR SELECT ename from scott.emp where empno = :v_empno; END; How does one display the information, change the value of :v_empno, and display the infromation again without re-opening the cursor. In the distant past when I was writing a lot of Pro*C I'd get the occaisional fetch out of sequence error when I would change the value of a bind variable and try to fetch without first opening the cursor. Doesn't one have to re-opne to rebind. N.B. mail sent in haste -- late for an appointment. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 12:38 AM To: Multiple recipients of list ORACLE-L On Wednesday 24 July 2002 22:08, MacGregor, Ian A. wrote: Please define soft parsing. Oracle needs to check that the user submitting a SQL statement has permissions to run it. It has to do this every time a statement is run, bind variables or not. No, code that uses bind variables need only parse SQL statements once if session_cached_cursors is set. Further executions of the same SQL don't require a hard or soft parse. Jared When cursor-sharing converts a statement to use bind variables it would save on hard parsing, if a match were found the pool; also, it could lessen the number of statements present in the pool. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Mike, Kirti, Try page 441 CURSOR_SHARING=FORCE does improve badly written applications that use lots of literals. However coding should be done using bind variables in almost all occasions. CURSOR_SHARING=FORCE reduces the hard parsing. What CURSOR_SHARING=FORCE does is rewrites all queries to use bind variables before parsing. eg. select ename from emp where empno = 10; rewritten as select ename from emp where empno =:SYS_B_0 or in 8.1.6 , 8.1.7 select name from emp where empno =:SYS_B_0 So it substitutes the literal with bind variables but incurs the cost of soft parsing the statement. Soft Parsing too frequently limits the scalability of applications and sacrifices optimal performance which could have been achieved in the first place if written using bind variables. Parse once and
RE: oracle 9i
fwiw Net8 (8.1.7 client) on Windows 2000 talks to SQL*Net v2 (db 7.3.2) on Netware ok via TCP. On 25 Jul 2002 at 8:48, Freeman, Robert wrote: I've had no problems with an 8i client talking to a 9i database. There *are* some problems with mixing and matching 7, 8i and 9i databases on the same listener version if you are = 9.0.1.3. ... -- 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: ORA-03113: end-of-file on communication channel. HELP !
I'm not sure what operating system you are working on and I'm not precisely sure why you get your particular symptom, but I do know what you are missing. When you use su - user, the environment will be changed to what would be expected if the user actually logged in as the specified user (from Solaris8 man page). If you omit the - argument, the new shell uses the current environment -- which, in your case, probably is not exactly the right environment for starting Oracle. To see the differences, save the output from env|sort after su - oracle then again after su oracle and use diff to compare them. I recommend that you always use the su - oracle login when starting oracle -- working under ksh while starting the database shouldn't be too painful even for a csh type person 8-) Note, on Solaris, su -u user seems to work the same as su - user. The u is not a documented parameter but it may have some relevance on your version of unix. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, July 25, 2002 5:23 AM To: Multiple recipients of list ORACLE-L Hi, We have a Unix user dcclive ( oracle database user ops$dcclive - os authentication ). I am able to connect my database using TNS Alias but not directly. when i start the database in the following way : After logging in as dcclive ( C Shell ), su -u oracle ( Korn Shell ) and started the database, exit from oracle login , connect from dcclive login using os authentication ( using / in sqlplus ), it connects to the database. But when i logging in as dcclive ( C Shell ), su oracle and started the database, exit from oracle login , connect from dcclive login using os authentication ( using / in sqlplus ), it DOES NOT connects to the database. To connect now, i have to use TNS Alias as seen below. uid=1037(dcclive) gid=101(dba) kitchen% sqlplus / SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 25 12:07:36 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-03113: end-of-file on communication channel Enter user-name: / @dcclive Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Why ? Please note that Oracle login has Korn shell. Does the change of shell matters ? or am i missing something ? I have checked all the necessary env. variables. All r set properly. How exactly su -u and su matters to oracle ? Thanks in advance. Arul. -- 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: kkennedy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 9i
We used it in testing and had no problems. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 5:58 PM We're doing that and haven't had any problems. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Hi All! We will use Oracle 9i db and I would like to know if Oracle8i client works fine with 9i database? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
My old argument against shutdown abort was a nasty little bug (it's been fixed in 9i). Here is how you simulate the bug: 1. Create a table, and insert a large number of records into it. do not commit. 2. shutdown abort. Startup the database. 3. Now, after the database is open and while Oracle is rolling back all of those inserts, truncate the table Watch an ora-600 appear and your database *crash*. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Thursday, July 25, 2002 12:19 PM To: Multiple recipients of list ORACLE-L imm Let me share with you the reason that shutdown abort is not a good practice: One day, along time ago, a database on the mainframe (ADABAS in this case) come up after a power failure (don't ask, the UPS and the generators that are the backup power supply also failed) with a message that the power failure occurred while writing a block to the disk and the database is corrupted. SOP, restore and roll forward. The roll forward abended and we finished up restoring to the morning backup after 20 hours work. Net loss to the bank about 1/2 million dollars in lost revenues. My luck was that during the postmortem the supplier technical expert said I did the right thing. Anyway NOBODY assure you that the recovery process after abort will not fail and leave you with the need to restore and roll forward. As Tom said in the discussion about moving the clock back If I will suggest to my client to stop the DB for 1.25 hours So the 2-20 minutes savings can become a lengthy process. I will use abort in the rare cases where there is no other option but not as everyday practice. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 10:53 AM I'm not saying that the shutdown abort *caused* the redo log corruption, but the code that writes redo logs is, like any other software, prone to bugs. Redo logs are only ever read during a recovery of one sort or another, so the code only really gets tested then, and if it fails, there is no fallback. The code that reads and writes to datafiles, on the other hand, is tested all the time, and if *it* fails, you've always got the redo logs. We use a script that tries to do a shutdown immediate and if that fails to complete in a reasonable time, does a checkpoint/abort/startup restrict/shutdown immediate. In a perfect world, the latter wouldn't be necessary because I would have investigated and cured every possible cause for shutdown immediate to hang, but a) debugging these problems is difficult and b) the effort involved upgrading to a sensible version of Oracle is not worth the (supposedly) limited lifetime of this database. Regards David Lord -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: 24 July 2002 23:44 To: Multiple recipients of list ORACLE-L Subject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm But if you are concerned that shutdown abort could corrupt your redo logs, then that is equivalent to mandating that all servers (that run oracle) must be on an infinite uninterruptible power supply. An instance failure (eg loss of power) is effectively a shutdown abort - so the only way to avoid that would be to have power available all the time. You couldn't have a UPS that is good for (say) 12 hours - because we can never guarantee that a shutdown immediate would finish in this amount of time - and you could not speed up the job with a shutdown abort because that is the cause of all the consternation in the first place If you're getting corrupt redo logs with shutdown abort, then you're exposed to corrupt redo logs anyway. Its not a shutdown abort problem, its a bug in either the oracle or OS layer. hth connor --- April Wells [EMAIL PROTECTED] wrote: That is EXACTLY what happened a week and a half ago. We had to do a shutdown abort because it wouldn't go down, and when we tried to restart it, it wouldn't come back... redo log corruption... and this being test... it isn't in archive log mode (another valid solution but no longer really an option in our case). After we can get back in to the building after the teeny little fire and vandalism thing we have going this morning and I can get all concerned parties in the same place (sans smoke and water) my suggestion is going to be that since we don't know why, and there isn't much of a work around yet, that test and development (at least for now) go into archive log mode, as well. ajw -Original Message- To: Multiple
RE: How to see howmany transactions commit per minute?
Transactions committing per minute... isn't that redundant? :-) Statspack report will tell you. Also, v$sysstat will help you, ya just need to query it at time point 0 and time point 1 and diff the result. Each user commit would essentially be one transaction. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Thursday, July 25, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Hi Gurus, Greetings. How to see howmany transactions commit per minute? v$sysstat does not help me. Thanks, Jonny _ http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_storag e.html Get a bigger mailbox -- choose a size that fits your needs. http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_storag e.html http://uk.docs.yahoo.com/mail_storage.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Lock against Inserts
I have a transaction which issues LOCK TABLE TABLE IN EXCLUSIVE MODE. This is to prevent INSERTs during processing. However this is way too restrictive - we only need to restrict certain types of insert, eg. where col1 = 123. I can do something like SELECT * FROM TABLE WHERE col1 = 123 FOR UPDATE to prevent updates of existing rows of this type, but this will not block further inserts. I could set up an insert trigger to prevent these inserts, but I don't want to error: just wait until the transaction ends. This would appear to make the trigger code too complex - surely there is a way to do this just with simple locks? Any ideas much appreciated! Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Problem with Oracle manager for MTS
Hello, Thank you for your help. I'll check it. Best regards, Thanh-truc Nguyen -- Debut du message initial --- De : [EMAIL PROTECTED] A : Multiple recipients of list ORACLE-L ORACLE- [EMAIL PROTECTED] Copies : Date : Thu, 25 Jul 2002 08:33:30 -0800 Objet : Re: Problem with Oracle manager for MTS Have you checked the regional settings on the server. Make sure you install the client with language=English USA. Yechiel Adar Mehish Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 /mn) ; tél : 08 92 68 13 50 (0,34/mn) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Thanh-truc_Nguyen? INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Title: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA Guys, I have been working hard on Oracle systems at various levels - various platforms, etc. for 8 years. It has been a long time since I have taken a course. Would like to go to IOUG. Reading e-mails I have made up my mind - I think it gives me more options to get certified. Problem has been I work and have 2 small kids. Also, I am a consultant who has been steadily applied - not a problem but it means I am either working on systems or with my kids. I am thinking this is a way to save myself the time I don't have and force the commitment - is it worth it? I know an unfair question but by taking this and the exams will I indeed completed what it takes to become certified for 9I? -Original Message- From: Edward Haskins [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 8:26 AM To: [EMAIL PROTECTED] Subject: reminder about tomorrow... Hello, Tomorrow (Friday July 26th) is the last day of our Summer Promotion that entitles you to save 50% off our Oracle8i / 9i DBA eBoot Camp. That's right, save $1,749. We have only a handful of remaining seats for our Live, Online, Instructor-led course, so call us and register today!! In case you have lost the previous email I sent, here's the facts: Because the classes must go on...whether there are only 5 or as many as 15 students enrolled...we've decided to allow you the opportunity to register for a seat in one of our upcoming courses for 50% OFF. That's right, instead of the normal $3,499 registration fee for our Oracle8i / 9i DBA eBoot Camp, you can register for only $1,749. Here's what you get: - A 5 week blended eLearning program that includes Instructor Led Training in our Virtual Classroom environment. That's right, you simply need to login to the Virtual Classroom at the designated time to receive Live, Instructor Led Training...without having to leave your home or office! - The course includes training for all 5 Oracle8i OCP DBA exams, plus as a FREE BONUS we are including our Oracle9i New Features for Administrators course that will prepare you for the Oracle9i Upgrade exam. That's a total of 6 courses! - Sybex and Oracle Press Exam Guides that cover the topics of all 6 exams - The Self Test Software practice tests for all 6 exams (This is worth $600 itself) - OCP Mentoring. You have 24x7 access to our OCP Mentors via our Mentor Forum and Chat Rooms. - eFlash Cards. Electronic Flash Cards quiz you on important topics of each exam. - An easy, step by step Syllabus for Success for each exam module will guarantee certification success. 94% of our students pass the first time they take their exams! - Unlimited access to recorded sessions for review or to retake if you had to miss a class (try THAT with traditional classroom training!). As a matter of fact, because our OCP program is so flexible, effective, and inexpensive, it is becoming a fast favorite among Oracle Professionals. Here are just a few of the comments we have received so far... --- There was so much information that I needed to know for each exam, but my Instructor made it a point to explain every area that was expected to be tested on the exams. Because of the Instructor's insights into the exam topics, I was able to spend less time in overall studying. ~Brenda Thomas, PeopleSoft --- --- I can't say enough about the personal attention I received by my Instructor and Mentors at OraKnowledge. They helped me when I needed better explanations and they provided the motivation to stay on track ~William Jennings, Ernst Young Consulting --- As always, we will be extending our 100% money back guarantee on your training: If you fail any exam the first time through, we will buy your next test voucher AND provide you with one on one mentoring and coaching to identify your weak areas. If you fail twice, we will refund 100% of your money...no questions asked. **FAIR WARNING** To get in on this 50% discount you must register within the next 10 days because the sale will be ending at midnight on July 26th. Also, since we only have a LIMITED NUMBER OF SEATS REMAINIG, this offer may end early if all seats have been sold!! Our upcoming eBoot Camp Schedule includes either DAY or EVENING courses: - July 29th, 2002 Class meets Mon, Tues, Wed from 1pm-4pm EST (10am-1pm PST) or August 19th, 2002 Class meets Mon, Tues, Wed from 7pm-10pm EST (4pm-7pm PST) - See www.oraknowledge.com/8idba.asp?source=0725 for more information. So what are you waiting for? To register, simply click on the link below and use the Promotional Code: SAVE50.
RE: oracle 9i
Yes, it does. -Original Message- Sent: Thursday, July 25, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Hi All! We will use Oracle 9i db and I would like to know if Oracle8i client works fine with 9i database? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle DB Crash
Did you get any replies? I was just told today (by a supervisor) that we should be considering going to 8.1.7.4 (we're on 8.1.7.3) to avoid this problem. Her research was from someone in our development group, so I took it with a grain of salt. BTW, we are on both HP-UX 11 and Tru64, both 64-bit. Thanks Stephen Andert [EMAIL PROTECTED] 07/24/02 11:17AM To ALL, I'm going to ask if anyone on the list has seen the following, and if so, what did you do about it if anything. First environment: Oracle 8.1.7.4.0 on HP-UX 11.0 both in 64 bit. OCI interface programs to the database. Various interfaces done by database links into other Oracle databases. Problem: Right out of the clear blue the database crashes with an ORA-00600[1158] and a trace file. Opened an iTAR with Oracle sending them the alert log and trace file. Their response is that it's a lock issue with an enqueue resource caused by reco while trying to recover/rollback a remote database update. According to Oracle this has only happen twice now in the entire 8.1.7 install base. This has become a rather important item in my daily life, as I've a manager in another department who is becoming a pain in the side wanting me to do something. Thanks in advance. Dick Goulet -- 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: 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[2]: Windohs client problems / (Fwd) RE: Reports 9i and Reports 6 on
also see: http://mhorder.com/oracle9i/0072194626.html --- Forwarded message follows --- fwiw, here is the OUI documentation for 9.0.1 http://docs.oracle.com/cd_a91202/901_doc/em.901/a88812 .pdf --- Oracle 8i Installation Guide Release 3 / 8.1.7 for NT http://docs.oracle.com/DOCS_DOT_PDF_Storage/a85302.pdf --- Oracle 8.1.7 Client Multiple Homes documentation: http://docs.oracle.com/cd_a87862/NT817CLI/index.htm (configuration parameters and registry: http://docs.oracle.com/cd_a87862/NT817CLI/win.817/a730 17/apc.htm#1020082 ) --- After installation, the OUI documentation is (typically?) here: F:\Program Files\Oracle\oui\guide\toc.htm Oracle(R) Universal Installer Concepts Guide Release 1.7 ... --- End of forwarded message --- -- 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: BR solutions
We switched to RMAN from BMC Backtrack. With RMAN there is 0 cost, it's got some nice features and it's not really that hard to use. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Thursday, July 25, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to see howmany transactions commit per min?
Answer: All of them, otherwise they would not be transactions :-) Anyway, humour aside, check out the 'user commits' statistic in v$sysstat hth connor --- Jonny Delmont [EMAIL PROTECTED] wrote: Hi Gurus, Greetings. How to see howmany transactions commit per minute? Thanks, Jonny - Get a bigger mailbox -- choose a size that fits your needs. http://uk.docs.yahoo.com/mail_storage.html = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: BR solutions
It *HAD* to get better when looking at the 8.0.4 version of RMAN. :-) RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Thursday, July 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I have used rman since O804 and it's just gotten better and better. I have never tried anything else. It's free so the State likes that. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 11:08 AM Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to see howmany transactions commit per min?
Check the 'user commits' in V$SYSSTAT... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Thursday, July 25, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Hi Gurus, Greetings. How to see howmany transactions commit per minute? Thanks, Jonny _ http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_storag e.html Get a bigger mailbox -- choose a size that fits your needs. http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_storag e.html http://uk.docs.yahoo.com/mail_storage.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: BR solutions
I agree with Ruth (using Rman since 805). Robust, stable and easy to use. And Free! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I have used rman since O804 and it's just gotten better and better. I have never tried anything else. It's free so the State likes that. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 11:08 AM Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SMP on windows2000
I've been wondering same, logged an iTAR. Will keep you in the loop. background (same old crap, sorry, nothing specific): http://www.winntmag.com/Articles/Index.cfm?ArticleID=7486 - http://www.ultratech-llc.com/Personal (look for SMP.TXT) ??? - http://www.2cpu.com/OSs/Windows/win2kintropart1/Win2kintrop1.html - this one claims to debunk myths: http://2cpu.com/How-To/article2.htm - http://2cpu.com/FAQ/2cpusmpfaq.htm http://www.google.com/search?q=windows+2000+smp regards, ep On 25 Jul 2002 at 4:23, Boivin, Patrice J wrote: Thanks. I was thinking of the Oracle executable on Windows2000. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 7:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: SMP on windows2000 File: Card for Don Jerman My understanding is according to design it should do it automatically. My experience is it does, sort of. But the app has to be multi-threaded (by the OS definition, not just context-mapped like Java green threads) for it to ever use more than one processor at the same time. If your single-threaded then for obvious reasons NT will tend to give the next time-slice to the same processor if it's not busy, so it looks like you're stuck on the same one much of the time. With the task manager you can set processor affinity on MP machines from the right-click menu of the process. This limits which of the N processors will be used to schedule your process. So you can limit one processor hog to 1 or 2 processors and let the well behaved programs run freely on the others. I don't know how to do this using non-gui tools or to set it up at start time, and your userid has to have permission to do it (essentially you have to be running as the process owner). But it's a starting point for research :). Boivin, Patrice J wrote: I am probably just complaining now, I think I know the answer already. Is it possible to force Windows2000 to spread the load for one application to 2 or more CPUs, from the OS side? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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[2]: Oracle DB Crash
Stephen, Not a single one. Either no one out there is using 8.1.7.4 or else they haven't seen this error. The later would square with what OTS told me, supposedly this is the second time it's happen in the entire install base. If that's true, it must be one of those REALLY obscure bugs. Dick Goulet Reply Separator Author: Stephen Andert [EMAIL PROTECTED] Date: 7/25/2002 10:25 AM Did you get any replies? I was just told today (by a supervisor) that we should be considering going to 8.1.7.4 (we're on 8.1.7.3) to avoid this problem. Her research was from someone in our development group, so I took it with a grain of salt. BTW, we are on both HP-UX 11 and Tru64, both 64-bit. Thanks Stephen Andert [EMAIL PROTECTED] 07/24/02 11:17AM To ALL, I'm going to ask if anyone on the list has seen the following, and if so, what did you do about it if anything. First environment: Oracle 8.1.7.4.0 on HP-UX 11.0 both in 64 bit. OCI interface programs to the database. Various interfaces done by database links into other Oracle databases. Problem: Right out of the clear blue the database crashes with an ORA-00600[1158] and a trace file. Opened an iTAR with Oracle sending them the alert log and trace file. Their response is that it's a lock issue with an enqueue resource caused by reco while trying to recover/rollback a remote database update. According to Oracle this has only happen twice now in the entire 8.1.7 install base. This has become a rather important item in my daily life, as I've a manager in another department who is becoming a pain in the side wanting me to do something. Thanks in advance. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Windohs client problems / (Fwd) RE: Reports 9i and Reports 6 on
also see: http://mhorder.com/oracle9i/0072194626.html --- Forwarded message follows --- Most of it was trial and error. Apparently, the old ORANT stuff(dev6) has to be in default_home. I ran into a lot of problems when that was not HOME0 in the registry. OEM was installed by default. I also discovered that oracle agent and oracleids agent can not run at the same time. Depending on what I am trying to do, I have to start and stop various jobs and http servers. This is my development box for trying out new things. I would not recommend this configuration for production. David Peck Baker Hughes Inc. BHBSS-BASIS (713) 625-6649 -Original Message- Sent: Wednesday, July 24, 2002 2:38 PM To: Peck, David; [EMAIL PROTECTED] On 24 Jul 2002 at 11:29, Peck, David wrote: I have 9i r2 of the database, 9idw r2, dev 6i and discoverer 6i on the same Win 2000 box. ok. I have found that you should install the dev 6i first into default_home. Is that documented, or did you determine that from trial-and-error, or hear about it from someone, or ?? I created a separate home for the 9i database and a separate home for 9ids. Did you patch everything? If so, did that go well? Believe it or not, everything works! cool. there are people that will be interested in hearing this. Any chance that ODBC and/or OEM was in the mix? fwiw, on a Win2000 client machine, I had v7 client stuff installed (Y2K installer), then mistakenly installed a trial version of 9i db, uninstalled it (using the 9i OUI , v?), then installed client stuff from 8.1.7.x with the 8.1.7 OUI, and even with that mess, it still works. :) regards, ep -Original Message- Sent: Wednesday, July 24, 2002 1:49 PM To: Multiple recipients of list ODTUG-DEV2K-L Hello List!! Has any one tried installing Reports 9i along with 6i or 6 on the same machine? Do these two go together? Any input will be appreciated. ... -- Author: Peck, David INET: [EMAIL PROTECTED] ... --- End of forwarded message --- -- 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).
Fwd: Lock against Inserts
Aha! Just seen the DBMS_LOCK example in Thomas Kyte's book where he does pretty much what I need (i.e. request a lock on hash(123) before the transaction starts). Still requires setting up a trigger, which I'd hoped to avoid, but if you need to do it this way, it's gotta go in! Thanks - Bill. I have a transaction which issues LOCK TABLE TABLE IN EXCLUSIVE MODE. This is to prevent INSERTs during processing. However this is way too restrictive - we only need to restrict certain types of insert, eg. where col1 = 123. I can do something like SELECT * FROM TABLE WHERE col1 = 123 FOR UPDATE to prevent updates of existing rows of this type, but this will not block further inserts. I could set up an insert trigger to prevent these inserts, but I don't want to error: just wait until the transaction ends. This would appear to make the trigger code too complex - surely there is a way to do this just with simple locks? Any ideas much appreciated! Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Listener Configuration - Oracle 7.3.4.5.2 on Windows 2000
you didn't mention whether or not you know that oracle 7 isn't certified on win2k. On 25 Jul 2002 at 6:18, Denham Eva wrote: Any ideas? I have installed Oracle 7.3.4.5.2 (7.3.4.0.0 + patchset 7.3.4.5.2) workgroup onto Windows 2000. ... ---Forwarded--- http://www.windowware.com/winware/fineprint.html Our standard, non-inclusive disclaimer Any similarity to real persons, living or dead, is purely coincidental. Void where prohibited. Some assembly required. List each check separately by bank number. Batteries not included. Contents may settle during shipment. Use only as directed. No other warranty expressed or implied. Do not use while operating a motor vehicle or heavy equipment. Postage will be paid by addressee. Subject to CAB approval. This is not an offer to sell securities. Apply only to affected area. May be too intense for some viewers. See store manager for further details. Do not stamp. Use other side for additional listings. For recreational use only. Do not disturb. All models over 18 years of age. If condition persists, consult your physician. No user-serviceable parts inside. Freshest if eaten before date on carton. Subject to change without notice. Times approximate. Simulated picture. No postage necessary if mailed in the United States. Breaking seal constitutes your acceptance of agreement. For off-road use only. As seen on TV. One size fits all. Many suitcases look alike. Contains a substantial amount of non-tobacco ingredients. Colors may, in time, fade. We have sent the forms which seem to be right for you. Slippery when wet. For official use only. Not affiliated with the American Red Cross. Drop in any mailbox. Edited for television. Keep cool; process promptly. Post office will not deliver without postage. List was current at time of printing. Return to sender, no forwarding order on file, unable to forward. Not responsible for direct, indirect, incidental or consequential damages resulting from any defect, error, or failure to perform. At participating locations only. Not the Beatles. Penalty for private use. See label for sequence. Substantial penalty for early withdrawal. Do not write below this line. Falling rock. Penalty for private use, $300. Lost ticket pays maximum rate. Your canceled check is your receipt. Add toner. Place stamp here. Avoid contact with skin. Sanitized for your protection. Be sure each item is properly endorsed. Sign here without admitting guilt. Slightly higher west of the Mississippi. Employees and their families are not eligible. Beware of dog. Contestants have been briefed on some questions before the show. Limited time offer, call now to insure prompt delivery. You must be present to win. No passes accepted for this engagement. No purchase necessary. Processed at location stamped in code at top of carton. Shading within a garment may occur. Keep away from fire or flame. Replace with same type. Approved for veterans. Booths for two or more. Check here if tax deductible. Some equipment shown is optional. Price does not include taxes. No Canadian coins. Not recommended for children. Prerecorded for this time zone. Reproduction strictly prohibited. No solicitors. No alcohol, dogs, or horses. No anchovies unless otherwise specified. Restaurant package, not for resale. List at least two alternate dates. First pull up, then pull down. Call toll free before digging. Driver does not carry cash. Some of the trademarks mentioned in this product appear for identification purposes only. Record additional transactions on back of previous stub. Do not fold, spindle or mutilate. 25 city, 35 highway. Your mileage may vary. ---End--- -- 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: BR solutions
I would guess: 1) in-house OS-dependent scripts 2) We don't need DB backups, we use x and it doesn't go down ;) Mike Hand -Original Message- Sent: Thursday, July 25, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Portal Question
Could anyone recommend a good news portal which offers RDBMS content which is updated daily? I've been using www.infoworld.com and www.cnet.com and would like more database related material. Thank you in advance, Jay _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Windohs client problems
On 24 Jul 2002 at 13:32, Jesse, Rich wrote: ... The kind of complex combo you are attempting is probably inherently going to be problematic, and I would definitely have asked Oracle tech support about install sequence issues ... Yeah, I know I need to place a TAR. But the last one I placed was a *dream*, thanks to Cathy@Oracle. Not only did she actually e-mail me directly (as opposed to only updating the TAR), but she even called to see that her fix actually worked. And it did (STATSPACK install f'ed up a couple dozen SYS packages)! I closed the TAR pleading that she forward my comments to her super because this was the way a TAR should be handled. haa haa haa! :) When I reread the install docs, I did see something about how deinstall of Intersolve (ODBC drivers?) would sometimes mes stuff up. I guess I'm afraid to try for another TAR because I know it'll be back to The Old Way of handling a TAR. ya. tease the larger/complex problem apart, and try simple combos of 2 of each of the problem components, and get TARs going for each? BTW, I've installed the 9i EE S/W in order to get the ONames Server and not to run a DB. I also wanted the ability to build a quick test DB for OiD if needed. ok. I sort of knew that, was just in such horror/shock/denial that my brain wouldn't allow recognition. :) I did read the whole section on networking in the Oracle9i/Windows 2000 book ( http://mhorder.com/oracle9i/0072194626.html ) yesterday. He doesn't address the specific problem, but there is excellent explanation of the underlying network architecture, and knowing that might help understand how to set up and go through trace logs during testing of various component combinations? regards, ep Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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: shutdown abort / startup restrict / shutdown vs. shutdown imm
Inder Singh IT Management 1101 Pacific Ave. Ph:859-815-2460 Email: [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L imm My old argument against shutdown abort was a nasty little bug (it's been fixed in 9i). Here is how you simulate the bug: 1. Create a table, and insert a large number of records into it. do not commit. 2. shutdown abort. Startup the database. 3. Now, after the database is open and while Oracle is rolling back all of those inserts, truncate the table Watch an ora-600 appear and your database *crash*. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Thursday, July 25, 2002 12:19 PM To: Multiple recipients of list ORACLE-L imm Let me share with you the reason that shutdown abort is not a good practice: One day, along time ago, a database on the mainframe (ADABAS in this case) come up after a power failure (don't ask, the UPS and the generators that are the backup power supply also failed) with a message that the power failure occurred while writing a block to the disk and the database is corrupted. SOP, restore and roll forward. The roll forward abended and we finished up restoring to the morning backup after 20 hours work. Net loss to the bank about 1/2 million dollars in lost revenues. My luck was that during the postmortem the supplier technical expert said I did the right thing. Anyway NOBODY assure you that the recovery process after abort will not fail and leave you with the need to restore and roll forward. As Tom said in the discussion about moving the clock back If I will suggest to my client to stop the DB for 1.25 hours So the 2-20 minutes savings can become a lengthy process. I will use abort in the rare cases where there is no other option but not as everyday practice. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 10:53 AM I'm not saying that the shutdown abort *caused* the redo log corruption, but the code that writes redo logs is, like any other software, prone to bugs. Redo logs are only ever read during a recovery of one sort or another, so the code only really gets tested then, and if it fails, there is no fallback. The code that reads and writes to datafiles, on the other hand, is tested all the time, and if *it* fails, you've always got the redo logs. We use a script that tries to do a shutdown immediate and if that fails to complete in a reasonable time, does a checkpoint/abort/startup restrict/shutdown immediate. In a perfect world, the latter wouldn't be necessary because I would have investigated and cured every possible cause for shutdown immediate to hang, but a) debugging these problems is difficult and b) the effort involved upgrading to a sensible version of Oracle is not worth the (supposedly) limited lifetime of this database. Regards David Lord -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: 24 July 2002 23:44 To: Multiple recipients of list ORACLE-L Subject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm But if you are concerned that shutdown abort could corrupt your redo logs, then that is equivalent to mandating that all servers (that run oracle) must be on an infinite uninterruptible power supply. An instance failure (eg loss of power) is effectively a shutdown abort - so the only way to avoid that would be to have power available all the time. You couldn't have a UPS that is good for (say) 12 hours - because we can never guarantee that a shutdown immediate would finish in this amount of time - and you could not speed up the job with a shutdown abort because that is the cause of all the consternation in the first place If you're getting corrupt redo logs with shutdown abort, then you're exposed to corrupt redo logs anyway. Its not a shutdown abort problem, its a bug in either the oracle or OS layer. hth connor --- April Wells [EMAIL PROTECTED] wrote: That is EXACTLY what happened a week and a half ago. We had to do a shutdown abort because it wouldn't go down, and when we tried to restart it, it wouldn't come back... redo log corruption... and this being test... it isn't in archive log mode (another valid solution but no longer really an option in our case). After we can get back in to the building after the teeny little fire and vandalism thing we have going this morning and I can get all concerned parties in the same place (sans smoke and water) my suggestion is going to be that since we don't know
RE: Cursor Sharing| Soft Parsing
No, code that uses bind variables need only parse SQL statements once if session_cached_cursors is set. Further executions of the same SQL don't require a hard or soft parse. Hmm read somewhere (James Morle?) that this may not apply if the (subsequent) bind variable sizes differ vastly from the initial. I would check that Jared (I know that you have JM's book and have actually read it!) I don't remember if this changes with session_cached_cursors. I ask because Apps is notorious for using bind variables that vastly differ (read: flexfields). 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).
Re: SMP on windows2000
fwiw, some stuff on NT4 SMP issues: http://www.windowsitlibrary.com/Content/435/05/4.html -- 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: Hot tables
Tom, If you are on 8i, how about using an ALTER TABLE tab MONITORING on all user tables - schema by schema if you prefer - and looking at DBA_TAB_MODIFICATIONS after a predefined period. My understanding from the Guru (Steve Adams that is!) is that this tracking is achieved in memory via unlatched activity so there is (should) be no performance overhead for turning on this monitoring - this structure is flushed to disk once in 3 hours apparently. 9i takes this further by allowing Indexes to be montored too (haven't tried that yet!) Oh-Boy! It is nice to have On-topic queries after all those long OT threads. Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Thursday, July 25, 2002 5:48 AM To: Multiple recipients of list ORACLE-L How is everyone identifying hot tables? In my tool box I have the following two scripts but I am looking for other options. How do you track frequently accessed tables? Script #1 - Author unknown: select obj_name, sum(decode(action_name,'SELECT',1,0)) sel ,sum(decode(action_name,'INSERT',1,0)) inserts, sum(decode(action_name,'UPDATE',1,0)) updates, sum(decode(action_name,'DELETE',1,0)) deletes from dba_audit_trail having sum(decode(action_name,'SELECT' , 1, 'INSERT',1, 'DELETE',1,'UPDATE',1,0)) 0 group by obj_name; Script #2 - Dave Ensor (BMC): set verify off col CTYP heading 'Command Type' col OBJ format a32 wrap heading 'Table' col EXES format 999,990heading 'Execs' col GETS format 99,999,990 heading 'Buff Gets' col ROWP format 99,999,990 heading 'Rows Proc' select CTYP , OBJ , 0 - EXEM EXES , GETS , ROWP from (select distinct EXEM, CTYP, OBJ, GETS, ROWP from ( select decode (S.COMMAND_TYPE , 2, 'Insert into ' , 3, 'Select from ' , 6, 'Update of ' , 7, 'Delete from ' , 26, 'Lockof ') CTYP , O.OWNER || '.' || O.NAMEOBJ , sum(0 - S.EXECUTIONS) EXEM , sum(S.BUFFER_GETS) GETS , sum(S.ROWS_PROCESSED) ROWP from V$SQL S , V$OBJECT_DEPENDENCY D , V$DB_OBJECT_CACHE O where S.COMMAND_TYPE in (2,3,6,7,26) and D.FROM_ADDRESS = S.ADDRESS and D.TO_OWNER = O.OWNER and D.TO_NAME = O.NAME and O.TYPE = 'TABLE' group by S.COMMAND_TYPE , O.OWNER , O.NAME ) ) where ROWNUM = 1 / -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor Sharing| Soft Parsing
When a SQL execution is requested the Shared SQL is first examined to see if the statement is in memory. The first time SQL is processed it goes through a hard parse, the most expensive parsing operation. A hard parse performs the following: checking syntax; validating all database objects referenced, (tables and columns); naming translation, (synonyms); authenticating user privileges on all tables and columns; producing a SQL execution plan via the optimizer; hashing and storing the parsed statement in the Shared SQL Area. If the SQL statement is found in the Shared Pool then a soft parse may be performed in an attempt to use a shareable cursor. There are three types of soft parses: 1) The first time a SQL statement is found in the shared pool Oracle performs name translation, user authentication, and adds the user to the authentication list. 2) On the second soft parse name translation does not need to be performed but user authentication does just in case user privileges were changed since the last execution.; 3) An entry is created for the session's cursor cache and future cursor CLOSEs are ignored. Once in the session cursor cache the SQL statement does not need to be reparsed. This gives a significant performance boost! Giving credit where due: The above was inspired from pages 277-280 in Scaling Oracle8i by James Morle. Steve Orr Bozeman, Montana -Original Message- Sent: Wednesday, July 24, 2002 11:08 PM To: Multiple recipients of list ORACLE-L Importance: High Please define soft parsing. Oracle needs to check that the user submitting a SQL statement has permissions to run it. It has to do this every time a statement is run, bind variables or not. I thought the processing of the statement to check permissions to be soft parsing. But, perhaps I'm misinformed. When cursor-sharing converts a statement to use bind variables it would save on hard parsing, if a match were found the pool; also, it could lessen the number of statements present in the pool. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: BR solutions
Ive been told that one major backup and recovery vendor is changing their product so that it is just a glorified front end to RMAN. Should tell you something. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Thursday, July 25, 2002 2:14 PM To: Multiple recipients of list ORACLE-L I agree with Ruth (using Rman since 805). Robust, stable and easy to use. And Free! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I have used rman since O804 and it's just gotten better and better. I have never tried anything else. It's free so the State likes that. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 11:08 AM Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
I had a friend of mine take it with mixed reactions. Basically they walk you through the Sybex books and answer questions. He found it useful but it in no way prepared him to take the tests. With 8 years of experience you might be better off just reading the Sybex books yourself. Also the Oracle Press OCP review books are really good as well. My advise would be save the money and go through the books yourself. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA Date: Thu, 25 Jul 2002 09:53:43 -0800 Guys, I have been working hard on Oracle systems at various levels - various platforms, etc. for 8 years. It has been a long time since I have taken a course. Would like to go to IOUG. Reading e-mails I have made up my mind - I think it gives me more options to get certified. Problem has been I work and have 2 small kids. Also, I am a consultant who has been steadily applied - not a problem but it means I am either working on systems or with my kids. I am thinking this is a way to save myself the time I don't have and force the commitment - is it worth it? I know an unfair question but by taking this and the exams will I indeed completed what it takes to become certified for 9I? -Original Message- Sent: Thursday, July 25, 2002 8:26 AM To: [EMAIL PROTECTED] Hello, Tomorrow (Friday July 26th) is the last day of our Summer Promotion that entitles you to save 50% off our Oracle8i / 9i DBA eBoot Camp. That's right, save $1,749. We have only a handful of remaining seats for our Live, Online, Instructor-led course, so call us and register today!! In case you have lost the previous email I sent, here's the facts: Because the classes must go on...whether there are only 5 or as many as 15 students enrolled...we've decided to allow you the opportunity to register for a seat in one of our upcoming courses for 50% OFF. That's right, instead of the normal $3,499 registration fee for our Oracle8i / 9i DBA eBoot Camp, you can register for only $1,749. Here's what you get: - A 5 week blended eLearning program that includes Instructor Led Training in our Virtual Classroom environment. That's right, you simply need to login to the Virtual Classroom at the designated time to receive Live, Instructor Led Training...without having to leave your home or office! - The course includes training for all 5 Oracle8i OCP DBA exams, plus as a FREE BONUS we are including our Oracle9i New Features for Administrators course that will prepare you for the Oracle9i Upgrade exam. That's a total of 6 courses! - Sybex and Oracle Press Exam Guides that cover the topics of all 6 exams - The Self Test Software practice tests for all 6 exams (This is worth $600 itself) - OCP Mentoring. You have 24x7 access to our OCP Mentors via our Mentor Forum and Chat Rooms. - eFlash Cards. Electronic Flash Cards quiz you on important topics of each exam. - An easy, step by step Syllabus for Success for each exam module will guarantee certification success. 94% of our students pass the first time they take their exams! - Unlimited access to recorded sessions for review or to retake if you had to miss a class (try THAT with traditional classroom training!). As a matter of fact, because our OCP program is so flexible, effective, and inexpensive, it is becoming a fast favorite among Oracle Professionals. Here are just a few of the comments we have received so far... --- There was so much information that I needed to know for each exam, but my Instructor made it a point to explain every area that was expected to be tested on the exams. Because of the Instructor's insights into the exam topics, I was able to spend less time in overall studying. ~Brenda Thomas, PeopleSoft --- --- I can't say enough about the personal attention I received by my Instructor and Mentors at OraKnowledge. They helped me when I needed better explanations and they provided the motivation to stay on track ~William Jennings, Ernst Young Consulting --- As always, we will be extending our 100% money back guarantee on your training: If you fail any exam the first time through, we will buy your next test voucher AND provide you with one on one mentoring and coaching to identify your weak areas. If you fail twice, we will refund 100% of your money...no questions asked. **FAIR WARNING** To get in on this 50% discount you must register within the next 10 days because the sale will be ending at midnight on July 26th. Also, since we only have a LIMITED NUMBER OF SEATS REMAINIG, this offer may end early if all seats have been sold!! Our upcoming eBoot Camp Schedule includes either DAY or EVENING courses:
RE: flexfield for Supplier's email address in 10.7NCA
Mandar, Thanks for caution. btw we need a descriptive flexfield with minimal validation. also the email entered by the Payables Clerk would be queried and processed by an external homegrown delphi app, so i am not sure what Custom code in 10.7 u r referring to. Aaah - descriptive FFs are a different matter. Adding them should be no problem: Are you looking at a form that already has a ff that you can modify? The Delpi program querying this will have to deal with the right ATTRIBUTEnn column (I think) on the view that results from the DFV. Would appreciate any links other than manual :) on descriptive flexfields. MetaBlink should have a ton of info. Ta, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** 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).
Re:RE: BR solutions
I kinfa hate to admit it, but I'm one of those who has not embrased RMAN. More out of lack of time to investigate than anything else, but to make real use of it here I need to intergrate it with OmniBack, which requires a database relink. And getting the databases away from the end users long enough is a real pain in the $%#. Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 7/25/2002 10:13 AM I agree with Ruth (using Rman since 805). Robust, stable and easy to use. And Free! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I have used rman since O804 and it's just gotten better and better. I have never tried anything else. It's free so the State likes that. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 11:08 AM Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Paula - I'm skeptical whether a boot camp could cover all the material involved in the OCP tests. I could see where you might come out tuned up enough to whip out a couple of tests, but once you got past them, you'd probably have to do the other tests the hard way -- study for them. I would rate the individual classes as more likely to help you through the OCP, one test at a time. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Guys, I have been working hard on Oracle systems at various levels - various platforms, etc. for 8 years. It has been a long time since I have taken a course. Would like to go to IOUG. Reading e-mails I have made up my mind - I think it gives me more options to get certified. Problem has been I work and have 2 small kids. Also, I am a consultant who has been steadily applied - not a problem but it means I am either working on systems or with my kids. I am thinking this is a way to save myself the time I don't have and force the commitment - is it worth it? I know an unfair question but by taking this and the exams will I indeed completed what it takes to become certified for 9I? -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, July 25, 2002 8:26 AM To: [EMAIL PROTECTED] Hello, Tomorrow (Friday July 26th) is the last day of our Summer Promotion that entitles you to save 50% off our Oracle8i / 9i DBA eBoot Camp. That's right, save $1,749. We have only a handful of remaining seats for our Live, Online, Instructor-led course, so call us and register today!! In case you have lost the previous email I sent, here's the facts: Because the classes must go on...whether there are only 5 or as many as 15 students enrolled...we've decided to allow you the opportunity to register for a seat in one of our upcoming courses for 50% OFF. That's right, instead of the normal $3,499 registration fee for our Oracle8i / 9i DBA eBoot Camp, you can register for only $1,749. Here's what you get: - A 5 week blended eLearning program that includes Instructor Led Training in our Virtual Classroom environment. That's right, you simply need to login to the Virtual Classroom at the designated time to receive Live, Instructor Led Training...without having to leave your home or office! - The course includes training for all 5 Oracle8i OCP DBA exams, plus as a FREE BONUS we are including our Oracle9i New Features for Administrators course that will prepare you for the Oracle9i Upgrade exam. That's a total of 6 courses! - Sybex and Oracle Press Exam Guides that cover the topics of all 6 exams - The Self Test Software practice tests for all 6 exams (This is worth $600 itself) - OCP Mentoring. You have 24x7 access to our OCP Mentors via our Mentor Forum and Chat Rooms. - eFlash Cards. Electronic Flash Cards quiz you on important topics of each exam. - An easy, step by step Syllabus for Success for each exam module will guarantee certification success. 94% of our students pass the first time they take their exams! - Unlimited access to recorded sessions for review or to retake if you had to miss a class (try THAT with traditional classroom training!). As a matter of fact, because our OCP program is so flexible, effective, and inexpensive, it is becoming a fast favorite among Oracle Professionals. Here are just a few of the comments we have received so far... --- There was so much information that I needed to know for each exam, but my Instructor made it a point to explain every area that was expected to be tested on the exams. Because of the Instructor's insights into the exam topics, I was able to spend less time in overall studying. ~Brenda Thomas, PeopleSoft --- --- I can't say enough about the personal attention I received by my Instructor and Mentors at OraKnowledge. They helped me when I needed better explanations and they provided the motivation to stay on track ~William Jennings, Ernst Young Consulting --- As always, we will be extending our 100% money back guarantee on your training: If you fail any exam the first time through, we will buy your next test voucher AND provide you with one on one mentoring and coaching to identify your weak areas. If you fail twice, we will refund 100% of your money...no questions asked. **FAIR WARNING** To get in on this 50% discount you must register within the next 10 days because the sale will be ending at midnight on July 26th. Also, since we only have a LIMITED NUMBER OF SEATS REMAINIG, this offer may end early if all seats have been sold!! Our upcoming eBoot Camp Schedule includes either DAY or EVENING courses:
Re: BR solutions
The Stratus fault tolerant box works good here. Every component is duplicated except the power cord. It uses HP chips and HP-UX. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 1:23 PM I would guess: 1) in-house OS-dependent scripts 2) We don't need DB backups, we use x and it doesn't go down ;) Mike Hand -Original Message- Sent: Thursday, July 25, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: Cursor Sharing| Soft Parsing
we have a lot of delphi and forms3 apps and Session_Cached_Cursors is zero for my database (7.3.4). I am thinking of setting the above parameter to 50. Also would monitor the stat 'session cursor cache hits' before and after setting the parameter. Do i need to increase/decrease any other parameter with this change? btw found this bug [BUG:931820] Direct Load Fails When Session_Cached_Cursors is larger than 0 Pls advise if i am on a wrong track. Thanks Mandar -Original Message- Sent: Thursday, July 25, 2002 11:49 AM To: Multiple recipients of list ORACLE-L When a SQL execution is requested the Shared SQL is first examined to see if the statement is in memory. The first time SQL is processed it goes through a hard parse, the most expensive parsing operation. A hard parse performs the following: checking syntax; validating all database objects referenced, (tables and columns); naming translation, (synonyms); authenticating user privileges on all tables and columns; producing a SQL execution plan via the optimizer; hashing and storing the parsed statement in the Shared SQL Area. If the SQL statement is found in the Shared Pool then a soft parse may be performed in an attempt to use a shareable cursor. There are three types of soft parses: 1) The first time a SQL statement is found in the shared pool Oracle performs name translation, user authentication, and adds the user to the authentication list. 2) On the second soft parse name translation does not need to be performed but user authentication does just in case user privileges were changed since the last execution.; 3) An entry is created for the session's cursor cache and future cursor CLOSEs are ignored. Once in the session cursor cache the SQL statement does not need to be reparsed. This gives a significant performance boost! Giving credit where due: The above was inspired from pages 277-280 in Scaling Oracle8i by James Morle. Steve Orr Bozeman, Montana -Original Message- Sent: Wednesday, July 24, 2002 11:08 PM To: Multiple recipients of list ORACLE-L Importance: High Please define soft parsing. Oracle needs to check that the user submitting a SQL statement has permissions to run it. It has to do this every time a statement is run, bind variables or not. I thought the processing of the statement to check permissions to be soft parsing. But, perhaps I'm misinformed. When cursor-sharing converts a statement to use bind variables it would save on hard parsing, if a match were found the pool; also, it could lessen the number of statements present in the pool. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to see howmany transactions commit per minute?
Hi Jesse,
That's great! I really enjoyed it ;-)) Thanks for this code and thanks who replied.
Jonny
"Jesse, Rich" [EMAIL PROTECTED] wrote:
Before I installed STATSPACK, I had a dbms_job run this every five minutes(in fact it still runs):DECLAREv_tx_count NUMBER;BEGINSELECT SUM(VALUE) INTO v_tx_countFROM V$SYSSTATWHERE NAME IN ('user commits','user rollbacks');INSERT INTO MY_TRANSACTION_LOG(TX_COUNT, TIMESTAMP)VALUES (v_tx_count, SYSDATE);COMMIT;END;It runs subsecond and puts no discernable load on my system, AFAIK. Toquery, I wrote a l'il webpage that makes this call:SELECT TIMESTAMP, TPMFROM(SELECT TO_CHAR(TIMESTAMP,'MM/DD/ HH24:MI') TIMESTAMP,TO_CHAR(TX_COUNT - LAG(TX_COUNT) OVER (ORDER BY TIMESTAMP)) TPMFROM SYSTEM.QT_TRANSACTION_LOGWHERE TIMESTAMP = TO_DATE('start_timestamp','MM/DD/:HH24:MI')AND TIMESTAMP =TO_DATE('end_timestamp','MM/DD/:HH24:MI'))WHERE TPM IS NOT NULLORD!
!
ER BY 1;Because of the LAG function, it's 8i-and-up-only (as an aside, I just lookedat this and the final "ORDER BY" probably isn't needed because of LAG). Anddon't forget to divide by the number of minutes between samples to get the"PM" in "TPM".I also dump the output into GNUPLOT for output on the webpage, but thatpart's optional. ;) It's great for seeing those huge spikes in the middleof the night where someone coded a COMMIT after every one of 50K INSERTS...HTH! Enjoy! :)Rich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Freeman, Robert [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to see howmany transactions commit per minute? Transactions committing per minute... isn't that redundan!
!
t? :-) Statspack report will tell you. Also, v$sysstat will help you, ya just need to query it at time point 0 and time point 1 and diff the result. Each user commit would essentially be one transaction. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote.-Original Message- Sent: Thursday, July 25, 2002 1:09 PM To: Multiple recipients of list ORACLE-LHi Gurus, Greetings. How to see howmany transactions commit per minute? v$sysstat does not help me. Thanks, Jonny-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jesse, RichINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Get a bigger mailbox -- choose a size that fits your needs.http://uk.docs.yahoo.com/mail_storage.html
RE: Hot tables
I will add that in 9i you can reset the statistics also. This is not available on 8i which reduces the usefulness of the data over time. My daily report for my databases includes a section the pulls info out of dba_tab_modifications sorted by highest activity first. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Thursday, July 25, 2002 1:39 PM To: Multiple recipients of list ORACLE-L Tom, If you are on 8i, how about using an ALTER TABLE tab MONITORING on all user tables - schema by schema if you prefer - and looking at DBA_TAB_MODIFICATIONS after a predefined period. My understanding from the Guru (Steve Adams that is!) is that this tracking is achieved in memory via unlatched activity so there is (should) be no performance overhead for turning on this monitoring - this structure is flushed to disk once in 3 hours apparently. 9i takes this further by allowing Indexes to be montored too (haven't tried that yet!) Oh-Boy! It is nice to have On-topic queries after all those long OT threads. Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hot tables
Thanks John. Good point. We are on 9.0.1.3 and we have turned on the monitoring flag for our tables. But the info that I am really looking for is the amount of selects against the tables. I just think that it would be nice to know the top 5% of the tables that the users are selecting from (statspack perhaps?). Tom -Original Message- Sent: Thursday, July 25, 2002 2:39 PM To: Multiple recipients of list ORACLE-L Tom, If you are on 8i, how about using an ALTER TABLE tab MONITORING on all user tables - schema by schema if you prefer - and looking at DBA_TAB_MODIFICATIONS after a predefined period. My understanding from the Guru (Steve Adams that is!) is that this tracking is achieved in memory via unlatched activity so there is (should) be no performance overhead for turning on this monitoring - this structure is flushed to disk once in 3 hours apparently. 9i takes this further by allowing Indexes to be montored too (haven't tried that yet!) Oh-Boy! It is nice to have On-topic queries after all those long OT threads. Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Thursday, July 25, 2002 5:48 AM To: Multiple recipients of list ORACLE-L How is everyone identifying hot tables? In my tool box I have the following two scripts but I am looking for other options. How do you track frequently accessed tables? Script #1 - Author unknown: select obj_name, sum(decode(action_name,'SELECT',1,0)) sel ,sum(decode(action_name,'INSERT',1,0)) inserts, sum(decode(action_name,'UPDATE',1,0)) updates, sum(decode(action_name,'DELETE',1,0)) deletes from dba_audit_trail having sum(decode(action_name,'SELECT' , 1, 'INSERT',1, 'DELETE',1,'UPDATE',1,0)) 0 group by obj_name; Script #2 - Dave Ensor (BMC): set verify off col CTYP heading 'Command Type' col OBJ format a32 wrap heading 'Table' col EXES format 999,990heading 'Execs' col GETS format 99,999,990 heading 'Buff Gets' col ROWP format 99,999,990 heading 'Rows Proc' select CTYP , OBJ , 0 - EXEM EXES , GETS , ROWP from (select distinct EXEM, CTYP, OBJ, GETS, ROWP from ( select decode (S.COMMAND_TYPE , 2, 'Insert into ' , 3, 'Select from ' , 6, 'Update of ' , 7, 'Delete from ' , 26, 'Lockof ') CTYP , O.OWNER || '.' || O.NAMEOBJ , sum(0 - S.EXECUTIONS) EXEM , sum(S.BUFFER_GETS) GETS , sum(S.ROWS_PROCESSED) ROWP from V$SQL S , V$OBJECT_DEPENDENCY D , V$DB_OBJECT_CACHE O where S.COMMAND_TYPE in (2,3,6,7,26) and D.FROM_ADDRESS = S.ADDRESS and D.TO_OWNER = O.OWNER and D.TO_NAME = O.NAME and O.TYPE = 'TABLE' group by S.COMMAND_TYPE , O.OWNER , O.NAME ) ) where ROWNUM = 1 / -- 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: Terrian, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: flexfield for Supplier's email address in 10.7NCA
John Are you looking at a form that already has a ff that you can modify? The Delpi program querying this will have to deal with the right ATTRIBUTEnn column (I think) on the view that results from the DFV. I need the Payables clerk to enter the email address for a Supplier. So i am talking about the Supplier Entry form APXVDMVD (ver 8.6.165). There is a DFF square bracket indicator just below the Tax Registration Number on my 10.7 NCA client with forms 4.5.10.13.0 But clicking on it does not invoke a popup page(bcos no DFF has been defined for that form). Although we have a test db instance on diff sever from the production, both of them share the same midtier. We have different urls to access the prod and test apps. but there are few folks who are worried that while testing with DFF, we corrupt the midtier forms, because they saw a COMPILE button on a FlexField setup form. Also here we try to avoid outside consultants, so the burden lies on me to find a solution. -Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: BR solutions
Title: RE: RE: BR solutions amen! and remember...what was it called...EBU? I wanted to make sure RMAN was here to stay before moving to it. Well it looks like it's here to stay, I just don't want to change a good backup strategy that I am comfortable with. - Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: BR solutions I kinfa hate to admit it, but I'm one of those who has not embrased RMAN. More out of lack of time to investigate than anything else, but to make real use of it here I need to intergrate it with OmniBack, which requires a database relink. And getting the databases away from the end users long enough is a real pain in the $%#. Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 7/25/2002 10:13 AM I agree with Ruth (using Rman since 805). Robust, stable and easy to use. And Free! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I have used rman since O804 and it's just gotten better and better. I have never tried anything else. It's free so the State likes that. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 11:08 AM Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
dbms_stats question
Hi,
We are testing dbma_stats package to gather statistics for our schema???
we have created 1 table 'test' with 1 column
abc number
we are doing following steps:
1) insert into test values(1);
commit;
2) SQL EXEC DBMS_STATS.GATHER_Schema_STATS('HS',STATTAB = 'stats_temp1',statid
=
'test1');
3) SQL select table_name,num_rows,blocks,empty_blocks from user_tables where
table
_name='TEST';
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS
-- -- --
test 1 10
4) insert into test values(2);
commit;
5) SQL EXEC DBMS_STATS.GATHER_Schema_STATS('HS',STATTAB = 'stats_temp1',statid
=
'test2');
6) SQL select table_name,num_rows,blocks,empty_blocks from user_tables where
table
_name='TEST';
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS
-- -- --
test 2 10
7) now if i do,
SQL EXEC DBMS_STATS.DELETE_Schema_STATS('HS');
8) If i try to import
SQL EXEC DBMS_STATS.import_Schema_STATS('HS',STATTAB = 'stats_temp1',STATID
=
'TEST1');
THIS DOES NOT POPULATE THE STATSISTICS IN USER_TABLES
9) And if i do like this:
SQL EXEC DBMS_STATS.import_Schema_STATS('HS',STATTAB = 'stats_temp1',STATID
=
'TEST2');
it shows output num_rows=1 whereas it is expected to have num_rows=2
3) SQL select table_name,num_rows,blocks,empty_blocks from user_tables where
table
_name='TEST';
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS
-- -- --
test 1 10
WHY THE FIRST IMPORT not poplulaing the stats column AND SECOND IMPORT have 1
rows and not 2 ROWS ?
Thanks
--Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: RE: BR solutions
Title: RE: RE: B solutions There's also the little matter of the dev refresh strategy being wedded to the backup strategy. Moving generally means ripping out the best part of the infrastructure. :) John P Weatherman Database Administrator Replacements Ltd. -Original Message-From: Gesler, Rich [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 25, 2002 4:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: BR solutions amen! and remember...what was it called...EBU? I wanted to make sure RMAN was here to stay before moving to it. Well it looks like it's here to stay, I just don't want to change a good backup strategy that I am comfortable with. - Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: BR solutions I kinfa hate to admit it, but I'm one of those who has not embrased RMAN. More out of lack of time to investigate than anything else, but to make real use of it here I need to intergrate it with OmniBack, which requires a database relink. And getting the databases away from the end users long enough is a real pain in the $%#. Dick Goulet Reply Separator Author: "Mercadante; Thomas F" [EMAIL PROTECTED] Date: 7/25/2002 10:13 AM I agree with Ruth (using Rman since 805). Robust, stable and easy to use. And Free! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I have used rman since O804 and it's just gotten better and better. I have never tried anything else. It's free so the State likes that. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 11:08 AM Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing:
Errors trying to connect from 8.1.7 client to 7.3.2 server
Environment: Client - 8.1.7 running on AIX 4.3.3 Server - 7.3.2 on SGI IRIX64 version 6.5 I can connect from SQLPlus Worksheet on Windows 2000 (also 8.1.7), but when I try to connect from sqplus (command line) on the AIX machine I get ORA-12504. I can connect to other 8.1.7 systems from the AIX client and the tnsnames.ora file entry for my 7.3.2 server is a direct copy from tnsnames.ora on my W2k box. My sqlnet.log file shows: *** Fatal NI connect error 12504, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mfgad11)(PORT=1521))(CONECT_DATA=( SID _NAME=test1))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=bemwi755)(USER=oracle VERSION INFORMATION: TNS for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Development TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 8.1.7.0 .0 - Development Time: 25-JUL-2002 16:09:03 Tracing to file: /opt/oracle/cli.trc Tns error struct: nr err code: 0 ns main err code: 12564 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Any suggestions? Thanks in advance, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dbms_stats question
Well, the results seem to indicate that the saved statistics are taken before
gathering new statistics. When I read the documentation, I see stattab User stat
table identifier describing where to save the current statistics. I guess this can
be read as save the current statistics in stattab before computing the new
statistics. Nothing like clarity of expression. This is why tech writers earn the
big bucks 8-)
Kevin Kennedy
First Point Energy Corporation
If you take RAC out of Oracle you get OLE! What can this mean?
-Original Message-
Sent: Thursday, July 25, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L
Hi,
We are testing dbma_stats package to gather statistics for our schema???
we have created 1 table 'test' with 1 column
abc number
we are doing following steps:
1) insert into test values(1);
commit;
2) SQL EXEC DBMS_STATS.GATHER_Schema_STATS('HS',STATTAB = 'stats_temp1',statid
=
'test1');
3) SQL select table_name,num_rows,blocks,empty_blocks from user_tables where
table
_name='TEST';
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS
-- -- --
test 1 10
4) insert into test values(2);
commit;
5) SQL EXEC DBMS_STATS.GATHER_Schema_STATS('HS',STATTAB = 'stats_temp1',statid
=
'test2');
6) SQL select table_name,num_rows,blocks,empty_blocks from user_tables where
table
_name='TEST';
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS
-- -- --
test 2 10
7) now if i do,
SQL EXEC DBMS_STATS.DELETE_Schema_STATS('HS');
8) If i try to import
SQL EXEC DBMS_STATS.import_Schema_STATS('HS',STATTAB = 'stats_temp1',STATID
=
'TEST1');
THIS DOES NOT POPULATE THE STATSISTICS IN USER_TABLES
9) And if i do like this:
SQL EXEC DBMS_STATS.import_Schema_STATS('HS',STATTAB = 'stats_temp1',STATID
=
'TEST2');
it shows output num_rows=1 whereas it is expected to have num_rows=2
3) SQL select table_name,num_rows,blocks,empty_blocks from user_tables where
table
_name='TEST';
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS
-- -- --
test 1 10
WHY THE FIRST IMPORT not poplulaing the stats column AND SECOND IMPORT have 1
rows and not 2 ROWS ?
Thanks
--Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kkennedy
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Cursor Sharing| Soft Parsing
I checked the Tom Kyte site. A soft parse comprises two operations. One is a simple syntax check; e.g. select from dual; would fail this soft parse as it is missing a column list or a literal. The other portion of a soft parse what he calls a semantics check is checking to see if the tables and columns exist, that the person has the proper permissions, that there are no ambiguities. select deptno from emp, dept where emp.deptno = dept.deptno / would fail this type of parse. My Kyte's definition of a soft parse jibes nicely with the one I used earlier. I didn't include the syntactical error portion as the statements in question are all valid SQL. However it is just as important. Semantic and syntactical checks are done; i.e.., a soft parse is done before the cache is checked. Quoting from the article The next step in the parse operation is to see if the statement we are currently parsing has already in fact been processed by some other session. If it has ? we may be in luck here, we can skip the next two steps in the process, that of optimization and row source generation. If we can skip these next two steps in the process, we have done what is known as a Soft Parse. While writing this it has suddenly dawned on me what Suhen was talking about when said cursor_sharing = 'FORCE' avoids a hard parse at the cost of a soft. If this is set select * from emp where ename = 'KING'; will be soft parsed. It will be changed to select * from emp where ename = :bind_variable; This statement will undergo soft parsing again. If the statement can be found in cache; then no hard parsing is needed. The generation of the second SQL statement replacing the literal with a bind variables increases the likelihood of not having to hard parse. -- Now about session_cached_cursors. First checking the hits 1 select a.name, b.value 2 from v$sysstat a, v$sesstat b 3 where a.statistic# = b.statistic# 4 and a.statistic# = 191 5* and b.sid = 8 SQL / NAME VALUE - session cursor cache hits 10 running the statement 1* select ename from scott.emp where empno = :v_empno SQL / ENAME -- MILL If I run the query to ge the session cached cursors statement. I see it has been incremented. NAME VALUE - session cursor cache hits 11 now if I revoke the permissions on the table. I get SQL / select ename from scott.emp where empno = :v_empno * ERROR at line 1: ORA-01031: insufficient privileges --- Sure seems like the statement is undergoing a semantics check despite the availability of a cached cursor. The article posted by Tom Kyte, does not state that session_cached_cursors avoids soft parses. It says they make finding the cursor less expensive. Particularly the expense of latching the shared pool and the library cache. He runs a query 1000 times. Once without it being cached and again with it being cached and finds NAME RUN1 RUN2 DIFF -- -- -- LATCH.shared pool 2142 1097 -1045 LATCH.library cache 17361 2388 -14973 == The lesser latch count is for the query using session_cached cursors. Session_Cached_Cursors do save on resources and are important to scalability. But I have yet to see something which proves they stop soft parsing. I saw Steve' Orr's contribution An entry is created for the session's cursor cache and future cursor CLOSEs are ignored. Once in the session cursor cache the SQL statement does not need to be reparsed. This gives a significant performance boost! Giving credit where due: The above was inspired from pages 277-280 in Scaling Oracle8i by James Morle. I have posted material which refutes the above. Again how does one avoid the soft parsing? -Original Message- Sent: Wednesday, July 24, 2002 11:43 PM To: Multiple recipients of list ORACLE-L Ian, When coding you should parse once and
RE: RE: BR solutions
I'll stick to my trusty unix scripts for hot cold backups. When I roll out RDBMS 9iR2 patched, then I will consider migrating to RMAN. From what I understand, 9iR2 RMAN is much improved over the 8.0 RMAN. I also agree, I want to make sure RMAN is sticking around. And of course it WORKS! :) Gene [EMAIL PROTECTED] 07/25/02 04:13PM amen! and remember...what was it called...EBU? I wanted to make sure RMAN was here to stay before moving to it. Well it looks like it's here to stay, I just don't want to change a good backup strategy that I am comfortable with. - Rich -Original Message- Sent: Thursday, July 25, 2002 3:34 PM To: Multiple recipients of list ORACLE-L I kinfa hate to admit it, but I'm one of those who has not embrased RMAN. More out of lack of time to investigate than anything else, but to make real use of it here I need to intergrate it with OmniBack, which requires a database relink. And getting the databases away from the end users long enough is a real pain in the $%#. Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 7/25/2002 10:13 AM I agree with Ruth (using Rman since 805). Robust, stable and easy to use. And Free! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I have used rman since O804 and it's just gotten better and better. I have never tried anything else. It's free so the State likes that. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 11:08 AM Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
security policy aka fine-grained access control (was: lock agains
Title: security policy aka fine-grained access control (was: lock against inserts) I see that Mr. Buchan answered his own question (use dbms_lock inside an insert trigger to wait until the processing is done.) But after reading your question I looked at security policies aka fine-grained access control (dbms_rls) and started wondering, how can the fine-grained access control apply to an insert? From my trials and from what the documentation says, a security policy will add an extra condition to the end of your where clause. But it also gives you the option to apply the security policy to an insert statement. Has anyone ever done that? If so, how and why?
RE: Errors trying to connect from 8.1.7 client to 7.3.2 server
Title: RE: Errors trying to connect from 8.1.7 client to 7.3.2 server What does the tnsnames.ora entry on the client machines look like? In the CONNECT_DATA entry, do you have SID= (connect_data = (sid = AAA)) or service_name = and instance_name = ? (connect_data = (service_name = BBB.CCC.DDD) (instance_name = BBB)) -Original Message- From: Schauss, Peter [mailto:[EMAIL PROTECTED]] Environment: Client - 8.1.7 running on AIX 4.3.3 Server - 7.3.2 on SGI IRIX64 version 6.5 I can connect from SQLPlus Worksheet on Windows 2000 (also 8.1.7), but when I try to connect from sqplus (command line) on the AIX machine I get ORA-12504. I can connect to other 8.1.7 systems from the AIX client and the tnsnames.ora file entry for my 7.3.2 server is a direct copy from tnsnames.ora on my W2k box. My sqlnet.log file shows: ** * Fatal NI connect error 12504, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mfgad11)(PORT=1521)) (CONECT_DATA=( SID _NAME=test1))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=bemwi755)(USER =oracle VERSION INFORMATION: TNS for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Development TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 8.1.7.0 .0 - Development Time: 25-JUL-2002 16:09:03 Tracing to file: /opt/oracle/cli.trc Tns error struct: nr err code: 0 ns main err code: 12564 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Any suggestions?
RE: Cursor Sharing| Soft Parsing
Interesting. Sometimes you've got to test things and not just believe what you read. now if I revoke the permissions on the table. Hmmm... if you modify a table all the associated shared SQL area is invalidated. I wonder if something like that is going on when you alter user privileges? Maybe the cached cursor is nolonger available? Sometimes trying to figure out what Oracle is doing is like smashing sub-atomic particles together at the speed of light. You deduce the way it was put together by the way it broke into pieces. Kind of crude but what else can you do without the source code of the creator? Steve Orr -Original Message- Sent: Thursday, July 25, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Importance: High I checked the Tom Kyte site. A soft parse comprises two operations. One is a simple syntax check; e.g. select from dual; would fail this soft parse as it is missing a column list or a literal. The other portion of a soft parse what he calls a semantics check is checking to see if the tables and columns exist, that the person has the proper permissions, that there are no ambiguities. select deptno from emp, dept where emp.deptno = dept.deptno / would fail this type of parse. My Kyte's definition of a soft parse jibes nicely with the one I used earlier. I didn't include the syntactical error portion as the statements in question are all valid SQL. However it is just as important. Semantic and syntactical checks are done; i.e.., a soft parse is done before the cache is checked. Quoting from the article The next step in the parse operation is to see if the statement we are currently parsing has already in fact been processed by some other session. If it has ? we may be in luck here, we can skip the next two steps in the process, that of optimization and row source generation. If we can skip these next two steps in the process, we have done what is known as a Soft Parse. While writing this it has suddenly dawned on me what Suhen was talking about when said cursor_sharing = 'FORCE' avoids a hard parse at the cost of a soft. If this is set select * from emp where ename = 'KING'; will be soft parsed. It will be changed to select * from emp where ename = :bind_variable; This statement will undergo soft parsing again. If the statement can be found in cache; then no hard parsing is needed. The generation of the second SQL statement replacing the literal with a bind variables increases the likelihood of not having to hard parse. -- Now about session_cached_cursors. First checking the hits 1 select a.name, b.value 2 from v$sysstat a, v$sesstat b 3 where a.statistic# = b.statistic# 4 and a.statistic# = 191 5* and b.sid = 8 SQL / NAME VALUE - session cursor cache hits 10 running the statement 1* select ename from scott.emp where empno = :v_empno SQL / ENAME -- MILL If I run the query to ge the session cached cursors statement. I see it has been incremented. NAME VALUE - session cursor cache hits 11 now if I revoke the permissions on the table. I get SQL / select ename from scott.emp where empno = :v_empno * ERROR at line 1: ORA-01031: insufficient privileges --- Sure seems like the statement is undergoing a semantics check despite the availability of a cached cursor. The article posted by Tom Kyte, does not state that session_cached_cursors avoids soft parses. It says they make finding the cursor less expensive. Particularly the expense of latching the shared pool and the library cache. He runs a query 1000 times. Once without it being cached and again with it being cached and finds NAME RUN1 RUN2 DIFF -- -- -- LATCH.shared pool 2142 1097 -1045 LATCH.library cache 17361 2388 -14973 == The lesser latch count is for the query using session_cached cursors. Session_Cached_Cursors do
Cursor Sharing .... Continued
Setting it to Force worked well as the pool has been cleared on many queries using literals any many of those hard parses went away. So far ... So good. I aint sayin nothin to the developers although some have already noticed an improvement. I am going to put the hammer down on them to rewrite those literals. FWIW. Mike -- 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).
global temp table problem
Hi Guys , I am using global temp table for a complex select . This stored proc is called very frequently . Almost 200 calls per min . As I have to clean up the temp table I included commit inside proc ( since temp table is ' on commit delete rows ' ), but now my concern is .. will it cause lots of checkpoints and degrade the performance fo db . If yes then what is alternative ? TIA, bp
Re: Errors trying to connect from 8.1.7 client to 7.3.2 server
Verify the client tnsnames.ora is using SID and not SERVICE_NAME for CONNECT_DATA. Schauss, Peter wrote: Environment: Client - 8.1.7 running on AIX 4.3.3 Server - 7.3.2 on SGI IRIX64 version 6.5 I can connect from SQLPlus Worksheet on Windows 2000 (also 8.1.7), but when I try to connect from sqplus (command line) on the AIX machine I get ORA-12504. I can connect to other 8.1.7 systems from the AIX client and the tnsnames.ora file entry for my 7.3.2 server is a direct copy from tnsnames.ora on my W2k box. My sqlnet.log file shows: *** Fatal NI connect error 12504, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mfgad11)(PORT=1521))(CONECT_DATA=( SID _NAME=test1))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=bemwi755)(USER=oracle VERSION INFORMATION: TNS for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Development TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 8.1.7.0 .0 - Development Time: 25-JUL-2002 16:09:03 Tracing to file: /opt/oracle/cli.trc Tns error struct: nr err code: 0 ns main err code: 12564 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Any suggestions? Thanks in advance, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SMP on windows2000
iTAR resulted in no info so far. Oracle Tech Support is basically saying all their really good info is confidential. some analysis of overall industry issues w/ SMP: http://www.aceshardware.com/read.jsp?id=45000350 (linked from http://2cpu.com) --- latest URL dump --- http://2cpu.com - http://www.aceshardware.com/read.jsp?id=45000350 - http://www.winntmag.com/Articles/Index.cfm?ArticleID=7486 - http://www.ultratech-llc.com/KB/?File=SMP.TXT - http://www.ultratech-llc.com/KB/?File=SMPOS.TXT - http://www.microsoft.com/windows2000/techinfo/howitworks/default.asp - http://www.microsoft.com/mspress/books/sampchap/4354.asp ( linked from http://www.microsoft.com/mspress/books/4354.asp ) - http://developer.intel.com/technology/hyperthread/ - http://www.microsoft.com/windows2000/server/evaluation/performance/reports/h yper thread.asp ( http://www.microsoft.com/windows2000/docs/hyperthreading.doc ) - http://support.microsoft.com/default.aspx?SCID=KB;EN-US;Q234558 - ( general/introductory material only: ) http://www.2cpu.com/OSs/Windows/win2kintropart1/Win2kintrop1.html - http://2cpu.com/How-To/article2.htm - http://2cpu.com/FAQ/2cpusmpfaq.htm Original Message: - Date: Thu, 25 Jul 2002 10:13:49 -0800 To: [EMAIL PROTECTED] I've been wondering same, logged an iTAR. Will keep you in the loop. background (same old crap, sorry, nothing specific): http://www.winntmag.com/Articles/Index.cfm?ArticleID=7486 mail2web - Check your email from the web at http://mail2web.com/ . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
shutdown abort not advised on NT, memory probs
Doc ID: Note:46001.1 l Bulletin Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 14-JAN-1998 Last Revision Date: 11-APR-2002 1. Purpose == This note explains how Oracle interacts with Windows NT's memory architecture, for addition information about NT's memory architecture see [NOTE:46053.1] e) How session memory is released thread termination consequences --- When a users session completes successfully it deallocates its memory using the Win32 API call VirtualFree with the MEM_DECOMMIT | MEM_RELEASE allocation flags. After all allocations have been freed the stack is also released, leaving the Oracle processes address space free of reference to the completed session. If a users session terminates unexpectedly it will not release the memory it has allocated, the allocated pages will remain in the Oracle processes address space until the process exits. Unexpected termination may occur if a users session if forced to terminate for one of the following reasons : - Shutdown abort. - Alter session kill session. - Oracle command line utility orakill. - Oracle Administration assistant for Windows : kill session. - Other utilities that can kill threads in processes. Oracle Support Services recommends customers minimize the use of the above commands, in particular the shutdown abort command. When shutdown abort is run its calls the Win32 API TerminateThread for each users session, which kills the thread without releasing its memory. On systems with many users a large percentage of the 2GB address space of the Oracle process will become inaccessible, ultimately causing allocation problems when Oracle is next started. The only way to release this memory is to stop and start the Oracle Service (e.g. OracleServiceORCL). ---end--- mail2web - Check your email from the web at http://mail2web.com/ . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: global temp table problem
Global temporary tables do not generate redo. They do however, generate undo, and redo is generated for the undo. It's in the concepts manual. Jared BigP [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/25/2002 05:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:global temp table problem Hi Guys , I am using global temp table for a complex select . This stored proc is called very frequently . Almost 200 calls per min . As I have to clean up the temp table I included commit inside proc ( since temp table is ' on commit delete rows ' ), but now my concern is .. will it cause lots of checkpoints and degrade the performance fo db . If yes then what is alternative ? TIA, bp -- 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: How to see howmany transactions commit per min?
Unless you code it into your application, you can't. Oracle only knows about 'commit'. This may technically end a transaction, but does not necessarily delinieate a business transaction. It's up to the app developers to deal with that. Some 3rd party software such as SAP will track that kind of information. Jared Jonny Delmont [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/25/2002 09:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to see howmany transactions commit per min? Hi Gurus, Greetings. How to see howmany transactions commit per minute? Thanks, Jonny Get a bigger mailbox -- choose a size that fits your needs. http://uk.docs.yahoo.com/mail_storage.html -- 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).
