Is it safe to use locally managed tablespaces in Oracle 9.2.0.2.0.

Hi,

I`m about to start the convertion of our production system from 8i to 9.2.0.2.0. 64 bit Solaris on Solaris 8 and looking or an info about durability of completely locally managed databases.

Does anybody have any negative experience with locally managed tablespaces with this version?

My test system works OK so long so far with all SYSTEM, UNDO, TEMP and data tablespaces created as 'SIZE 1998M REUSE AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K SEGMENT SPACE MANAGEMENT AUTO;'. Is it safe to be so for production or is it still too vulnerable?

Thanks in advance,
Paul.

Is it safe? What is this, a throwback to "Marathon Man," when Rod Steiger is torturing Dustin Hoffman? Is it safe? Is it safe?

Yes, it's safe. It's so safe you wouldn't believe it

Quote:

---

Originally posted by stecal
Is it safe? What is this, a throwback to "Marathon Man," when Rod Steiger is torturing Dustin Hoffman? Is it safe? Is it safe?

---

There is no reason to be sarcastic.
It`s my job to be paranoid, i`m getting paid for it.

I used to have issues with locally managed temporary and SYSTEM tablespaces in early versions of 9i and lost interest to it for a pretty long time, so, if nobody have had any issues with recent versions of 9i on the long running production systems - that`s fine.

Something you should know: If you created the database with SYSTEM tablespace as locally managed, ALL THE TABLESPACES in the databases have to be locally managed. You WILL NOT BE ABLE TO CREATE any dictionary managed tablespaces.

it was laurence oilivier who was torturing dustin hoffman in Marathon Man. not rod steiger.

Ohmigod, I can't believe I did that.

Marathon Man (1976) is a scary nightmare thriller, best known for the suspenseful pursuit scenes and a truly repellent scene of torture.
Doc Levy (Roy Scheider), an American secret agent, who is thought to have stolen a valuable cache of diamonds, is killed by evil ex-Nazi Szell (Laurence Olivier), an ex-concentration camp dentist by profession. Szell has come to New York to retrieve the fortune in diamonds. Szell kidnaps Doc's brother, lone, idealistic Jewish graduate student Babe Levy (Dustin Hoffman), who knows nothing about his brother's involvement.

In the most memorable torture scene, Szell uses his dental instruments for sadistic oral surgery to torture and extract information from Babe. Szell is the essence of evil and disturbingly effective during the torture, repeatedly asking Babe the question:


Is it safe?

Quote:

---

Originally posted by utkinpol
There is no reason to be sarcastic.
It`s my job to be paranoid, i`m getting paid for it.

I used to have issues with locally managed temporary and SYSTEM tablespaces in early versions of 9i and lost interest to it for a pretty long time, so, if nobody have had any issues with recent versions of 9i on the long running production systems - that`s fine.

---

Oracle 9i R1 supports LMT for system tablespace???

Quote:

---

Originally posted by utkinpol
I used to have issues with locally managed temporary and SYSTEM tablespaces in early versions of 9i and lost interest to it for a pretty long time...

---

Yeah, utkinpol, what were the isues with localy managed SYSTEM tablespace in early versions of 9i? I bet your main isue was the fact that you were not able to create SYSTEM as LMT back then! So, was that the reason why you've lost interest in it?

well that's why I thought he is talking non-sense

Quote:

---

Originally posted by stecal
Is it safe? What is this, a throwback to "Marathon Man," when Rod Steiger is torturing Dustin Hoffman? Is it safe? Is it safe?

---

Hi to all moderators,
what utkinpol asked, i always ask too. When i can use a new feature or it is better to stay on the good old ways.
But even the 'old' things surprisingly often do not want to work with the Oracle-Server.
For example the 9.2.0.2-Patch showed about 20 Errors in parallel-query-processing. Has somebody tuned the code or deletetd the comment-lines of Dennis Ritchie and Brian Kernighan, or migrated it to Bjarne Stroustup newest Paradigm's???

I do not know i only know that i understand utkinpol.
Orca
:cool:

Quote:

---

Originally posted by jmodic
Yeah, utkinpol, what were the isues with localy managed SYSTEM tablespace in early versions of 9i? I bet your main isue was the fact that you were not able to create SYSTEM as LMT back then! So, was that the reason why you've lost interest in it?

---

It`s quite strange, for the last time I visited this place almost an year ago, but it looks like all you have here now is a gang of stupid tins or a gang of elderly morons who act like a gang of stupid kids.

Who cares what it was? This thing died in several days on staging environment, so who CARES what was it?

Quote:

---

Originally posted by Orca777
Hi to all moderators,
what utkinpol asked, i always ask too. When i can use a new feature or it is better to stay on the good old ways.
But even the 'old' things surprisingly often do not want to work with the Oracle-Server.
For example the 9.2.0.2-Patch showed about 20 Errors in parallel-query-processing. Has somebody tuned the code or deletetd the comment-lines of Dennis Ritchie and Brian Kernighan, or migrated it to Bjarne Stroustup newest Paradigm's???

I do not know i only know that i understand utkinpol.
Orca
:cool:

---

