Re: Pondering Question of the Day-RESPECT

Lisa, A sweatshop?! Now that sounds a bit harsh. .; ) And just yesterday, both Larry and Jeff complimented me on something nice some developers said about me. Last Friday they reorged a bit and now Leo is Larry's boss. So basically Development and our group is under the same umbrella.

Re: Pondering Question of the Day-RESPECT

Oops, I hate it when I do that. That was supposed to go straight to Lisa. Everyone else can just scratch their head and wonder. Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: Pondering Question of the Day-RESPECT

Lisa, What?!! Are you betting against getting fired or for being fired? Cherie Oh well. It's Friday and I have a bet going that I'll be fired by the end of the day. If I do get fired today I win $500! Ha! Have a great weekend everyone Lisa -Original Message- Sent: Friday,

Re:NLS and ORA-03106: fatal two-task communication protocol

Dick, In this case, it doesn't appear to be NLS or a network problem. The developer has replied with the following: When I ran this code, I got the Oracle -1458 problem: EXEC SQL EXECUTE BEGIN EmployeePackage.GetNextDownloadEmployee; :xversion:=

RE: Pondering Question of the Day-RESPECT

Lisa, Yes. Don't keep us in suspense. Let us know how the bet turned out. Cherie p.s. If you lose, that's $50 down the drain "Steve Orr" [EMAIL PROTECTED] on 02/02/2001 03:36:12 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

Re: recovery catalog creation

Psycharis, Do you have the database defined in your tnsnames.ora file? Can you connect via sql*net to this database shown behind the @ symbol? We get this error when we don't have our ORACLE_HOME set properly. We have multiple versions of Oracle on the same Unix box. Cherie Psycharis

Re: Vendor Package Implementation Strategy

Lisa, We have just been upgrading the majority of our applications that run on Oracle from 7.3.4 to 8.1.5. Some of the apps do not run on 8.1.5 or are not certified. Our solution has been to leave some apps where they are on 7.3.4, have some at 8.0.4 and some at 8.1.5. In other words, we have

Re: On-Call - terms, conidtions and perks!

Sean, This reply sounds different from the others but I thought I would throw it out for comparison. I am a full-time employee at a smallish company. When I was hired, part of the job description was to be on-call. We went over the specifics in some detail before I signed on for the job.

Fantastic Information on Sun Semaphores

My sys admin found the following document on a Sun Bulletin Board. It is by far the most comprehensive writeup I've seen on the topic. File this one away. It'll come in helpful sometime. Enjoy, Cherie Machler Gelco Information Network INFODOC ID: 2270 SYNOPSIS: Understanding semaphores,

Re: Beta program opportunity

Rachael, I looked at the requirements for this tool on their web site. I am a bit confused. Will the server run on 8.1.5 or does it require 8.1.7? Perhaps you know off the top of your head. Thanks, Cherie Machler Gelco Information Network "Rachel Carmichael" [EMAIL PROTECTED] on

Re: IP change and TNS Names, etc.

John, Yes, you can use hostnames in your tnsnames.ora file instead of IP addresses. We are doing so with Oracle 7.3.4 on Sun Solaris 2.6. As long as your DNS is resolving the host names to the IP addresses correctly, you should have no problem. Cherie Machler Gelco Information Network

What is limit on Search Condition in DBA_CONSTRAINTS table

One of our developers is wondering why they can't see all of their check constraint options when they query from DBA_CONSTRAINTS, USER_CONSTRAINTS, ALL_CONSTRAINTS. The Search Condition column only shows about 60 characters, no matter what you set your output string to in SQL*Plus. How can we

What database can I migrate to for Des/2000?

I have a 7.3.4 Oracle database (called CASE) on my Sun Solaris 2.6 operating system that contains my Des/2000 R2.1 repository. I'd like to migrate the 7.3.4 CASE database to 8.1.5. My question is this: Can the Designer/2000 R2.1 repository be hosted in an 8.1.5 database? If yes, do I have to

Re: write error

Is the output file larger than 1 Gig? Do you have an upper limit on your file sizes? Cherie -- 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

Translation Re: Stefan Barth/GrundOrg/Fraspa ist

Jared, I guess that now you have to start screening your mail for the word vac*tion in other languages as well. ; ) Cherie Machler [EMAIL PROTECTED] on 03/10/2001 05:20:20 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc:

How do I migrate 7.3.4 database that supports Des/2000?

