RE: Win2000/8.1.7.3.0/SQL
Title: RE: Win2000/8.1.7.3.0/SQL Hi Mike, I got 'DEFAULT'. After 'alter table ... noparallel', it was '1'. From Metalink 66484.1: (3) If any table in a query has a parallel degreee greater than one (including the DEFAULT degree), Oracle uses the cost-based optimizer for that query--even if OPTIMIZER_MODE = RULE, or if there is a RULE hint in the query itself So, since you said that a RULE hint makes it work, this may not be the problem. Dan. -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Win2000/8.1.7.3.0/SQL Dan: When you did a 'select degree from dba_tables', did you get '1' or 'DEFAULT'? I get '1's for all my tables. Is there someplace else I should look? Thanks, Mike
RE: Win2000/8.1.7.3.0/SQL
Title: RE: Win2000/8.1.7.3.0/SQL I think you are on to something Jared. We had this happen at a production site last year. For some reason, the site began reporting performance problems after upgrading from 7.3.4 to 8.1.6. I finally tracked it down to the fact that a majority of our tables had 'degree' set to 'DEFAULT', which forces the use of the CBO. We fixed this by doing 'alter table noparallel' for all the tables which set degree to 1 and solved the problem. Dan. > -Original Message- > From: Jared Still [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 19, 2002 7:38 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Win2000/8.1.7.3.0/SQL > > > > Mike, > > Is the DEGREEE on the table > 1? > > You can see this in DBA_TABLES. > > If the degree of parallelism is > 1 then CBO > will be used regardless of OPTIMIZER_MODE or > OPTIMIZER_GOAL. > > Using a RULE hint will override the optimizer settings. > > I'm guessing that degree is > 1 and you have old statistics. > > Jared > > On Monday 19 August 2002 17:58, Vergara, Michael (TEM) wrote: > > Ok...this is strange. The optimizer_mode is set to RULE, but if > > I put a RULE hint into the SQL it runs OK. I tried increasing > > the sort_area_size, but no joy. The segment with the largest > > number of extents is the silly TEMP segment with 985. After that > > is IDL_UB1$ with 739, and it tapers off quickly after that. > > On the other hand, this query runs fine on our SAP system, and > > it has thousands of tables and lots of extents. > > > > Well, the RULE hint in a RULE system seems to have worked. > > Weird. I never woulda tried that. > > > > Thanks, > > Mike > > > > -Original Message- > > [mailto:[EMAIL PROTECTED]] > > Sent: Monday, August 19, 2002 4:28 PM > > To: Multiple recipients of list ORACLE-L > > > > > > or is that 1 db set to first_rows? > > If so try the query with a rule hint? > > > > Bruce Reardon > -- > 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: Win2000/8.1.7.3.0/SQL
Title: RE: Win2000/8.1.7.3.0/SQL Just a WAG, but do any of your objects have a huge number of extents? Dan. > -Original Message- > From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 19, 2002 4:23 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Win2000/8.1.7.3.0/SQL > > > John: > > > Does that particular Db have it's SYS schema ANALYZED? This > should return no > > rows - if it does, then you can drop the stats for SYS and > run this query > > again. > > Nope. Checked that already, but I checked it again. Any other > suggestions? > > Thanks, > Mike
RE: How to clone a local database from 9i server to a remote 8i s
Title: RE: How to clone a local database from 9i server to a remote 8i server site > > Anyone please direct me where I can find > good resources about how to clone a local > database from Oracle9i server to a remote > Oracle8i server site. > See the "export/import" documentation and Metalink # 61949.1 Dan.
RE: RE: Dba tools on NT
Title: RE: RE: Dba tools on NT Stay on the good side Jared. Your code snippet looks great to me, and looking at it finally showed me a clear example of how that q{} thingy works. I write a lot of Oracle utility type stuff that has to run on both Windows and UNIX. Perl does the job every time. Rachel, Jared should admit that he would probably need just a few more characters (about 6 alpha and 48 special!) to actually run the code, but the essence is there and with a glance you can tell that it does produce CSV output using DBI/DBD to access the database. :) Dan. "There are only 10 types of people in the world: Those who understand binary, and those who don't." -Original Message- From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 8:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Dba tools on NT How many developers can maintain that "cryptic" Perl code? Come over to the light...don't be afraid. Chris PS. 20 alpha characters...and about 25 special characters in that bit of code.hm, not going to say anything about that. -Original Message- To: [EMAIL PROTECTED] Cc: Grabowy, Chris Sent: 8/14/2002 2:03 PM How many of those "non-cryptic" languages can dump a table to a CSV file in 2 lines of (readable ) code? while ( my $ary = $sth->fetchrow_arrayref ) { print q{"} . join(q{","},@{$ary}) . qq{"\n}; } Come over to the dark side Chris. ;) Jared
RE: Oracle Corp. move to India
Well said, Dave. -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 01, 2002 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Corp. move to India
RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Title: RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA You're on target there. Don't start. It's not just a job it's an adventure. I must say that I used the DBCA twice. After cleaning up the mess it made the first time, I just had it create the scripts for me. After 'fixing' the scripts to do it right and give me what I wanted, I've since been able to skip that particular Gooey. Dan. -Original Message- To: Multiple recipients of list ORACLE-L Subject: Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA Unfortunately, we have no choice but to use the java-infested, half-baked ruinStaller. Don't even get me started about the DataBase Cremation Assistant! Don Granaman [OraSaurus]
RE: Jared, please do something
Title: RE: Jared, please do something I'm sure that folks who have Unix email can handle this somehow. I must admit, it was pretty amusing reading the thread, but I subscribed to this list for the technical level and content, not for cyber-pissing contests. Personally, I use the tool (hardware or software) that produces the desired results in the least amount of time with the least amount of effort. I'm probably 50% Windows and 50% Unix throughout the day with databases on both platforms. Each platform has it's advantages and disadvantages. Use what you knowknow what you use. blah, blah, blah... Now given a choice between CodeWright and vi :-) -Original Message-From: Gesler, Rich [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 31, 2002 11:18 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Jared, please do something That won't work...obviously everybody is on Unix here. -Original Message-----From: Straub, Dan [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 31, 2002 2:03 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Jared, please do something This works pretty good in Outlook: apply this rule after message arrives with [EMAIL PROTECTED] in the sender's address clear the message flag and delete it and stop processing more rules Dan.
RE: Jared, please do something
Title: RE: Jared, please do something This works pretty good in Outlook: apply this rule after message arrives with [EMAIL PROTECTED] in the sender's address clear the message flag and delete it and stop processing more rules Dan.
RE: Why DB_Name 4 chars only.
Title: RE: Why DB_Name 4 chars only. > > What is the reason behind DB_Name/SID usually 4 chars > length only. I have a customer who is asking us to > create instance/db with 6 chars length. We usually > keep instance name and db_name parameters same in .ora > file. Can someone please explain the reason behind > db_name 4 chars only. Is it a common practice to keep > SID/db_name/instance name parameters same (for example > PBDS). > Only a limitation on NT. We use up to 8 characters for UNIX. From Metalink doc 48681.1: "The SID should consist of four or fewer alphanumeric characters. This is to avoid problems with filename length restrictions on some platforms, e.g. the 8.3 restriction on DOS, which is still present on NT if using DOS-style names (which Oracle requires). So the initialization file for a database called ORCL will be called initORCL.ora, representing the longest possible filename." HTH, Dan Straub McKesson Information Solutions 541-681-8278 44°03'N 123°05'W (or thereabouts) Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Title: RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA > > > > ...hardcore DBAs might never use GUI tools. > > > > I fit that category. :) > What about the OUI? Don't you use that? :) Dan.
RE: Creating a **DEFAULT** database
Title: RE: Creating a **DEFAULT** database > > The same thing is not required on Sun Solaris. On Solaris 'user1' still belongs > to a different unix group. > I have an user on both DG-UX and HP-UX which is not in the 'dba' group. Connection (internal or tcpip) works fine on both systems with following setup: export ORACLE_HOME=/u01/app/oracle/product/8.1.7 export ORACLE_BASE=/u01/app/oracle export ORACLE_SID=ORCL export ORACLE_PATH=.:${ORACLE_HOME}/bin:/opt/bin:/bin:/GNU/bin/make:/usr/ccs/bin export SQLPATH=$ORACLE_HOME/sqlplus/admin export PATH=${PATH}:${ORACLE_HOME}/bin:/usr/contrib/bin/X11:${OBK_HOME}/bin I initially got the 'oracle not available' error on HP-UX when I tested this just now on both systems, but then realized that the HP was running 8.1.7 and DG was on 8.1.6. I had forgotten to set oracle_home correctly to 8.1.7. :) Once I did that, all was fine. Regards, Dan Straub McKesson Information Solutions 541-681-8278 44°03'N 123°05'W (or thereabouts) Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
RE: import question
Title: RE: import question > > If the Export has been taken with DIRECT = Y, meaning that the SQL > Evaluation buffer has to be bypassed then Import would not generate the Redo > buffer while Importing back the objects and the relevant data. > Very interesting, except that I believe you are wrong. ALL of my exports are done with direct=y option. I can demonstrate very easily that there will be 'redo' generated when doing the import by putting the importing database into archivelog mode and turning off the archiver process. If redo is not being produced (as you state), why do I see messages in the alert log telling me that the database is halted because all my redo logs are full and need archiving? Have a nice day, Dan Straub McKesson Information Solutions 541-681-8278 44°03'N 123°05'W (or thereabouts) Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.