RE: RE: db file sequential read [WAS:wait event puzzler]

y, June 12, 2003 7:29 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: db file sequential read [WAS:wait event puzzler] > > > he is talking about altering the column in the data > dictionary. Ive updated TS$ myself and its not that big of a deal. > > id be a bit

Re: RE: db file sequential read [WAS:wait event puzzler]

he is talking about altering the column in the data dictionary. Ive updated TS$ myself and its not that big of a deal. id be a bit concerned about actually altering a column. Oracle may have some underlying code that you dont know about that assumes a maximum column length = 30 or there is som

RE: Re: Rule Based Optimizer

I think Wolfgang did a presentation on the NBO recently, so you should ask him ;-) - Babette -Original Message- Hallas, John, Tech Dev Sent: Wednesday, June 11, 2003 10:25 AM To: Multiple recipients of list ORACLE-L No it was just BO - and it stunk -Original Message- Sent: 11

RE: RE: Rule Based Optimizer

RBO was the optimizer as far back as I can remember and that was V3. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, June 11, 2003 2:10 PM To: Multiple recipients of list ORACLE-L did oracle always use the RBO? or did it have some extremely sim

Re: RE: Rule Based Optimizer

did oracle always use the RBO? or did it have some extremely simplified optimizer prior to 6.0? i know some of you haev been around a while... hopefully this doesnt make you feel old. no real need to know. just curious how the technology has progressed over time. > > From: "Mercadante, Thomas

RE: Re: Rule Based Optimizer

No it was just BO - and it stunk -Original Message- Sent: 11 June 2003 14:20 To: Multiple recipients of list ORACLE-L Perhaps MBO (Mood Based Optimizer)! - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 11, 2003 7

Re: Re: Rule Based Optimizer

Perhaps MBO (Mood Based Optimizer)! - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 11, 2003 7:39 AM Subject: Re: Re: Rule Based Optimizer what did oracle use before the RBO? > > From:

Re: Re: Rule Based Optimizer

what did oracle use before the RBO? > > From: Mogens Nørgaard <[EMAIL PROTECTED]> > Date: 2003/06/11 Wed AM 12:39:20 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Rule Based Optimizer > > Yep. Here's the official statement from Oracle about RBO in 10i: > > "T

RE: RE: anyone have any soundex scripts?

Try the Levenshtein Distance algorithm. If you scroll to the bottom of the page you will see a PL/SQL implementation. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > yes, Im familiar with that function. but you have to write a > soundex algorithm in order to

RE: RE: anyone have any soundex scripts?

into the SOUNDEX function to make it tell the difference between 301 Fof Lane 301 Faf Lane > > From: "Seefelt, Beth" <[EMAIL PROTECTED]> > Date: 2003/06/09 Mon AM 11:04:53 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE

RE: RE: anyone have any soundex scripts?

; To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: anyone have any soundex scripts? > > > What advanced functionality are you looking for? > > -Original Message- > Sent: Monday, June 09, 2003 10:29 AM > To: Multiple recipients of

RE: RE: anyone have any soundex scripts?

Mon AM 11:04:53 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: anyone have any soundex scripts? > > > What advanced functionality are you looking for? > > -Original Message- > Sent: Monday, June 09, 2003 10:29 AM >

RE: RE: anyone have any soundex scripts?

Soundex essentially takes a single word and produces a value which can be compared to a similar value, to determine if the words are logically equivalent, mostly by paying attention to consonants. PROD> select soundex('Fairfield') from dual 2 / F614 1* select soundex('Faerfield') from dual P

RE: RE: anyone have any soundex scripts?

What advanced functionality are you looking for? -Original Message- Sent: Monday, June 09, 2003 10:29 AM To: Multiple recipients of list ORACLE-L yes, Im familiar with that function. but you have to write a soundex algorithm in order to get advanced functionality. I wouldnt even know wh

Re: RE: anyone have any soundex scripts?