I am migrating a 7.3.4 database to 8.1.5 on Sun Solaris 2.6. This database holds the repository for Des/2000. We do not want to upgrade Des/2000. I basically just want to migrate the underlying database. Can I do this? I've read through all of the documentation for Des/2000 but it all

Why can't I find bug 909635 ?

I have an error on an 8.1.5 export/import. Metalink shows a reference to bug 909635. When I search the bug database putting the bug number 909635 in the bug number field and pressing search, the search engine replies that there were no hits. How can this be? If a bug is identified in the

Is terminal release of 8.0.x still supported?

We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal

Why can't I see any Application Systems in my Des 2000 Popup Window?

I just migrated my database that supports Des/2000 version 2.1 from 7.3.4 to 8.1.5. I did not upgrade Designer and don't plan to at this time. Due to lack of any specific documentation anywhere on how to migrate this database, I simply created a brand new database of the same name on a

Re:OT: RANT ABOUT OCP, Re: Small help

Dick/Lee/Joe, I'm not trying to defend him but unless I have not yet recieved a post in my mail, Xing never said he had an OCP. Plus, Lee, I think you may need to define "silver bullet". It probably doesn't translate for people who don't use English as a second language. Cherie Machler

RE: OT -- # tables in your db (was: Slow database)

Lisa, No we did not. It's still there. It's a ridiculous design but it was there when I got here and it's not going away anytime soon. Cherie Machler Gelco Information Network "Koivu, Lisa" [EMAIL PROTECTED] on 03/29/2001 06:58:20 PM To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED],

Re: Upgrade from 8.0.6 to 8.1.7

Pallav, There is very explicit documentation for upgrading from 8.0.x to 8.1.x in the Migration Guide of the 8.1.7 server documentation set. You can see that documentation at technet.oracle.com. You need to be a registered user to login to that site but it's free to become registered and it

RE: How can I tell if an index is a function-based index/

Jack, Thanks for your helpful reply. Looks like my index is not function-based. Darn! Now I don't know why I'm getting this error and Metalink won't let me in to update my TAR. Cherie

Re: Exp/imp into different version

Connie, Yes it is. As a matter of fact it is part of a documented upgrade method outline in the Server Migration Guide. Cherie Machler Gelco Information Network

Need fragmentation reports

We're trying to determine which partitioned tables are good candidates for reorganization due to fragmentation. Anybody got any good scripts that would detect various kinds of fragmentation. Perhaps someone could point me in the direction of some on various web sites? Thanks in advance for

Should each partition have it's own tablespace and datafile?

We have a 120 Gig datawarehouse that uses more than 100 date-based partitions. For financial and political reasons, we have run out of disk space to give this database as it continues in it's relentless growth. The developers have resigned themselves to purge out some of the old data and get

Dropping partitions with data versus empty

Anyone have any problems dropping partitions that hold data? We are debating the risk involved in dropping populated partitions as opposed to purging the data out of them first and then dropping them (a lot of work). Theoretically, this should work o.k. but has anybody actually had problems

RE: Dropping partitions with data versus empty

Jun, Thanks for your reply. We are considering truncating the partitions first. Our main issue is recoverability. Not so much if we can't recover a partition that we want to get rid of but rather if we accidentally truncate a partition that we want to keep. Just trying to cover all our

Re: Dropping partitions with data versus empty

Stephane, Thanks for your reply. We are considering truncating the partitions first. Our main issue is recoverability. Not so much if we can't recover a partition that we want to get rid of but rather if we accidentally truncate a partition that we want to keep. Just trying to cover all

How does dropping a partition affect the rest of the table?

I've looked through the on-line documentation on dropping partitions but I have not seen the following question specifically addressed: How does dropping a date-range partition affect the rest of the table/partitions? I read that if I drop a partition with a global partitioned index that the

Re: How does dropping a partition affect the rest of the table?

Gregory, However, if I have a locally partitioned index, the impact on indexes should be minimized. I believe that I should only have to rebuild the index on the next highest partition. The remainder of the local index partitions should be unaffected. Am I correct in my understanding of the

Re: Urgent - Migration

Gilberto, We got very similar errors when upgrading from 8.0.4 to 8.1.5 and then to 8.1.7. In both cases, we opened a TAR with Oracle and they asked us to turn off the star_transformation_enabled init.ora parameter as a workaround. We did and it made our errors go away. However, this is not

Re: How does dropping a partition affect the rest of the table?

Stephane, Thanks for your reply. Cherie paquette stephane

