Changes to RULE based optimizer between Oracle8 and 9i
We move an application that uses OPTIMIZER_MODE=RULE from Oracle8 to 9i. Most of it is fine, but there are two queries that have a very different execution plan. In one case, the execution time increases from less than a minute to more than an hour. Neither query uses any of the new Oracle 9i features. My understanding is that the Rule optimizer code has not changed, except to account for new features like IOT's. Has anyone else seen this type of behavior? Keith MooreOracle Certified Professional972-431-5126[EMAIL PROTECTED] The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Re: how can I make Oracle not use all processors in machine?
I believe you license based on the 'actual' number of cpu's, BUT you can only license standard edition on a machine that has a maximum CPU count of 4 or less. Maybe that is what Jared is remembering. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 17, 2003 4:34 PM [EMAIL PROTECTED] wrote: Actually, I believe it is even more restrictive than that. It doesn't matter how many CPU's are in the machine, what matters is how many CPU's the machine is capable of holding. So what they are really licensing is not the # of CPU's, but the class of the machine. Try digging in the archives, this has been discussed recently. Jared We've licensed servers with less cpu's than they hold. According to our Oracle rep, this is fine. Number of actual cpu's only. Of course they like to check up to make sure you haven't added any recently ;) -Brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Haas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Re: perl dbi dbd
I'm in the process of doing the same thing. You can go to http://www.cmve.net/~merijn for a compiled version of Perl 5.8.1 that is prepared from DBI and DBD::Oracle. That will save you from compiling it yourself. My understanding is that you will still need gcc (or the HP ansi compiler) to compile DBI and DBD::Oracle. If I get that working, I'll let you know. Right now, I can't proceed because I don't have root access on the box. Keith - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:54 PM HP has pretty good customer service. They have usenet discussion forums on which they readily help. I'm sure that a question like would not take HP long time to answer. On 2003.10.03 00:34, Jesse, Rich wrote: Well, it's not at http://hpux.cs.utah.edu/, so I'm not sure where you can get it. Are you sure you can't build it? It'll build with the icky non-ANSI cc that comes with HP/UX (I think). Or d/l a gcc binary depot from the above site and compile it with that. There is at least one major caveat with DBI/DBD::Oracle on HP/UX. You must have compiled Perl to use threads in order to use DBI. Also, you may need to define LD_PRELOAD in order to avoid runtime problems. OK, so that's two... Anyway, see the DBI/DBD::Oracle docs and a Google search for hints on these. Hope you get a binary running! GL! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Thursday, October 02, 2003 5:40 PM To: Multiple recipients of list ORACLE-L where can I get binaries for perl DBI and DBD for hp-ux 9000 . I dont have pre requisite for building binaries from source . Thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Undo Tablespace vs Rollback segments
Can anyone point me to an article or white paper that goes into detail on this. When I RTFM, it just says use Undo TBS, don't worrry about it and all your problems will be solved. We are upgrading from Oracle8 to 9i and currently have Rollback segments in 4 tablespaces spread over 4 disks. It looks like you can specify multiple data files, but I can't find anything on how they would be used. I know that striping would spread the load, but that is not an option. Thanks, Keith Moore Oracle Certified Professional 972-431-5126 [EMAIL PROTECTED] The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Re: RMAN: What blocks are backed up with a full backup?
This matches the data I have collected, with the following addition: RMAN will backup any blocks that have ever had data in them, even if the extent has been deallocated or the object dropped. Keith - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:13 AM What it doesn't write are the blocks that are not allocated to any extent. RMAN doesn't go into the logical structures, like tables and indexes, it looks into the tablespace header and reads the information from the bitmap information there. It cannot go into tables/indexes because it should also work when the database is only mounted and not opened, which genrally means that data dictionary is not accessible. Empty blocks are blocks that don't have any rows in them but are allocated to an extent. New or unallocated blocks are blocks that have been initialized when the datafile was allocated to the tablespace but have not been assigned to any object (table, index, materialized view, cluster, partition or alike) -Original Message- Sent: Thursday, April 03, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Actually this is how RMAN works. It writes all blocks up to the HWM of a given table, even empty ones. So, if your HWM is artifically high, you will encounter backups that are larger than they need to be. Oracle9i RMAN Backup and Recovery On bookshelves now! RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/3/2003 11:19 AM Keith Here is my understanding (don't rely on this one). When Oracle allocates tablespace, the disk blocks are cleared. My interpretation is that when RMAN encounters a clear block, it doesn't write it to the backup piece. I don't think it spends a lot of time trying to figure out above HWM and such. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 03, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Our RMAN backup is backing up much more than the actual data blocks when doing a full backup. I know that it backs up all blocks that have ever been used, but I'm trying to figure out exactly what that means. My first thought was that it backs up all blocks below the HWM, but I analyzed the tables and that is not the case. Sometimes it backs up more blocks than exist below the HWM for the tables and sometimes it backs up fewer blocks than those below the HWM. We are doing this to determine what we can do to reduce the size of the backup. Anyone have an idea how this works? Keith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this
RMAN: What blocks are backed up with a full backup?
Our RMAN backup is backing up much more than the actual data blocks when doing a full backup. I know that it backs up all blocks that have ever been used, but I'm trying to figure out exactly what that means. My first thought was that it backs up all blocks below the HWM, but I analyzed the tables and that is not the case. Sometimes it backs up more blocks than exist below the HWM for the tables and sometimes it backs up fewer blocks than those below the HWM. We are doing this to determine what we can do to reduce the size of the backup. Anyone have an idea how this works? Keith The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Re: RMAN: What blocks are backed up with a full backup?
I should have stated that this is Oracle 8.0.5, if that makes a difference. After posting the questions, I went to Metalink and found some conflicting informaiton, but the consensus seemed to be that it was unrelated to the HWM of the tables. For example, after dropping a table, all the blocks were still being backed up. And as I said, for some tablespaces, it backs up many more blocks than are below the HWM blocks of the tables and in other cases it backs up fewer blocks than those below the HWM. My current thinking is that the best way to reduce the backup size is to resize the datafiles as small as possible and then resize them back to the original size. This should reduce the size some, but I don't think there is any way to tell how much. To get the maximum reduction, we could export...receate tablespaces...import, but it's not worth that much effort. Keith - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 3:23 PM Actually this is how RMAN works. It writes all blocks up to the HWM of a given table, even empty ones. So, if your HWM is artifically high, you will encounter backups that are larger than they need to be. Oracle9i RMAN Backup and Recovery On bookshelves now! RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/3/2003 11:19 AM Keith Here is my understanding (don't rely on this one). When Oracle allocates tablespace, the disk blocks are cleared. My interpretation is that when RMAN encounters a clear block, it doesn't write it to the backup piece. I don't think it spends a lot of time trying to figure out above HWM and such. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 03, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Our RMAN backup is backing up much more than the actual data blocks when doing a full backup. I know that it backs up all blocks that have ever been used, but I'm trying to figure out exactly what that means. My first thought was that it backs up all blocks below the HWM, but I analyzed the tables and that is not the case. Sometimes it backs up more blocks than exist below the HWM for the tables and sometimes it backs up fewer blocks than those below the HWM. We are doing this to determine what we can do to reduce the size of the backup. Anyone have an idea how this works? Keith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Keith Moore INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle License for Training
Oracle makes money there too. I teach Oracle classes at a community college. They pay a fee to Oracle and use the same books, powerpoint slides, etc. It's the exact same class, just taught by someone other than Oracle. It's amazing that more people don't take these classes instead of through Oracle education. They are significantly cheaper. But, they are mainly night classes, so maybe most businesses don't like that. Keith The point here is to allow people easier access to Oracle knowledge, through courses you can pick up at your local community college. What Oracle is doing right now is stifling this. -- Lyndon Tiu The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Re: Perl - Was unix time conversion function
I've started writing some perl and it is hard to learn, but once you learn,
it can do some great things. And if you learned it from the Larry Wall book
like I did, then it's even harder.
The thing I've discovered about perl it that it may be the only language
(computer or otherwise) that is easier to write than it is to read. I'm sure
a perl expert would gasp at my code, it's far too readable.
Keith
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 28, 2003 10:09 AM
please don't take umbridge, but I feel enticed to quote
what you don't know, dosn't (really) matter
Larry Wall, programming with perl, O'Reilly.
just for a giggle.
sorry
apologies for any typos overlooked
kr mr
[EMAIL PROTECTED] 01/28/03 12:22 PM
I've managed to successfully avoid learning Perl for a while now... my
reaction, while not quite so dramatic as yours, was that it made my
head hurt to try to understand it! :)
--- Robert Freeman [EMAIL PROTECTED] wrote:
unix time conversion functionCary I once thought I wanted to do
some
Perl coding... So I bought a book and started to play with it. It
made my
head bleed... literally I had little droplets of blood emerging from
my
head They rushed me to the hospital and put me in the Perl ward
where I
languished for days on IV's of Mountain Dew and pulverized Ritz
crackers. it was close.
In my mind there is nothing obvious about Perl, this coming from and
old C
coder who did pointers and linked lists in his sleep years ago. I
don't
know, maybe I was having a bad day and it's time to get my learning
Perl
book out again
Anyone else feel that way about Perl or am I a lone wolf in a Perl
world?
RF
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cary
Millsap
Sent: Friday, January 24, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: unix time conversion function
At the risk of stating the obvious, doing it in Perl looks like
this:
#!/usr/bin/perl
use Date::Format qw(time2str);
my $t = 1043447100; # for example
print time2str(%T %A %d %B %Y, $t), \n;
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12
Dallas
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101, Mar 26-28 London
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Post,
Ethan
Sent: Friday, January 24, 2003 3:30 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: unix time conversion function
Kinda...you can change the year to 1970 if you want, this also
converts to
minutes, not seconds. It is a really ugly function but it seems to
work.
You could always use perl.
function f_minutes {
# Funky function I use to calculate the number of minutes since
2000
MIN_YEAR=$( date +%Y )
MIN_YEAR=$( expr ${MIN_YEAR} - 2000 )
MIN_YEAR=$( expr ${MIN_YEAR} \* 525600 )
MIN_DAYS=$( date +%j )
MIN_DAYS=$( expr ${MIN_DAYS} - 1 )
MIN_DAYS=$( expr ${MIN_DAYS} \* 1440 )
MIN_HOURS=$( date +%H )
MIN_HOURS=$( expr ${MIN_HOURS} \* 60 )
MIN_MINS=$( date +%M )
MIN_TOTAL=$(( ${MIN_YEAR} + ${MIN_DAYS} + ${MIN_HOURS} +
${MIN_MINS} ))
print ${MIN_TOTAL}
}
-Original Message-
From: Adams, Matthew (GECP, MABG, 088130)
[mailto:[EMAIL PROTECTED]]
Sent: Friday, January 24, 2003 1:14 PM
To: Multiple recipients of list ORACLE-L
Subject: unix time conversion function
Anybody got a handy little function to
convert a standard unix seconds-since-Jan-1970 epoch
time (stored as a number) to a readable date?
It would save me a lot of time not having to re-invent the
wheel.
Matt
Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like
Re: New Schema or New Database?
As you said, one advantage of a single instance is the memory and disk space usage. Another disadvantage is when you need to upgrade the database for one application, but not for another. Keith - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 8:53 AM Our DBA group has recently been getting numerous requests for new databases (training, inventory, customer contacts, etc..) from different departments within the company. Our normal procedure is to create a new instance for the database, create the schema, users, etc..., set up backups and turn it over. However, with the volume of requests we are now getting, we are pondering the idea of creating just one instance and giving each database request its own tablespace and schema. (similar to informix and sybase architecture). My questions for discussion are these; 1) What are the benefits/risks associated with this scenario? Please note that these databases/schemas are unrelated. 2) What questions (for a user questionaire) should we ask regarding their database requirements, which will help us make an informed decision? My concerns are; 1) the inability to tune the instance for one schema/applications performance needs. 2) uptime/availability requirements may differ among the databases. 3) backup/restore scenarios specific to the schema/database (restore just one schema to a point-in-time). We want to be able to save on memory(sga) and processes by combining the databases into one instance as schemas, but don't want to limit the different applications to 'one-size-fits-all' for performance/recovery scenarios. Any advice would be greatly welcomed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Re: USER_TABLESPACES has more rows than DBA_TABLESPACES
I'm still confused. They are not in DBA_TABLESPACES, only USER_TABLESPACES.Keith- Original Message - From: "Stephane Faroult" [EMAIL PROTECTED]To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Monday, January 13, 2003 1:34 PMSubject: Re: USER_TABLESPACES has more rows than DBA_TABLESPACES Keith Moore wrote: Has anyone else seen this or can you explain it? I have 7 tablespaces in USER_TABLESPACES that don't exist in DBA_TABLESPACES. These have been dropped, but somehow did not disappear from USER_TABLESPACES. They have a status of INVALID. The database is version 8.0.5 (Yeah, I know, we'll be going to 9i real soon now)Keith Regular behaviour. Rows are never deleted from sys.ts$ (on which DBA_TABLESPACES is based). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Re: Minimum required init.ora parameters
It seems like I remember misspelling 'control_file' once and discorvering that even it has a default. Of course with Oracle, it could depend on the version, O/S, patch level, phase of the moon, etc. Keith - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 13, 2003 8:54 AM compatibility or compatible is not a mandatory init.ora parameter. I would think that only the first three are required. Hemant At 06:08 AM 13-01-03 -0800, you wrote: Nirmal - I believe there are four: db_name control_file db_block_size compatibility This is from John Hibbard, a great Oracle Education instructor. But why not try for yourself? Save off your init.ora, then create a new init.ora with just the above parameters. If Oracle comes up, then remove parameters. If there is another parameter, Oracle will tell you. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 4:59 AM To: Multiple recipients of list ORACLE-L List, I'm interested to know the minimum required parameters to startup the database. Pls anybody list out that? Nirmal., -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
USER_TABLESPACES has more rows than DBA_TABLESPACES
Has anyone else seen this or can youexplain it? I have 7 tablespaces in USER_TABLESPACES that don't exist in DBA_TABLESPACES. These have been dropped, but somehow did not disappear from USER_TABLESPACES. They have a status of INVALID. The database is version 8.0.5 (Yeah, I know, we'll be going to 9i real soon now) Keith The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Re: RMAN datafile allocation to channels
Here the the answer to my own question. This is the response from Oracle support about how datafiles are allocated to channels. The manual approach means explicitly specifying which datafiles go with which channels. I need to look at this further, because what happens when you add a datafile and forget to add it to the RMAN script. It should still get backed up, because it's a full backup. Keith You are right. Datafiles are assigned randomly to channels when backup database and you cannot predict the way they are assigned. So, as you have stated, the only way is manual approach which you already know. The same algorithm is used in most recent releases. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 16, 2002 1:49 PM My condolences on 8.0.5, you should patch to 8.0.5.1 for better a much better rman. I think that every channel is used for each datafile. When one datafile has been completely backed up the channels are used for the next. This is empiracal thought, what I have observed. I have 2 channels going to one disk. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, December 15, 2002 1:38 PM Does anyone know how RMAN decides which data files get backed up by which channels. I'm backing up to disk and have 4 channels, each to a separate disk drive. The data files seem to get assigned to channels at random. Also, this is a version 8.0.5 database (U). Keith -- -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Re: password
I don't know if 'crack' is the right word. It just tries words from the dictionary until it finds one that encrypts to the same value. Keith - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 11:09 AM Hmm... Well maybe you *can* crack oracle passwords. I've just ordered the full version of this product. ( $4, I don't think I need to bother the purchasing department ). I'll let you know how it works. Jared Mark Leith [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 06:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: password Yes, you can do this, but it still doesn't tell you the users *current* password does it? Has anyone tried: http://home.earthlink.net/~adamshalon/oracle_password_cracker/ ? Mark -Original Message- Sent: 17 December 2002 13:59 To: Multiple recipients of list ORACLE-L And you can use it to change it to your convenience and later get this encrypted password IN without the knowledge of the user.. Regards Jai Paulo Gomes [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/02 06:08 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: password nope u can get the encripted password from the oracle dictionáry -Original Message- Sent: terça-feira, 17 de Dezembro de 2002 11:34 To: Multiple recipients of list ORACLE-L Check the post-it note on their monitor? :) -Original Message- Sent: 17 December 2002 10:55 To: Multiple recipients of list ORACLE-L he can't but he can change it to a new one and then put the old back on -Original Message- Sent: terça-feira, 17 de Dezembro de 2002 4:09 To: Multiple recipients of list ORACLE-L how can a dba see the password of a user. The new MSN 8: smart spam protection and 2 months FREE* -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: faisal ahmad INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Re: RMAN datafile allocation to channels
My condolences on 8.0.5, you should patch to 8.0.5.1 for better a much better rman. Actually we are on 8.0.5.1. What are the differences in rman between these versions? I think that every channel is used for each datafile. When one datafile has been completely backed up the channels are used for the next. This is empiracal thought, what I have observed. I have 2 channels going to one disk. Here is a portion of log file. It is definitely assigning each datafile to a separate channel. It seems to be doing it at random. But, it doesn't look like it balances the output in any way. RMAN-08008: channel dev1: starting datafile backupset RMAN-08502: set_count=7143 set_stamp=480787230 RMAN-08010: channel dev1: including datafile 20 in backupset RMAN-08010: channel dev1: including datafile 15 in backupset RMAN-08010: channel dev1: including datafile 89 in backupset RMAN-08010: channel dev1: including datafile 65 in backupset RMAN-08010: channel dev1: including datafile 39 in backupset RMAN-08010: channel dev1: including datafile 91 in backupset RMAN-08010: channel dev1: including datafile 24 in backupset RMAN-08010: channel dev1: including datafile 80 in backupset RMAN-08010: channel dev1: including datafile 3 in backupset RMAN-08010: channel dev1: including datafile 74 in backupset RMAN-08010: channel dev1: including datafile 46 in backupset RMAN-08010: channel dev1: including datafile 49 in backupset RMAN-08010: channel dev1: including datafile 11 in backupset RMAN-08010: channel dev1: including datafile 9 in backupset RMAN-08008: channel dev2: starting datafile backupset RMAN-08502: set_count=7144 set_stamp=480787230 RMAN-08010: channel dev2: including datafile 94 in backupset RMAN-08010: channel dev2: including datafile 97 in backupset RMAN-08010: channel dev2: including datafile 88 in backupset RMAN-08010: channel dev2: including datafile 36 in backupset RMAN-08010: channel dev2: including datafile 37 in backupset RMAN-08010: channel dev2: including datafile 34 in backupset RMAN-08010: channel dev2: including datafile 47 in backupset RMAN-08010: channel dev2: including datafile 4 in backupset RMAN-08010: channel dev2: including datafile 38 in backupset RMAN-08010: channel dev2: including datafile 28 in backupset RMAN-08010: channel dev2: including datafile 71 in backupset RMAN-08010: channel dev2: including datafile 70 in backupset RMAN-08010: channel dev2: including datafile 10 in backupset RMAN-08010: channel dev2: including datafile 50 in backupset Keith The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Re: password
The best defense is to lock the account if there are over x number of failed logon attempts. Then they have to guess in just a few tries. You can also reduce the change that it will work by enforcing password complexity. Or at least it would take a long time. Make sure people have a number and/or punctuation in their password, preferrable not the last character. It will also be much more difficult if the intruder doesn't know the usernames. Keith - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 12:14 PM oh this is very scary especially that price did you try out the demo? I'm still in catch-up, deal with crises mode so I haven't had a chance Rachel --- [EMAIL PROTECTED] wrote: Hmm... Well maybe you *can* crack oracle passwords. I've just ordered the full version of this product. ( $4, I don't think I need to bother the purchasing department ). I'll let you know how it works. Jared Mark Leith [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 06:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: password Yes, you can do this, but it still doesn't tell you the users *current* password does it? Has anyone tried: http://home.earthlink.net/~adamshalon/oracle_password_cracker/ ? Mark -Original Message- Sent: 17 December 2002 13:59 To: Multiple recipients of list ORACLE-L And you can use it to change it to your convenience and later get this encrypted password IN without the knowledge of the user.. Regards Jai Paulo Gomes [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/02 06:08 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: password nope u can get the encripted password from the oracle dictionáry -Original Message- Sent: terça-feira, 17 de Dezembro de 2002 11:34 To: Multiple recipients of list ORACLE-L Check the post-it note on their monitor? :) -Original Message- Sent: 17 December 2002 10:55 To: Multiple recipients of list ORACLE-L he can't but he can change it to a new one and then put the old back on -Original Message- Sent: terça-feira, 17 de Dezembro de 2002 4:09 To: Multiple recipients of list ORACLE-L how can a dba see the password of a user. The new MSN 8: smart spam protection and 2 months FREE* -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: faisal ahmad INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended
RMAN datafile allocation to channels
Does anyone know how RMAN decides which data files get backed up by which channels. I'm backing up to disk and have 4 channels, each to a separate disk drive. The data files seem to get assigned to channels at random. Also, this is a version 8.0.5 database (U). Keith The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Listener question. What is PNPKEY?
The default listener.ora file contains an IPC listing with (KEY=PNPKEY). I've searched the documentation and can't find any description of what this is for. Thanks, Keith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Bug in dbstart Script?
I've seen something similar. I installed the Java option and it changed the
text from PL/SQL Release 8.1.6.0.0 to JServer Release 8.1.6.0.0, which
broke dbstart.
At 09:47 AM 7/12/2001 -0800, you wrote:
Folks,
I'm not sure if this applies to any of you, but the
$ORACLE_HOME/bin/dbstart script 8.1.6 for Solaris 2.6
appears to have a slight bug in it. Whenever we
re-booted, during the system startup, the dbstart
script is called but none of our databases ever come
up. I finally tracked it down to this offending piece
of code in dbstart:
if test -f $ORACLE_HOME/bin/svrmgrl; then
VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk
'
/PL\/SQL (Release|Version)/ {substr($3,1,3) ;
print substr($3,1,3)}'`
...
...
...
which I've replaced with this:
if test -f $ORACLE_HOME/bin/svrmgrl; then
VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk
'
/Oracle8i Enterprise Edition (Release|Version)/
{substr($5,1,3) ;
print substr($5,1,3)}'`
...
...
...
Our databases come up automatically after a re-boot.
hth someone.
mkb
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mohammed bhatti
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Keith Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