yes, Im familiar with that function. but you have to write a soundex algorithm in order to get advanced functionality. I wouldnt even know where to start with something like that. Im hoping there is one on the web some where. > > From: "Seefelt, Beth" <[EMAIL PROTECTED]> > Date: 2003/06/09 Mo

Re: RE: query run time vs IN list elements

scratch my last email. I wasnt thinking straight. I was thinking of something else. Jerome is right. 'IN' is faster when the cost of the sub-query is small. Exists is faster when the cost of the result set is high. sorry about that. my last post is incorrect. > > From: "Whittle Jerome Contr NC

RE: Re[2]: performance questions

One answer is: Queueing theory. It's Chapter 9 of "Optimizing Oracle Performance," if I can ever finish it. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Reykjavik, Ottawa, Dallas, Washington, Denver, Sydney - Visit www.hotsos.com for schedu

Re: Re: Snapshot too old during stress test... how to avoid

nope. My process is rather simple. A flag comes in... either we do a create table as, drop the old table, and create the indexes based on the data in the stage tablespace or, we do insert select Commit; update commit; delete commit; The snapshot too old is occuring during the process of creat

RE: Re: Snapshot too old during stress test... how to avoid

AIL PROTECTED]> Sent by: rootcc: Subject: Re: Re: Snapshot too old during stress test... how to avoid 06/05/2003 08:31

RE: Re: Snapshot too old during stress test... how to avoid

; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 05 June 2003 18:40 > To: Multiple recipients of list ORACLE-L > Subject: Re: Re: Snapshot too old during stress test... how to avoid > > > nope. My process is rather simple. > > A flag comes in... either we do a cr

RE: Re: Snapshot too old during stress test... how to avoid

2003/06/05 Thu AM 10:09:52 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Re: Snapshot too old during stress test... how to avoid > > Snapshot Too Old Maybe caused bcos of Delayed Block Cleanout Problems. > Now this Bock was updated an Hour ago and

RE: Re: Snapshot too old during stress test... how to avoid

Snapshot Too Old Maybe caused bcos of Delayed Block Cleanout Problems. Now this Bock was updated an Hour ago and u are now selecting it.. It finds that there are ITL Entries in there and oracle wants to see if the Transaction has been commited. He Goes back to the Transaction Table of the RBS Poi

RE: Re: Snapshot too old during stress test... how to avoid

and Im not updating the data dictionary. > > From: "Ganesh Raja" <[EMAIL PROTECTED]> > Date: 2003/06/05 Thu AM 10:09:52 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Re: Snapshot too old during stress test... how to avoid >

Re: Re: Snapshot too old during stress test... how to avoid

ORACLE-L <[EMAIL PROTECTED]> Sent by: rootcc: Subject: Re: Re: Snapshot too old during stress test... how to

RE: Re[2]: performance questions

Title: RE: Re[2]: performance questions Mark, I do not think this thread is OT ... this is till very much on topic. I have been gaining so many views on SLA ... I love this topic. Raj Rajendra dot Jamadagni at

Re: Re: Snapshot too old during stress test... how to avoid

why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some

Re: Re[2]: performance questions

Jonathan, Your comment "this is probably harder than it sounds" should be reworded to "this IS harder than it sounds". I've been involved in these bumfights before and they are never pleasant, especially when a contract of significant question is on the line (like a $3m / month performance bonus

RE: RE: Schedule Analyze using DBMS_STATS ???

There are a Lot of options to DBMS_STATS .. And be Judicious in using the same. Read the docs before attempting it. BTW .. What is the session waiting for .. Just Check v$session_wait. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 ===

Re: Re: question about large pool (now NetApp)

thanks for your excellent responses. I guess striping doesnt help with netapps. I was finding alot of waits for redo logs, full table scans, and index reads. However, I guess I have to live with it with the netapps. I believe we have a 1GB pipe. Does it matter if I put my indexes in seperate da

RE: RE: Schedule Analyze using DBMS_STATS ???