Why do I still see index partitions when I dropped the underlying table

This one's got me stumped. We are on 8.0.4 on Sun Solaris 2.6. I have some locally indexed partitions on a table that's partitioned by time. I dropped the '96 and '95 partitions of the underlying table and I no longer see them. I used the following statements: alter table xx truncate

Can I partition my primary key constraint index?

Oracle will automatically create an index for your primary key constraint. I have a lot of large partitioned tables in my data warehouse. All of my primary key indexes are non-partitioned. I would like them to be partitioned. When I drop the constraint and re-enable it, can I specify at that

Re: Why do I still see index partitions when I dropped the

Ron, Thanks for your kind reply. I'll give it a try. Cherie Ron Rogers

Re: Goldilocks repost, please?

For what it's worth, we use 128k, 4m, and 128m. Those numbers were taken from the paper How to Stop Defragmenting and Start Living. Can't remember the author but I'm sure someone will chime in as it's a well-known paper. Cherie Machler Oracle DBA Gelco Information Network

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

Connor, What version of Oracle was this coded for? Thanks, Cherie Connor

RE: But I *want* to use RBO!

Last I saw, version 9.0.1.x is scheduled to be desupported in June of '03. I haven't seen any desupport date for Rev2 of 9i which is 9.2.0.1. We've upgraded from 9.0.1 to 9.2.0 in order to avoid any issues with desupport before we even get our product to market which we've been developing on 9i.

When is the next patchset for 9.2.0.1 coming out?

Gene, What patchsets are currently available for 9iR2 (9.2.0.1)? I'm not aware that any are available. Does anyone know when the next patchset is expected to be released for 9.2.0.1? Thanks, Cherie Machler Oracle DBA Gelco Information Network

How to use pipe-delimited SQL*Plus output with a long datatype

One of our developers wants to create a reusable report where the pipe-delimited output generated by SQL*Plus would be sent off and used as input into another process. The problem is the remarks field which is of type long. It causes ORA-00997 errors. If I take the pipe-delimits off, the

Re: How to use pipe-delimited SQL*Plus output with a long datatype

Thanks to those who recommended the relatively new set colsep command. It did work in this report. Thanks again, Cherie Machler Oracle DBA Gelco Information Network

Creating sequences on the DUAL table?

I have a request from one of our developers to create two new sequences on the DUAL table. This seems like a bad idea to me. I've never had such a request in the past. I asked for clarification on why this is needed and I didn't get a lot of details yet. Is this something that is standard

RE: Creating sequences on the DUAL table?

Dan, Haven't heard the why yet but I think it may be just a poorly worded request. I suspect he wants the sequences created on another table and just wants to be able to select from dual. Maybe he never realized that the sequences were actually created on another table.Maybe he actually

RE: Creating sequences on the DUAL table?

Kevin, Thanks for the suggestion on select statements. I will pass them on. I think it's just a misunderstanding on his part as to where the sequences are actually created. Apparently he only uses them in a select from dual so he thinks they reside there. Cherie

RE: Creating sequences on the DUAL table?

Mladen, Thanks for everyone's response on this. I think that this is just a misperception on the part of the developer. I took the phrase verbatim from his change request. I suspect that he has only ever used sequences in the SELECT from DUAL statement so he thinks that they are actual

RE: SOME SOLUTIONS!

Dennis, The sales critter could give better pricing for Leccotech's SQL*Expert. For a SWAG I believe it's less than a $1000 per seat and I believe that is sold with a per-database component to the pricing. I think there are also discounts when you buy more copies. It was well worth what we

Is port 1575 the standard for any Oracle product?

Is port 1575 the standard port number for any particular Oracle product? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: dbms_utility and dbms_stat difference

Barbara, I can't speak for dbms_utility but dbms_stats is supposed to generate statistics at both the partition level and at the table level for partitioned tables, which analyze does not do. These are supposed to be better quality statistics. Be aware that there are bugs related to

Rerunning CSSCAN character set scan utility on same database

With the end-goal of doing a character set conversion from US7ASCII to UTF8, I have run csminst.sql to create work tables and then run the CSSCAN utility from rdbms/admin on my test database. We have written a C program to identify and alter exceptional characters identified by the CSSCAN

Re: Another Character Set Problem

Scott, You can only use the alter database command to move from one character set that is a strict superset of your current character set. You can find lists of superset relationships on Metalink. Search on something like character set conversion and superset or UTF8 and WE8ISO8859P1. You

