OT: Re: 10g new features question for beta testers
Oh yes, the RDD story is good. Carel-Jan and I were in Paris for Oracle World, sharing the horrendous costs of a hotel room, and having one final beer when the phone rang at 2 am. It was a Dane, and it was also one of Miracle's support customers. Since our motto for Miracle Support is "Call us anytime about anything" I of course answered the phone. He was slightly drunk after the big Oracle party, he was lost in a deserted area with no roads, couldn't remember the name of his hotel or the street or the Metro station near it, and he had just been robbed by six guys. Initially they had been two, and he fought like a real Dane, but when the four others came around he went down, and they took his wallet. So we asked him several times if he could describe anything he could see, and he finally told us "I can zee the Raifel Tover". Is it close? we asked. "Noo, it's weeery far awaaay" he answered. So now we knew he was in Paris. Finally, after much talking and him walking around for a while, he managed to stop a taxi, who then spoke French to Carel-Jan. Carel-Jan directed the taxi to our hotel, paid it, and led the good Dane to our room. There we washed off the blood & mud on him, gave him a beer, and put him to sleep on the floor. He thought he had received splendid support :-). I'm sure this could become a textbook case in some future book by Tom Peters and other management gurus. Mogens Carel-Jan Engel wrote: -Original Message- Mogens Nørgaard Sent: Sunday, December 21, 2003 10:14 PM To: Multiple recipients of list ORACLE-L It's the Best of Breed versus One Vendor debate, and there are pros and cons galore. The perfect scenario, of course, is when they combine, so one vendor delivers the best of everything. That's what we have with Microsoft, isn't it? ;-) : Office stuff, OS, Database, ERP, CRM, video player, what have you... Then on the Support side of things, it's indeed good to be able to call One Vendor Only... if that vendor is good at Support. If he isn't, you might be better off if you have more than one option for calling. Mogens Or, when you happen to be a RDD (Robbed Drunk Dane) in Paris, and you're able to call a particular Danish non-Vendor. That might be even better ;-) Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: 10g new features question for beta testers
The credit for that goes to Gary Dodge. It has been his email signature for better than 10 years... "Building tomorrow's legacy systems today - one crisis at a time" Gene Fosnight (a successfully retired Oracle consultant) had an email signature that was, if anything, even better: "Look, listen, and learn, for an original mistake is as rare as an original idea." on 12/22/03 5:34 PM, Mogens Nørgaard at [EMAIL PROTECTED] wrote: > Imagine the banner text: "Miracle A/S. The Legacy Support of Tomorrow. > Filling the Gap (jeans) like nobody else." > > Thanks to Tim Gorman for inspiration. I don't recall the text completely > anymore, but he used to have this one about "Building tomorrow's legacy > systems - one crisis at a time". Or something to that effect. > > Mogens > > Pete Sharman wrote: > >> But I thought this was the perfect opportunity for Miracle to fill any >> perceived gap in support? :) >> >> Pete >> >> "Controlling developers is like herding cats." >> >> Kevin Loney, Oracle DBA Handbook >> >> "Oh no, it's not. It's much harder than that!" >> >> Bruce Pihlamae, long-term Oracle DBA >> >> >> -Original Message- >> Mogens Nørgaard >> Sent: Sunday, December 21, 2003 10:14 PM >> To: Multiple recipients of list ORACLE-L >> >> It's the Best of Breed versus One Vendor debate, and there are pros and >> cons galore. >> >> The perfect scenario, of course, is when they combine, so one vendor >> delivers the best of everything. That's what we have with Microsoft, >> isn't it? ;-) : Office stuff, OS, Database, ERP, CRM, video player, what >> >> have you... >> >> Then on the Support side of things, it's indeed good to be able to call >> One Vendor Only... if that vendor is good at Support. If he isn't, you >> might be better off if you have more than one option for calling. >> >> Mogens >> >> Pete Sharman wrote: >> >> >> >>> Just a couple of comments on this which hopefully won't go down the >>> Marketing track too far. :) >>> >>> 1. I'm pretty sure Steve Adams agrees with you, since he co-presented >>> on ASM at OracleWorld in San Fran. Not sure if he monitors this group >>> actively or not, but I believe the presentation he did is loaded with >>> all the other OracleWorld 2003 presentations so you can see what he >>> said. >>> >>> 2. One point which makes a lot of sense to me, and it happens in a >>> variety of places in 10g such as ASM and the RAC clusterware. If you >>> have one vendor to raise an issue with (not that you'd need to do that >>> with Oracle of course!), it's a lot easier to get an answer without the >>> finger pointing that can go on between vendors. Take the clusterware >>> example - if you run into a problem running RAC on Sun with the Sun >>> Cluster technology and Veritas owning the disk side, who you gonna >>> >>> >> call? >> >> >>> GhostBusters, maybe! But if you're running RAC on Sun with Oracle's >>> clusterware and ASM, it's a lot easier to determine who to call. >>> >>> Pete >>> >>> "Controlling developers is like herding cats." >>> >>> Kevin Loney, Oracle DBA Handbook >>> >>> "Oh no, it's not. It's much harder than that!" >>> >>> Bruce Pihlamae, long-term Oracle DBA >>> >>> >>> -Original Message- >>> Connor McDonald >>> Sent: Saturday, December 20, 2003 2:34 AM >>> To: Multiple recipients of list ORACLE-L >>> >>> As with anything I suppose, if a single vendor can be >>> in control of more of the stack between application >>> and physical server structure then there is a greater >>> opportunity for benefits. For example, ASM offers the >>> ability to add disks to a stripe without needing to >>> redistribute(reload) the entire stripeset. >>> >>> A (bug-free) ASM product looks very very impressive to >>> me. Time will tell how close Oracle are to achieving >>> it. >>> >>> hth >>> connor >>> >>> --- [EMAIL PROTECTED] wrote: > no ASMs are >>> considerably different. Its supposed to >>> >>> >>> >>> >>>> manage everything. You dont give it a f
Re: 10g new features question for beta testers
Imagine the banner text: "Miracle A/S. The Legacy Support of Tomorrow. Filling the Gap (jeans) like nobody else." Thanks to Tim Gorman for inspiration. I don't recall the text completely anymore, but he used to have this one about "Building tomorrow's legacy systems - one crisis at a time". Or something to that effect. Mogens Pete Sharman wrote: But I thought this was the perfect opportunity for Miracle to fill any perceived gap in support? :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Mogens Nørgaard Sent: Sunday, December 21, 2003 10:14 PM To: Multiple recipients of list ORACLE-L It's the Best of Breed versus One Vendor debate, and there are pros and cons galore. The perfect scenario, of course, is when they combine, so one vendor delivers the best of everything. That's what we have with Microsoft, isn't it? ;-) : Office stuff, OS, Database, ERP, CRM, video player, what have you... Then on the Support side of things, it's indeed good to be able to call One Vendor Only... if that vendor is good at Support. If he isn't, you might be better off if you have more than one option for calling. Mogens Pete Sharman wrote: Just a couple of comments on this which hopefully won't go down the Marketing track too far. :) 1. I'm pretty sure Steve Adams agrees with you, since he co-presented on ASM at OracleWorld in San Fran. Not sure if he monitors this group actively or not, but I believe the presentation he did is loaded with all the other OracleWorld 2003 presentations so you can see what he said. 2. One point which makes a lot of sense to me, and it happens in a variety of places in 10g such as ASM and the RAC clusterware. If you have one vendor to raise an issue with (not that you'd need to do that with Oracle of course!), it's a lot easier to get an answer without the finger pointing that can go on between vendors. Take the clusterware example - if you run into a problem running RAC on Sun with the Sun Cluster technology and Veritas owning the disk side, who you gonna call? GhostBusters, maybe! But if you're running RAC on Sun with Oracle's clusterware and ASM, it's a lot easier to determine who to call. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Connor McDonald Sent: Saturday, December 20, 2003 2:34 AM To: Multiple recipients of list ORACLE-L As with anything I suppose, if a single vendor can be in control of more of the stack between application and physical server structure then there is a greater opportunity for benefits. For example, ASM offers the ability to add disks to a stripe without needing to redistribute(reload) the entire stripeset. A (bug-free) ASM product looks very very impressive to me. Time will tell how close Oracle are to achieving it. hth connor --- [EMAIL PROTECTED] wrote: > no ASMs are considerably different. Its supposed to manage everything. You dont give it a file, you give it entire disks and oracle does everything. Sets up files, manages, I/O, everything. you only look at the tablespace level. you dont even install any software on it. If your on SAN, you dont install SAN software on it. From: "Goulet, Dick" <[EMAIL PROTECTED]> Date: 2003/12/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces. The database picks the filenames for you. Now mind you it does work, but I'll be damned if I use it in anything other than a development environment. For some reason Oracle has never gotten over that DUMB SAME (Stripe And Mirror Everything) idea. The concept is great in theory, but in practice it's absolutely abysmal at best. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 8:24 AM To: Multiple recipients of list ORACLE-L I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know atleast one other person from the list was there. Since Oracle is releasing details and its going to be released(in theory) in the next 2 weeks, I was wondering if you guys could talk about it. 1. does ASMs work as well as Oracle claims? I always wonder about first generation features... takes most software vendors a couple of generations to get
RE: 10g new features question for beta testers
-Original Message- Mogens Nørgaard Sent: Sunday, December 21, 2003 10:14 PM To: Multiple recipients of list ORACLE-L It's the Best of Breed versus One Vendor debate, and there are pros and cons galore. The perfect scenario, of course, is when they combine, so one vendor delivers the best of everything. That's what we have with Microsoft, isn't it? ;-) : Office stuff, OS, Database, ERP, CRM, video player, what have you... Then on the Support side of things, it's indeed good to be able to call One Vendor Only... if that vendor is good at Support. If he isn't, you might be better off if you have more than one option for calling. Mogens Or, when you happen to be a RDD (Robbed Drunk Dane) in Paris, and you're able to call a particular Danish non-Vendor. That might be even better ;-) Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) ===
RE: 10g new features question for beta testers
But I thought this was the perfect opportunity for Miracle to fill any perceived gap in support? :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Mogens Nørgaard Sent: Sunday, December 21, 2003 10:14 PM To: Multiple recipients of list ORACLE-L It's the Best of Breed versus One Vendor debate, and there are pros and cons galore. The perfect scenario, of course, is when they combine, so one vendor delivers the best of everything. That's what we have with Microsoft, isn't it? ;-) : Office stuff, OS, Database, ERP, CRM, video player, what have you... Then on the Support side of things, it's indeed good to be able to call One Vendor Only... if that vendor is good at Support. If he isn't, you might be better off if you have more than one option for calling. Mogens Pete Sharman wrote: >Just a couple of comments on this which hopefully won't go down the >Marketing track too far. :) > >1. I'm pretty sure Steve Adams agrees with you, since he co-presented >on ASM at OracleWorld in San Fran. Not sure if he monitors this group >actively or not, but I believe the presentation he did is loaded with >all the other OracleWorld 2003 presentations so you can see what he >said. > >2. One point which makes a lot of sense to me, and it happens in a >variety of places in 10g such as ASM and the RAC clusterware. If you >have one vendor to raise an issue with (not that you'd need to do that >with Oracle of course!), it's a lot easier to get an answer without the >finger pointing that can go on between vendors. Take the clusterware >example - if you run into a problem running RAC on Sun with the Sun >Cluster technology and Veritas owning the disk side, who you gonna call? >GhostBusters, maybe! But if you're running RAC on Sun with Oracle's >clusterware and ASM, it's a lot easier to determine who to call. > >Pete > >"Controlling developers is like herding cats." > >Kevin Loney, Oracle DBA Handbook > >"Oh no, it's not. It's much harder than that!" > >Bruce Pihlamae, long-term Oracle DBA > > >-Original Message- >Connor McDonald >Sent: Saturday, December 20, 2003 2:34 AM >To: Multiple recipients of list ORACLE-L > >As with anything I suppose, if a single vendor can be >in control of more of the stack between application >and physical server structure then there is a greater >opportunity for benefits. For example, ASM offers the >ability to add disks to a stripe without needing to >redistribute(reload) the entire stripeset. > >A (bug-free) ASM product looks very very impressive to >me. Time will tell how close Oracle are to achieving >it. > >hth >connor > > --- [EMAIL PROTECTED] wrote: > no ASMs are >considerably different. Its supposed to > > >>manage everything. You dont give it a file, you give >>it entire disks and oracle does everything. Sets up >>files, manages, I/O, everything. >> >>you only look at the tablespace level. you dont even >>install any software on it. If your on SAN, you dont >>install SAN software on it. >> >> >>>From: "Goulet, Dick" <[EMAIL PROTECTED]> >>>Date: 2003/12/19 Fri AM 09:14:27 EST >>>To: Multiple recipients of list ORACLE-L >>> >>> >><[EMAIL PROTECTED]> >> >> >>>Subject: RE: 10g new features question for beta >>> >>> >>testers >> >> >>>That is not exactly a new feature. Oracle 9i has >>> >>> >>Oracle Managed Files where you give it a directory >>and then just build tablespaces. The database picks >>the filenames for you. Now mind you it does work, >>but I'll be damned if I use it in anything other >>than a development environment. For some reason >>Oracle has never gotten over that DUMB SAME (Stripe >>And Mirror Everything) idea. The concept is great >>in theory, but in practice it's absolutely abysmal >>at best. >> >> >>>Dick Goulet >>>Senior Oracle DBA >>>Oracle Certified 8i DBA >>> >>>-Original Message- >>>Sent: Friday, December 19, 2003 8:24 AM >>>To: Multiple recipients of list ORACLE-L >>> >>> >>>I saw a presentation from Oracle on 10g new >>> >>> >>features last night in Reston,VA. I know atleast one >>other person from the list was there. Since Oracle >>is
Re: 10g new features question for beta testers
Thats why I carefully wrote: "opportunity for benefits" as opposed to "benefits" :-) --- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote: > It's the Best of Breed versus One Vendor debate, and > there are pros and > cons galore. > > The perfect scenario, of course, is when they > combine, so one vendor > delivers the best of everything. That's what we have > with Microsoft, > isn't it? ;-) : Office stuff, OS, Database, ERP, > CRM, video player, what > have you... > > Then on the Support side of things, it's indeed good > to be able to call > One Vendor Only... if that vendor is good at > Support. If he isn't, you > might be better off if you have more than one option > for calling. > > Mogens > > Pete Sharman wrote: > > >Just a couple of comments on this which hopefully > won't go down the > >Marketing track too far. :) > > > >1. I'm pretty sure Steve Adams agrees with you, > since he co-presented > >on ASM at OracleWorld in San Fran. Not sure if he > monitors this group > >actively or not, but I believe the presentation he > did is loaded with > >all the other OracleWorld 2003 presentations so you > can see what he > >said. > > > >2. One point which makes a lot of sense to me, and > it happens in a > >variety of places in 10g such as ASM and the RAC > clusterware. If you > >have one vendor to raise an issue with (not that > you'd need to do that > >with Oracle of course!), it's a lot easier to get > an answer without the > >finger pointing that can go on between vendors. > Take the clusterware > >example - if you run into a problem running RAC on > Sun with the Sun > >Cluster technology and Veritas owning the disk > side, who you gonna call? > >GhostBusters, maybe! But if you're running RAC on > Sun with Oracle's > >clusterware and ASM, it's a lot easier to determine > who to call. > > > >Pete > > > >"Controlling developers is like herding cats." > > > >Kevin Loney, Oracle DBA Handbook > > > >"Oh no, it's not. It's much harder than that!" > > > >Bruce Pihlamae, long-term Oracle DBA > > > > > >-Original Message- > >Connor McDonald > >Sent: Saturday, December 20, 2003 2:34 AM > >To: Multiple recipients of list ORACLE-L > > > >As with anything I suppose, if a single vendor can > be > >in control of more of the stack between application > >and physical server structure then there is a > greater > >opportunity for benefits. For example, ASM offers > the > >ability to add disks to a stripe without needing to > >redistribute(reload) the entire stripeset. > > > >A (bug-free) ASM product looks very very impressive > to > >me. Time will tell how close Oracle are to > achieving > >it. > > > >hth > >connor > > > > --- [EMAIL PROTECTED] wrote: > no ASMs are > >considerably different. Its supposed to > > > > > >>manage everything. You dont give it a file, you > give > >>it entire disks and oracle does everything. Sets > up > >>files, manages, I/O, everything. > >> > >>you only look at the tablespace level. you dont > even > >>install any software on it. If your on SAN, you > dont > >>install SAN software on it. > >> > >> > >>>From: "Goulet, Dick" <[EMAIL PROTECTED]> > >>>Date: 2003/12/19 Fri AM 09:14:27 EST > >>>To: Multiple recipients of list ORACLE-L > >>> > >>> > >><[EMAIL PROTECTED]> > >> > >> > >>>Subject: RE: 10g new features question for beta > >>> > >>> > >>testers > >> > >> > >>>That is not exactly a new feature. Oracle 9i has > >>> > >>> > >>Oracle Managed Files where you give it a directory > >>and then just build tablespaces. The database > picks > >>the filenames for you. Now mind you it does work, > >>but I'll be damned if I use it in anything other > >>than a development environment. For some reason > >>Oracle has never gotten over that DUMB SAME > (Stripe > >>And Mirror Everything) idea. The concept is great > >>in theory, but in practice it's absolutely abysmal > >>at best. > >> > >> > >>>Dick Goulet > >>>Senior Oracle DBA > >>>Oracle
Re: 10g new features question for beta testers
It's the Best of Breed versus One Vendor debate, and there are pros and cons galore. The perfect scenario, of course, is when they combine, so one vendor delivers the best of everything. That's what we have with Microsoft, isn't it? ;-) : Office stuff, OS, Database, ERP, CRM, video player, what have you... Then on the Support side of things, it's indeed good to be able to call One Vendor Only... if that vendor is good at Support. If he isn't, you might be better off if you have more than one option for calling. Mogens Pete Sharman wrote: Just a couple of comments on this which hopefully won't go down the Marketing track too far. :) 1. I'm pretty sure Steve Adams agrees with you, since he co-presented on ASM at OracleWorld in San Fran. Not sure if he monitors this group actively or not, but I believe the presentation he did is loaded with all the other OracleWorld 2003 presentations so you can see what he said. 2. One point which makes a lot of sense to me, and it happens in a variety of places in 10g such as ASM and the RAC clusterware. If you have one vendor to raise an issue with (not that you'd need to do that with Oracle of course!), it's a lot easier to get an answer without the finger pointing that can go on between vendors. Take the clusterware example - if you run into a problem running RAC on Sun with the Sun Cluster technology and Veritas owning the disk side, who you gonna call? GhostBusters, maybe! But if you're running RAC on Sun with Oracle's clusterware and ASM, it's a lot easier to determine who to call. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Connor McDonald Sent: Saturday, December 20, 2003 2:34 AM To: Multiple recipients of list ORACLE-L As with anything I suppose, if a single vendor can be in control of more of the stack between application and physical server structure then there is a greater opportunity for benefits. For example, ASM offers the ability to add disks to a stripe without needing to redistribute(reload) the entire stripeset. A (bug-free) ASM product looks very very impressive to me. Time will tell how close Oracle are to achieving it. hth connor --- [EMAIL PROTECTED] wrote: > no ASMs are considerably different. Its supposed to manage everything. You dont give it a file, you give it entire disks and oracle does everything. Sets up files, manages, I/O, everything. you only look at the tablespace level. you dont even install any software on it. If your on SAN, you dont install SAN software on it. From: "Goulet, Dick" <[EMAIL PROTECTED]> Date: 2003/12/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces. The database picks the filenames for you. Now mind you it does work, but I'll be damned if I use it in anything other than a development environment. For some reason Oracle has never gotten over that DUMB SAME (Stripe And Mirror Everything) idea. The concept is great in theory, but in practice it's absolutely abysmal at best. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message----- Sent: Friday, December 19, 2003 8:24 AM To: Multiple recipients of list ORACLE-L I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know atleast one other person from the list was there. Since Oracle is releasing details and its going to be released(in theory) in the next 2 weeks, I was wondering if you guys could talk about it. 1. does ASMs work as well as Oracle claims? I always wonder about first generation features... takes most software vendors a couple of generations to get it right(takes any project Im on just as long). This is a radical departure. for those of you who dont know. Oracle claims that they will manage your disks for you. All you do is give Oracle some Raw Disks and Oracle will set up, and handle all your datafiles. All you do is look at logical tablespaces. It will also handle I/O balancing. How well does this work? Anyone test it with a SAN? 2. RAC Load Balancing. Oracle claims that you only need Oracle software from now on. They also claim that you can load balance multiple applications. Lets say you have One application that runs batch loads over night and a transactional application during the day oracle will automatically steal resources from the other when its not busy... anyone test this? 3. Flashback database. Kyte was the presenter and he said that you can keep massive undo ar
Re: RE: 10g new features question for beta testers
SAME is stripe and mirror everything. There is a doc on otn by that name. ASMs will do that for you, 'in theory'. kyte is the technical face of oracle. This is why they pay him so much money. presentation would have been better if people didnt play 'stump the dba'. It seems like people were trying to show him how smart they were by asking irrelevent narrow questions that will be in the docs when they come in the next couple of months... wish he would have cut them off and covered more big picture stuff. > > From: Michael Thomas <[EMAIL PROTECTED]> > Date: 2003/12/19 Fri PM 01:14:29 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: 10g new features question for beta testers > > I was in Reston last night, too. Also, Tom repeatedly > emphasized RMAN, which I've not spent enough time > mastering, will be even more important in 10g. Does > everyone here use RMAN that is using 9i currently? > > BTW. Tom mentioned SAME, as you say, but I can not > remember what he said about it. Sorry. Maybe Ryan > remembers? > > As far as ASM, I thought it was interesting that ASM > was supposed to run as additional PMON/SMON processes > with separate dynamic V$ views as the API. > > I was pretty impressed that Tom was spending the week > before holidays travelling around and doing Oracle > presentations. He is really amazing. > > Regards, > > Mike > > --- "Goulet, Dick" <[EMAIL PROTECTED]> wrote: > > That is not exactly a new feature. Oracle 9i has > > Oracle Managed Files where you give it a directory > > and then just build tablespaces. The database picks > > the filenames for you. Now mind you it does work, > > but I'll be damned if I use it in anything other > > than a development environment. For some reason > > Oracle has never gotten over that DUMB SAME (Stripe > > And Mirror Everything) idea. The concept is great > > in theory, but in practice it's absolutely abysmal > > at best. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle Certified 8i DBA > > > > -Original Message- > > Sent: Friday, December 19, 2003 8:24 AM > > To: Multiple recipients of list ORACLE-L > > > > > > I saw a presentation from Oracle on 10g new features > > last night in Reston,VA. I know atleast one other > > person from the list was there. Since Oracle is > > releasing details and its going to be released(in > > theory) in the next 2 weeks, I was wondering if you > > guys could talk about it. > > > > 1. does ASMs work as well as Oracle claims? I always > > wonder about first generation features... takes most > > software vendors a couple of generations to get it > > right(takes any project Im on just as long). This is > > a radical departure. > > > > for those of you who dont know. Oracle claims that > > they will manage your disks for you. All you do is > > give Oracle some Raw Disks and Oracle will set up, > > and handle all your datafiles. All you do is look at > > logical tablespaces. It will also handle I/O > > balancing. > > > > How well does this work? Anyone test it with a SAN? > > > > > > 2. RAC Load Balancing. Oracle claims that you only > > need Oracle software from now on. They also claim > > that you can load balance multiple applications. > > Lets say you have One application that runs batch > > loads over night and a transactional application > > during the day oracle will automatically steal > > resources from the other when its not busy... > > > > anyone test this? > > > > > > 3. Flashback database. Kyte was the presenter and he > > said that you can keep massive undo areas, so that > > if you have a failure or delete data you shouldnt > > have you can have oracle automatically write the DML > > necessary to bring it back to any point in time. > > Kyte said that regular EIDE hard drives that you put > > in home PCs are plenty fast enough for most systems. > > He recommends getting 4 300 GB drives(1.2 TBs) for > > about $1400 to do this and to make tape backups off > > of this since they are really slow. > > > > Can any beta testers comment? > > > > Im pleased with the rename tablespace feature... > > that way I dont have to update TS$ anymore... I > > wonder if it was our complaining that got them to > > add it :) > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > -- > > Author: <[EMAIL PROTECTED] > &
RE: RE: 10g new features question for beta testers
This could simplify life, particularly with wait event-based tuning. If Oracle properly instruments these additional layers for timing, it makes it easy to diagnose performance problems, not harder. Interested in Cary's thoughts on this. Adam "Goulet, Dick" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/19/2003 07:49 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc Subject RE: RE: 10g new features question for beta testers And the more that vendor, namely the database in this case, controls more and more of the stack the more any performance problem must be a database problem. No thank you. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 10:34 AM To: Multiple recipients of list ORACLE-L As with anything I suppose, if a single vendor can be in control of more of the stack between application and physical server structure then there is a greater opportunity for benefits. For example, ASM offers the ability to add disks to a stripe without needing to redistribute(reload) the entire stripeset. A (bug-free) ASM product looks very very impressive to me. Time will tell how close Oracle are to achieving it. hth connor --- [EMAIL PROTECTED] wrote: > no ASMs are considerably different. Its supposed to > manage everything. You dont give it a file, you give > it entire disks and oracle does everything. Sets up > files, manages, I/O, everything. > > you only look at the tablespace level. you dont even > install any software on it. If your on SAN, you dont > install SAN software on it. > > > > From: "Goulet, Dick" <[EMAIL PROTECTED]> > > Date: 2003/12/19 Fri AM 09:14:27 EST > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > Subject: RE: 10g new features question for beta > testers > > > > That is not exactly a new feature. Oracle 9i has > Oracle Managed Files where you give it a directory > and then just build tablespaces. The database picks > the filenames for you. Now mind you it does work, > but I'll be damned if I use it in anything other > than a development environment. For some reason > Oracle has never gotten over that DUMB SAME (Stripe > And Mirror Everything) idea. The concept is great > in theory, but in practice it's absolutely abysmal > at best. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle Certified 8i DBA > > > > -Original Message- > > Sent: Friday, December 19, 2003 8:24 AM > > To: Multiple recipients of list ORACLE-L > > > > > > I saw a presentation from Oracle on 10g new > features last night in Reston,VA. I know atleast one > other person from the list was there. Since Oracle > is releasing details and its going to be released(in > theory) in the next 2 weeks, I was wondering if you > guys could talk about it. > > > > 1. does ASMs work as well as Oracle claims? I > always wonder about first generation features... > takes most software vendors a couple of generations > to get it right(takes any project Im on just as > long). This is a radical departure. > > > > for those of you who dont know. Oracle claims that > they will manage your disks for you. All you do is > give Oracle some Raw Disks and Oracle will set up, > and handle all your datafiles. All you do is look at > logical tablespaces. It will also handle I/O > balancing. > > > > How well does this work? Anyone test it with a > SAN? > > > > > > 2. RAC Load Balancing. Oracle claims that you only > need Oracle software from now on. They also claim > that you can load balance multiple applications. > Lets say you have One application that runs batch > loads over night and a transactional application > during the day oracle will automatically steal > resources from the other when its not busy... > > > > anyone test this? > > > > > > 3. Flashback database. Kyte was the presenter and > he said that you can keep massive undo areas, so > that if you have a failure or delete data you > shouldnt have you can have oracle automatically > write the DML necessary to bring it back to any > point in time. Kyte said that regular EIDE hard > drives that you put in home PCs are plenty fast > enough for most systems. He recommends getting 4 300 > GB drives(1.2 TBs) for about $1400 to do this and to > make tape backups off of this since they are really > slow. > > > > Can any beta testers comment? > > > > Im pleased with the rename tablespace feature... > that way I dont have to update TS$ anymore... I > wonder if it was our co
RE: RE: 10g new features question for beta testers
Right. Then the finger pointing will be contained within Oracle Corp. I don't know whether ASM is a good idea, a bad one, or a mediocre one, but I don't believe holding one vendor responible will help resolve issues in a more timely manner. "Pete Sharman" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/19/2003 10:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: RE: 10g new features question for beta testers Just a couple of comments on this which hopefully won't go down the Marketing track too far. :) 1. I'm pretty sure Steve Adams agrees with you, since he co-presented on ASM at OracleWorld in San Fran. Not sure if he monitors this group actively or not, but I believe the presentation he did is loaded with all the other OracleWorld 2003 presentations so you can see what he said. 2. One point which makes a lot of sense to me, and it happens in a variety of places in 10g such as ASM and the RAC clusterware. If you have one vendor to raise an issue with (not that you'd need to do that with Oracle of course!), it's a lot easier to get an answer without the finger pointing that can go on between vendors. Take the clusterware example - if you run into a problem running RAC on Sun with the Sun Cluster technology and Veritas owning the disk side, who you gonna call? GhostBusters, maybe! But if you're running RAC on Sun with Oracle's clusterware and ASM, it's a lot easier to determine who to call. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Connor McDonald Sent: Saturday, December 20, 2003 2:34 AM To: Multiple recipients of list ORACLE-L As with anything I suppose, if a single vendor can be in control of more of the stack between application and physical server structure then there is a greater opportunity for benefits. For example, ASM offers the ability to add disks to a stripe without needing to redistribute(reload) the entire stripeset. A (bug-free) ASM product looks very very impressive to me. Time will tell how close Oracle are to achieving it. hth connor --- [EMAIL PROTECTED] wrote: > no ASMs are considerably different. Its supposed to > manage everything. You dont give it a file, you give > it entire disks and oracle does everything. Sets up > files, manages, I/O, everything. > > you only look at the tablespace level. you dont even > install any software on it. If your on SAN, you dont > install SAN software on it. > > > > From: "Goulet, Dick" <[EMAIL PROTECTED]> > > Date: 2003/12/19 Fri AM 09:14:27 EST > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > Subject: RE: 10g new features question for beta > testers > > > > That is not exactly a new feature. Oracle 9i has > Oracle Managed Files where you give it a directory > and then just build tablespaces. The database picks > the filenames for you. Now mind you it does work, > but I'll be damned if I use it in anything other > than a development environment. For some reason > Oracle has never gotten over that DUMB SAME (Stripe > And Mirror Everything) idea. The concept is great > in theory, but in practice it's absolutely abysmal > at best. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle Certified 8i DBA > > > > -Original Message- > > Sent: Friday, December 19, 2003 8:24 AM > > To: Multiple recipients of list ORACLE-L > > > > > > I saw a presentation from Oracle on 10g new > features last night in Reston,VA. I know atleast one > other person from the list was there. Since Oracle > is releasing details and its going to be released(in > theory) in the next 2 weeks, I was wondering if you > guys could talk about it. > > > > 1. does ASMs work as well as Oracle claims? I > always wonder about first generation features... > takes most software vendors a couple of generations > to get it right(takes any project Im on just as > long). This is a radical departure. > > > > for those of you who dont know. Oracle claims that > they will manage your disks for you. All you do is > give Oracle some Raw Disks and Oracle will set up, > and handle all your datafiles. All you do is look at > logical tablespaces. It will also handle I/O > balancing. > > > > How well does this work? Anyone test it with a > SAN? > > > > > > 2. RAC Load Balancing. Oracle claims that you only > need Oracle software from now on. They also claim > tha
RE: 10g new features question for beta testers
I was in Reston last night, too. Also, Tom repeatedly emphasized RMAN, which I've not spent enough time mastering, will be even more important in 10g. Does everyone here use RMAN that is using 9i currently? BTW. Tom mentioned SAME, as you say, but I can not remember what he said about it. Sorry. Maybe Ryan remembers? As far as ASM, I thought it was interesting that ASM was supposed to run as additional PMON/SMON processes with separate dynamic V$ views as the API. I was pretty impressed that Tom was spending the week before holidays travelling around and doing Oracle presentations. He is really amazing. Regards, Mike --- "Goulet, Dick" <[EMAIL PROTECTED]> wrote: > That is not exactly a new feature. Oracle 9i has > Oracle Managed Files where you give it a directory > and then just build tablespaces. The database picks > the filenames for you. Now mind you it does work, > but I'll be damned if I use it in anything other > than a development environment. For some reason > Oracle has never gotten over that DUMB SAME (Stripe > And Mirror Everything) idea. The concept is great > in theory, but in practice it's absolutely abysmal > at best. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Friday, December 19, 2003 8:24 AM > To: Multiple recipients of list ORACLE-L > > > I saw a presentation from Oracle on 10g new features > last night in Reston,VA. I know atleast one other > person from the list was there. Since Oracle is > releasing details and its going to be released(in > theory) in the next 2 weeks, I was wondering if you > guys could talk about it. > > 1. does ASMs work as well as Oracle claims? I always > wonder about first generation features... takes most > software vendors a couple of generations to get it > right(takes any project Im on just as long). This is > a radical departure. > > for those of you who dont know. Oracle claims that > they will manage your disks for you. All you do is > give Oracle some Raw Disks and Oracle will set up, > and handle all your datafiles. All you do is look at > logical tablespaces. It will also handle I/O > balancing. > > How well does this work? Anyone test it with a SAN? > > > 2. RAC Load Balancing. Oracle claims that you only > need Oracle software from now on. They also claim > that you can load balance multiple applications. > Lets say you have One application that runs batch > loads over night and a transactional application > during the day oracle will automatically steal > resources from the other when its not busy... > > anyone test this? > > > 3. Flashback database. Kyte was the presenter and he > said that you can keep massive undo areas, so that > if you have a failure or delete data you shouldnt > have you can have oracle automatically write the DML > necessary to bring it back to any point in time. > Kyte said that regular EIDE hard drives that you put > in home PCs are plenty fast enough for most systems. > He recommends getting 4 300 GB drives(1.2 TBs) for > about $1400 to do this and to make tape backups off > of this since they are really slow. > > Can any beta testers comment? > > Im pleased with the rename tablespace feature... > that way I dont have to update TS$ anymore... I > wonder if it was our complaining that got them to > add it :) > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > 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: Goulet, Dick > 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 >
RE: RE: 10g new features question for beta testers
Just a couple of comments on this which hopefully won't go down the Marketing track too far. :) 1. I'm pretty sure Steve Adams agrees with you, since he co-presented on ASM at OracleWorld in San Fran. Not sure if he monitors this group actively or not, but I believe the presentation he did is loaded with all the other OracleWorld 2003 presentations so you can see what he said. 2. One point which makes a lot of sense to me, and it happens in a variety of places in 10g such as ASM and the RAC clusterware. If you have one vendor to raise an issue with (not that you'd need to do that with Oracle of course!), it's a lot easier to get an answer without the finger pointing that can go on between vendors. Take the clusterware example - if you run into a problem running RAC on Sun with the Sun Cluster technology and Veritas owning the disk side, who you gonna call? GhostBusters, maybe! But if you're running RAC on Sun with Oracle's clusterware and ASM, it's a lot easier to determine who to call. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Connor McDonald Sent: Saturday, December 20, 2003 2:34 AM To: Multiple recipients of list ORACLE-L As with anything I suppose, if a single vendor can be in control of more of the stack between application and physical server structure then there is a greater opportunity for benefits. For example, ASM offers the ability to add disks to a stripe without needing to redistribute(reload) the entire stripeset. A (bug-free) ASM product looks very very impressive to me. Time will tell how close Oracle are to achieving it. hth connor --- [EMAIL PROTECTED] wrote: > no ASMs are considerably different. Its supposed to > manage everything. You dont give it a file, you give > it entire disks and oracle does everything. Sets up > files, manages, I/O, everything. > > you only look at the tablespace level. you dont even > install any software on it. If your on SAN, you dont > install SAN software on it. > > > > From: "Goulet, Dick" <[EMAIL PROTECTED]> > > Date: 2003/12/19 Fri AM 09:14:27 EST > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > Subject: RE: 10g new features question for beta > testers > > > > That is not exactly a new feature. Oracle 9i has > Oracle Managed Files where you give it a directory > and then just build tablespaces. The database picks > the filenames for you. Now mind you it does work, > but I'll be damned if I use it in anything other > than a development environment. For some reason > Oracle has never gotten over that DUMB SAME (Stripe > And Mirror Everything) idea. The concept is great > in theory, but in practice it's absolutely abysmal > at best. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle Certified 8i DBA > > > > -Original Message- > > Sent: Friday, December 19, 2003 8:24 AM > > To: Multiple recipients of list ORACLE-L > > > > > > I saw a presentation from Oracle on 10g new > features last night in Reston,VA. I know atleast one > other person from the list was there. Since Oracle > is releasing details and its going to be released(in > theory) in the next 2 weeks, I was wondering if you > guys could talk about it. > > > > 1. does ASMs work as well as Oracle claims? I > always wonder about first generation features... > takes most software vendors a couple of generations > to get it right(takes any project Im on just as > long). This is a radical departure. > > > > for those of you who dont know. Oracle claims that > they will manage your disks for you. All you do is > give Oracle some Raw Disks and Oracle will set up, > and handle all your datafiles. All you do is look at > logical tablespaces. It will also handle I/O > balancing. > > > > How well does this work? Anyone test it with a > SAN? > > > > > > 2. RAC Load Balancing. Oracle claims that you only > need Oracle software from now on. They also claim > that you can load balance multiple applications. > Lets say you have One application that runs batch > loads over night and a transactional application > during the day oracle will automatically steal > resources from the other when its not busy... > > > > anyone test this? > > > > > > 3. Flashback database. Kyte was the presenter and > he said that you can keep massive undo areas, so > that if you have a failure or delete data you > shouldnt have you can have oracle automatically > write the DML necessary to bring
RE: RE: 10g new features question for beta testers
Hi, I sat in a presentation up here in Wisconsin. I got the distinct feeling that most of the new "features" aren't optional. Either you use them or you don't use 10g. I can't remember if ASM was one of those mandatory features. -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA > HUMM, That gives me an even worse feeling. Not something I'll use > that's for sure. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Friday, December 19, 2003 9:45 AM > To: Multiple recipients of list ORACLE-L > > > no ASMs are considerably different. Its supposed to manage > everything. You dont give it a file, you give it entire disks and > oracle does everything. Sets up files, manages, I/O, everything. > > you only look at the tablespace level. you dont even install any > software on it. If your on SAN, you dont install SAN software on it. >> >> From: "Goulet, Dick" <[EMAIL PROTECTED]> >> Date: 2003/12/19 Fri AM 09:14:27 EST >> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >> Subject: RE: 10g new features question for beta testers >> >> That is not exactly a new feature. Oracle 9i has Oracle Managed >> Files where you give it a directory and then just build >> tablespaces. The database picks the filenames for you. Now mind >> you it does work, but I'll be damned if I use it in anything other >> than a development environment. For some reason Oracle has never >> gotten over that DUMB SAME (Stripe And Mirror Everything) idea. >> The concept is great in theory, but in practice it's absolutely >> abysmal at best. >> >> Dick Goulet >> Senior Oracle DBA >> Oracle Certified 8i DBA >> >> -Original Message- >> Sent: Friday, December 19, 2003 8:24 AM >> To: Multiple recipients of list ORACLE-L >> >> >> I saw a presentation from Oracle on 10g new features last night in >> Reston,VA. I know atleast one other person from the list was >> there. Since Oracle is releasing details and its going to be >> released(in theory) in the next 2 weeks, I was wondering if you >> guys could talk about it. >> >> 1. does ASMs work as well as Oracle claims? I always wonder about >> first generation features... takes most software vendors a couple >> of generations to get it right(takes any project Im on just as >> long). This is a radical departure. >> >> for those of you who dont know. Oracle claims that they will >> manage your disks for you. All you do is give Oracle some Raw >> Disks and Oracle will set up, and handle all your datafiles. All >> you do is look at logical tablespaces. It will also handle I/O >> balancing. >> >> How well does this work? Anyone test it with a SAN? >> >> >> 2. RAC Load Balancing. Oracle claims that you only need Oracle >> software from now on. They also claim that you can load balance >> multiple applications. Lets say you have One application that runs >> batch loads over night and a transactional application during the >> day oracle will automatically steal resources from the other >> when its not busy... >> >> anyone test this? >> >> >> 3. Flashback database. Kyte was the presenter and he said that you >> can keep massive undo areas, so that if you have a failure or >> delete data you shouldnt have you can have oracle automatically >> write the DML necessary to bring it back to any point in time. >> Kyte said that regular EIDE hard drives that you put in home PCs >> are plenty fast enough for most systems. He recommends getting 4 >> 300 GB drives(1.2 TBs) for about $1400 to do this and to make tape >> backups off of this since they are really slow. >> >> Can any beta testers comment? >> >> Im pleased with the rename tablespace feature... that way I dont >> have to update TS$ anymore... I wonder if it was our complaining >> that got them to add it :) >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: <[EMAIL PROTECTED] >> 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 'ListG
RE: RE: 10g new features question for beta testers
And the more that vendor, namely the database in this case, controls more and more of the stack the more any performance problem must be a database problem. No thank you. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 10:34 AM To: Multiple recipients of list ORACLE-L As with anything I suppose, if a single vendor can be in control of more of the stack between application and physical server structure then there is a greater opportunity for benefits. For example, ASM offers the ability to add disks to a stripe without needing to redistribute(reload) the entire stripeset. A (bug-free) ASM product looks very very impressive to me. Time will tell how close Oracle are to achieving it. hth connor --- [EMAIL PROTECTED] wrote: > no ASMs are considerably different. Its supposed to > manage everything. You dont give it a file, you give > it entire disks and oracle does everything. Sets up > files, manages, I/O, everything. > > you only look at the tablespace level. you dont even > install any software on it. If your on SAN, you dont > install SAN software on it. > > > > From: "Goulet, Dick" <[EMAIL PROTECTED]> > > Date: 2003/12/19 Fri AM 09:14:27 EST > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > Subject: RE: 10g new features question for beta > testers > > > > That is not exactly a new feature. Oracle 9i has > Oracle Managed Files where you give it a directory > and then just build tablespaces. The database picks > the filenames for you. Now mind you it does work, > but I'll be damned if I use it in anything other > than a development environment. For some reason > Oracle has never gotten over that DUMB SAME (Stripe > And Mirror Everything) idea. The concept is great > in theory, but in practice it's absolutely abysmal > at best. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle Certified 8i DBA > > > > -----Original Message- > > Sent: Friday, December 19, 2003 8:24 AM > > To: Multiple recipients of list ORACLE-L > > > > > > I saw a presentation from Oracle on 10g new > features last night in Reston,VA. I know atleast one > other person from the list was there. Since Oracle > is releasing details and its going to be released(in > theory) in the next 2 weeks, I was wondering if you > guys could talk about it. > > > > 1. does ASMs work as well as Oracle claims? I > always wonder about first generation features... > takes most software vendors a couple of generations > to get it right(takes any project Im on just as > long). This is a radical departure. > > > > for those of you who dont know. Oracle claims that > they will manage your disks for you. All you do is > give Oracle some Raw Disks and Oracle will set up, > and handle all your datafiles. All you do is look at > logical tablespaces. It will also handle I/O > balancing. > > > > How well does this work? Anyone test it with a > SAN? > > > > > > 2. RAC Load Balancing. Oracle claims that you only > need Oracle software from now on. They also claim > that you can load balance multiple applications. > Lets say you have One application that runs batch > loads over night and a transactional application > during the day oracle will automatically steal > resources from the other when its not busy... > > > > anyone test this? > > > > > > 3. Flashback database. Kyte was the presenter and > he said that you can keep massive undo areas, so > that if you have a failure or delete data you > shouldnt have you can have oracle automatically > write the DML necessary to bring it back to any > point in time. Kyte said that regular EIDE hard > drives that you put in home PCs are plenty fast > enough for most systems. He recommends getting 4 300 > GB drives(1.2 TBs) for about $1400 to do this and to > make tape backups off of this since they are really > slow. > > > > Can any beta testers comment? > > > > Im pleased with the rename tablespace feature... > that way I dont have to update TS$ anymore... I > wonder if it was our complaining that got them to > add it :) > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: <[EMAIL PROTECTED] > > 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 f
Re: RE: 10g new features question for beta testers
As with anything I suppose, if a single vendor can be in control of more of the stack between application and physical server structure then there is a greater opportunity for benefits. For example, ASM offers the ability to add disks to a stripe without needing to redistribute(reload) the entire stripeset. A (bug-free) ASM product looks very very impressive to me. Time will tell how close Oracle are to achieving it. hth connor --- [EMAIL PROTECTED] wrote: > no ASMs are considerably different. Its supposed to > manage everything. You dont give it a file, you give > it entire disks and oracle does everything. Sets up > files, manages, I/O, everything. > > you only look at the tablespace level. you dont even > install any software on it. If your on SAN, you dont > install SAN software on it. > > > > From: "Goulet, Dick" <[EMAIL PROTECTED]> > > Date: 2003/12/19 Fri AM 09:14:27 EST > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > Subject: RE: 10g new features question for beta > testers > > > > That is not exactly a new feature. Oracle 9i has > Oracle Managed Files where you give it a directory > and then just build tablespaces. The database picks > the filenames for you. Now mind you it does work, > but I'll be damned if I use it in anything other > than a development environment. For some reason > Oracle has never gotten over that DUMB SAME (Stripe > And Mirror Everything) idea. The concept is great > in theory, but in practice it's absolutely abysmal > at best. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle Certified 8i DBA > > > > -----Original Message- > > Sent: Friday, December 19, 2003 8:24 AM > > To: Multiple recipients of list ORACLE-L > > > > > > I saw a presentation from Oracle on 10g new > features last night in Reston,VA. I know atleast one > other person from the list was there. Since Oracle > is releasing details and its going to be released(in > theory) in the next 2 weeks, I was wondering if you > guys could talk about it. > > > > 1. does ASMs work as well as Oracle claims? I > always wonder about first generation features... > takes most software vendors a couple of generations > to get it right(takes any project Im on just as > long). This is a radical departure. > > > > for those of you who dont know. Oracle claims that > they will manage your disks for you. All you do is > give Oracle some Raw Disks and Oracle will set up, > and handle all your datafiles. All you do is look at > logical tablespaces. It will also handle I/O > balancing. > > > > How well does this work? Anyone test it with a > SAN? > > > > > > 2. RAC Load Balancing. Oracle claims that you only > need Oracle software from now on. They also claim > that you can load balance multiple applications. > Lets say you have One application that runs batch > loads over night and a transactional application > during the day oracle will automatically steal > resources from the other when its not busy... > > > > anyone test this? > > > > > > 3. Flashback database. Kyte was the presenter and > he said that you can keep massive undo areas, so > that if you have a failure or delete data you > shouldnt have you can have oracle automatically > write the DML necessary to bring it back to any > point in time. Kyte said that regular EIDE hard > drives that you put in home PCs are plenty fast > enough for most systems. He recommends getting 4 300 > GB drives(1.2 TBs) for about $1400 to do this and to > make tape backups off of this since they are really > slow. > > > > Can any beta testers comment? > > > > Im pleased with the rename tablespace feature... > that way I dont have to update TS$ anymore... I > wonder if it was our complaining that got them to > add it :) > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: <[EMAIL PROTECTED] > > 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
RE: RE: 10g new features question for beta testers
HUMM, That gives me an even worse feeling. Not something I'll use that's for sure. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 9:45 AM To: Multiple recipients of list ORACLE-L no ASMs are considerably different. Its supposed to manage everything. You dont give it a file, you give it entire disks and oracle does everything. Sets up files, manages, I/O, everything. you only look at the tablespace level. you dont even install any software on it. If your on SAN, you dont install SAN software on it. > > From: "Goulet, Dick" <[EMAIL PROTECTED]> > Date: 2003/12/19 Fri AM 09:14:27 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: 10g new features question for beta testers > > That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you > give it a directory and then just build tablespaces. The database picks the > filenames for you. Now mind you it does work, but I'll be damned if I use it in > anything other than a development environment. For some reason Oracle has never > gotten over that DUMB SAME (Stripe And Mirror Everything) idea. The concept is > great in theory, but in practice it's absolutely abysmal at best. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Friday, December 19, 2003 8:24 AM > To: Multiple recipients of list ORACLE-L > > > I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know > atleast one other person from the list was there. Since Oracle is releasing details > and its going to be released(in theory) in the next 2 weeks, I was wondering if you > guys could talk about it. > > 1. does ASMs work as well as Oracle claims? I always wonder about first generation > features... takes most software vendors a couple of generations to get it > right(takes any project Im on just as long). This is a radical departure. > > for those of you who dont know. Oracle claims that they will manage your disks for > you. All you do is give Oracle some Raw Disks and Oracle will set up, and handle all > your datafiles. All you do is look at logical tablespaces. It will also handle I/O > balancing. > > How well does this work? Anyone test it with a SAN? > > > 2. RAC Load Balancing. Oracle claims that you only need Oracle software from now on. > They also claim that you can load balance multiple applications. Lets say you have > One application that runs batch loads over night and a transactional application > during the day oracle will automatically steal resources from the other when its > not busy... > > anyone test this? > > > 3. Flashback database. Kyte was the presenter and he said that you can keep massive > undo areas, so that if you have a failure or delete data you shouldnt have you can > have oracle automatically write the DML necessary to bring it back to any point in > time. Kyte said that regular EIDE hard drives that you put in home PCs are plenty > fast enough for most systems. He recommends getting 4 300 GB drives(1.2 TBs) for > about $1400 to do this and to make tape backups off of this since they are really > slow. > > Can any beta testers comment? > > Im pleased with the rename tablespace feature... that way I dont have to update TS$ > anymore... I wonder if it was our complaining that got them to add it :) > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > 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: Goulet, Dick > 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
Re: RE: 10g new features question for beta testers
no ASMs are considerably different. Its supposed to manage everything. You dont give it a file, you give it entire disks and oracle does everything. Sets up files, manages, I/O, everything. you only look at the tablespace level. you dont even install any software on it. If your on SAN, you dont install SAN software on it. > > From: "Goulet, Dick" <[EMAIL PROTECTED]> > Date: 2003/12/19 Fri AM 09:14:27 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: 10g new features question for beta testers > > That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you > give it a directory and then just build tablespaces. The database picks the > filenames for you. Now mind you it does work, but I'll be damned if I use it in > anything other than a development environment. For some reason Oracle has never > gotten over that DUMB SAME (Stripe And Mirror Everything) idea. The concept is > great in theory, but in practice it's absolutely abysmal at best. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Friday, December 19, 2003 8:24 AM > To: Multiple recipients of list ORACLE-L > > > I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know > atleast one other person from the list was there. Since Oracle is releasing details > and its going to be released(in theory) in the next 2 weeks, I was wondering if you > guys could talk about it. > > 1. does ASMs work as well as Oracle claims? I always wonder about first generation > features... takes most software vendors a couple of generations to get it > right(takes any project Im on just as long). This is a radical departure. > > for those of you who dont know. Oracle claims that they will manage your disks for > you. All you do is give Oracle some Raw Disks and Oracle will set up, and handle all > your datafiles. All you do is look at logical tablespaces. It will also handle I/O > balancing. > > How well does this work? Anyone test it with a SAN? > > > 2. RAC Load Balancing. Oracle claims that you only need Oracle software from now on. > They also claim that you can load balance multiple applications. Lets say you have > One application that runs batch loads over night and a transactional application > during the day oracle will automatically steal resources from the other when its > not busy... > > anyone test this? > > > 3. Flashback database. Kyte was the presenter and he said that you can keep massive > undo areas, so that if you have a failure or delete data you shouldnt have you can > have oracle automatically write the DML necessary to bring it back to any point in > time. Kyte said that regular EIDE hard drives that you put in home PCs are plenty > fast enough for most systems. He recommends getting 4 300 GB drives(1.2 TBs) for > about $1400 to do this and to make tape backups off of this since they are really > slow. > > Can any beta testers comment? > > Im pleased with the rename tablespace feature... that way I dont have to update TS$ > anymore... I wonder if it was our complaining that got them to add it :) > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > 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: Goulet, Dick > 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: <[EMAIL PROTECTED] INET
RE: 10g new features question for beta testers
That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces. The database picks the filenames for you. Now mind you it does work, but I'll be damned if I use it in anything other than a development environment. For some reason Oracle has never gotten over that DUMB SAME (Stripe And Mirror Everything) idea. The concept is great in theory, but in practice it's absolutely abysmal at best. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 8:24 AM To: Multiple recipients of list ORACLE-L I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know atleast one other person from the list was there. Since Oracle is releasing details and its going to be released(in theory) in the next 2 weeks, I was wondering if you guys could talk about it. 1. does ASMs work as well as Oracle claims? I always wonder about first generation features... takes most software vendors a couple of generations to get it right(takes any project Im on just as long). This is a radical departure. for those of you who dont know. Oracle claims that they will manage your disks for you. All you do is give Oracle some Raw Disks and Oracle will set up, and handle all your datafiles. All you do is look at logical tablespaces. It will also handle I/O balancing. How well does this work? Anyone test it with a SAN? 2. RAC Load Balancing. Oracle claims that you only need Oracle software from now on. They also claim that you can load balance multiple applications. Lets say you have One application that runs batch loads over night and a transactional application during the day oracle will automatically steal resources from the other when its not busy... anyone test this? 3. Flashback database. Kyte was the presenter and he said that you can keep massive undo areas, so that if you have a failure or delete data you shouldnt have you can have oracle automatically write the DML necessary to bring it back to any point in time. Kyte said that regular EIDE hard drives that you put in home PCs are plenty fast enough for most systems. He recommends getting 4 300 GB drives(1.2 TBs) for about $1400 to do this and to make tape backups off of this since they are really slow. Can any beta testers comment? Im pleased with the rename tablespace feature... that way I dont have to update TS$ anymore... I wonder if it was our complaining that got them to add it :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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: Goulet, Dick 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).
10g new features question for beta testers
I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know atleast one other person from the list was there. Since Oracle is releasing details and its going to be released(in theory) in the next 2 weeks, I was wondering if you guys could talk about it. 1. does ASMs work as well as Oracle claims? I always wonder about first generation features... takes most software vendors a couple of generations to get it right(takes any project Im on just as long). This is a radical departure. for those of you who dont know. Oracle claims that they will manage your disks for you. All you do is give Oracle some Raw Disks and Oracle will set up, and handle all your datafiles. All you do is look at logical tablespaces. It will also handle I/O balancing. How well does this work? Anyone test it with a SAN? 2. RAC Load Balancing. Oracle claims that you only need Oracle software from now on. They also claim that you can load balance multiple applications. Lets say you have One application that runs batch loads over night and a transactional application during the day oracle will automatically steal resources from the other when its not busy... anyone test this? 3. Flashback database. Kyte was the presenter and he said that you can keep massive undo areas, so that if you have a failure or delete data you shouldnt have you can have oracle automatically write the DML necessary to bring it back to any point in time. Kyte said that regular EIDE hard drives that you put in home PCs are plenty fast enough for most systems. He recommends getting 4 300 GB drives(1.2 TBs) for about $1400 to do this and to make tape backups off of this since they are really slow. Can any beta testers comment? Im pleased with the rename tablespace feature... that way I dont have to update TS$ anymore... I wonder if it was our complaining that got them to add it :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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: 10g new features (was: dc_used_extents ,dc_free_extents
Hi! > Tanel, > Thanks for sharing the presentation in the 10g features. > I started looking at the slides and I have a question about the "cross > platform transportable tablespaces" and the command you used. > From what I gather in the command I can take a Unix based datafile and > convert it to a "Microsoft Windows NT" > format just by quoting the destination OS type and version? Then > basically I have to copy the converted datafile to the new OS and > recognize the datafile by the new OS to have to data available? How is > this possible? the different OS's use different storage (fat's, inodes) > unless it converts it into a common format like ASCII. Do you have to > perform and "conversion" on the new OS when the file is copied over? For No, contents of a file are just a sequence of bytes. No fats, no inodes. These are file system internal mechanisms to keep track about file chunks on a device. As I understand, convert tablespace does just little-endian to big-endian conversion (or vice versa) for appropriate datatypes, maybe something in the datafile header as well. > query purposes why not use a DBLINK? I think it would be faster. I can > understand some complicated actions and wanting to keep the data > separate between platforms or if you wanted to migrate between > platforms. Other than that reason I am finding it difficult to > understand the full advantage for this feature. You might be right, direct load inserts over dblinks can be quite fast and they don't require intermediate storage+disk IO capacity for transferring data. But within SAN environment you can just mount your device with converted file elsewhere, here we might have more benefit from transportable tablespaces. I depends on environment, which method will be faster for data transfer, I think. Also, 10g's data pump with it's direct read & load capabilities will change the picture. > > I think that the online segment shrink is a nice feature but as I > understand the feature, it requires the use of RAW devices. Is this > correct? The RAW device must have a portion of the disk allocated for > the max size file before the shrink or else the disk could be clobbered > by creating a file on the device. No, the segment is shrunk within Oracle datafile, it doesn't matter on which storage layer they lie. > No SQLPLUSW for windows? Is this because of a browser based access to > the sqlplus function? SQLPLUSW was quite crappy, I've never used it anyway, regular sqlplus on cmd.exe will do the job just fine. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: 10g new features (was: dc_used_extents ,dc_free_extents
Tanel, Thanks for sharing the presentation in the 10g features. I started looking at the slides and I have a question about the "cross platform transportable tablespaces" and the command you used. From what I gather in the command I can take a Unix based datafile and convert it to a "Microsoft Windows NT" format just by quoting the destination OS type and version? Then basically I have to copy the converted datafile to the new OS and recognize the datafile by the new OS to have to data available? How is this possible? the different OS's use different storage (fat's, inodes) unless it converts it into a common format like ASCII. Do you have to perform and "conversion" on the new OS when the file is copied over? For query purposes why not use a DBLINK? I think it would be faster. I can understand some complicated actions and wanting to keep the data separate between platforms or if you wanted to migrate between platforms. Other than that reason I am finding it difficult to understand the full advantage for this feature. I think that the online segment shrink is a nice feature but as I understand the feature, it requires the use of RAW devices. Is this correct? The RAW device must have a portion of the disk allocated for the max size file before the shrink or else the disk could be clobbered by creating a file on the device. No SQLPLUSW for windows? Is this because of a browser based access to the sqlplus function? Just a few question. Thanks for sharing the knowledge. Ron >>> [EMAIL PROTECTED] 12/10/2003 4:34:25 PM >>> > Pete, I'd like to clarify my position first: I don't have any burning problem > that would compel me to start testing 10g. I want only to learn the new > features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my presentations from: http://integrid.info/Poder_10g_New_Features.ppt Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Ron Rogers 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: 10g new features (was: dc_used_extents ,dc_free_extents and d
Yes .. that is good. GovindanK On Wed, 10 Dec 2003 13:44:34 -0800, "Freeman Robert - IL" <[EMAIL PROTECTED]> said: > Excellent slide show Tanel! > > Robert > > -Original Message- > To: Multiple recipients of list ORACLE-L > Sent: 12/10/2003 3:34 PM > dc_histogram_defs) > > > Pete, I'd like to clarify my position first: I don't have any burning > problem > > that would compel me to start testing 10g. I want only to learn the > new > > features. > > Btw, if you want to learn some of the 10g database engine new features > (not > the marketing buzzwords), then check out one of my presentations from: > > http://integrid.info/Poder_10g_New_Features.ppt > > Tanel. > > > -- -- http://www.fastmail.fm - A no graphics, no pop-ups email service -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK 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: 10g new features (was: dc_used_extents ,dc_free_extents and d
I concur. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 11:44 PM > Excellent slide show Tanel! > > Robert > > -Original Message- > To: Multiple recipients of list ORACLE-L > Sent: 12/10/2003 3:34 PM > dc_histogram_defs) > > > Pete, I'd like to clarify my position first: I don't have any burning > problem > > that would compel me to start testing 10g. I want only to learn the > new > > features. > > Btw, if you want to learn some of the 10g database engine new features > (not > the marketing buzzwords), then check out one of my presentations from: > > http://integrid.info/Poder_10g_New_Features.ppt > > Tanel. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tanel Poder > 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: Yechiel Adar 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: 10g new features (was: dc_used_extents ,dc_free_extents and d
Yep, sqlplus.exe will still be there. Otherwise one wouln't be able to run any automated sql scripts, because isqlplus can't do it as far as I understand. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 11, 2003 12:04 AM > Tanel, > > Whthough they may not have the sqlplusw.exe for windoes is the sqlplus.exe still there? > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Wednesday, December 10, 2003 4:45 PM > To: Multiple recipients of list ORACLE-L > d > > > Excellent slide show Tanel! > > Robert > > -Original Message- > To: Multiple recipients of list ORACLE-L > Sent: 12/10/2003 3:34 PM > dc_histogram_defs) > > > Pete, I'd like to clarify my position first: I don't have any burning > problem > > that would compel me to start testing 10g. I want only to learn the > new > > features. > > Btw, if you want to learn some of the 10g database engine new features > (not > the marketing buzzwords), then check out one of my presentations from: > > http://integrid.info/Poder_10g_New_Features.ppt > > Tanel. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tanel Poder > 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: Goulet, Dick > 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: Tanel Poder 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: 10g new features (was: dc_used_extents ,dc_free_extents and d
Robert, Robert, Robert, when will you ever learn? You've been listening to the marketing people again. :) The whole goal behind this part of the release is not to make the database look easy to manage (which is good because I've never thought it WAS difficult to manage!) It's for those lower end customers who may not have the requirement for a full-time DBA. The idea is to set as few parameters as needed by having sensible defaults (whether they ARE sensible or not is a separate argument), while still having the full power and flexibility of all the other parameters for those lucky DBA's who have more complex systems to manage. Make more sense? I can see I'm gonna have to keep a VERY close eye on you if we ever get around to writing our 10g book! :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Freeman Robert - IL Sent: Thursday, December 11, 2003 10:40 AM To: Multiple recipients of list ORACLE-L d >> Doesn't matter if there's 30 or 300, you don't usually mess with >> them other than at database create time. Shh Oracle thinks this is a marketing coup They want to make the database look easy to manage... "Parameters? Ha, you only need configure a few basic parameters and the database will take care of itself." WHEN PIGS FLY This just speaks to the general management desire to push costs down stream Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/10/2003 5:24 PM dc_histogram_defs) Much seems to be made of this 'less than 30 init parameter to tune'. Who really spends much time doing that anyway? If you do, you're probably going after the wrong end of a problem. Doesn't matter if there's 30 or 300, you don't usually mess with them other than at database create time. Jared "Tanel Poder" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/10/2003 01:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs) > Pete, I'd like to clarify my position first: I don't have any burning problem > that would compel me to start testing 10g. I want only to learn the new > features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my presentations from: http://integrid.info/Poder_10g_New_Features.ppt Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Pete Sharman 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: 10g new features (was: dc_used_extents ,dc_free_extents and d
>> Doesn't matter if there's 30 or 300, you don't usually mess with >> them other than at database create time. Shh Oracle thinks this is a marketing coup They want to make the database look easy to manage... "Parameters? Ha, you only need configure a few basic parameters and the database will take care of itself." WHEN PIGS FLY This just speaks to the general management desire to push costs down stream Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/10/2003 5:24 PM dc_histogram_defs) Much seems to be made of this 'less than 30 init parameter to tune'. Who really spends much time doing that anyway? If you do, you're probably going after the wrong end of a problem. Doesn't matter if there's 30 or 300, you don't usually mess with them other than at database create time. Jared "Tanel Poder" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/10/2003 01:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs) > Pete, I'd like to clarify my position first: I don't have any burning problem > that would compel me to start testing 10g. I want only to learn the new > features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my presentations from: http://integrid.info/Poder_10g_New_Features.ppt Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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).
Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs)
Much seems to be made of this 'less than 30 init parameter to tune'. Who really spends much time doing that anyway? If you do, you're probably going after the wrong end of a problem. Doesn't matter if there's 30 or 300, you don't usually mess with them other than at database create time. Jared "Tanel Poder" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/10/2003 01:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs) > Pete, I'd like to clarify my position first: I don't have any burning problem > that would compel me to start testing 10g. I want only to learn the new > features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my presentations from: http://integrid.info/Poder_10g_New_Features.ppt Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs)
On 12/10/2003 04:34:25 PM, Tanel Poder wrote: > > Pete, I'd like to clarify my position first: I don't have any burning > problem > > that would compel me to start testing 10g. I want only to learn the new > > features. > > Btw, if you want to learn some of the 10g database engine new features (not > the marketing buzzwords), then check out one of my presentations from: > > http://integrid.info/Poder_10g_New_Features.ppt > > Tanel. I've checked enough articles, presentations and white papers. It doesn't mean anything without being able to try them. That, precisely, is my beef with the whole "beta process". Thanks for the offer, though. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tanel Poder > 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 Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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).
RE: 10g new features (was: dc_used_extents ,dc_free_extents and d
Tanel, Whthough they may not have the sqlplusw.exe for windoes is the sqlplus.exe still there? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, December 10, 2003 4:45 PM To: Multiple recipients of list ORACLE-L d Excellent slide show Tanel! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/10/2003 3:34 PM dc_histogram_defs) > Pete, I'd like to clarify my position first: I don't have any burning problem > that would compel me to start testing 10g. I want only to learn the new > features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my presentations from: http://integrid.info/Poder_10g_New_Features.ppt Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Goulet, Dick 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: 10g new features (was: dc_used_extents ,dc_free_extents and d
Excellent slide show Tanel! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/10/2003 3:34 PM dc_histogram_defs) > Pete, I'd like to clarify my position first: I don't have any burning problem > that would compel me to start testing 10g. I want only to learn the new > features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my presentations from: http://integrid.info/Poder_10g_New_Features.ppt Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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).
Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs)
> Pete, I'd like to clarify my position first: I don't have any burning problem > that would compel me to start testing 10g. I want only to learn the new > features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my presentations from: http://integrid.info/Poder_10g_New_Features.ppt Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: 10g new features
Hi, Gopa: I ever saw you can rename tablespace via transportable tablespace via edit the dmp file and reimport metadata into database. But it is not one command line. How do you rename tablespace in 9i? I tested rename tablespace in 10i beta1 and found rename tablespace does update sys.ts$ and with a few check. In fact, without transfer data between database, I do not see any usage of renaming tablespace in a production database. Like to flush the data buffer in 10g as a so called new-feature. Regards. Zhu Chao. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, November 04, 2003 5:29 PM > Yong: > > I was not joking. Actually there is a command to rename tablespaces in 9i > and that is undocumented. IIRC it is with some FROM and TO options or > something similar to that. > > Let me check that come back to you offline.. > > KG > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, November 04, 2003 9:39 AM > > > > Gopal was joking about the fact that Jared only said 'alter tablespace > rename' > > instead of ALTER TABLESPACE RENAME DATAFILE. > > > > In fact, 9.2 SQL Reference has this > > > > Moving and Renaming Tablespaces: Example > > This example moves and renames a datafile associated with the tbs_01 > tablespace > > from 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat': > > > > If you only read the subtitle here (first line), you *will* be surprised. > > > > Yong > > > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > > Actually, I don't understand what you mean. Here is 9.2: > > > > > > SQL> create tablespace test datafile '/data/oradata/data/test01.dbf' > > > 2 size 10M extent management local autoallocate > > > 3 segment space management auto; > > > > > > Tablespace created. > > > > > > SQL> alter tablespace test rename to test01; > > > alter tablespace test rename to test01 > > > * > > > ERROR at line 1: > > > ORA-01904: DATAFILE keyword expected > > > > > > > > > SQL> > > > > > > > > > So, what did you mean? > > > > > > On 2003.11.03 21:59, K Gopalakrishnan wrote: > > > > Jared: > > > > > > > > 'alter tablespace rename' is not the REAL 10g feature. It is available > > > > from 9.2 onwards... :) Hope you know what I mean,, > > > > > > > > KG > > > > > > > > - Original Message - > > > > From: [EMAIL PROTECTED] > > > > To: Multiple recipients of list ORACLE-L > > > > Sent: Tuesday, November 04, 2003 12:54 AM > > > > Subject: 10g new features > > > > > > > > > > > > > > > > Found a site with some 10g new features. > > > > > > > > http://www.adp-gmbh.ch/ora/misc/10g.html > > > > > > > > I'm sure some will like the new 'alter tablespace rename' > > > > > > > > http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux > > > > > > > > > > > > Jared > > > > > > -- > > > 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). > > > > > > __ > > Do you Yahoo!? > > Protect your identity with Yahoo! Mail AddressGuard > > http://antispam.yahoo.com/whatsnewfree > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Yong Huang > > INET: [EMAIL PROTECTED] > > > > Fa
Re: 10g new features
... and now printed and nicely bound. :) "Tanel Poder" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/04/2003 02:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: 10g new features Exactly, until the doc is in google's cache, you still can get the HTML version. I thought that anyone keen enough to have this doc would figure it out :) Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 10:49 PM Subject: Re: 10g new features The link is dead. :( But thanks to the googlecache effect, you can still see the doc: http://216.239.57.104/search?q=cache:UVsNMDV-OBIJ:www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf+Oracle10g_New_Features.pdf&hl=en&ie=UTF-8 Jared "Tanel Poder" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/04/2003 12:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: 10g new features Btw, bold guys from Polish Oracle User Group have put out Oracle's 10g New Features beta documentation at their website... http://www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf I already sent a notification to PLOUG to remove this doc immediately, because I'm affiliated with European Oracle User Group myself and would not like if PLOUG would get into trouble. But anyway, take the most out of this URL, it might not last for long ;) Tanel. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 8:04 PM Subject: RE: 10g new features Oh My ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: 10g new features OK KG, the cat is out of the bag. Now you have to tell all of us. Especially Raj. :) Jared ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5
Re: 10g new features
Exactly, until the doc is in google's cache, you still can get the HTML version. I thought that anyone keen enough to have this doc would figure it out :) Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 10:49 PM Subject: Re: 10g new features The link is dead. :( But thanks to the googlecache effect, you can still see the doc: http://216.239.57.104/search?q=cache:UVsNMDV-OBIJ:www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf+Oracle10g_New_Features.pdf&hl=en&ie=UTF-8 Jared "Tanel Poder" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/04/2003 12:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: 10g new featuresBtw, bold guys from Polish Oracle User Group have put out Oracle's 10g New Features beta documentation at their website... http://www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf I already sent a notification to PLOUG to remove this doc immediately, because I'm affiliated with European Oracle User Group myself and would not like if PLOUG would get into trouble. But anyway, take the most out of this URL, it might not last for long ;) Tanel. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 8:04 PM Subject: RE: 10g new features Oh My ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, November 04, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: Re: 10g new featuresOK KG, the cat is out of the bag. Now you have to tell all of us. Especially Raj. :) Jared **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**5
Re: 10g new features
The link is dead. :( But thanks to the googlecache effect, you can still see the doc: http://216.239.57.104/search?q=cache:UVsNMDV-OBIJ:www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf+Oracle10g_New_Features.pdf&hl=en&ie=UTF-8 Jared "Tanel Poder" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/04/2003 12:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: 10g new features Btw, bold guys from Polish Oracle User Group have put out Oracle's 10g New Features beta documentation at their website... http://www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf I already sent a notification to PLOUG to remove this doc immediately, because I'm affiliated with European Oracle User Group myself and would not like if PLOUG would get into trouble. But anyway, take the most out of this URL, it might not last for long ;) Tanel. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 8:04 PM Subject: RE: 10g new features Oh My ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: 10g new features OK KG, the cat is out of the bag. Now you have to tell all of us. Especially Raj. :) Jared ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5
Re: 10g new features
Btw, bold guys from Polish Oracle User Group have put out Oracle's 10g New Features beta documentation at their website... http://www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf I already sent a notification to PLOUG to remove this doc immediately, because I'm affiliated with European Oracle User Group myself and would not like if PLOUG would get into trouble. But anyway, take the most out of this URL, it might not last for long ;) Tanel. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 8:04 PM Subject: RE: 10g new features Oh My ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, November 04, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: Re: 10g new featuresOK KG, the cat is out of the bag. Now you have to tell all of us. Especially Raj. :) Jared **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**5
Re: 10g new features
Yup, out of bag, definitely. I already scanned through v$reserved_words to find anything usable with alter tablespace (or perhaps database), but no luck. However, words such "undrop" and "disk group" are already reserved in 9.2.0.4 ;-9 Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 7:24 PM Subject: Re: 10g new features OK KG, the cat is out of the bag. Now you have to tell all of us. Especially Raj. :) Jared "K Gopalakrishnan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/04/2003 01:29 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: 10g new featuresYong:I was not joking. Actually there is a command to rename tablespaces in 9iand that is undocumented. IIRC it is with some FROM and TO options orsomething similar to that.Let me check that come back to you offline..KG- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Tuesday, November 04, 2003 9:39 AM> Gopal was joking about the fact that Jared only said 'alter tablespacerename'> instead of ALTER TABLESPACE RENAME DATAFILE.>> In fact, 9.2 SQL Reference has this>> Moving and Renaming Tablespaces: Example> This example moves and renames a datafile associated with the tbs_01tablespace> from 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat':>> If you only read the subtitle here (first line), you *will* be surprised.>> Yong>> --- Mladen Gogala <[EMAIL PROTECTED]> wrote:> > Actually, I don't understand what you mean. Here is 9.2:> >> > SQL> create tablespace test datafile '/data/oradata/data/test01.dbf'> > 2 size 10M extent management local autoallocate> > 3 segment space management auto;> >> > Tablespace created.> >> > SQL> alter tablespace test rename to test01;> > alter tablespace test rename to test01> > *> > ERROR at line 1:> > ORA-01904: DATAFILE keyword expected> >> >> > SQL>> >> >> > So, what did you mean?> >> > On 2003.11.03 21:59, K Gopalakrishnan wrote:> > > Jared:> > >> > > 'alter tablespace rename' is not the REAL 10g feature. It is available> > > from 9.2 onwards... :) Hope you know what I mean,,> > >> > > KG> > >> > > - Original Message -> > > From: [EMAIL PROTECTED]> > > To: Multiple recipients of list ORACLE-L> > > Sent: Tuesday, November 04, 2003 12:54 AM> > > Subject: 10g new features> > >> > >> > >> > > Found a site with some 10g new features.> > >> > > http://www.adp-gmbh.ch/ora/misc/10g.html> > >> > > I'm sure some will like the new 'alter tablespace rename'> > >> > > http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux> > >> > >> > > Jared> >> > -- > > 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).>>> __> Do you Yahoo!?> Protect your identity with Yahoo! Mail AddressGuard> http://antispam.yahoo.com/whatsnewfree> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net> -- > Author: Yong Huang> INET: [EMAIL PROTECTED]>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com> San Diego, California -- Mailing list and web hosting services> ---
RE: 10g new features
Oh My ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, November 04, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: Re: 10g new featuresOK KG, the cat is out of the bag. Now you have to tell all of us. Especially Raj. :) Jared **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**5
Re: 10g new features
OK KG, the cat is out of the bag. Now you have to tell all of us. Especially Raj. :) Jared "K Gopalakrishnan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/04/2003 01:29 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: 10g new features Yong: I was not joking. Actually there is a command to rename tablespaces in 9i and that is undocumented. IIRC it is with some FROM and TO options or something similar to that. Let me check that come back to you offline.. KG - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, November 04, 2003 9:39 AM > Gopal was joking about the fact that Jared only said 'alter tablespace rename' > instead of ALTER TABLESPACE RENAME DATAFILE. > > In fact, 9.2 SQL Reference has this > > Moving and Renaming Tablespaces: Example > This example moves and renames a datafile associated with the tbs_01 tablespace > from 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat': > > If you only read the subtitle here (first line), you *will* be surprised. > > Yong > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > Actually, I don't understand what you mean. Here is 9.2: > > > > SQL> create tablespace test datafile '/data/oradata/data/test01.dbf' > > 2 size 10M extent management local autoallocate > > 3 segment space management auto; > > > > Tablespace created. > > > > SQL> alter tablespace test rename to test01; > > alter tablespace test rename to test01 > > * > > ERROR at line 1: > > ORA-01904: DATAFILE keyword expected > > > > > > SQL> > > > > > > So, what did you mean? > > > > On 2003.11.03 21:59, K Gopalakrishnan wrote: > > > Jared: > > > > > > 'alter tablespace rename' is not the REAL 10g feature. It is available > > > from 9.2 onwards... :) Hope you know what I mean,, > > > > > > KG > > > > > > - Original Message - > > > From: [EMAIL PROTECTED] > > > To: Multiple recipients of list ORACLE-L > > > Sent: Tuesday, November 04, 2003 12:54 AM > > > Subject: 10g new features > > > > > > > > > > > > Found a site with some 10g new features. > > > > > > http://www.adp-gmbh.ch/ora/misc/10g.html > > > > > > I'm sure some will like the new 'alter tablespace rename' > > > > > > http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux > > > > > > > > > Jared > > > > -- > > 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). > > > __ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Yong Huang > 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: K Gopalakrishnan 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: 10g new features
>I was not joking. Actually there is a command to rename tablespaces in 9i >and that is undocumented. IIRC it is with some FROM and TO options or >something similar to that. > >Let me check that come back to you offline.. ^^ > Gopal, please let us all know! I personally like to know about undocumented features. Kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: 10g new features
Yong: I was not joking. Actually there is a command to rename tablespaces in 9i and that is undocumented. IIRC it is with some FROM and TO options or something similar to that. Let me check that come back to you offline.. KG - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, November 04, 2003 9:39 AM > Gopal was joking about the fact that Jared only said 'alter tablespace rename' > instead of ALTER TABLESPACE RENAME DATAFILE. > > In fact, 9.2 SQL Reference has this > > Moving and Renaming Tablespaces: Example > This example moves and renames a datafile associated with the tbs_01 tablespace > from 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat': > > If you only read the subtitle here (first line), you *will* be surprised. > > Yong > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > Actually, I don't understand what you mean. Here is 9.2: > > > > SQL> create tablespace test datafile '/data/oradata/data/test01.dbf' > > 2 size 10M extent management local autoallocate > > 3 segment space management auto; > > > > Tablespace created. > > > > SQL> alter tablespace test rename to test01; > > alter tablespace test rename to test01 > > * > > ERROR at line 1: > > ORA-01904: DATAFILE keyword expected > > > > > > SQL> > > > > > > So, what did you mean? > > > > On 2003.11.03 21:59, K Gopalakrishnan wrote: > > > Jared: > > > > > > 'alter tablespace rename' is not the REAL 10g feature. It is available > > > from 9.2 onwards... :) Hope you know what I mean,, > > > > > > KG > > > > > > - Original Message - > > > From: [EMAIL PROTECTED] > > > To: Multiple recipients of list ORACLE-L > > > Sent: Tuesday, November 04, 2003 12:54 AM > > > Subject: 10g new features > > > > > > > > > > > > Found a site with some 10g new features. > > > > > > http://www.adp-gmbh.ch/ora/misc/10g.html > > > > > > I'm sure some will like the new 'alter tablespace rename' > > > > > > http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux > > > > > > > > > Jared > > > > -- > > 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). > > > __ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Yong Huang > 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: K Gopalakrishnan 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: 10g new features
Yes, I think you must be right. It's late, and I've been playing with indexes for a couple hours. Jared On Mon, 2003-11-03 at 20:44, Yong Huang wrote: > How can *you* not get it? Gopal says in Oracle 9.2, 'alter tablespace rename' > is possible. Of course. The full syntax is alter tablespace mytablespace rename > datafile '/path/file.dbf' to '/path/newfile.dbf'. You see the three words > 'alter', 'tablespace' and 'rename' in there? > > You'll get it in the morning. homo sapien think better during the day. > > Yong > > > --- Jared Still <[EMAIL PROTECTED]> wrote: > > Not sure I get it either. :) > > > > The command listed on the 10g site that I referred to is this: > > > > alter tablespace ts_user rename to ts_user_01; > > > > Renaming a tablespace is apparently possible with 10g. > > > > Must be a joke here somewhere I'm missing. > > > > Jared > > > > > > On Mon, 2003-11-03 at 20:09, Yong Huang wrote: > > > Gopal was joking about the fact that Jared only said 'alter tablespace > > rename' > > > instead of ALTER TABLESPACE RENAME DATAFILE. > > > > > > In fact, 9.2 SQL Reference has this > > > > > > Moving and Renaming Tablespaces: Example > > > This example moves and renames a datafile associated with the tbs_01 > > tablespace > > > from 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat': > > > > > > If you only read the subtitle here (first line), you *will* be surprised. > > > > > > Yong > > > > > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > > > Actually, I don't understand what you mean. Here is 9.2: > > > > > > > > SQL> create tablespace test datafile '/data/oradata/data/test01.dbf' > > > > 2 size 10M extent management local autoallocate > > > > 3 segment space management auto; > > > > > > > > Tablespace created. > > > > > > > > SQL> alter tablespace test rename to test01; > > > > alter tablespace test rename to test01 > > > > * > > > > ERROR at line 1: > > > > ORA-01904: DATAFILE keyword expected > > > > > > > > > > > > SQL> > > > > > > > > > > > > So, what did you mean? > > > > > > > > On 2003.11.03 21:59, K Gopalakrishnan wrote: > > > > > Jared: > > > > > > > > > > 'alter tablespace rename' is not the REAL 10g feature. It is available > > > > > from 9.2 onwards... :) Hope you know what I mean,, > > > > > > > > > > KG > > > > > > > > > > - Original Message - > > > > > From: [EMAIL PROTECTED] > > > > > To: Multiple recipients of list ORACLE-L > > > > > Sent: Tuesday, November 04, 2003 12:54 AM > > > > > Subject: 10g new features > > > > > > > > > > > > > > > > > > > > Found a site with some 10g new features. > > > > > > > > > > http://www.adp-gmbh.ch/ora/misc/10g.html > > > > > > > > > > I'm sure some will like the new 'alter tablespace rename' > > > > > > > > > > http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux > > > > > > > > > > > > > > > Jared > > > > > > > > -- > > > > 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
Re: 10g new features
How can *you* not get it? Gopal says in Oracle 9.2, 'alter tablespace rename' is possible. Of course. The full syntax is alter tablespace mytablespace rename datafile '/path/file.dbf' to '/path/newfile.dbf'. You see the three words 'alter', 'tablespace' and 'rename' in there? You'll get it in the morning. homo sapien think better during the day. Yong --- Jared Still <[EMAIL PROTECTED]> wrote: > Not sure I get it either. :) > > The command listed on the 10g site that I referred to is this: > > alter tablespace ts_user rename to ts_user_01; > > Renaming a tablespace is apparently possible with 10g. > > Must be a joke here somewhere I'm missing. > > Jared > > > On Mon, 2003-11-03 at 20:09, Yong Huang wrote: > > Gopal was joking about the fact that Jared only said 'alter tablespace > rename' > > instead of ALTER TABLESPACE RENAME DATAFILE. > > > > In fact, 9.2 SQL Reference has this > > > > Moving and Renaming Tablespaces: Example > > This example moves and renames a datafile associated with the tbs_01 > tablespace > > from 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat': > > > > If you only read the subtitle here (first line), you *will* be surprised. > > > > Yong > > > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > > Actually, I don't understand what you mean. Here is 9.2: > > > > > > SQL> create tablespace test datafile '/data/oradata/data/test01.dbf' > > > 2 size 10M extent management local autoallocate > > > 3 segment space management auto; > > > > > > Tablespace created. > > > > > > SQL> alter tablespace test rename to test01; > > > alter tablespace test rename to test01 > > > * > > > ERROR at line 1: > > > ORA-01904: DATAFILE keyword expected > > > > > > > > > SQL> > > > > > > > > > So, what did you mean? > > > > > > On 2003.11.03 21:59, K Gopalakrishnan wrote: > > > > Jared: > > > > > > > > 'alter tablespace rename' is not the REAL 10g feature. It is available > > > > from 9.2 onwards... :) Hope you know what I mean,, > > > > > > > > KG > > > > > > > > - Original Message - > > > > From: [EMAIL PROTECTED] > > > > To: Multiple recipients of list ORACLE-L > > > > Sent: Tuesday, November 04, 2003 12:54 AM > > > > Subject: 10g new features > > > > > > > > > > > > > > > > Found a site with some 10g new features. > > > > > > > > http://www.adp-gmbh.ch/ora/misc/10g.html > > > > > > > > I'm sure some will like the new 'alter tablespace rename' > > > > > > > > http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux > > > > > > > > > > > > Jared > > > > > > -- > > > 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). > > > > > > __ > > Do you Yahoo!? > > Protect your identity with Yahoo! Mail AddressGuard > > http://antispam.yahoo.com/whatsnewfree > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Yong Huang > > 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,
Re: 10g new features
Not sure I get it either. :) The command listed on the 10g site that I referred to is this: alter tablespace ts_user rename to ts_user_01; Renaming a tablespace is apparently possible with 10g. Must be a joke here somewhere I'm missing. Jared On Mon, 2003-11-03 at 20:09, Yong Huang wrote: > Gopal was joking about the fact that Jared only said 'alter tablespace rename' > instead of ALTER TABLESPACE RENAME DATAFILE. > > In fact, 9.2 SQL Reference has this > > Moving and Renaming Tablespaces: Example > This example moves and renames a datafile associated with the tbs_01 tablespace > from 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat': > > If you only read the subtitle here (first line), you *will* be surprised. > > Yong > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > Actually, I don't understand what you mean. Here is 9.2: > > > > SQL> create tablespace test datafile '/data/oradata/data/test01.dbf' > > 2 size 10M extent management local autoallocate > > 3 segment space management auto; > > > > Tablespace created. > > > > SQL> alter tablespace test rename to test01; > > alter tablespace test rename to test01 > > * > > ERROR at line 1: > > ORA-01904: DATAFILE keyword expected > > > > > > SQL> > > > > > > So, what did you mean? > > > > On 2003.11.03 21:59, K Gopalakrishnan wrote: > > > Jared: > > > > > > 'alter tablespace rename' is not the REAL 10g feature. It is available > > > from 9.2 onwards... :) Hope you know what I mean,, > > > > > > KG > > > > > > - Original Message - > > > From: [EMAIL PROTECTED] > > > To: Multiple recipients of list ORACLE-L > > > Sent: Tuesday, November 04, 2003 12:54 AM > > > Subject: 10g new features > > > > > > > > > > > > Found a site with some 10g new features. > > > > > > http://www.adp-gmbh.ch/ora/misc/10g.html > > > > > > I'm sure some will like the new 'alter tablespace rename' > > > > > > http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux > > > > > > > > > Jared > > > > -- > > 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). > > > __ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Yong Huang > 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: Jared Still 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: 10g new features
Gopal was joking about the fact that Jared only said 'alter tablespace rename' instead of ALTER TABLESPACE RENAME DATAFILE. In fact, 9.2 SQL Reference has this Moving and Renaming Tablespaces: Example This example moves and renames a datafile associated with the tbs_01 tablespace from 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat': If you only read the subtitle here (first line), you *will* be surprised. Yong --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > Actually, I don't understand what you mean. Here is 9.2: > > SQL> create tablespace test datafile '/data/oradata/data/test01.dbf' > 2 size 10M extent management local autoallocate > 3 segment space management auto; > > Tablespace created. > > SQL> alter tablespace test rename to test01; > alter tablespace test rename to test01 > * > ERROR at line 1: > ORA-01904: DATAFILE keyword expected > > > SQL> > > > So, what did you mean? > > On 2003.11.03 21:59, K Gopalakrishnan wrote: > > Jared: > > > > 'alter tablespace rename' is not the REAL 10g feature. It is available > > from 9.2 onwards... :) Hope you know what I mean,, > > > > KG > > > > - Original Message - > > From: [EMAIL PROTECTED] > > To: Multiple recipients of list ORACLE-L > > Sent: Tuesday, November 04, 2003 12:54 AM > > Subject: 10g new features > > > > > > > > Found a site with some 10g new features. > > > > http://www.adp-gmbh.ch/ora/misc/10g.html > > > > I'm sure some will like the new 'alter tablespace rename' > > > > http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux > > > > > > Jared > > -- > 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: 10g new features
Actually, I don't understand what you mean. Here is 9.2: SQL> create tablespace test datafile '/data/oradata/data/test01.dbf' 2 size 10M extent management local autoallocate 3 segment space management auto; Tablespace created. SQL> alter tablespace test rename to test01; alter tablespace test rename to test01 * ERROR at line 1: ORA-01904: DATAFILE keyword expected SQL> So, what did you mean? On 2003.11.03 21:59, K Gopalakrishnan wrote: Jared: 'alter tablespace rename' is not the REAL 10g feature. It is available from 9.2 onwards... :) Hope you know what I mean,, KG - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 12:54 AM Subject: 10g new features Found a site with some 10g new features. http://www.adp-gmbh.ch/ora/misc/10g.html I'm sure some will like the new 'alter tablespace rename' http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux Jared -- 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).
Re: 10g new features
Jared: 'alter tablespace rename' is not the REAL 10g feature. It is available from 9.2 onwards... :) Hope you know what I mean,, KG - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 12:54 AM Subject: 10g new features Found a site with some 10g new features. http://www.adp-gmbh.ch/ora/misc/10g.html I'm sure some will like the new 'alter tablespace rename' http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux Jared
Re: 10g new features
That's a nice article. The author could have enhanced it by adding or changing some wording. The buffer cache can be flushed with alter system flush buffer_cache. -> ... instead of using the undocumented alter session set events = 'immediate trace name flush_cache' in 9i SQL: Regular Expressions (finally) -> SQL: Regular Expressions; much enhanced over the less known owa_pattern (see http://www.stormloader.com/yonghuang/computer/OracleRegExp.html) Plus Oracle trace collection is deprecated (or gone?) after it's finally improved to the level of being quite useful (see http://www.dbazine.com/jlewis1.html) One of the biggest improvements to me is the datafile reuse across OSes. When my previous employer outsourced Financials to Oracle.com (and laid off all DBAs including me incidentally), Oracle had to use Solaris because it was too difficult to export. All other databases we outsourced are running on Linux now. Yong Huang --- [EMAIL PROTECTED] wrote: > Found a site with some 10g new features. > > http://www.adp-gmbh.ch/ora/misc/10g.html > > I'm sure some will like the new 'alter tablespace rename' > > http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux > > > Jared __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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).
10g new features
Found a site with some 10g new features. http://www.adp-gmbh.ch/ora/misc/10g.html I'm sure some will like the new 'alter tablespace rename' http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux Jared