Hi all, Everyone is recommending DBMS_STATS to be used for computing the statistics. But even after specifying the parallel option , DBMS_STATS is taking lots of time ! in comparison to Analyze... In case of tables with a million records the query just hangs when i use the

RE: Re: question about large pool

To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Re: question about large pool My experience with NetApp says that it is easy to clog up your bandwidth to the device. I would worry more about that issue and finding just how much thr

RE: RE: Schedule Analyze using DBMS_STATS ???

DBMS_STATS is quicker because it can run in parallel mode. Analyze cannot. (B (B-Original Message- (BSent: Tuesday, June 03, 2003 11:25 AM (BTo: Multiple recipients of list ORACLE-L (B (B (BSorry JP, I should have clarified that DBMS_STATS is the way to go, when on (Ba 9i or above

RE: Re: question about large pool

nts of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Re: question about large pool My experience with NetApp says that it is easy to clog up your bandwidth to the device. I would worry more about that issue and finding just how much throughput you could get to th

RE: RE: Schedule Analyze using DBMS_STATS ???

JP, After you've initially created statistics and set the tables into monitoring mode this script will create a DBMS_JOB that keeps them up to date each morning: set serverout on size 10 prompt "Connecting to SYS" connect sys@&_dbname grant select on dba_tab_modifications to system;

RE: Re: question about large pool

My experience with NetApp says that it is easy to clog up your bandwidth to the device. I would worry more about that issue and finding just how much throughput you could get to the device. Usually the DBWR tuning is for the situation where you have lots of devices with separate paths to those devi

RE: RE: Schedule Analyze using DBMS_STATS ???

Sorry JP, I should have clarified that DBMS_STATS is the way to go, when on a 9i or above release. One of the simple factors being that ANALYZE is being deprecated.. There seemed to be a number of bugs/quirks, whatever you want to call them, in certain 8.1.x versions, which are now fixed within 9i.

Re: Re: question about large pool

Not sure what you mean by "I/O points". Whether or not multiple DB writer will be of benefit to you depends on a couple things. First of all, can you use async IO? I don't see any mention of what platform you are on. If you're using Windoze, it is async IO by default. Async IO is generally a

Re: RE: Schedule Analyze using DBMS_STATS ???

Thanx a lot Mark. Sure , your code has given me a starting point. let me change accordingly to use DBMS_STATSe and give a try :-) So,can i conclude that DBMS_STATS is better than ANALYZE ?! Someone over the list mentioned that DBMS_STATS is slower. is it so ? What is your opinion regarding this ?

Re: RE: IN or Exists --- performance issue

http://asktom.oracle.com/pls/ask/f?p=4950:8:247354401321242398::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:953229842074, that will give you a detailed explanation > > From: "Stephane Faroult" <[EMAIL PROTECTED]> > Date: 2003/06/03 Tue AM 09:01:28 EDT > To: Multiple recipients of list ORACLE-L <[EMA

Re: Re: question about large pool

you only want DBWR_IO_SLAVES or multiple DBWRn if you have datafiles spread over multiple I/O points correct? We are using 'Network Appliance' hard disk array that Im not all that familiar with. It looks like we have 3 I/O points and 5 mount points. my boss told me that striping data files and r

RE: RE: question about large pool

Nope, it's not accurate. PGA areas for shared server sessions are also allocated from the large pool. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 02, 2003 4:35 PM To: Multiple recipients of list ORACLE-L for some reason w

RE: RE: question about large pool

>From the doc: LARGE_POOL_SIZE lets you specify the size (in bytes) of the large pool allocation heap. The large pool allocation heap is used in shared server systems for session memory, by parallel execution for message buffers, and by backup processes for disk I/O buffers. (Parallel execution al

RE: RE: question about large pool

That is pretty much my understanding. Here is a Web page that explains it pretty well: http://www.interealm.com/roby/technotes/tnlargepool.html Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 02, 2003 3:35 PM To: Multiple r

Re: RE: question about large pool

for some reason we have 100MB large pool. I dont think we need it at all. I read that its only used by RMAN or Parallel server. Is that accurate? > > From: DENNIS WILLIAMS <[EMAIL PROTECTED]> > Date: 2003/06/02 Mon PM 03:39:42 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >

Re: RE: Need help

to get a speed advantage from dbms_stats in parallel do you have to the tablespace and/or segments broken up over several mount points? > > From: "Jankovic, Djordje" <[EMAIL PROTECTED]> > Date: 2003/06/02 Mon PM 02:34:41 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subjec

Re: RE: Function Based Index - Not Used ???

Cary, I will be first one to get a copy of the book. And now this is my turn to request Tim ;) Book! Book! Book! Jp. 2003/06/02 18:54:38, "Cary Millsap" <[EMAIL PROTECTED]> wrote: >To clarify my "Book! Book! Book! :)"... >This is my request for Tim to write [another] one. > >Cary Millsap --

Re: RE: Oracle 11i new features

Better still!! Maybe they will call everything (database/iAS/JDeveloper/IDS) 11i :) Cyril On Sat, 31 May 2003 John Kanagaraj wrote : >Nope! - Oracle 10i will be the end of the world (as Oracle knows >it at least >:) since we already have an Oracle 11i (aka Oracle Applications >11i - but >gen

RE: RE: Tablespace management.

I USA > -Original Message- > From: Wolfgang Breitling [mailto:[EMAIL PROTECTED] > Sent: Friday, May 30, 2003 4:00 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: Tablespace management. > > > To quote the paper: > > "Oracle supports an unlim

RE: RE: Tablespace management.

To quote the paper: "Oracle supports an unlimited number of extents in a segment. The performance for DML operations is largely independent of the number of extents in the segment. However, certain DDL operations such as dropping and truncating of segments are sensitive to the number of extents.

RE: RE: Tablespace management.

ROTECTED] > Sent: Friday, May 30, 2003 1:15 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: Tablespace management. > > > What Oracle documentation would that be? > > At 09:39 AM 5/30/2003 -0800, you wrote: > >i read some oracle documentation that re

Re: RE: Tablespace management.

What Oracle documentation would that be? At 09:39 AM 5/30/2003 -0800, you wrote: i read some oracle documentation that recommends you keep the number of extents below 1024. do you feel that this is inaccurate in an LMT? What if Im stuck with dictionary tablespacse and am not allowed to change?

Re: RE: Tablespace management.

i read some oracle documentation that recommends you keep the number of extents below 1024. do you feel that this is inaccurate in an LMT? What if Im stuck with dictionary tablespacse and am not allowed to change? Does it matter? I do keep all my extents uniform. I thought there were issuse wit

RE: RE: Function Based Index - Not Used ???

olumn "AGE" whose value cannot not be found from the index. Regards Naveen > -Original Message- > From: Prem Khanna J [mailto:[EMAIL PROTECTED] > Sent: Friday, May 30, 2003 8:45 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: Function Based Ind

Re: RE: Function Based Index - Not Used ???

John, I tried it with COMPATIBLE=8.1.6. no nulls in that particular column but it's the same again. As Tim pointed out, CARD=262146 --> as per the EXPLAIN PLAN for SELECT w/o HINT. the SELECT retuens about 2.5 million rows. which is why it goes for a FTS than a Index scan is my understanding corr

Re: RE: Which method is more efficient

how would you do that? if you dont know which columns have changed values? you would have to compare every column? how else can you do it? > > From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]> > Date: 2003/05/29 Thu PM 01:24:43 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > S

RE: RE: Which method is more efficient

recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: Which method is more efficient > > Yes, I am in archive log mode and I have had 2 occurances of filling up the > archive log filesystem, but I don't want to change one problem for another. > > Bryan

RE: RE: Which method is more efficient

, Bryan" <[EMAIL PROTECTED]> > Date: 2003/05/28 Wed PM 02:40:25 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: Which method is more efficient > > The fields that are changed are determined by > 1) A loop would start until all r

Re: Re: Which method is more efficient

oh it wasnt none, it was cut in half. I skimmed it. my bad > From: Richard Foote <[EMAIL PROTECTED]> > Date: 2003/05/29 Thu AM 08:45:46 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Which method is more efficient > > > - Original Message - > To: "M

Re: Re: Which method is more efficient

so GTT's help reducing redo when you do inserts and deletes? but not for deletes? there was a post by tom kyte on dejanews from a few years back where someone asked the redo question and he recommended GTTs. here is the link... did I misread it? http://groups.google.com/groups?hl=en&lr=&ie=UTF-

RE: RE: Which method is more efficient

Title: RE: RE: Which method is more efficient And with CTAS you can specify nologging to minimize redo generation. "Cloning" a table, renaming/dropping the source, and renaming the clone to the production table could be interesting. You would have to recreate indexes. ---

RE: RE: Which method is more efficient

Title: RE: RE: Which method is more efficient Bryan, Can you ... create table my_work_table as select * from changed_parts_table minus select * from existing_parts_table / The result will give you all the rows where _something_ is different between your existing table and changed table

RE: RE: Which method is more efficient

? > > From: "Rodrigues, Bryan" <[EMAIL PROTECTED]> > Date: 2003/05/28 Wed PM 02:40:25 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: Which method is more efficient > > The fields that are changed are determined by > 1)

RE: RE: Which method is more efficient

The fields that are changed are determined by 1) A loop would start until all records in parts change table are done 2) Select a part record from the part changes table 3) Select the same part from the existing part table 4) Compare the value in the parts changes table against the corresponding fi

Re: RE: Which method is more efficient

oh i missed part of it. the question is how do you figure out which fields have changed? if you have to do an anti-join on each field, then do an update of every field. the question is how will you determine which fields have changed? > > From: DENNIS WILLIAMS <[EMAIL PROTECTED]> > Date: 2003

RE: Re: Is there an Oracle 9i on 32-bit ??

>64 is a bigger number than 32. Therefor the human >mind tends to like it >better. Man, I can't wait for the 512-bit OS'es. >The Law Of Bigger >Numbers (LOB-N) applies everywhere you go. This is >just one LOB. There >are other LOBs. LOB-D (Law Of Bigger Dudes), LOB-S >(Law Of Bigger >Salary), L

Re: Re: thanks all/OCP

Hi, I am sorry if I sounded discouraging. That wasnt the idea. anyway if the idea or point was missed I guess it is not anyway worth labouring on it :) Best Regards Cyril On Wed, 28 May 2003 Joan Hsieh wrote : >Cyril, > >we need some encouragements on those who has the experiences and >al

Re: RE: ocp discount

Yes, that's it.   Shamita Singh AK <[EMAIL PROTECTED]> wrote: is it OTN20 ?   -ak - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Tuesday, May 27, 2003 11:01 AM Subject: RE: RE: ocp discount when you signed up with technet there

Re: RE: ocp discount

Title: RE: RE: ocp discount is it OTN20 ?   -ak - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Tuesday, May 27, 2003 11:01 AM Subject: RE: RE: ocp discount when you signed up with technet there should have been an

RE: RE: ocp discount

When you signed up for the exam, there was a question as to whether you had any discount codes. It is the same screen that asks if you are an Oracle employee. If you enter the code on that screen, then you receive the discount. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: RE: ocp discount

OTN20 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 27 May 2003 10:01:44 -0800 when you signed up with technet there should have been an announcement or a splash screen that gave you a discount code... you have to type that in when you register

RE: RE: ocp discount

Title: RE: RE: ocp discount when you signed up with technet there should have been an announcement or a splash screen that gave you a discount code... you have to type that in when you register for the tests.  Don't remember what the code was, off hand, but I remember it was delivered i

Re: RE: ocp discount

im registered with technet and when i signed up to take my tests with prometric? I was charged the same $125/test? > > From: April Wells <[EMAIL PROTECTED]> > Date: 2003/05/27 Tue PM 01:04:44 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: ocp discount > > > y

Re: RE: Oracle, IBM fight of whose DB is more manageable

there are also stupid ones too. I was pointed to a study on a Sybase usenet where they said sybase was 1000% faster than Oracle when you have 250 users and something like 1TB of data. They contacted oracle and oracle told them to use shared server. The sybase guys thought Oracle was pulling the

RE: Re: Sizing - RAC, storage subsystem EMC

> -Original Message- > > Can someone please suggest if it is a basic database design > flaw which leads to the requirement of such costly technologies > like RAC in the first place? > (I mean if the dataset is huge why not use transportable > tablespaces > and keep 'regularly purging' t

Re: RE: Autoallocate vs Uniform extent performance

Hi Jonathan, OK let's give it a go (note that I'm now doing this at home on my not quite so powerful PC with Best of Bowie playing on the CD so it's just me having a play) SQL> create tablespace biggish 2 datafile 'c:\bowie\biggish01.dbf' size 3000m 3 uniform size 24k; Tablespace created.

Re: RE: Autoallocate vs Uniform extent performance

I think you ought to refine your test: Create two tables at one extent each, then alternately allocate one extent to each table until you get to a very large number of extents. THEN try dropping one of them. Remember to set tablespace quotas for the user creating the table. It still won't sca

Re: RE: Autoallocate vs Uniform extent performance

I count that as 127 thousand extents dropped in 6seconds. The CREATE TABLE + EXTENTS took 49seconds. No, I am not trying to draw any conclusions, just making an observation. I am comfortable with thousands of extents but wouldn't look at a million extents. Hemant At 12:23 AM 04-04-03 -0800, you wro

Re: RE: Autoallocate vs Uniform extent performance

Hi Pete, Stop using my favourite answer :) I'm not suggesting this is particularly scientific but here's a quick test on dropping a moderate number of extents (9.2 on XP): SQL> create tablespace biggish 2 datafile 'c:\bowie\biggish01.dbf' size 2000M 3 uniform size 16K; Tablespace created.

Re: RE: how to find INDEX CORRUPTION ???

Have you analyzed table msg_history with cascade structure option? do you find any message in alert_log for any possible corruption. You index is b-tree index as per syntax Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed,

Re: RE: how to find INDEX CORRUPTION ???

Thans Rafiq. The degree for the table is 1. SQL > create index idx_mh_frommemno on msg_history ( frommemno ); this is what i did ? either it's a bitmap or b-tree on this column (only) , it results in ORA-600. i wonder why it happens so ?! any clue !! thanx once again. Jp. 2003/04/03 5:54:54

Re: RE: ORA-03001: unimplemented feature -- When creating BLOB ?

Thanx a lot Andrei. Thanks everybody. the tablespace had SEGMENT SPACE MANAGEMENT AUTO. that was the problem. i can proceed now . Regards, Prem Khanna J. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Servic

Re: RE: ORA-03001: unimplemented feature -- When creating BLOB ?

Thanx a lot Andrei. Thanks everybody. the tablespace had SEGMENT SPACE MANAGEMENT AUTO. that was the problem. i can proceed now . Regards, Prem Khanna J. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Servic

RE: RE: Locally Managed Tablespaces

Jared I'm with you on this one. I switched our production tablespaces (except system) to autoextend several years ago and couldn't be happier. I used to scrupulously check the free space in tablespaces, but over the years, being a solo DBA, as more instances were added, this took longer and long

Re: RE: Locally Managed Tablespaces

AUTOEXTEND can be abused for sure, but it can also be a big time saver. Say you want to load 100 gigabytes of data, and you have 5 disks to spread it out on. You opt for 5 files of 4 gig each on each disk. That gives you 20 files to create in your tablespace. Creating 100 gig of datafiles tak

RE: RE: Locally Managed Tablespaces

Title: RE: RE: Locally Managed Tablespaces Well, my first suggestion would be to buy a software package from a reputable software company that lets you predict object growth and an estimate of when your tablespace will be full. Contact me for more details. :) But seriously, you can write a