Re: * Oracle 11i DBA position in Wisconsin..

Baraboo is in a fairly rural area more than an hour from Madison or from Milwaukee. Neither of those cities are a vast metropolis. Not everyone is keen to live in the country. Plus I would imagine that a DBA job in this part of the country wouldn't pay a massive salary. However, the cost of

RE: Another Character Set Problem

The utility is called csscan for character set scan. It runs at the unix prompt with additional parameters (some optional and some not) much as export or import would. Before you use it the first time, you need to run csminst.sql from $ORACLE_HOME/rdbms/admin to set up the work tables, etc.

Outstanding bugs in 8.1.7.2

I've been hunting around OTN and can't remember where to find this. I'd like to see a list of all outstanding bugs that are present in version 8.1.7.2 of EE. Is there one convenient place to find these or am I going to have to compile a list from multiple other versions. Thanks, Cherie

RE: Outstanding bugs in 8.1.7.2

Is there anyway to download the readme file without downloading the whole product set for 8.1.7.3? Thanks, Cherie Jesse, Rich

RE: I/O EVENTS

Cary, Thanks for this meaty example and especially for the analysis afterwards. Real-life examples like this are so much more revealing and insightful than any amount of theoretical discussion. We could learn so much if once a month someone would post the statistics and output from their

Re: Statistical sampling and representative stats collection

Jack, What version are you on? Are you able to utilize the gather_stale option. That way you would not only be optimizing the amount you are estimating but the interval between analyzing. Of course, that option of DBMS_STATS is not available on older versions. Cherie Machler Oracle DBA

Re: Statistical sampling and representative stats collection

Jack, Isn't the problem with this concept that it doesn't take into consideration how skewed the data is? Statistically significance would be relevant to perfectly distributed data but wouldn't you need a higher percentage of data for significance in more highly skewed data? Just something

Re: Diagnose Slow System

Tim, I'm curious why you say that utlbstat/utlestat should be run from svrmgrl and not sqlplus. I've not heard/read that before. Cherie Machler Oracle DBA Gelco Information Network

Re: Legato oracle module.

Mike, We did create another RMAN catalog on a small alternate host. We back up our main catalog. Yes, it is redundant but if you're going to go to all the work of getting RMAN working, you might as well go the extra distance and do this so you're covered. Cherie Machler Oracle DBA Gelco

RE: Statistical sampling and representative stats collection

I have had some really good experiences with using histograms. They didn't always produce the improvements that I expected but in many cases, I saw 10 times, 100 times, or even 1,000 faster execution times after adding histograms. I don't have the specifics, but these were cases where the data

RE: Statistical sampling and representative stats collection

Larry, Thanks for taking the time to write this lengthy reply. I've never seen this particular information on histograms anywhere. This has been very informative. Cherie Machler Oracle DBA Gelco Information Network

Re: RMAN error registering database

Danny, Many RMAN errors will show a hit when searching Metalink. I found the following related document on Metalink when I searched with the RMAN-10031 error: fact: Oracle Enterprise Edtion 8.1.7 fact: Recovery Manager (RMAN) symptom: Unable to register a database

RE: partition tables

Jack, Thanks for these great hints. I have not seen lots of these before and they have given me lots of ideas. Here's a question that you've induced: How do you determine what a good value is for INITRANS? What are the downsides of setting it too high? Thanks, Cherie Machler Oracle DBA

Re: Partitions

Lee, I've been doing a lot of work with reorging partitioned tables and splitting them. I'm on Oracle version 8.0.4 and 2.6 of Sun Solaris. I don't believe that you need to unload your data. You should be able to create your new tablespaces to the correct size. I believe you plan on

Is this a good upgrade path from 8.0.4 to 8.1.7.2?

We are preparing to do an upgrade of our Data Warehouse on Sun Solaris from version 8.0.4.0.0 to 8.1.7.2. We've done a number of upgrades in the past but this is the first time we are going from 8.0.4 to 8.1.7. Following is the basic, high level plan: 1. Upgrade from 8.0.4 to 8.1.7.0 (Oracle

Re: Oracle DBA with 8i through 11i Experience Needed in Columbus,

Columbus, Ohio is not a real big market.I'm not sure what market rates are there but I would assume that they are not top of the line. Cherie Machler With in-laws that live in Columbus

Why is Parallel Query Running after upgrading to 8.1.7.2