I just know that I`m getting paid for my production system which runs 24x7 for more than an year already. And I know that it will be NOT understood by management if this system will start to go down on unpredictable basis, WHATEVER will be the reason. Who cares why it`s down? It`s down. And it`s my job not to let it go there. I just have a certain lack of trust in stability of 9i, it`s just my personal opinion...

It`s a pity to see such a reaction here, anyway.
I`m doing this job for too many ears for now so it does not bother me much, but it`s a pity, anyway. I remebered this place as a good resource to chat with people with professional attitude.
Too bad if it`s not like this anymore.

Quote:

---

Originally posted by utkinpol
It`s quite strange, for the last time I visited this place almost an year ago, but it looks like all you have here now is a gang of stupid tins or a gang of elderly morons who act like a gang of stupid kids.

---

You always have to option of not participating...

Quote:

---

Who cares what it was? This thing died in several days on staging environment, so who CARES what was it?

---

Of course it died. You can't have a LMT SYSTEM tablespace in versions less than 9.2...

Is it safe?
Well If you have "Oracle GOLD" support then I think you may save your job.:D

Oh, come on, utkinpol! The fact is that you made something totaly up from imagination and now you want to sell it as a real life expirience. Do you expect to get a serious answer to a question which is based on an evident lie? Your argument about your question was that "used to have issues with locally managed temporary and SYSTEM tablespaces in early versions of 9i " - and I pointed out that you made that argument up, because you couldn't possibly have SYSTEM as LMT. So do wee need to discuss your original answer any further?

Now about your original question - if you decided to migrate to 9.2, then you need not ask if you should use LMT or not. If you use 9.2 then it is (almost) mandatory to have all your tablespaces as LMT. Is it safe, you ask? Well, I guess about 99.9% of all instalations of 9.2 have all the tablespaces in LMT mode (because very few people know how to create database without being forced to use LMTs in 9.2). So is it safe? Well, if it was not safe there wouldn't be any production instalations of 9.2. It's as simple as that. So is it safe? Yes, it PROBABLY is safe. Is it safer to use DMT with 9.2? You PROBABLY won't find anyone that will be able to answer this, as noone is using DMT in 9.2.

In the future, if you wan't some meaningfull answers to your questions you should at least describe your problems or doubts truthfully.

strange, not fired already

Quote:

---

Originally posted by jmodic
Oh, come on, utkinpol! The fact is that you made something totaly up from imagination and now you want to sell it as a real life expirience. Do you expect to get a serious answer to a question which is based on an evident lie? Your argument about your question was that "used to have issues with locally managed temporary and SYSTEM tablespaces in early versions of 9i " - and I pointed out that you made that argument up, because you couldn't possibly have SYSTEM as LMT. So do wee need to discuss your original answer any further?

Now about your original question - if you decided to migrate to 9.2, then you need not ask if you should use LMT or not. If you use 9.2 then it is (almost) mandatory to have all your tablespaces as LMT. Is it safe, you ask? Well, I guess about 99.9% of all instalations of 9.2 have all the tablespaces in LMT mode (because very few people know how to create database without being forced to use LMTs in 9.2). So is it safe? Well, if it was not safe there wouldn't be any production instalations of 9.2. It's as simple as that. So is it safe? Yes, it PROBABLY is safe. Is it safer to use DMT with 9.2? You PROBABLY won't find anyone that will be able to answer this, as noone is using DMT in 9.2.

In the future, if you wan't some meaningfull answers to your questions you should at least describe your problems or doubts truthfully.

---

All you people have the same teenager`s problem - you read the original message and see not that was written there but something else you decided was there and than start making assumptions instead of further clarification of the issue.

Well, who cares, if according to your opinion R1 is the only earlier version prior to '9.2.0.2 64 bit' - it`s your problem, not mine.

Don`t get me wrong again for a god sake and don`t try to get me any more moronic advices, please.

well if you said what problems you had with so called *earlier* versions of 9i?

Quote:

---

Originally posted by pando
well if you said what problems you had with so called *earlier* versions of 9i?

---

don`t give me any more moronic answers, please

Boys, boys, boys. Can't we all just get along?

Quote:

---

Originally posted by marist89
Boys, boys, boys. Can't we all just get along?

---

I calm as an dead arctic elefant, it`s not my problem and never was.

What I really need to solve at the moment is how to deal with freaking TOAD which does not like all this locally managed crap we got in 9.2 anymore - it screams 'Invalid variant operation' every time you try to access storage info.

Interesting, what else will I find...

so..don't use TOAD anymore..simple.

It is not safe.

Quote:

---

Originally posted by utkinpol
I calm as an dead arctic elefant, it`s not my problem and never was.

What I really need to solve at the moment is how to deal with freaking TOAD which does not like all this locally managed crap we got in 9.2 anymore - it screams 'Invalid variant operation' every time you try to access storage info.

Interesting, what else will I find...

---

Why don't you just use Enterprise manager that comes standard with 9iSR2.

BTW, I believe that LMT are perfectly safe. It is my preference that we use them too. Unfortunately, I am forced to create 9iSR2 databases with DMT and rollback because we haven't certified to LMT yet. But we will. I think its safe to say that LMT's have been around long enough to be stable.

Did you know Zero is the only number that cannot be represented by Roman numerals? Oh wait, different thread...

No matter where you go, there you are.

Quote:

---

Originally posted by utkinpol
don`t give me any more moronic answers, please

---

well I am asking what problem you had with tablespace SYSTEM with earlier Oracle 9i version because you said you had problems and I would like to hear what

if you cant answer it then fine, just dont invent thing you dont have a clue about