Re: RE: Locally Managed Tablespaces

I knew I'd forget something :) it's been a while since I worked on 7.3 thanks! --- Jonathan Lewis <[EMAIL PROTECTED]> wrote: > > For 7.3 it is also important to set MINIMUM EXTENT > for the tablespace to match the initial and next - then > every extent has to be at worst a multiple of the min

RE: RE: Locally Managed Tablespaces

Title: RE: RE: Locally Managed Tablespaces I think minimum extent was a new parameter in 8.0. > -Original Message- > From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] > > For 7.3 it is also important to set MINIMUM EXTENT > for the tablespace to match the initial

Re: RE: Locally Managed Tablespaces

ECTED] > 03/21/2003 11:00 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: RE: Locally Managed Tablespaces > > > > -Original Message- > > Fr

RE: RE: Locally Managed Tablespaces

Title: RE: RE: Locally Managed Tablespaces > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > I think my 'reasonable' # of extents must be higher than > yours Jacques. :) I agree that having a datafile autoextend is better than

Re: RE: Locally Managed Tablespaces

For 7.3 it is also important to set MINIMUM EXTENT for the tablespace to match the initial and next - then every extent has to be at worst a multiple of the minimum extent size whatever a rogue user does. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk For one-day tutorials: (see http://ww

RE: RE: Locally Managed Tablespaces

gt; Sent by: [EMAIL PROTECTED] 03/21/2003 11:00 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: RE: Locally Managed Tablespaces > -Original Message- > From: [EMAIL PROTECTED] [ma

Re: RE: Locally Managed Tablespaces

pctincrease=0 and set the storage parameters at the tablespace level and do NOT put storage parameters on the individual objects. you can "fake" the workings (without the bitmap!) of an LMT by doing that. Next extent=initial extent, pctincrease=0 will effectively allocate extents of equal sizes

RE: RE: Locally Managed Tablespaces

Title: RE: RE: Locally Managed Tablespaces > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > thanks in case I happen to work on a 7.3 database > > what kind of pctincrease should I set? What about the other > settings? Just cu

Re: RE: Locally Managed Tablespaces

thanks in case I happen to work on a 7.3 database what kind of pctincrease should I set? What about the other settings? Just curious. Ryan > > From: "BALA,PRAKASH (HP-USA,ex1)" <[EMAIL PROTECTED]> > Date: 2003/03/21 Fri PM 12:54:41 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROT

RE: RE: Value of OCP

  OK, done with OT.   -Original Message-From: Jeremy Pulcifer [mailto:[EMAIL PROTECTED]Sent: Thursday, March 20, 2003 11:04 AMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: Value of OCP If the ladies can't find you handsome, at least let them find you handy!

RE: RE: Value of OCP

Title: RE: RE: Value of OCP You sure that isn't spackle you are talking about?  Oracle OCP DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 20, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Value o

RE: RE: Value of OCP

remind me to tell you about my glue-gun related accident.. never ever try to brush the hot glue off your hand! --- [EMAIL PROTECTED] wrote: > Personally I like the old glue gun - well okay, watch out for > electricity > surges whilst deploying the glue gun method. However, really useful > for >

RE: RE: Value of OCP

Title: RE: RE: Value of OCP Personally I like the old glue gun - well okay, watch out for electricity surges whilst deploying the glue gun method.  However, really useful for most kid related things - wip up a costume in no time, fix that plastic toy, diaper to cheap to stick - the glue gun

RE: RE: Value of OCP

Title: Message If the ladies can't find you handsome, at least let them find you handy! -Original Message-From: Orr, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 8:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: Value of OCP Red

RE: RE: Value of OCP

Title: RE: RE: Value of OCP Red Green, my hero!!! http://www.ducttapeforever.com/forever.html -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 20, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Value of OCP Good

<    8   9   10   11   12   13   14   15   16   17   >