I have just upgraded my 8.0.4 database to 8.1.7.2. Previously, parallel query would only run on objects that a DEGREE set 1. I just checked and all of my tables and indexes have DEGREE set to 1. So are most of my queries now running in parallel? I just checked my init.ora file and I haven't

Re: Why is Parallel Query Running after upgrading to 8.1.7.2

Tim, Thanks for replying on a weekend. After doing some reading, I discovered that parallel_threads_per_cpu is set to the default of 2 on our database. With 8 CPUs, we are seeing 16 parallel threads on these queries, when they do go to parallel (a few of them do not). I experimented with

Re: Nologging index tablespaces?

Dennis, We have set particular indexes to nologging when building them. These are indexes that we drop every night for our warehouse load. It is a hassle because whenever we clone this database to our QA box, those nologged indexes get corrupt and we have to rebuild them. Takes us three

Analyze running twice as long after upgrade to 8.1.7.2

We just upgraded our data warehouse from version 8.0.4 to version 8.1.7.2 of Oracle. We run on Sun Solaris 2.6 vith Veritas Quick I/O. We do an analyze compute nightly with a 10% estimate of our large, main fact table. Before the upgrade, the analyze ran for 45 minutes. Since the upgrade,

RE: Analyze running twice as long after upgrade to 8.1.7.2

Paula, Yes, it is a partitioned table. I am planning on switching over to analyzing it in parallel but first the application owners want to know WHY it's taking twice as long to analyze since the upgrade to 8.1.7.2. What is different about ANALYZE that would cause it to run so much longer.

RE: Analyze running twice as long after upgrade to 8.1.7.2

John, Thanks for this advice. I will try to get this data tonight on the updated version. We do not have the old version around anymore to try this out. Cherie

RE: Analyze running twice as long after upgrade to 8.1.7.2

Jack, Thanks for this insight. I'll check this out. We did not change our sort_area_size. However, I suspect there have been changes in the default method that Oracle is using sort_area_size. Perhaps I need to increase sort_area_size? I have a test database I can try it out on and see.

Re: Upgrade from 8.1.5 to 9.2

Igor, In the 9.2 upgrade manual, there should be a section in the front about preparing to upgrade and selecting your upgrade path.There should be a table that shows which versions you can upgrade from.Does that table list 8.1.5 as a supported version to migrate directly to 9.2? Cherie

Re: Urgent - Query Optimization

What version of Oracle and operating system/type are you using.Is this the Clarify help desk application? If it is Clarify, you can contact their support and open a case with them. They have some additional indexes, etc. that they recommend that helped us quite a bit with our Clarify

Should we upgrade from 9.0.1.2 to 9.2?

We have a couple of new applications in development that are moving to QA. These databases are currently running 9.0.1.2 on Sun Solaris 2.6. We've been pretty happy with this version to this point but are at a pivotal spot in our product development cycle where we have a narrow window in which

Re:Should we upgrade from 9.0.1.2 to 9.2?

Dick, Thanks for your comments. So, the bottom line is that you are recommending moving from 9.0.1.2 to 9.2? Cherie [EMAIL PROTECTED]

RE: Upgrade from 9.0.1.2 - NOPE!

Does anyone have the bug number on this security bug? Thanks, Cherie Machler Oracle DBA Gelco Information Network Connor

Re: Exporting stats for a production server to a dev/test server

Jack, Were your old statistics generated with the ANALYZE command? If yes, were you able to export ALL of the old statistics with the export option of DBMS_STATS before you actually analyzed with DBMS_STATS for the first time? If yes, after exporting them, did you delete the old statistics

OEM Intelligent Agent and port numbers - How can I assign/configure a port

We have a third-party application that needs to use the SNMP agent associated with OEM. They want to be able to get to it via a particular port. We have a port assigned to each database, based on which Oracle version it is running. However, as far as I know, there is not a particular port

Timed statistics and SQL_TRACE for already running session

I used the following syntax/package to run a trace on a user's already running session. EXECUTE dbms_system.set_sql_trace_in_session(8,12,TRUE); I then ran tkprof on the resulting trace file. It all worked fairly well but I didn't get any times on any of the statements that executed. Is

SQL tuning / optimization problem - IS NOT NULL - Clarify

I have been struggling with a SQL statement that is generated by a help desk application called Clarify. The code is all canned so I can't change it (well maybe the view if that's the only way). So far I have been tuning this application by adding indexes, histograms, etc. However, I've hit

Re: Timed statistics and SQL_TRACE for already running session

Jonathan, Version is 8.0.4. I looked at the parameters for dbms_system in the 8.0.4 documentation and saw nothing pertaining to timed_statistics. I did an alter system over lunch and set timed statistics for the entire database without bouncing the database. That did the trick. Thanks for

Re: Timed statistics and SQL_TRACE for already running session

Stephane, This sounds very clever. However, it's too much work for me today as I have so irons in the fire. I'll keep it in mind for the future, though. Thanks for taking time to reply. Cherie

RE: Converting Inner join in MS-SQL to Oracle SQL syntax

Thanks to Adrian Roe, Jon Walthour, and Rodd Holman for their helpful replies. The text that Jon provided worked perfectly. Scored big points with my users. Thanks for taking the time to help me out, Cherie Machler Oracle DBA Gelco Information Network

Re: Timed statistics and SQL_TRACE for already running session

Igor, Thanks for your reply. I decided to just turn it on for the whole database for a few minutes over lunch. Cherie Igor Neyman

RE: SQL tuning / optimization problem - IS NOT NULL - Clarify

Alex, I had achieved a full index scan before and was disappointed with the test results because it was showing a full scan on the index. However, after I got your email, I turned on timed_statistics and had the user do a real test for me on the test database and the actual times where

RE: auditing ... getting offending SQL ??

John, Who is the vendor for EZSQL? Do you have a web site for them? Thanks, Cherie Machler Oracle DBA Gelco Information Network John Lewis

RE: OT RE: How do you audit a DBA?

Joe, Having worked with Lisa for a short time, I can attest to the fact that she does bear somewhat of a resemblence to Laura Croft. However, don't look for her starring in an action movie any time soon. After all, she is gimping around : ) Cherie Machler Oracle DBA Gelco Information

No Subject

I am running tkprof and explain plan on the following SQL statement: SELECT DISTINCT CNFR_NO, SPLT_PAY_TYPE, ACH_AMT FROM whse_dbo.ACH_TRAN WHERE ACCT_NO = '46807' AND TRUNC(TRAN_DT) = TRUNC(TO_DATE('20-JUL-01','DD-MON-YY')) AND STATUS = '2' AND CNFR_NO 0 AND

Re: Tablespace layout

Don, By uniform extents, do you mean all extents in the same tablespace being the same size? Or do you mean having a choice of say three different sizes in on tablespace but sticking to those sizes? That seems to be the crux of the disagreement amongst our team. Thanks for your

RE: Tablespace layout

Lisa, I have a copy of the paper you refer to and have read it a couple of times. We've gone over this issue many times in our team but our other two DBAs remain unconvinced. Perhaps I need to actually give them a copy of the paper. As I said, the crux of the issue is whether we should only

RE: !! *Very* important Oracle-L message !!

I would let Bruce speak for himself but I have to assume that it would be a lot of work and hassle to set up a subscription and then deny access to those who have not paid. Is that true, Bruce. If so, perhaps we should all just voluntarily send in some money. $25 would be a drop in the bucket

Index full scan versus index range scan

-- 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

Fast Full Index Scan in 8.1.7

I had been using the FAST_FULL_SCAN_ENABLED initialization parameter in an 8.0.4 database. Apparently this parameter is now obsolete in 8.1.7.2. Seems as though I am getting the fast full index scans automatically now. I'm not sure if I want them in all cases. Is there a way to turn them

Do fast full index scans do physical disk reads?

I am confused by the output from tkprof below. An fast full index scan is being performed. However, from the statistics, it looks as thought 649 physical disk reads are being performed. Is that actually the case? Are physical disk reads being done? Thanks, Cherie Machler Oracle DBA

Re: Fast Full Index Scan in 8.1.7

I wanted to turn it off in testing so I could try some other indexes as an alternative. I'm not sure that I trust it to make a good decision. Even with an alternative index hint, it's not using the index I'm trying to get it to use, but rather the fast full index scan. I can't see any typo

RE: Do fast full index scans do physical disk reads?

Ian, The last one I looked at it was cached, I guess. I could purposely cache the table (and index) if it was small, though. I'm confused though. Isn't the whole benefit of the fast, full index scan that you don't have to go against the table, thereby avoiding those physical reads? Or, in

RE: Do fast full index scans do physical disk reads?

Ian, I'll look at compressing the index. Does that only work on unique indexes or can you do it on non-unique multi-column indexes as well? Thanks, Cherie

  1   2   3   >