RE: Bye...
NOO!! -Original Message- Sent: Friday, January 30, 2004 7:44 PM To: Multiple recipients of list ORACLE-L -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 last post [EMAIL PROTECTED] wrote: | | bye... - -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAGwhjR8fSap71V7YRAr2kAJ9mCheNbKDgqaxYv+PwCZfOwfUj6wCgkTco Ekwzd7uVojMNOewaxJ6k0dU= =+8Vo -END PGP SIGNATURE- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: Chris Stephens 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: Automatic or Uniform allocation
Ron, I agree, uniform sizing is best. I hardly ever use automatic except for small development databases and small MISC tablespaces and even then I think Why didn't I use use uniform 64K ? Cheers, Chris Quoting Ron Rogers [EMAIL PROTECTED]: Brad, For LMT's I prefer uniform sizing that I can define to meet the needs of the data. If you use automatic the extend sizes will change drimatically as the number if extends increase. With a little planning you can have little waste in the tablespace and use the tablespace for multiple tables of the same size requirements. We have used the partitioning and LMT's for the yearly data we have, about 5 gig per table per year and the extend count is only around 100 with minimal free space. It makes it easier in the planning stage if you can keep it simple. Ron [EMAIL PROTECTED] 01/22/2004 10:14:34 AM for LMTs... Advantages in uniform versus automatic? Uniform 5 MB? 10 MB.100MB etc thoughts would be appreciatd Thanks Brad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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). Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: pga_aggregate_target and a memory leak
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris 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: What to look for in STATSPACK report
I had this same problem. It ended up being that when I opened the file in exel, all the columns from the csv went into one excel column and for some reason it wasn't apparentor something like that. .now if I could only remember what it was I did to fix it. hmmm. ..i think it was some searching and replacing or something. ..that should get you started though. ...sorry for the not so helpful post, but maybe this will trigger something. chris -Original Message- Sent: Thursday, January 22, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network
Re: FW: Disk capacity planning
Mladen, I agree you can measure how many IOs are being done and how many a disk sub- system, such as those provided by EMC, can perform and still give good performance. What I meant is that it is hard and some would say impossible to estimate how many IOs per sec a new application will do. A combination of paper calculations, testing, experience and looking at comparable systems will help to provide a good estimate. Cheers, Chris Quoting Mladen Gogala [EMAIL PROTECTED]: Oh, but it is done, you only need to ask. EMC routinely measures how many I/Os per second can they perform and they even have tools to measure it. Speaking of monitoring I/O, there used to be an old OS, which is mostly dead today and it used to have command monitor io/item=queue which would show length of the I/O queues per device, which was extremely useful, because you could quickly find out which devices are hot and which are not. On 2004.01.20 04:19, [EMAIL PROTECTED] wrote: Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system's peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you'll really, truly need. The way I'd recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements.) Roughly speaking, the number of disks you'll need to buy is max(B, P, A, .). It's more complicated than that because you'll need to segment your total drive set into sensibly-sized arrays, you'll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle server. Thanks in advance. Best Regards, Rhojel Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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
RE: 9iAS Calender Servlet
I did a quick and dirty one in pl/sql. No security, or checks on content yet though. I'd be more than happy to send it to you. It might be kind of ugly...i've not done a ton of coding. (something I am actively working on. Let me know, Chris -Original Message- Sent: Wednesday, January 21, 2004 6:45 AM To: Multiple recipients of list ORACLE-L Does anybody by chance have any examples for creating a calender servlet for 9iAS? I have to admit to being a servlet virgin! ;) Any pointers much apreciated! Many thanks Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: Chris Stephens 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).
after the discussion yesterday on db2/mysql/postgresql....
I thought this might be relevant and interesting... http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci945589,00.html?tr ack=NL-93 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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: Does SQL Server have a wait interface?
I believe the Jan edition of SQL Server magazine has an article on this very subject. -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 8:35 AM To: Multiple recipients of list ORACLE-L anyone know? -- 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: Grabowy, Chris 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: FW: Disk capacity planning
Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system's peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you'll really, truly need. The way I'd recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements.) Roughly speaking, the number of disks you'll need to buy is max(B, P, A, .). It's more complicated than that because you'll need to segment your total drive set into sensibly-sized arrays, you'll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle server. Thanks in advance. Best Regards, Rhojel Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: What to look for in STATSPACK report
Helmet, Mogens makes a lot of good points as normal. As usual it's never as simple as we'd like it too be and it depends on how your system runs. One thing that is worth monitoring is changes in statistic values over time. For example if your buffer cache hit ratio is normally 85% during your peak on- line usage but then on it changes to 75% this indicates that something significant has changed and probably needs investigating. It doesn't necessarily mean you have a performance problem because if the users are happy that performance is good and batch is performing as expected then all's OK. (BTW I'm aware that buffer cache hit ratio statistics in isolation aren't a good indicator of performance good or bad.) HTH Cheers, Chris Quoting Mogens Nørgaard [EMAIL PROTECTED]: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- 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). Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: ORA-904 after table rename
I went through a similar problem with the 904 error. I had to use oradebug to get a trace file to be produced. Good luck, Chris -Original Message- Sent: Monday, January 19, 2004 8:14 AM To: Multiple recipients of list ORACLE-L It turns out that the user had configured TOAD to use a table filter, which causes it to create and store a query. As you've probably guessed, the query was referencing a column which no longer exists. On a related note, I initially tried to capture the failing query using alter system set events='904 TRACE NAME ERRORSTACK', but no trace files were ever created. Any idea what the command should really have been? -Original Message- Norris, Gregory T [ITS] Sent: Friday, January 16, 2004 9:10 AM To: Multiple recipients of list ORACLE-L We're developing some schema update scripts for an in-house application, which includes renaming an existing table, and creating a new version using the original name. No problem... or so I thought. :( All seems well under OEM and SQL+, but I have a developer who consistently gets an ORA-904 error (invalid column name) when trying to access the new table under TOAD. I can't think of anything weird about this table, except that the original has some column-level grants (but not to his userid... he has select/insert/update/delete on both tables). I had him try exiting and restarting TOAD, in case it was caching something relevant, but that didn't make any apparent difference. Any idea what might be going on? SQL desc tool_request_old NameNull?Type --- TREQ_TOOLS_REQUEST_PKEY NOT NULL NUMBER(6) TREQ_PEOPLE_FKEYNOT NULL NUMBER(6) TREQ_SUBMIT_DATENOT NULL DATE TREQ_COMPLETE_DATE DATE TREQ_STATUS NOT NULL NUMBER(6) TREQ_COMMENTSVARCHAR2(2024) TREQ_BYPASS_STARTDATE TREQ_BYPASS_END DATE SQL desc tool_request NameNull?Type --- TREQ_ID NOT NULL NUMBER(6) TREQ_PERS_IDNOT NULL NUMBER(6) TREQ_STATUS_ID NOT NULL NUMBER(6) TREQ_SUBMIT_TMSTNOT NULL DATE TREQ_BYPASS_START_TMST DATE TREQ_BYPASS_END_TMST DATE TREQ_COMPLETE_TMST DATE TREQ_COMMENTSVARCHAR2(1024) -- My employers like me, but not enough to let me speak for them. Greg Norris Sprint LTD Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] 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: Norris, Gregory T [ITS] 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: Chris Stephens 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: powerbuilder in rbo and multiple constraint question...
Chris, I've worked on a large Powerbuilder App for a number of years. We used CBO all the time under 7.3.2, 7.3.4 and 8.1.7. You're right Powerbuilder per se requiring RBO is rubbish. Cheers, Chris Dunscombe Quoting Chris Stephens [EMAIL PROTECTED]: I'm working with a 3rd party vendor to resolve some performance issues with there call center app. The app is written in PowerBuilder. When I traced the offending sessions, I noticed the queries are being run under the rbo. When I run those same queries under the cbo the response time is dramatically different. I asked why they insisted on running under the rbo. There response was that it's a limitation of powerbuilder. I don't buy that for a second. ...anyone know for sure? ..and on a side note...my company is developing a call center app in .not. The dba's were conveniently left out of the design process. I just took a look at the schema they are using and noticed redundant constraints on almost every table. i.e. not null, primary key, unique on the same column. Before I investigate myself with a 10046, does anyone know if oracle has to do multiple recursive sql to validate each constraint or is it smart enough to know they are redundant and only validate the pk constraint? .when I saw this, I blasted the developers (admittedly some misdirected aggression) for not having a clue what they were working with and blankly stated that the redundant constraints (among other things if found...no bind variables for one) would negatively affect performance. ..after possibly putting my foot in my mouth I'm looking to validate what I said. ...if I don't get any responses to this, I'll run the trace myself and post my findings. oh yeah...the .not developers responded by saying the redundant constraints wouldn't be a problem in sql server. ...something I'm almost positive they haven't validated either. Thanks! chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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). Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
powerbuilder in rbo and multiple constraint question...
I'm working with a 3rd party vendor to resolve some performance issues with there call center app. The app is written in PowerBuilder. When I traced the offending sessions, I noticed the queries are being run under the rbo. When I run those same queries under the cbo the response time is dramatically different. I asked why they insisted on running under the rbo. There response was that it's a limitation of powerbuilder. I don't buy that for a second. ...anyone know for sure? ..and on a side note...my company is developing a call center app in .not. The dba's were conveniently left out of the design process. I just took a look at the schema they are using and noticed redundant constraints on almost every table. i.e. not null, primary key, unique on the same column. Before I investigate myself with a 10046, does anyone know if oracle has to do multiple recursive sql to validate each constraint or is it smart enough to know they are redundant and only validate the pk constraint? .when I saw this, I blasted the developers (admittedly some misdirected aggression) for not having a clue what they were working with and blankly stated that the redundant constraints (among other things if found...no bind variables for one) would negatively affect performance. ..after possibly putting my foot in my mouth I'm looking to validate what I said. ...if I don't get any responses to this, I'll run the trace myself and post my findings. oh yeah...the .not developers responded by saying the redundant constraints wouldn't be a problem in sql server. ...something I'm almost positive they haven't validated either. Thanks! chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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: table reorganizations
Rachel, Thanks for the idea but the system is running 8i. I'll remember it for the future. Chris Quoting Rachel Carmichael [EMAIL PROTECTED]: Chris, Have you considered using dbms_redefinition for your second case? That would allow you to reorg and swap the tables without locking for any length of time. Rachel --- [EMAIL PROTECTED] wrote: Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Cheers, Chris Dunscombe Quoting Richard Foote [EMAIL PROTECTED]: MessageHi Thomas, Never say never (oh bugger, I've just gone and done it myself). A large table accessed via a FTS for various important reporting requirements has permanently shrunk in size from 10G to 100M (say list of Informix customers ;) Business requirements have changed and you need to add some columns to a table resulting in mucho row migration. You were told (incorrectly) that rows would grow significantly after loading (honestly) but now the 80 pctfree value you've set is causing problems for other really important reports. There are of course other cases but you get my point ;) Cheers Richard - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 6:34 AM Subject: RE: table reorganizations Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say in a year, then place it in a Locally Managed tablespace with extent sizes to hold enough data for one year (say 1M). You should never have to reorganize a table. Tom Mercadante Oracle Certified Professional -Original Message- From: Shrake, Jolene [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Subject: table reorganizations What SQL statement do you use to identify tables that need reorganization? How do you identify tables that are used in full table scans? How often do you run this query? Thanks, Jolene Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: table reorganizations
Tom, In my first example you are right that new inserts would use the space freed by the deletes but the purge program is run every quarter (sorry for not stating that explictly earlier). Therefore there is at most 2.25 years worth of data in the tables when before the first purge there was 4 years. Hence I believe the table reorg is valid for both disk space savings and performance. In my second example the amount of data loaded into the transaction log table can vary dramatically due to double-day processing caused by public holidays etc. Therefore if the table wasn't reorganised daily the table would end up being at least twice as large as necessary and therefore impcat the performance of FTS. These examples were both on 8i but I don't think 9i would make any difference. Pls let me know the details if 9i does make a difference. Cheers, Chris Quoting Mercadante, Thomas F [EMAIL PROTECTED]: Chris, I would argue that in your two examples, nothing needs to be done if you are using Locally Managed Tablespaces. All of the free space that your deletes generated would be reused by new inserts. When you say not good for FTS, I think you are wrong. Have you tried testing this statement? How much slower is it? Of course, I am talking about using Oracle 9i. Prior versions behaved much differently. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 09, 2004 6:09 AM To: Multiple recipients of list ORACLE-L Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Cheers, Chris Dunscombe Quoting Richard Foote [EMAIL PROTECTED]: MessageHi Thomas, Never say never (oh bugger, I've just gone and done it myself). A large table accessed via a FTS for various important reporting requirements has permanently shrunk in size from 10G to 100M (say list of Informix customers ;) Business requirements have changed and you need to add some columns to a table resulting in mucho row migration. You were told (incorrectly) that rows would grow significantly after loading (honestly) but now the 80 pctfree value you've set is causing problems for other really important reports. There are of course other cases but you get my point ;) Cheers Richard - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 6:34 AM Subject: RE: table reorganizations Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say in a year, then place it in a Locally Managed tablespace with extent sizes to hold enough data for one year (say 1M). You should never have to reorganize a table. Tom Mercadante Oracle Certified Professional -Original Message- From: Shrake, Jolene [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Subject: table reorganizations What SQL statement do you use to identify tables that need reorganization? How do you identify tables that are used in full table scans? How often do you run this query? Thanks, Jolene Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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
RE: table reorganizations
Niall, In the first case disk space was the primary reason, performance improvement being a positive side-affect, so as to avoid a major disk array upgrade. I know that new inserts would use the deleted space in the pruged tables. However that free-space within the table block isn't very flexible i.e. it can only be used for inserts into the particular table. After the reorg the space is available to all objects in the tablespace and in our case as we moved the tables to new tablespaces we were also able to reduce the size of the tablespaces, therefore gving the space back as the OS level where it can be allocated to any tablespace in the future. In the second the table-swap was first implemented under Oracle 7 so alter table move wasn't available. I hope this explains the reasoning. Chris Quoting Niall Litchfield [EMAIL PROTECTED]: Hi Chris Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. What would be the rationale for this? If the rationale is performance how much faster does it make everything, and how many users are complaining to start with? If purely for space management purposes then I'd ask why the deleted space could not be reused? 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Pah. Once a day indeed. Once every 5 minutes... I'm interested in why you implemented table swap instead of 'alter table move' which is what we did. Cheers, Chris Dunscombe Cheers Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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). Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: table reorganizations
Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Cheers, Chris Dunscombe Quoting Richard Foote [EMAIL PROTECTED]: MessageHi Thomas, Never say never (oh bugger, I've just gone and done it myself). A large table accessed via a FTS for various important reporting requirements has permanently shrunk in size from 10G to 100M (say list of Informix customers ;) Business requirements have changed and you need to add some columns to a table resulting in mucho row migration. You were told (incorrectly) that rows would grow significantly after loading (honestly) but now the 80 pctfree value you've set is causing problems for other really important reports. There are of course other cases but you get my point ;) Cheers Richard - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 6:34 AM Subject: RE: table reorganizations Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say in a year, then place it in a Locally Managed tablespace with extent sizes to hold enough data for one year (say 1M). You should never have to reorganize a table. Tom Mercadante Oracle Certified Professional -Original Message- From: Shrake, Jolene [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Subject: table reorganizations What SQL statement do you use to identify tables that need reorganization? How do you identify tables that are used in full table scans? How often do you run this query? Thanks, Jolene Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Oracle Warehouse Builder Tutorial
Good luck finding any relevant documentation outside of TFM. I looked for a while before I decided to go back and read what oracle provided. The docs are decent. ...once you get the hang of owb it's fairly intuitive. The thing is laden with bugs though. 9.2 is vastly better IMHO that previous releases. Chris -Original Message- Sent: Friday, January 09, 2004 10:55 AM To: Multiple recipients of list ORACLE-L Would love to know! -Original Message- Stahlke, Mark Sent: Friday, January 09, 2004 11:34 AM To: Multiple recipients of list ORACLE-L Greetings, Does anyone know of a good, readable tutorial on Oracle Warehouse Builder? I've been searching Google and even looking for books on Amazon.com and there seems to be a dearth of info on this product out there. I successfully installed it (9.2.0.3 Linux) and built the repository, run time repository, and target schema but I don't know where to go from here. Thanks, Mark Stahlke Oracle DuhBA Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stahlke, Mark 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: [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: Chris Stephens 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: Any good product / option for Source code control
Cary, You recall correctly, just checked the website and it's distributed under the GPL with no costs mentioned. There are also a number of other interesting utilities for download also under the GPL. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: WinCVS has worked well for us and several of our friends. www.wincvs.org If I recall correctly, it's free. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- M Rafiq Sent: Wednesday, January 07, 2004 12:34 PM To: Multiple recipients of list ORACLE-L Env: Windows 2000/NT/HP-UX/Solaris/Linux Oracle Databases: 7.3 to 9.2.0.4 I am looking for any good product/option for centralized source code control. Any pointer or experiences shall be appreciated. Regards Rafiq _ Have fun customizing MSN Messenger - learn how here! http://www.msnmessenger-download.com/tracking/reach_customize -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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: Cary Millsap 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). Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Difference on ArchiveLog
The logical explanation is that activity in your database varies from day to day. Try sitting back and keeping the size the same for a while and watch the space taken. Chris -Original Message- From: Mauricio Vilez [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 4:29 PM To: Multiple recipients of list ORACLE-L Subject: Difference on ArchiveLog Hello Everybody I'm rewriting the question, Some days ago the database I work on had 3 logfiles that sized 100M and the database was generating 4G of archive daily. I changed the size to 20M and the database began to generate 2G of archive daily, then I changed to 50M and It began to generate 3G of archive daily. I think I'ts not logical that archive size change. The database I'm working on is oracle 9i and I'is on Windows NT. Regards Mauricio Vlez Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
ora1652 question...
Is there an event to set where I can identify any sql that receives a 1652 error message? There is some process running each night in a reporting database that has been generating this error for the past week. I figured someone would complain. That didn't happen so I went and asked the reporting people if any of the reports were blowing up. They said no. I just set up statspack and will run that every 10 minutes tonight. I also have a query that will capture the session info on sessions currently sorting that I will run every 10 minutes. Neither of the techniques are very direct. I would imagine there is an event to set so that I can generate a trace file. Any other suggestions of nailing this down would be appreciated. ..and so I don't have to ask about events anymore...where do I find what event means what? Thanks, Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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: RE: Hit Ratio
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: Chris Stephens 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: Who fired the trigger
Couldn't your trigger fire off a procedure to evaluate userenv and the proceed or not? -Original Message- Sent: Friday, December 19, 2003 1:49 PM To: Multiple recipients of list ORACLE-L To All, I'm feeling in a LAZY mood this afternoon so I'm going to ask the list if someone has an answer to this. Otherwise I guess it will wait till Monday. We have a before update trigger on a table to prevent assemblies on the line from being unscrapped. But we also have a need o periodically unscrap stuff. The question is can a trigger recognize who fired it abort if that is a particular user? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- 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: Chris Stephens 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: SQL and PL/SQL tuning template document required urgently
Dennis, Excellent recommendation, Guy Harrison's book (2nd Edition) is excellent the best I've seen on SQL tuning. I've used it for a number of years. I had the 1st edition and then bought the 2nd when it came out. Cheers, Chris -Original Message- Sent: 29 October 2003 15:49 To: Multiple recipients of list ORACLE-L Ranganath Since you mentioned proactive and reactive query tuning, I think the philosophy with which one approaches the tuning exercise means everything. Wrong philosophy and you spend your time spinning your wheels. All of us have only a limited amount of time to devote, so the best approach will make the best use of that time. Get Optimizing Oracle Performance by Cary Millsap. It doesn't take long to read the important parts. Implement Cary's approach to locate the queries where you will get the most bang for the buck. Then use books like Guy Harrison's (Ryan's suggestion) for pointers on making those queries perform better. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 29, 2003 8:24 AM To: Multiple recipients of list ORACLE-L Hi there, Does any body have a template for proactive and reactive query tuning which can be used as a guideline/report while tuning simple, medium complex and complex SQL queries and PL/SQL stored procedures? If so, can you please forward the same to me please? If not, can anybody suggest as to how to go about doing one? Any help in this regard is very much appreciated. Thanks and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ranganath K 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: DENNIS WILLIAMS 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: Dunscombe, Chris 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: RE: OCP 9i New Features for DBAs
Jared, I didn't make a detailed list but where I clearly noticed the inaccuracies was in the sample exam questions at the back of the book e.g. In which version of Oracle was hash partitioning introduced? A) 7 B) 8 C) 8i D) 9i Answer D. The real answer as we know is C. Which statement is true about the TIMESTAMP WITH TIME ZONE datatype? A) It represents absolute time. B) In addition to the date and time, you can store the time zone displacement (offset), which requires additional bytes of storage. C) In addition to the date and time, you can store the time zone displacement (offset), without consuming additional bytes of storage. D) You can use the NLS_TIMESTAMP_TZ_FORMAT initialisation parameter to specify the default timestamp format for retrieval. Answer C. The real answer is B. What this means is that you need to checkout the answers when marking yourself just to be on the safe side. I must point out that on a couple of occaisions the book was right when I initially thought it was wrong. Cheers, Chris -Original Message- Sent: 20 November 2003 18:35 To: Multiple recipients of list ORACLE-L Chris, Care to share details on the inaccuracies? Jared Dunscombe, Chris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/20/2003 02:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: OCP 9i New Features for DBAs Ryan, I took my exam yesterday and passed!! I used the Oracle Press - OCP Oracle 9i Database: New Features for Administrators Exam Guide book. Even though there are a number of inaccuracies it was good preparation especially the sample exams it provides. Regarding 9.2 vs 9.0 content in the exam it all seemed to be 9.0. Hope all goes well when you take your exam. Cheers, Chris -Original Message- Sent: 12 November 2003 18:25 To: Multiple recipients of list ORACLE-L im going to take it soon. I was going to just read howard rogers guide then the otn one. you think that is enough? I just want to pass it and get my piece of paper. I already know the 9i stuff that is useful to me. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/11/12 Wed PM 12:19:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OCP 9i New Features for DBAs Chris I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle would have had to go back and recreate the test. And Oracle would have felt compelled to change the name of the test. However, I think it possible that any question whose answer would be true for 9.0 but false for 9.2 might be removed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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: DENNIS WILLIAMS 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: [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
SQL comparison addition: Resolution...
A few weeks ago I had a problem with the following query not returning rows: Select count(*) . from global.client_dim a where a.reports_login = sys_context('userenv','session_user'); even though the following query indicated a match (thanks to whomever suggested I dump the fields): SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; SYS_CONTEXT('USERENV','SESSION_USER') DUMP(SYS_CONTEXT('USERENV','SESSION_USER')) REPORTS_LOGIN -- DUMP(A.REPORTS_LOGIN) REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 I said I would post the resolution to this. It ended up being a bug in 9203. Not sure which bug. Support insisted that we patch to 9204 and the problem went away. Thanks for everyone's help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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: RE: OCP 9i New Features for DBAs
Ryan, I took my exam yesterday and passed!! I used the Oracle Press - OCP Oracle 9i Database: New Features for Administrators Exam Guide book. Even though there are a number of inaccuracies it was good preparation especially the sample exams it provides. Regarding 9.2 vs 9.0 content in the exam it all seemed to be 9.0. Hope all goes well when you take your exam. Cheers, Chris -Original Message- Sent: 12 November 2003 18:25 To: Multiple recipients of list ORACLE-L im going to take it soon. I was going to just read howard rogers guide then the otn one. you think that is enough? I just want to pass it and get my piece of paper. I already know the 9i stuff that is useful to me. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/11/12 Wed PM 12:19:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OCP 9i New Features for DBAs Chris I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle would have had to go back and recreate the test. And Oracle would have felt compelled to change the name of the test. However, I think it possible that any question whose answer would be true for 9.0 but false for 9.2 might be removed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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: DENNIS WILLIAMS 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: [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: Dunscombe, Chris 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: HTML DB
Ask tom has a link. I think it's marvel.orcle.com. ...installation is easy. ...it looks to be a pretty cool tool. -Original Message- Sent: Thursday, November 13, 2003 10:15 AM To: Multiple recipients of list ORACLE-L On 11/13/2003 10:54:25 AM, Jamadagni, Rajendra wrote: Although we are getting our feet wet ... the installation on a 9202/4 is a breeze. Raj I don't see it on OTN. Where can I get it? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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: SQL comparison addition:
I'll try tracing the session. Global.client_dim is just a table with client info and a column that corresponds to client logins to enable row level security. Thanks for the suggestions. As stated earlier..i'll post the resolution. chris -Original Message- Sent: Tuesday, November 11, 2003 4:39 PM To: Multiple recipients of list ORACLE-L You can flush shared pool, optionally, then enable SQL tracing and CBO tracing and check the trace file, anyway you will be asked to do that when you open a tar. What Oracle version do you use? What's the object you're referencing in your query -- global.client_dim? Is it a [partitioned] table, [m]view or synonym for some other object? -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Chris Stephens wrote: SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN); SYS_CONTEXT('USERENV','SESSION_USER') DUMP(SYS_CONTEXT('USERENV','SESSION_USER')) REPORTS_LOGIN -- DUMP(A.REPORTS_LOGIN) REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 And 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 I'm going to open a tar on this. I will email the resolution. ...and check for any more suggestions! :) Chris -Original Message- Sent: Tuesday, November 11, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Chris There is a contradiction below: Chris Stephens wrote: SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; Produces some output. Your original query does not return anything. 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN) The obvious differences here are: . TRIM function . probably when you've tried to launch the original query you had pofile functions enabled, when you tried it second time it was disabled. . query rewrite is used (could be, right?) Could you please check the second and third items? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun 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: Chris Stephens 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: (looong) PCTFREE, PCTUSED and ASSM
Tanel, Maybe a PQ FTS needs to resolve migrated rows immediately as it's possible that the migrated row is located in a block that's allocated to a different PQ slave. Chris -Original Message- Sent: 12 November 2003 15:49 To: Multiple recipients of list ORACLE-L As a strange thing, from 10046 trace I saw that normal table scanning was done using direct reads, this was expected behaviour, but the lookups of migrated rows were reflected as 'db file sequential reads'. And even more, there were 3 subsequent sequential read waits for the same datablock in a row, it seems that a PX slave isn't even able to cache one datablock in it's PGA, in case of finding migrated rows... (or a wait event is registered for reading from cache...) I was just wondering, why a PQ FTS requires resolving migrated rows immediately, instead of reading them when scan hits their location. Could it be some concurrency issue, that if a row migrates to another location during the scan, then results could get inconsistent? It is not a direct read issue, because I experimented using _serial_direct_read parameter, and for regular FTS, no migrated rows were resolved ahead. There's lot to learn... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:34 PM I believe it's direct read from files in parallel execution, nothing gets read from cache. Cached blocks for the table get flushed to files before the direct read. Regards, Waleed -Original Message- Sent: Wednesday, November 12, 2003 7:10 AM To: Multiple recipients of list ORACLE-L Yep, the situation can get bad for parallel execution, especially if blocks read aren't cached... But for serial FTS I haven't seen such a problem, I did even a test to verify it on 9.2.0.4, and did see behaviour as I expected - all blocks were scanned using multiblock reads and rows were returned in order the contents of them were found, instead of pointers. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 5:14 AM Actually row migration is a big problem for FTS also(whether serially or using PQ). You end up waiting for too many db file sequential read single block reads instead of MBRC in (direct path read, db file scattered read) Regards, Waleed -- 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: Khedr, Waleed 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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
OCP 9i New Features for DBAs
Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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).
SQL comparison question...
This is part of a row-level security implementation: For some reason the following comparison works but currently it isn't: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 SQL select sys_context('userenv','session_user') from dual; SYS_CONTEXT('USERENV','SESSION_USER') REPORTS_DELTA SQL select reports_login 2 from global.client_dim 3 where reports_login='REPORTS_DELTA'; REPORTS_LOGIN -- REPORTS_DELTA I thought maybe it was due to hidden characters so I tried: SQL select '|'||sys_context('userenv','session_user')||'|' from dual; '|'||SYS_CONTEXT('USERENV','SESSION_USER')||'|' |REPORTS_DELTA| SQL select '|'||reports_login||'|' 2 from global.client_dim 3 where reports_login='REPORTS_DELTA'; '|'||REPORTS_LOGIN||'|' |REPORTS_DELTA| ...that doesn't appear to be it. any ideas? Thanks for any help! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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).
SQL comparison addition:
I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where the comparison only worked when I put in the trim. ? 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE TRIM(sys_context('userenv','session_user')) =TRIM(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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: SQL comparison addition:
SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; SYS_CONTEXT('USERENV','SESSION_USER') DUMP(SYS_CONTEXT('USERENV','SESSION_USER')) REPORTS_LOGIN -- DUMP(A.REPORTS_LOGIN) REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 -Original Message- Sent: Tuesday, November 11, 2003 11:44 AM To: Multiple recipients of list ORACLE-L I may be barking up the wrong tree, but humour an old dba... Could you try running the following and post the output? select sys_context('userenv','session_user'), dump(sys_context('userenv','session_user')), a.reports_login, dump(a.reports_login) from global.client_dim a WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; Daniel Chris Stephens wrote: I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where the comparison only worked when I put in the trim. ? 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE TRIM(sys_context('userenv','session_user')) =TRIM(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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: Daniel Fink 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: Chris Stephens 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: SQL comparison addition:
But wouldn't whitespace show up when I select '|'||reports_login||'|' ?? -Original Message- Sent: Tuesday, November 11, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Perhaps it's your clients? I've spouted off here before about the MACHINE column of V$SESSION having an extra CHR(0) at then end of it for Winders clients. Maybe something similar's happening to you, but with whitespace (the TRIM in your statement won't lop off CHR(0)). HTH! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Chris Stephens [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 11:19 AM To: Multiple recipients of list ORACLE-L Subject: SQL comparison addition: I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where the comparison only worked when I put in the trim. ? 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE TRIM(sys_context('userenv','session_user')) =TRIM(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: Chris Stephens 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: SQL comparison addition:
SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN); SYS_CONTEXT('USERENV','SESSION_USER') DUMP(SYS_CONTEXT('USERENV','SESSION_USER')) REPORTS_LOGIN -- DUMP(A.REPORTS_LOGIN) REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 And 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 I'm going to open a tar on this. I will email the resolution. ...and check for any more suggestions! :) Chris -Original Message- Sent: Tuesday, November 11, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Chris There is a contradiction below: Chris Stephens wrote: SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; Produces some output. Your original query does not return anything. 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN) The obvious differences here are: . TRIM function . probably when you've tried to launch the original query you had pofile functions enabled, when you tried it second time it was disabled. . query rewrite is used (could be, right?) Could you please check the second and third items? -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. SYS_CONTEXT('USERENV','SESSION_USER') DUMP(SYS_CONTEXT('USERENV','SESSION_USER')) REPORTS_LOGIN -- DUMP(A.REPORTS_LOGIN) REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 -Original Message- Sent: Tuesday, November 11, 2003 11:44 AM To: Multiple recipients of list ORACLE-L I may be barking up the wrong tree, but humour an old dba... Could you try running the following and post the output? select sys_context('userenv','session_user'), dump(sys_context('userenv','session_user')), a.reports_login, dump(a.reports_login) from global.client_dim a WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; Daniel Chris Stephens wrote: I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where the comparison only worked when I put in the trim. ? 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE TRIM(sys_context('userenv','session_user')) =TRIM(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun 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: Chris Stephens 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
Apps HR Info - OID/SSO/Portal
Title: Message Anyone have any experience in synchronizing Apps HR (11i) information with OID (902)? We are looking at ways to automatically generate portal accounts out of the HR module. There is documentation on this in TFM's and it doesn't look all that hard. However, I talked to someone that actually attempted to do this and he said it was a nightmare and didn't work as described in the manuals...lots of custom coding. To me it looks like just altering a few configuration files to map table columns to OID attributes. was he full of it? ...anyone have any pointers? ...or information outside of the docs? Thanks! Chris
Trapping Portal Login
Title: Message I am writing a procedure to generate a company calendar and to allow for scheduling various resources in the organization. This will run as a portlet and I need to verify that the user has been authenticated through portal before I allow them to add/edit/delete entries. So far I am unable to figure out how to get the portal userid. ...I tried owa_util.get_cgi_env('REMOTE_USER') and Sys_Context but they both just return the userid from the DAD. Anyone know how to do this? ...ehem...I haven't spent a whole lot of time trying to figure this out but I thought I would pose the question in hopes of a quick and easy response. Thanks Chris
RE: RE: wait/notify syntax for unix help please
There's no problem with waiting after the process has already finished, you'll just get a non-zero return code the wait but evrything will still work fine. Chris -Original Message- Sent: 27 October 2003 18:54 To: Multiple recipients of list ORACLE-L if you attemp to wait after the process is complete, will it cause a problem? say the PID no longer exists when you issue wait? From: Dunscombe, Chris [EMAIL PROTECTED] Date: 2003/10/27 Mon AM 11:39:34 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: wait/notify syntax for unix help please I don't know about Solaris but on HP-UX and AIX you can do: run_sql_1 run_sql_2 wait This will wait until both have finished. Re a specific PID $! will return you PID of the last child process and then you can wait on that PID. Looks something like: run_sql_1 run_sql_2 PID_WAIT=$! wait ${PID_WAIT} HTH Chris Dunscombe -Original Message- Sent: 27 October 2003 16:09 To: Multiple recipients of list ORACLE-L I need to parallelize some sql operations and Im running them from unix scripts. I want to spawn off a few in the background from a master script, then have the master script 'wait' for them to finish. Ive done this in Java and with dbms_alert, but I cant dig up the syntax to do this with korn shell on solaris. Also, if I want to wait for a specific PID, how do I get the PID of the thread I want to wait for? so I have nohup run_sql wait(on previous nohup) then to use notify, I just use 'notify()' inside the script right? -- 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: Dunscombe, Chris 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: [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: Dunscombe, Chris 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: wait/notify syntax for unix help please
I don't know about Solaris but on HP-UX and AIX you can do: run_sql_1 run_sql_2 wait This will wait until both have finished. Re a specific PID $! will return you PID of the last child process and then you can wait on that PID. Looks something like: run_sql_1 run_sql_2 PID_WAIT=$! wait ${PID_WAIT} HTH Chris Dunscombe -Original Message- Sent: 27 October 2003 16:09 To: Multiple recipients of list ORACLE-L I need to parallelize some sql operations and Im running them from unix scripts. I want to spawn off a few in the background from a master script, then have the master script 'wait' for them to finish. Ive done this in Java and with dbms_alert, but I cant dig up the syntax to do this with korn shell on solaris. Also, if I want to wait for a specific PID, how do I get the PID of the thread I want to wait for? so I have nohup run_sql wait(on previous nohup) then to use notify, I just use 'notify()' inside the script right? -- 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: Dunscombe, Chris 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: Opinions sought on possible TOAD replacement
Paul, I've used PL/SQL Developer by Allround Automations to develop PL/SQL procs, packages and it's fine including a well featured de-bugger. I believe that a site licence costs $3,000. As to it being a DBA tool I'd have to say it's not in the same league as TOAD Xpert with DBA module. Chris Dunscombe Accenture Worthing Unit Internal: 71-3558 External: 01903-283558 Email: [EMAIL PROTECTED] -Original Message- Sent: 15 October 2003 16:59 To: Multiple recipients of list ORACLE-L Management have been grumbling about the cost of TOAD Professional licenses, and have been recommended a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!. But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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: LMT and Fragmentation
Niall, I played around with autoallocate on 8.1.7 a while back and came to the same conclusions as yourself. Chris -Original Message- Sent: 13 October 2003 21:54 To: Multiple recipients of list ORACLE-L A week or so ago Jesse (I think) suggested a test to see whether auto-allocate LMTs were susceptible to fragmentation, or whether the fact that under the hood every allocation unit was 64k made this irrelevant. The test below shows that under 9.2 creating 32 tables, extending them until each has a next extent of 64k. Then we drop half the tables. Can Oracle allocate a new extent for a table. Looks like it can't and the old fun of fragmentation might remain. I'll be sticking with ULMTs but flames/corrections welcomed. SQL set echo on SQL select banner from v$version; BANNER Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production PL/SQL Release 9.2.0.3.0 - Production CORE9.2.0.3.0 Production TNS for 32-bit Windows: Version 9.2.0.3.0 - Production NLSRTL Version 9.2.0.3.0 - Production SQL SQL create tablespace auto_alloc_test 2 datafile 'c:\oracle\oradata\nl9iwk\auto_alloc.dbf' size 32832k 3 extent management local; Tablespace created. SQL SQL /* DOCcreate the tables DOC*/ SQL SQL begin 2 for i in 1..32 loop 3 execute immediate 'create table table'||i||'(col1 number,col2 number) tablespace auto_alloc_test'; 4 end loop; 5 end; 6 / PL/SQL procedure successfully completed. SQL SQL select sum(bytes)/1024 free_k from dba_free_space where tablespace_name='AUTO_ALLOC_TEST'; FREE_K -- 30720 SQL SQL begin 2 for i in 1..15 loop 3 for j in 1..32 loop 4 execute immediate 'alter table table'||j||' allocate extent'; 5 end loop; 6 end loop; 7 end; 8 / PL/SQL procedure successfully completed. SQL SQL select sum(bytes)/1024/1024 free_M from dba_free_space where tablespace_name='AUTO_ALLOC_TEST'; FREE_M -- SQL SQL begin 2 for i in 1..32 loop 3 if i mod 2 = 0 then 4 execute immediate 'drop table table'||i; 5 end if; 6 end loop; 7 end; 8 / PL/SQL procedure successfully completed. SQL SQL select sum(bytes)/1024/1024 free_mb from dba_free_space where tablespace_name='AUTO_ALLOC_TEST'; FREE_MB -- 16 SQL SQL alter table table1 allocate extent; alter table table1 allocate extent * ERROR at line 1: ORA-01653: unable to extend table NIALL.TABLE1 by 64 in tablespace AUTO_ALLOC_TEST -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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: Dunscombe, Chris 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: EMC Snapshot Technology
Hey Tom, I'm in the same boat. Have you looked over some of the red papers at www.storage.ibm.com/ess??? If not, check this one out... Storage Management for SAP and Oracle8i on SUN SOLARIS Split Mirror Backup/Recovery with IBM's ESS. Granted its for Solaris, but I would think the concepts are the same. And of course, there are more about Oracle. I believe were running RAID 5, which has me a bit concerned being a unofficial member of the BAARF organization. The red papers speak to this problem, and supposedly it has been resolved. Something about the entire stripe being cached. Since I'm a SAN newbie, I'm starting with the Introduction to SAN paper, and reading my way up. I don't want to raise a red flag until I can prove it. Please keep me in mind with whatever path you take. And if you present your findings let me know, I would love to read'em. Thanks. Chris -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Mercadante, Thomas FSent: Thursday, October 09, 2003 9:10 AMTo: Multiple recipients of list ORACLE-LSubject: RE: EMC Snapshot Technology Gene, What happens when you need to perform a recovery from the Flashcopy backup? Is Flashcopy done while the database is open or closed? If the database is open, then I assume that you would need to perform an incomplete recovery? Just curious. I am in the middle of setting up new IBM/AIX boxes, and we will using either EMC or IBM Shark disk. Flashcopy was mentioned as a possible solution for backups. But I don't like being boxed in to performing an incomplete recovery. Tom Mercadante Oracle Certified Professional -Original Message-From: Gene Sais [mailto:[EMAIL PROTECTED]Sent: Thursday, October 09, 2003 8:35 AMTo: Multiple recipients of list ORACLE-LSubject: Re: EMC Snapshot Technology I don't use snapshots, but have used EMC BCV's in the past and now use IBM's Flashcopy for backups. I backup 1TB db in ~20 mins using Flashcopy. Then I take it off to tape, i.e. filesystems monted on a TSM Backup server, hence no resources needed from the production server :). hth, Gene [EMAIL PROTECTED] 10/08/03 09:39PM We are implementing Oracle RAC on two Windows nodes, connected to an EMCSAN. We'll also have a failover sight. We are using S.A.M.E. disk configuration, with only one logical volume,and backups/archivelogs dumping to another volume.The SAN is an EMC Clariion CX400. I immediately vetoed snapshots, opting for RMAN, but I'm now taking asecond look. Does anyone use the snapshot technology as a solution for full backups? Thanks,Jeff-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: jwiegand INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Re[2]: Cary's Book - new topic
Perhaps a flashback query would help??? -Original Message- Wolfgang Breitling Sent: Tuesday, October 07, 2003 5:55 PM To: Multiple recipients of list ORACLE-L Unfortunately it's not my ability to see into the future, but an inability to see all of the past. Now what was that I was looking for? At 03:34 PM 10/7/2003, you wrote: Wolfgang, Tuesday, October 7, 2003, 2:04:24 PM, you wrote: W A totally different point: How come I see your response before I W see my own post? Sounds like you can see into the future. Would you mind reading the Wall Street journal and reporting back to us? -rje Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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: Grabowy, Chris 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: RE: Desupport of RBO
I didn't ask for a comment, just a suggestion...or a hint...off the record. Don't worry Raj, I'll stop by Mr. Freeman's house with a keg...soon he'll be commenting a lot. If that doesn't work then I'll threaten to call him a SQL Server DBA... -Original Message- Sent: Tuesday, October 07, 2003 5:16 PM To: Grabowy, Chris; 'Multiple recipients of list ORACLE-L ' For right now, I am unable to comment on anything 10g. Thanks for understanding! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/7/2003 3:44 PM Nope. Mr Freeman are you out there?? Also, Jonathan Lewis is a commentary author for this book, so he may some insight. But wait, I have some dice at my desk...bingo...it's 8 percent faster. You can quote me. -Original Message- [EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 4:04 PM To: Multiple recipients of list ORACLE-L did he mention any benchmarked performance improvements from gathering statistics on the system tablespacE? From: Grabowy, Chris [EMAIL PROTECTED] Date: 2003/10/07 Tue PM 03:34:25 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Desupport of RBO At the recent NYOUG conference, they were handing out special preview copies of Oracle 10g New Features by our very own Robert Freeman Page 11 has a section entitled...Collecting Data Dictionary Statistics...this is done using the DBMS_STATS.GATHER_DICTIONARY_STATS procedure. Does that answer your question Patrice? -Original Message- Sent: Tuesday, October 07, 2003 3:00 PM To: Multiple recipients of list ORACLE-L We had issues here with first_rows and all_rows when set in init.ora for 8i a couple of years ago... performance dropped significantly. During discussions with Oracle Support I learned that the data dictionary for 8i has to run in rule mode, I don't know if they changed that in 9i or 10G. Hopefully... 10G still has a data dictionary I imagine. : ) Patrice. -Original Message- Sent: Tuesday, October 07, 2003 3:14 PM To: Multiple recipients of list ORACLE-L 10g it won't be supported... wander when rule hints won't be used in E-Business Suite... 11.5.8 still has rule hints in some of the code. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- Sent: Tuesday, October 07, 2003 1:05 PM To: Multiple recipients of list ORACLE-L OK, dumb question. Does this mean the rule hint won't be possible? Application I support mostly uses CBO but there have been cases where we had to resort to RBO hint. 'course it'll be some time before we can consider v10... Kip |Hi Jared, |haven't seen it, too. But the fact |was spreaded over the newsgroups. |We still have some 3rd party apps that don't use |*any* feature above Oracle 7 (well, almost). Queries with |the RULE hint where it's not necessary. |But if we change a thing, support will be lost. |So we decided to rewrite the whole app. |Lucky me: enough work for the next years. |Greetings, |Guido | [EMAIL PROTECTED] 07.10.2003 01.34 Uhr |First time I've seen this note: 189702.1 |Jared |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Guido Konsolke | 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: 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice
RE: Small Oracle db
Now we know where the RBO went too!! They pulled it out of 10g and stuck it into Oracle Standard Edition One. Duh. It's smaller, cheaper it uses RBO. You gotta pay extra for CBO. Sorry for stealing your thunder Mladen ...just borrowing it...you can have it back now. -Original Message- Dwayne Cox Sent: Wednesday, October 08, 2003 8:21 AM To: Multiple recipients of list ORACLE-L Does anyone have more info on this? http://www.infoworld.com/article/03/10/07/HNoraclesmb_1.html -- Dwayne Cox Corporate DBA Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox 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: Grabowy, Chris 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).
interesting article...
Title: RE: RE: Cary's Book - new topic http://www.eweek.com/article2/0,4149,1312906,00.asp
Sujatha.Madan@optus.net.au
Title: Message I've been looking to do this for a while...would you mind sharing the script?? Thanks either way!! chris -Original Message- From: Sujatha Madan [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 11:29 PM To: Multiple recipients of list ORACLE-L Subject: IGNORE: Unix Help Sorry ... but I solved it. Cheers Sujatha -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sujatha Madan Sent: Wednesday, 8 October 2003 1:24 PM To: Multiple recipients of list ORACLE-L Subject: Unix Help Hi, Sorry for the slightly non-Oracle post. I am after a UNIX code snippet that will help me copy archive logs to another directory BUT not if they already exist. So if only 2 archive logs are generated between script runs only the two new ones should copy. I know I can do this using sysdate - time interval but I am trying to avoid that. Thanks in advance, Sujatha Madan.
RE: Desupport of RBO
Title: RE: Desupport of RBO At the recent NYOUG conference, they were handing out special preview copies of Oracle 10g New Features by our very own Robert Freeman Page 11 has a section entitled...Collecting Data Dictionary Statistics...this is done using the DBMS_STATS.GATHER_DICTIONARY_STATS procedure. Does that answer your question Patrice? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Boivin, Patrice JSent: Tuesday, October 07, 2003 3:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Desupport of RBO We had issues here with first_rows and all_rows when set in init.ora for 8i a couple of years ago... performance dropped significantly. During discussions with Oracle Support I learned that the data dictionary for 8i has to run in rule mode, I don't know if they changed that in 9i or 10G. Hopefully... 10G still has a data dictionary I imagine. : ) Patrice. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 07, 2003 3:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Desupport of RBO 10g it won't be supported... wander when rule hints won't be used in E-Business Suite... 11.5.8 still has rule hints in some of the code. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 07, 2003 1:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: Desupport of RBO OK, dumb question. Does this mean the rule hint won't be possible? Application I support mostly uses CBO but there have been cases where we had to resort to RBO hint. 'course it'll be some time before we can consider v10... Kip |Hi Jared, |haven't seen it, too. But the fact |was spreaded over the newsgroups. |We still have some 3rd party apps that don't use |*any* feature above Oracle 7 (well, almost). Queries with |the RULE hint where it's not necessary. |But if we change a thing, support will be lost. |So we decided to rewrite the whole app. |Lucky me: enough work for the next years. |Greetings, |Guido | [EMAIL PROTECTED] 07.10.2003 01.34 Uhr |First time I've seen this note: 189702.1 |Jared |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Guido Konsolke | 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: 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: Openworld Papers
Unlike IOUG, if I remember correctly, OracleWorld's presentations were publicly available via their websiteon the first or was it the second day of the conference. I could not make it to the conference, but I was watching some of the keynotes and reading over their presentations during the conference. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Govindan KSent: Tuesday, October 07, 2003 3:15 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Openworld Papers Here is what you are asking for http://otn.oracle.com/ow2003/content.html HTH GovindanK -Original Message- From: Post, Ethan;Post, EthanSent: 10/7/2003 11:56:25 AMTo: [EMAIL PROTECTED]Subject: Re: Openworld PapersBeen off the list for a few days, anyone know if the papers from Openworld have been posted anyplace? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] - . ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
RE: RE: Desupport of RBO
Nope. Mr Freeman are you out there?? Also, Jonathan Lewis is a commentary author for this book, so he may some insight. But wait, I have some dice at my desk...bingo...it's 8 percent faster. You can quote me. -Original Message- [EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 4:04 PM To: Multiple recipients of list ORACLE-L did he mention any benchmarked performance improvements from gathering statistics on the system tablespacE? From: Grabowy, Chris [EMAIL PROTECTED] Date: 2003/10/07 Tue PM 03:34:25 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Desupport of RBO At the recent NYOUG conference, they were handing out special preview copies of Oracle 10g New Features by our very own Robert Freeman Page 11 has a section entitled...Collecting Data Dictionary Statistics...this is done using the DBMS_STATS.GATHER_DICTIONARY_STATS procedure. Does that answer your question Patrice? -Original Message- Sent: Tuesday, October 07, 2003 3:00 PM To: Multiple recipients of list ORACLE-L We had issues here with first_rows and all_rows when set in init.ora for 8i a couple of years ago... performance dropped significantly.During discussions with Oracle Support I learned that the data dictionary for 8i has to run in rule mode, I don't know if they changed that in 9i or 10G. Hopefully... 10G still has a data dictionary I imagine. : ) Patrice. -Original Message- Sent: Tuesday, October 07, 2003 3:14 PM To: Multiple recipients of list ORACLE-L 10g it won't be supported... wander when rule hints won't be used in E-Business Suite... 11.5.8 still has rule hints in some of the code. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- Sent: Tuesday, October 07, 2003 1:05 PM To: Multiple recipients of list ORACLE-L OK, dumb question. Does this mean the rule hint won't be possible? Application I support mostly uses CBO but there have been cases where we had to resort to RBO hint. 'course it'll be some time before we can consider v10... Kip |Hi Jared, |haven't seen it, too. But the fact |was spreaded over the newsgroups. |We still have some 3rd party apps that don't use |*any* feature above Oracle 7 (well, almost). Queries with |the RULE hint where it's not necessary. |But if we change a thing, support will be lost. |So we decided to rewrite the whole app. |Lucky me: enough work for the next years. |Greetings, |Guido | [EMAIL PROTECTED] 07.10.2003 01.34 Uhr |First time I've seen this note: 189702.1 |Jared |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Guido Konsolke | 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: 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all
RE: RE: Unintentional Humor
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris 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: Seems odd to me....(bug?)
What am I doing wrong here? SQL alter system set events '942 trace name errorstack forever, level 10' 2 ; System altered. SQL insert into sbc_global.employee_role values ('d','dd',8); insert into sbc_global.employee_role values ('d','dd',8) * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist SQL alter system set events='942 trace name context off'; System altered. SQL there is no trace file in udump? This is all that's in the alert file... Fri Oct 3 09:24:56 2003 OS Pid: 24017 executed alter system set events '942 trace name errorstack foreve r, level 10' Fri Oct 3 09:25:39 2003 OS Pid: 24017 executed alter system set events '942 trace name context off' Fri Oct 3 09:27:38 2003 ...no location though. -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: Seems odd to me(bug?) Chris, normally you should get only the table or view does not exist, but you are also getting ora-0604 which leads me to the conclusion that there's more to it them meets the eye. Also, the recursive SQL level 1 is confusing. My suggestion would be to catch the offending SQL, on the system level. There is an old DBA trick which is used when trying to diagnose SQL errors in 3rd party applications for which you don't have the source code. Here is the trick: Fri Oct 3 09:08:24 2003 OS Pid: 25495 executed alter system set events '942 trace name errorstack forever, level 10' Fri Oct 3 09:11:49 2003 Errors in file /data/db/OraHome1/admin/compldb/udump/compldb_ora_25503.trc: ORA-00942: table or view does not exist Here is the trace file: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production ORACLE_HOME = /data/db/OraHome1 System name: Linux Node name: tux925 Release: 2.4.18-5smp Version: #1 SMP Mon Jun 10 15:19:40 EDT 2002 Machine: i686 Instance name: compldb Redo thread mounted by this instance: 1 Oracle process number: 28 Unix process pid: 25503, image: [EMAIL PROTECTED] (TNS V1-V3) *** SESSION ID:(9.30215) 2003-10-03 09:11:49.382 *** 2003-10-03 09:11:49.382 ksedmp: internal or fatal error ORA-00942: table or view does not exist Current SQL statement for this session: select zcvzcxv from czxvvc - Call Stack Trace - calling call entry argument values in hex The offending SQL is shown in bold. The trick goes like this: You set an event for the error you get (942 in your case), connect using DEDICATED SERVER and execute your stuff. The statement that causes the error will appear in the trace file. You can turn it off like this: SQL alter system set events='942 trace name context off'; System altered. SQL When you identify the offending SQL, you'll be able to tell precisely which table causes the problem. May the force be with you. On Thu, 2003-10-02 at 18:39, Chris Stephens wrote: Oracle EE 8.1.7.2HP-UX 11Can anyone explain this? 1* INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)SQL /INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL) *ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-00942: table or view does not exist 1* select count(*) from user_tables where table_name='EMPLOYEE_ROLE'SQL / COUNT(*)-- 1 SQL CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES;CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES *ERROR at line 1:ORA-00955: name is already used by an existing object Any ideas?-- Please see the official ORACLE-L FAQ: http://www.orafaq.net 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 LLCand 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.
RE: alter system
Thank You!!! Found this in the trace file ORA-00942: table or view does not exist Current SQL statement for this session: INSERT INTO SBC_GLOBAL.MLOG$_EMPLOYEE_ROLE (dmltype$$,old_new$$,snaptime$$,c hange_vector$$) VALUES (:d,:o,to_date('4000-01-01:00:00:00','-MM-DD:HH24:MI: SS'),:c) ...I looked then proceeded to query all_objects SQL select object_name, object_type from all_objects where object_name like '%MLOG%'; OBJECT_NAMEOBJECT_TYPE -- -- C_MLOG#CLUSTER I_MLOG#INDEX MLOG$ TABLE MLOG_REFCOL$ TABLE I_MLOG_REFCOL1 INDEX MLOG$_ACTION TABLE didn't show up there. ??? so I got into OEM and looked under snapshot logs and sure enough it was there. ...so I dropped it through OEM and the error disappeared. ...so I guess OEM is good for something!! But...why didn't the MLOG$_EMPLOYEE_ROLE not show up in all_objects (or dba_objects) but it did in OEM? ...and what tells Oracle to update that snapshot log? ..where is that information stored? Thanks for your help!!!...and everyone's help for that matter! chris -Original Message- Sent: Friday, October 03, 2003 10:11 AM To: Chris Stephens Then, you have to use oradebug. It goes like this: oradebug setmypid oradebug event 942 trace name errorstack forever, level 10 You MUST be connected as sysdba in order to use oradebug. It may be platform/version specific problem. On Fri, 2003-10-03 at 11:08, Chris Stephens wrote: Dedicated server. -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 10:04 AM To: Chris Stephens Subject: RE: alter system Are you using a dedicated server connection or MTS? On Fri, 2003-10-03 at 10:59, Chris Stephens wrote: I was connected as sysdba. ...after I first tried it as the object owner and received an insufficient privileges message. Any other ideas? Thanks for your help. -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 9:47 AM To: Chris Stephens Subject: alter system Chris, you might need a SYSDBA connection to do that and and it must be a dedicated one. 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. 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. 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: Chris Stephens
RE: Seems odd to me....(bug?)
Title: RE: Seems odd to me(bug?) 1 select owner, object_name, object_type, status 2 from all_objects 3* where object_name='EMPLOYEE_ROLE' SQL / OWNER OBJECT_NAME OBJECT_TYPE STATUS -- -- -- --- SBC_GLOBAL EMPLOYEE_ROLE TABLE VALID NET_SBC EMPLOYEE_ROLE SYNONYM VALID. ...when I did the sql in the original message I was connected as sbc_global...so the synonym could not be the problem. ...I've also confirmed that there are no triggers on the table. I should also mention that this has happened before but since it was ONLY in test, I simply dropped the objects and recreated them. I (without any evidence. .( i know...I know!!)) though it might have have something to do with data dictionary corruption or somehting so I exported the schema and placed it into a database that I have never had problems with. that did not solve it. ...I will try Mladen's suggestion next. chris -Original Message- From: April Wells [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 4:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Seems odd to me(bug?) something other than a table? Synonym that the inserter only has select on? see what you can find in all_objects or all_tables -Original Message- From: Chris Stephens To: Multiple recipients of list ORACLE-L Sent: 10/2/2003 5:39 PM Subject: Seems odd to me(bug?) Oracle EE 8.1.7.2 HP-UX 11 Can anyone explain this? 1* INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL) SQL / INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL) * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist 1* select count(*) from user_tables where table_name='EMPLOYEE_ROLE' SQL / COUNT(*) -- 1 SQL CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES; CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES * ERROR at line 1: ORA-00955: name is already used by an existing object Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
Seems odd to me....(bug?)
Oracle EE 8.1.7.2 HP-UX 11 Can anyone explain this? 1* INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL) SQL / INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL) * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist 1* select count(*) from user_tables where table_name='EMPLOYEE_ROLE' SQL / COUNT(*) -- 1 SQL CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES; CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES * ERROR at line 1: ORA-00955: name is already used by an existing object Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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: Off Topic: PC Firewall Recommendation
Try Zonealarm. It's free. I have a wireless router, which has a built in firewall. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of KENNETH JANUSZSent: Monday, September 29, 2003 10:05 AMTo: Multiple recipients of list ORACLE-LSubject: Off Topic: PC Firewall Recommendation I have a Dell 8200 with XP Prof. SP1. I would like recommendations as to a good firewall for this machine. XP has a firewall but it is not the greatest. Thanks much, Ken Janusz, CPIM
RE: FTP big file to little laptop
Sounds more like there HOT HOT HOT XXXInfo files of you...according to that other email. Large files = picture files. -Original Message- Bellow, Bambi Sent: Friday, September 26, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Friends -- Don't ask for the details... they're too gruesome for print... but I need to FTP several 30GB files to my laptop, and all the FTP packages I've tried crap out at 4G. And before someone yells OT, they're DBF files and this is a backup. BTW, the Maxtor 250GB external storage device... very nice. Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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: Grabowy, Chris 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: FTP big file to little laptop
OMG!! I just spewed tea all over my keyboard and screen -Original Message- Bellow, Bambi Sent: Friday, September 26, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Yeah, baby! You should see what I keep in BLOBS! Bambi. -Original Message- Sent: Friday, September 26, 2003 1:10 PM To: Multiple recipients of list ORACLE-L Sounds more like there HOT HOT HOT XXXInfo files of you...according to that other email. Large files = picture files. -Original Message- Bellow, Bambi Sent: Friday, September 26, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Friends -- Don't ask for the details... they're too gruesome for print... but I need to FTP several 30GB files to my laptop, and all the FTP packages I've tried crap out at 4G. And before someone yells OT, they're DBF files and this is a backup. BTW, the Maxtor 250GB external storage device... very nice. Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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: Grabowy, Chris 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: Bellow, Bambi 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: Grabowy, Chris 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: equivalent for isdate, isnumeric
You must work for SCO... -Original Message- Mladen Gogala Sent: Thursday, September 25, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Hey, I'll sue you for using my code. My code is fair and balanced and you cannot use it without paying royalties. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of AK Sent: Thursday, September 25, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: equivalent for isdate, isnumeric I am not sure if there is any such function in 9i . But you can definnitely accomplish this by writing your own function something like function isNum(a varchar2) returns boolean is begin b := tonumber(a); result = true; return result; exception when (numer or value error) -- get proper exception result=false return result; end; same can be done for isDate as well. -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 8:34 AM Hi All, I am investigating an effort to move our product into Oracle from SQL Server. Came across the function isnumeric, isdate in SQL Server that returns true or false if the input string is in a form that can be converted into a numeric or date type. searched in oracle help and am not able to find an equivalent. Is there any equivalent form of these functions in Oracle?? Thanks, ShivaM DISCLAIMER: This e-mail contains proprietary information some or all of which may be legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail. If you are not the intended recipient, you must not use, save, disclose, distribute, copy, print or relay this e-mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shiva Maran 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: AK 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). 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San
RE: 64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)
Peter, I know that this looks odd but as the hardware is 64 bit the AIX O/S has some sort of translation layer that allows it to run Oracle 64 bit even though the kernel is in 32 bit mode. I discovered this when investigating running Oracle 9.2 and Oracle 8.1.7 on AIX 5L. After raising a TAR with Oracle I received the response which basically stated: - Oracle 8.1.7 can only be run in 32 bit mode on AIX 5L. - To run Oracle 8.1.7 and Oracle 9.2 concurrently on AIX 5L you must run AIX in 32 bit mode on 64 bit hardware with 32 bit Oracle 8.1.7 and Oracle 9.2 64 bit (it only exists in 64 bit mode). Confusing I know but somehow true. As an aside I don't think this applies to the likes of HP-UX. I'm fairly sure that running 32bit HP-UX 11 on 64 bit hardware will not allow 64 bit Oracle to run. HTH Chris Dunscombe -Original Message- Sent: 11 September 2003 21:39 To: Multiple recipients of list ORACLE-L O/S is AIX 4.3.3 /usr/sbin/bootinfo -p returns chrp meaning that the hardware is capable of either 32 or 64 bit operation. /usr/sbin/bootinfo -K returns 32 meaning that the kernel is running in 32 bit mode. When I run sqlplus the server says: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production How can I be running the 64 bit server on a system with a 32 bit kernel? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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: Dunscombe, Chris 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: 64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)
Peter, I'll answer the 2nd question first as it's easier. - You will need to change the word size of your database from 64 bit to 32 bit. This involves running a few scripts and bouncing the database were required. The exact process is described in a Metalink note, sorry but I don't have the number to hand. - In answer to the 1st question I believe you can only run the Oracle 8.1.7 software in 32 bit mode on AIX 5L so Oracle 8.1.7 will be running as 32 bit software even after you apply the patch. See the end of the Metalink note: Oracle Releases for AIX 4.3.3 and AIX 5L: - The 64-bit ABI in AIX 4.3.3 is not supported under AIX 5L. Moving existing 64-bit applications from AIX 4.3.x to AIX 5L requires recompiling the application source code, and possibly changing application source code to ensure that data types are used correctly and consistently. Due to this restriction, starting from 9.2.0 version, Oracle ships different CDs for AIX 433 and AIX 5L. Customers should be careful not to use the wrong CDs, since these two releases are not compatible. This is also the reason why the 64-bit versions 9.0.1 and 8.1.7/64 do not run on AIX 5L. Cheers, Chris -Original Message- Sent: 12 September 2003 15:30 To: Multiple recipients of list ORACLE-L Thanks for the response. I have Metalink note 231901.1 which explains the options for installing 8.1.7 on AIX 5L, so I understand what I have to do (after reading it three times). Additional questions: - If we run the 64 bit kernel and put on the required patch for 8.1.7 will I be running Oracle in 64 bit or 32 bit mode? - If Oracle is running in 32 bit mode, what will happen if I restore a cold backup of my AIX 4.3.3 (64 bit) database onto the AIX 5L system? Thanks, Peter Schauss -Original Message- Sent: Friday, September 12, 2003 5:24 AM To: Multiple recipients of list ORACLE-L Peter, I know that this looks odd but as the hardware is 64 bit the AIX O/S has some sort of translation layer that allows it to run Oracle 64 bit even though the kernel is in 32 bit mode. I discovered this when investigating running Oracle 9.2 and Oracle 8.1.7 on AIX 5L. After raising a TAR with Oracle I received the response which basically stated: - Oracle 8.1.7 can only be run in 32 bit mode on AIX 5L. - To run Oracle 8.1.7 and Oracle 9.2 concurrently on AIX 5L you must run AIX in 32 bit mode on 64 bit hardware with 32 bit Oracle 8.1.7 and Oracle 9.2 64 bit (it only exists in 64 bit mode). Confusing I know but somehow true. As an aside I don't think this applies to the likes of HP-UX. I'm fairly sure that running 32bit HP-UX 11 on 64 bit hardware will not allow 64 bit Oracle to run. HTH Chris Dunscombe -Original Message- Sent: 11 September 2003 21:39 To: Multiple recipients of list ORACLE-L O/S is AIX 4.3.3 /usr/sbin/bootinfo -p returns chrp meaning that the hardware is capable of either 32 or 64 bit operation. /usr/sbin/bootinfo -K returns 32 meaning that the kernel is running in 32 bit mode. When I run sqlplus the server says: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production How can I be running the 64 bit server on a system with a 32 bit kernel? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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: Dunscombe, Chris 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: Schauss, Peter 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
RE: Copying statistics : used a lot ????
By chance, do you have Tom Kyte's latest book? Effective Oracle by Design?? He states his opinion on this approach on page 30, section entitled Test Against Representative Data. -Original Message- Stephane Paquette Sent: Thursday, September 11, 2003 4:38 PM To: Multiple recipients of list ORACLE-L HI, I was wandering if a lot of people are copying statistics using dbms_stats from production to test environment to see what will be the access plan. If not used, why ? no time to look at it, bugged, not usefull ,... ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Grabowy, Chris 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: Oracle Masters exam
I was just looking into this. If I understand it correctly, you have to take 2 'advanced' classes =$2000-$5000 total (depending on which courses) and then you have to pay $2000 just to take the practicum. This might be the real deal and an exciting achievement to work towards but I for one know that my company won't be shelling the $$$ out and my pockets are nowhere near that deep. It's too bad. It seems like it would be fun. Chris -Original Message- Sent: Thursday, September 04, 2003 10:20 AM To: Multiple recipients of list ORACLE-L So, it's nothing like OCP where you get the certification when you spew out certain amount of the green stuff? I wonder how long will it take before seeing oracle masters who don't know how to take a hot backup. -- Mladen Gogala Oracle DBA -Original Message- Sharman Sent: Wednesday, September 03, 2003 6:39 PM To: Multiple recipients of list ORACLE-L And having sat through the beta of the masters exam, let me reiterate what Reichert said in the article. You really do have to have the hands on experience to pass it. I've been using Oracle for something like 15 years now, and training others in the DBA world for 11 or so of those 12 years, and this was the hardest exam I've ever sat through. 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- Boivin, Patrice J Sent: Thursday, September 04, 2003 6:45 AM To: Multiple recipients of list ORACLE-L Oracle Mag has something about the Oracle Masters program... http://otn.oracle.com/oramag/oracle/03-sep/o53news.html Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J 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). 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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
Oracle's Masters program....
Here's a little more info. This is from a lady I work with Hey I found out a little bit of info on the masters certification. My dad is the author/architect of the test. He did not assign the scoring it sounded like it was an outside organization that came up with the scoring. Anyway he said that if someone really knows their stuff they will probably finish 1-2 sections within the time and probably complete around 70% of the other sections within the time. You do not have to finish the sections in order to pass, I believe he told me there are a total of eight sections. That he knows of there has only been one individual who has completed all sections under the time limit he told me the persons name but I do not remember what it was. Another individual knew that one of the sections was his troublesome area so he spent several hours over a couple weeks period studying that area and was able to finish that section within 45 minutes the allotted time was an hour and half. He did say that in the first section the test comes out and tells you to make three backups and there has been several people who fail to do so and in the second section have to do a restore which they have to write and end up only completing around 30% of that section. A little bit of info on it for you anyway. If there is anything you would like to know about it I can try to find out for you. It'll be interesting to see if this thing takes off. Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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).
OT: The Coming Job Boom
My apologies for this OT post. There is an article in Business 2.0 magazine, Sept issue, titled The Coming Job Boom that is very interesting. The point of the article is that there will be a labor shortage by 2010 because the Baby Boomer generation will be retiring over the next decade. Obviously, there are critics of these reports but supposedly this is based on demographics, which is supposed to be more reliable. The articles quotes that companies like, Cigna, Intel, SAS, Sprint, Whirlpool, etc. are worried about this problem. Now for the tie into this list...there is a chart that depicts the 10 fastest growing occupations, DBAs are 7th. A 66% increased demand for DBAs by 2010. Software developers are 1st on the chart, with a 100% increase in demand by 2010. So for those of us hurting right now, hang in there. Aside from this article, has anyone else seen articles or reports like these? Below is a link to the article, which requires membership... http://www.business2.com/articles/mag/0,1640,51816,00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris 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: The Coming Job Boom...cnn has a an article on the job boom su
Title: Message http://www.business2.com/articles/mag/0,1640,51816,00.html -Original Message- From: April Wells [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: The Coming Job Boom Oh it's okay... Paula lives in Florida... she has to be more tolerant of old people in their monstrous Cadillacs, driving 40 mph inthe passing lane... and snowbirds and bad humor... =) I was wondering how one performed CPA though... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: The Coming Job Boom CPR, not CPA. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen Gogala Sent: Friday, August 29, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: The Coming Job Boom Paula, does that mean that the DBA of the future will have to learn how to perform CPA and do a therapeutic massage? I have problems with surgery, except if done on damagement. We'll have to speak louder and be more tolerant to old people in their monstrous Cadillacs, driving 40 mph inthe passing lane and not use long beams, horn, ourextremities or the combination of the above. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: The Coming Job Boom That's nice but what if the companies outsource overseas in response to this concern - hmmm. Still on the up-side they won't be able to do this in all cases and so overall there will likely be a positive demand for DBA skills in relation to the ageing of our Nation. However, how's about (having elderly parents) you are a DBA with experience in the -medical areas The big demand in the workforce will be related to the healthcare industry and spin-offs or retirement issues as the aging population will require this. Interesting to see what it does to our healthcare industry, pharme., medicine. It is insane what the medical profession costs in this country in the face of an aging population with much more and not less need for medical care. Sorry - some O.T. coming up. -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 12:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: The Coming Job Boom Sounds similar to the economic theories of Harry S. Dent, Jr. -- it's all based on birth-rate. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 9:31 AM To: Multiple recipients of list ORACLE-L Subject: OT: The Coming Job Boom My apologies for this OT post. There is an article in Business 2.0 magazine, Sept issue, titled The Coming Job Boom that is very interesting. The point of the article is that there will be a labor shortage by 2010 because the Baby Boomer generation will be retiring over the next decade. Obviously, there are critics of these reports but supposedly this is based on demographics, which is supposed to be more reliable. The articles quotes that companies like, Cigna, Intel, SAS, Sprint, Whirlpool, etc. are worried about this problem. Now for the tie into this list...there is a chart that depicts the 10 fastest growing occupations, DBAs are 7th. A 66% increased demand for DBAs by 2010. Software developers are 1st on the chart, with a 100% increase in demand by 2010. So for those of us hurting right now, hang in there. Aside from this article, has anyone else seen articles or reports like these? Below is a link to the article, which requires membership... http://www.business2.com/articles/mag/0,1640,51816,00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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). Note: This message
RE: Oracle World anyone?
Connor, So will those 9i goodies be available to those of us that are not going to make it??? Everyone seems to agree that the economy is starting to rebound except when you ask for training funds -Original Message- Connor McDonald Sent: Friday, August 15, 2003 12:34 PM To: Multiple recipients of list ORACLE-L I'll be presenting there. Come see me on Monday for 9i goodies that aren't so well known as some of the other more heavily marketed features. Its also a chance to see someone try get through 100 plus slides in an hour without taking a breath. Only got to 98 last year at UKOUG so I'm keen to break the 100 barrier :-) Are we all doing the standard oracle-l mexican next to the moscone on one of the nights ? Anyone live in SF that can arrange a booking ? Preferred nights ? Cheers Connor --- John Kanagaraj [EMAIL PROTECTED] wrote: And there will be a bunch of us 'Silicon Valley' types who can arrange a get-together for ORACLE-L members. The rowdy bunch that got together last year nearly tore up the Restaurant, btw John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 7:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle World anyone? Thursday, August 14, 2003, 9:24:29 PM, you wrote: SM Just completed the registration, and was wondering how much company I was SM going to have there. SM Who else has plans to attend? I'll be there. I'm even presenting this year. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: John Kanagaraj 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Move selected tables
You've gotten several suggestions for how to move the data - let me mention some of the caveats. We went from one big shared schema to several smaller schemas, which is what led to issue 3 below. If that's not what you're doing, you may not have this problem. We've done some of this, and here are some of the issues we've run into. 1) make sure your referential integrity is maintained. If you are moving a parent or child table, you'll have to drop and recreate any foreign keys. export/import makes this somewhat easier than 'create as select *', but not trivial. It's easier if you move both parents and children in the same export set (assuming they're all being moved). 2) make sure the data doesn't change while you're moving the tables. What we've done in some cases is open an SQLPlus window, lock the tables, then do the export/import in a different shell. 3) make sure any code finds the correct tables. We've created private synonyms for the tables in the new locations as an interim solution. There is a little overhead associated with resolving synonyms while parsing queries but it doesn't seem to be a problem for us. The down side is that there is not much incentive for developers to point to the correct tables, and there's no good way to keep someone from referring to the old schema when they should be using the new schema. Some on this list will say this is a matter of DBA discipline: at any rate it is a matter of management discipline, and the DBA's ability to do anything about it depends on how much control they have over introduction of new code. Good luck, -Chris -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Subject: Move selected tables I need to move selected tables from one schema to another schema within the same database. The tables I need to move all start with the same prefix (abc_sometablename). Say there are 200 tables out of 1000 that I want to move. Is there an easy way to do this? Thanks! Ron -- LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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: Redo Logs Problem
You don't mention the database version, but if it is 8i or later, you could use logminer to view the contents of the redo logs. -Original Message- Sent: Friday, August 01, 2003 6:34 AM To: Multiple recipients of list ORACLE-L Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client). Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated. Regards Munish Bajaj LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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: How to display FLOAT in 99999.999 format
use a 0 instead of a 9 for leading/trailing zeroes. SQLselect to_char(123.45, '999.990') from dual; TO_CHAR( 123.450 SQLselect to_char(123.45678, '999.990') from dual; TO_CHAR( 123.457 SQLselect to_char(123.45, '0999.990') from dual; TO_CHAR(1 - 0123.450 -Original Message- From: Odland, Brad [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 2:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to display FLOAT in 9.999 format Tried that. 1234.1 won't show the trailing zeros... -Original Message- Sent: Friday, August 01, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Not sure if this is the best way but you could do something like SELECT TO_CHAR(1,'999.999') FROM DUAL; Only drawback that I have been running into is if you don't allot of enough spaces before the decimal it display a value of . Hope this helps. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 01, 2003 12:14 PM How do I force display of a FLOAT in a format like Original number Result 1234.34 1234.340 12345.456 12345.456 123.1 123.100 123123.000 The dev on a project wants to preformat the data for a report on the database side. He wants 3 places after the decimal to display even if the number is a whole number (I know most VB report controls do this easilybut...) I thought it was complicated as it would require a to_char with format description then searching for the postion of the decimal and then moving from there to the right counting the characters if the number of characters to the right of the decimal was 3 then pad with zeros... I messed around with RPAD, TRUNC, ROUND and TO_CHAR and found I was not able handle all cases of possible significant digits. Sounded like a complicated function to do something thats automagic in a reporting control. Or am I forgetting a oracle functionor fomat? This is 8.1.7 I told the developer to use the field formatting contols of his reporting control because the additional zeros padded in a number are basically meaningless in a database and mathematical operations. Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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: Jay 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: Odland, Brad 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). LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http
nothing directly related to Oracle...but certainly relevant...
Title: nothing directly related to Oracle...but certainly relevant... http://story.news.yahoo.com/news?tmpl=story=/nm/20030729/tc_nm/tech_jobs_dc_1 the world is changing quickly. Chris Current DBA in-progress...future ???
RE: Oracle Banner
Yes it is. We actually had to do it for a canned app that checked the exact version of the database...for no apparent reason. The app would only run on 8.1.6 and we were running 8.1.7...so we just created a table with the exact same structure as v$_version and update the table to reflect 8.1.6. We then just pointed the public synonym (v$version) to the dummy table. This is probably not recommended but we tested it on our development database and have had no ill effects. Mladen...please have mercy on me. J ...it isn't the same as messing with the data dictionary or screwing with objects owned by sys. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 2:39 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Banner Does anybody know if is possible to change the Oracle banner description? Oracle9i Enterprise Edition Release 9.0.1.3.0 - Production PL/SQL Release 9.0.1.3.0 - Production CORE 9.0.1.2.0 Production TNS for Solaris: Version 9.0.1.3.0 - Production NLSRTL Version 9.0.1.3.0 - Production I would like to identify the environment as development environment instead of production. Sandro Augusto da Silva Technology Services Support NLA Technology Services Phone: +55 11 3398-8438 Fax: +55 11 3398-7522 Esta mensagem, incluindo seus anexos, pode conter informao confidencial e/ou privilegiada. Se voc recebeu este e-mail por engano, no utilize, copie ou divulgue as informaes nele contidas. E, por favor, avise imediatamente o remetente, respondendo ao e-mail, e em seguida apague-o. Este e-mail possui contedo informativo e no transacional. Caso necessite de atendimento imediato, recomendamos utilizar um dos canais disponveis: Internet Banking , BankBoston por telefone ou agncia/representante de atendimento de sua convenincia. Agradecemos sua colaborao. This message, including its attachments, may contain confidential and/or privileged information. If you received this email by mistake, do not use, copy or disseminate any information herein contained. Please notify us immediately by replying to the sender and then delete it. This email is for information purposes only, not for transactions. In case you need immediate assistance, please use one of the following channels: Internet Banking , BankBoston by phone or branch/relationship manager at your convenience. Thank you for your cooperation.
RE: Oracle Banner
Actually...went to look and see exactly how we did this...(it was quite a while ago)... We didn't drop the v$version public synonym. We created a private synonym with the same name in the schema the app ran in and had it point to the new dummy table. -Original Message- From: Chris Stephens [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Banner Yes it is. We actually had to do it for a canned app that checked the exact version of the database...for no apparent reason. The app would only run on 8.1.6 and we were running 8.1.7...so we just created a table with the exact same structure as v$_version and update the table to reflect 8.1.6. We then just pointed the public synonym (v$version) to the dummy table. This is probably not recommended but we tested it on our development database and have had no ill effects. Mladen...please have mercy on me. J ...it isn't the same as messing with the data dictionary or screwing with objects owned by sys. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 2:39 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Banner Does anybody know if is possible to change the Oracle banner description? Oracle9i Enterprise Edition Release 9.0.1.3.0 - Production PL/SQL Release 9.0.1.3.0 - Production CORE 9.0.1.2.0 Production TNS for Solaris: Version 9.0.1.3.0 - Production NLSRTL Version 9.0.1.3.0 - Production I would like to identify the environment as development environment instead of production. Sandro Augusto da Silva Technology Services Support NLA Technology Services Phone: +55 11 3398-8438 Fax: +55 11 3398-7522 Esta mensagem, incluindo seus anexos, pode conter informao confidencial e/ou privilegiada. Se voc recebeu este e-mail por engano, no utilize, copie ou divulgue as informaes nele contidas. E, por favor, avise imediatamente o remetente, respondendo ao e-mail, e em seguida apague-o. Este e-mail possui contedo informativo e no transacional. Caso necessite de atendimento imediato, recomendamos utilizar um dos canais disponveis: Internet Banking , BankBoston por telefone ou agncia/representante de atendimento de sua convenincia. Agradecemos sua colaborao. This message, including its attachments, may contain confidential and/or privileged information. If you received this email by mistake, do not use, copy or disseminate any information herein contained. Please notify us immediately by replying to the sender and then delete it. This email is for information purposes only, not for transactions. In case you need immediate assistance, please use one of the following channels: Internet Banking , BankBoston by phone or branch/relationship manager at your convenience. Thank you for your cooperation.
RE: Problem with Autotrace ?
SQL-Plus is a little like the old interactive fiction games (text-based games, like 'Adventure' or 'Zork'). You only need to type enough of some words so that they are unambiguous. See the SQL-Plus User's Guide, command reference (chapter 8 for 8.1.7, chapter 13 for 9.2.0) for details. I'm afraid I don't have anything add to the original question, I was going to suggest the obvious grant PLUSTRACE but I reviewed the thread and saw that was already dealt with. -Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 5:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: Problem with Autotrace ? I don't know much about Oracle, Is there a spelling mistake in the command you gave ? SQL set autot trace - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 28, 2003 09:19 Guys, when i try the same from a different machine,i get the error below. { this client machine has 9.2.0.2/Win2K server - with SP3 } SQLconnect cti/[EMAIL PROTECTED]; SQLset autot trace SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report .seems to be unusual.isn't it ? had anyone faced the same problem ? can someone help me out. Regards, Jp. LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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: dbms_job
It would seem that dbms_system has become undocumented. It used to be partially documented, e.g. there was a description of set_sql_trace_in_session, but they seem to have pulled that as of 8.1. You're supposed to use dbms_support now, but that too seems to be undocumented. At least on Solaris, you have to beg support for the 8i install script, but the 9i install script is included in $ORACLE_HOME/rdbms/admin. There are some notes about this in some of the forums at metalink ( I searched 'dbms_system dbms_support'). HTH, -Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: dbms_job Hello list, I am running 9.2.0.1.0 enterprise edition on win32. Why doesn't the Supplied PLSQL Packages and Types Reference docs mention dbms_system ? It doesn't seem to be explained anywhere in the docs although the admin docs say that it can be used enable sql_trace for another session. I was able to do that only after learning about its parameters thru : sql describe dbms_system while I was logged in as sysdba. .. LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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).
bad press for oracle....
Title: bad press for oracle http://rss.com.com/2110-1017_3-5053453.html?type=pt=rss=feed=news
DB_BLOCK_SIZE??? Survey.
I just started at my new DBA job, and I have been reviewing their database installation procedure. I noticed that they create all their databases with a 4K block size. This is for Oracle 9.2 on AIX 5.2. It has been my general understanding that most sites these days use 8K db_block_size as a minumum for general OLTP databases. And some sites are considering 16K db block size tablespace for indexes. At any rate, does anyone have any pro/con thoughts on the smaller 4K db block size??? Also, if your interested, please reply back to me DIRECTLY with your site's DB_BLOCK_SIZEs for OLTP/DWs. I promise to tally the results and share them with everyone. mailto:[EMAIL PROTECTED] Many thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris 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: Veritas like RMAN?
Can they point to backup sets from which you can test recovery? As someone else mentioned, that's the crucial issue. There are a couple of possibilities: Veritas can do volume mirroring, for example. I haven't used this at the Veritas level but we do something similar on our Hitachi SAN (to generate a development image, not backup). The SAN mirror instructions say that we have to put the DB in hot backup mode and quiesce the database during the split, which seems a bit like belt and suspenders to me (how can you get a split block if the database is quiesced?) but that's what we do. I'd guess Veritas mirroring would require at least one of the two steps, both of which should show up in the alert log. From: Michael Kline [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Subject: Veritas like RMAN? I found no signs of RMAN being used in any way shape or form... I've been told they are doing hot backups using Veritas... HOWEVER, the alert log shows no signs what so ever of alter tablespace xyz begin/end backup... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place. Is Veritas capable of this? If so, why is there a Veritas interface to RMAN??? Confusion, confusion... LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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: faq broke? -- Other options
Title: RE: faq broke? -- Other options There was an astTom article in the latest issue of Oracle magazine that went over how to do this (I don't think it was specific to 9i) and then went on to explain why you WOULDNT want to do this. -Original Message- From: Hallas, John, Tech Dev [mailto:[EMAIL PROTECTED]] Sent: Monday, July 21, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Subject: RE: faq broke? -- Other options Good point Rich. I am sure I saw a post recently from Cary Millsap which shows how you could flush the buffers out with an alter system command (9i only) - to save restarting the database when running performance trials I have searched for it everywhere to no avail So if anybody recalls what it was please let me know (I assume it is undocumented as I cannot find anything in the manual) Thnaks John -Original Message- Sent: 21 July 2003 15:45 To: Multiple recipients of list ORACLE-L Hey Bruce, Any possibility of making the bodies of the FatCity archived messages searchable, instead of just the subject? That's the only reason why I even bother with the orafaq search. Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Bruce A. Bergman [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 19, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Subject: Re: faq broke? -- Other options Don't think that the only searchable archives are on orafaq. Fat City has the definitive archives that date back to the start of the list here. You should consider using the archives here as well. You can find them here: http://www.listguru.com thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: Hallas, John, Tech Dev 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: Empty String is interpreted as NULL
Oracle is nearly SQL-92 compliant. Oracle does in fact think that empty strings are equivalent to NULL. What's worse is that some developers depend on this behavior in their code. I thought I'd seen warnings about the possibility this may change in the future in the Oracle docs but I couldn't find anything after a quick search (the '' == NULL is documented). I don't think there's any workaround. Oracle simply does not allow empty VARCHAR2 strings (well, it does, but it calls them NULL). And what's even worse than that is that, depending on the interface you use, if you try to use a string made up entirely of spaces Oracle will helpfully strip trailing spaces, you'll end up with an empty string, and you'll get the same error again. There are workarounds for this, it depends on the interface you're using. -Original Message- From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Subject: Empty String is interpreted as NULL Hello all, Suppose I have this table SQL DESC FRUIT Name Null?Type - ORANGENOT NULL VARCHAR2(10) APPLE NOT NULL VARCHAR2(10) If I do this insert: SQL / INSERT INTO FRUIT VALUES ('hello', '') * ERROR at line 1: ORA-01400: cannot insert NULL into (LIGHTCONE.FRUIT.APPLE) I got an error cannot insert NULL. But, what if I meant is to insert empty string '' ? Certainly empty string is NOT equal to NULL values. So how do I get around this? Thanks in advance for any help. LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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: Find the table's name that using sequences
Well, there could be business logic reasons as to why you would have one sequence per table. Also, I don't know if I would ever go with one sequence for many tables, sounds like a bottle neck to me. And how would one sequence for many tables impact scalability?? Or having lots of users hammering the database?? And what happens if you have to reset the sequence, then you have to check the primary key values on many tables. One sequence to one table sounds good to me, but I would love to hear pros/cons about this... -Original Message- Sent: Wednesday, July 16, 2003 3:35 PM To: Multiple recipients of list ORACLE-L no table uses a sequence. And there is no reason (other than sanity checks) to have one sequence per table. SQL code will use the sequence, usually to retrieve a value from the sequence to then insert into or update a column in a table. --- Mitchell [EMAIL PROTECTED] wrote: Hi All At first I thought it is easy to find those tables to use sequences but I failed. dba_sequence don't give too much info. Is there any idea? Thanks in advance Mitchell __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com 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). attachment: winmail.dat
RE: full usefullness of CURRENT OF ???
I believe (I could be totally wrong here) the reason for the CURRENT OF is both for performance and consistency. The second example has to run the update statement seperately. CURRENT OF can go directly to the row(s) affected. CURRENT OF still has to modify each block header in the table to lock which is a small performance hit. To prevent that you could update by rowid and avoid the header updates. Also, the CURRENT OF locks the table so that no one can modify (or even read) it while the transaction is taking place. This guarantees nothing is changing between retrieving values from the cursor and updating the table based on those values. -Original Message- Sent: Friday, July 11, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Could anyone give us an idea as to the full usefullness of CURRENT OF? Here are my two separate examples: /* 1 this one has a CURRENT OF */ DECLARE CURSOR EmpCursor IS SELECT * FROM Emp FOR UPDATE; BEGIN FOR EmpRec IN EmpCursor LOOP UPDATE EMP SET SALARY = SALARY * 1.08 WHERE CURRENT OF EmpCursor END LOOP; END; /* 2 same as above, except without the CURRENT OF */ DECLARE CURSOR EmpCursor IS SELECT * FROM Emp FOR UPDATE; BEGIN FOR EmpRec IN EmpCursor LOOP UPDATE EMP SET SALARY = SALARY * 1.08 WHERE EMP_ID = EmpRec.Emp_ID; END LOOP; END; / Is one more efficient than the other? If I could have done business without the CURRENT OF, then why did oracle made it available? thx maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson 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: full usefullness of CURRENT OF ???
Title: RE: full usefullness of CURRENT OF ??? Locking if something oracle is very good at. It happens all over the place and it happens quickly...there is very little overhead to it. Block headers. ...each block in the affected table. By updating the table by rowid, you get the best of both worlds assuming no one is re-orging the table (or somehow altering rowid to row value relationship) and that there is no need prevent users from touching the table while you are doing the update. Cursor c_crud is select rowid, col1 from t_crud; For v_crud in c_crud loop Update t_crud Set col1=whatever where rowid = v_crud.rowid; End loop; (I remember reading about this in Guy Harrison's SQL tuning book...if you have a copy, I'd check that outbecause I am very prone to memory recall error :) ) -Original Message- From: MaryAnn Atkinson [mailto:[EMAIL PROTECTED]] Sent: Friday, July 11, 2003 3:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: full usefullness of CURRENT OF ??? --- Chris Stephens [EMAIL PROTECTED] wrote: Also, the CURRENT OF locks the table so that no one can modify (or even read) it while the transaction is taking place. This guarantees nothing is changing between retrieving values from the cursor and updating the table based on those values. OK, fair enough. The second example has to run the update statement seperately. CURRENT OF can go directly to the row(s) affected. CURRENT OF still has to modify each block header in the table to lock which is a small performance hit. So CURRENT OF has to lock, so its slower, right? Does it have any advantages after all? To prevent that you could update by rowid How? How can I update by ROWID? I was thinking to update by PRIMARY_KEY... and avoid the header updates. ... what header updates? thx maa __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson 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: salary question
The beer is cheaper in Canada... -Original Message- Sent: Monday, July 07, 2003 7:54 AM To: Multiple recipients of list ORACLE-L Check out the Canadian results... http://www.payscale.com/salary-survey/aid-10747/raname-SALARY/fid-7031/ http://www.payscale.com/salary-survey/aid-10747/raname-SALARY/fid-7031/ I have never been able to figure this out, salaries are typically lower in Canada than in the U.S., for no apparent reason that I can think of. Patrice. -Original Message- Sent: Friday, June 27, 2003 1:10 PM To: Multiple recipients of list ORACLE-L http://www.payscale.com/research/vid-18563 http://www.payscale.com/research/vid-18563 choose the personal payscale report, to have an idea about what you get and what you should be getting.. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Didn't someone earlier this week post another site besides salary.com? Something with the word pay in it? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 27, 2003 4:19 AM To: Multiple recipients of list ORACLE-L Whatever the figure may be, two things are certain if the salary is X: a) I probably don't deserve to get X b) I should be getting more than X :-) --- Helen J Mitchell [EMAIL PROTECTED] wrote: Does anyone have information about salaries in Denver? I looked at salary.com and saw the median salary was $72K. Does anyone have any opinions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Helen J Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com 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). = Connor McDonald web: http://www.oracledba.co.uk http://www.oracledba.co.uk web: http://www.oaktable.net http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com 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 http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com 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). = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Raid 0+1 vs. mirrored pairs
Title: Raid 0+1 vs. mirrored pairs Hi Everyone, I guess I am stuck in the old myth which says one giant raid array for everything is bad. We have been told Windows 2000 server is what we will now run Oracle on. Setting aside the debate putting of Oracle on a Windows box, I am currently in discussions about how said server will be spec'ed out. So far we have agreed on everything except the disc drives. Our 2000 admin says taking six 36g drives and making a raid 0+1 out of them (108 raid 0, mirrored) is the fastest and absolute best way for this server to be setup. I like the idea of having sets of mirrored pairs. That way I can separate tables, indexes, redo logs, rollbacks, etc. Is my admin right? Are raid 0+1 setups the best of the best? Better than sets of mirrored pairs? Thank you in advance. Chris
RE: perl DBI/DBD: can I pass in an array as parameter?
Responses to 2 emails below: Alex wrote: not sure if this is what you want. one sql call select tab1.col1, tab2.col2 from tab1, tab2 where tab1.ID1 = tab2.ID2 and tab1.X = ? and tab1.X = ? and tab1.X = ? ; @my_array = (1,2,3); sth-execute(@my_array); Errm, no rows will be returned. Think about this one a little more. Steve Ollig wrote: ok - that makes more sense. sorry for misinterpreting the question. i've never done it, but my first instinct would be to explore using an in clause in the query - select tab1.col1, tab2.col2 from tab1, tab2 where tab1.ID1 = tab2.ID2 and tab1.X in (1, 2, 3) can you simply pass an array to the prepared statement that way? i'd try it but don't have a sandbox with the DBI/DBD modules handy. perhaps one of the great Perl gurus of the list will offer some insight... I'm not a Perl guru, but I can think of 2 solutions: #build an array with the keys you want to look for: my @my_array = (1, 2, 3); # then add that many ?s to the query #the 'in' solution: my $query = ' select tab1.col1, tab2.col2 from tab1, tab2 where tab1.ID1 = tab2.ID2 and tab1.X in (' . join(',',('?') x @my_array) . ')'; # or the 'union' solution my $subquery = ' select tab1.col1, tab2.col2 from tab1, tab2 where tab1.ID1 = tab2.ID2 and tab1.X = ?'; my $query = join(' union ', ($subquery) x @my_array); # pick only one of the above! # and then my $sth = $db-prepare($query); $sth-execute(@my_array); # then get the data back your favorite way: fetchall_arrayref, fetch_array, etc But is it really worth the trouble? As long as you are using bind variables, the overhead of multiple executes should not be very high. warning: these are typed from memory - I may have typos in the perl code. But the concept should work. -Chris LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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: SELECT Output Default Ordering ?
The official answer is, however the database feels like doing it at the time. In practice, it depends on the access method. If an index is used the output may be sorted by that index. Otherwise it might be by rowid. There are no guarantees and no defaults. Relational data has no default order. -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 9:33 AM To: Multiple recipients of list ORACLE-L Subject: SELECT Output Default Ordering ? When NOT Giving any Order by Clause , How is the Output of the SELECT Clause ordered by Default ? Assuming There exists a Unique index on the Table Is some Rule followed ? NOTE Records may have been INSERTED into the Table in some manner differing from the Order of the data of the Unique index Key fields. Thanks LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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).
Test please ignore
. -- Chris J. Guidry Principal Engineer, DCSI Phone: (314) 895-6516 Fax: (314) 895-6453 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guidry, Chris 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: Rebuilding MLOG tables
I don't think it will do quite what you want it to, since the 'alter table move' statements are DDL so will release the lock. I just tried this experiment in 2 SQLPlus windows: SQL 1.1 lock table blah in exclusive mode; returns with Table(s) Locked. SQL 2.1 insert into blah values (1); (this waits) SQL 1.2 alter table summ_snapshot move tablespace tools_data; returns with ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified but this is enough to release the first lock, because 2.1 now returns with 1 row created. On the other hand the move should be harmless. I see someone else has given a response with the same ultimate moral, but I'll still post, to point out the lock behavior. -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Subject: Rebuilding MLOG tables Among some of the Rube Goldberg applications around here, is one that has multiple replication clients that subscribe to a master. For whatever reason, we might have a client not update for a while and the MLOG table(s) get big. Then, after that, every update has to read up to sky-high high water mark. From the looking around we have done, the thing to do to get the HWM back down without rattling replication seems to be (during a time when we know no updates are going into the master): lock table xyz in exclusive mode; alter table mlog$_xyz move tablespace over_there; alter table mlog$_xyz move tablespace back_here; (optional, I suppose) rollback; (release the lock) LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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: SAME technology question .....
I think there's a lot of confusion about SAME. For example, we have a SAN with the disks grouped into 4-disk RAID-5 sets, and volumes striped across all of the sets (well, we have 2 sets of sets). These are presented as LUNs to Veritas, and then built up into a 1 TB logical volume. All of my datafiles are on that one volume. I multiplex the redo logs, control file, and archived redo logs to a smaller volume on separate spindles. There are several other volumes, used for different things (a copy of the Genbank database, for example), but all residing on the same 3 TB or so of spindles. I/O is not a bottleneck for us. The database activity is 90% reads and 10% writes, so RAID-5 does not seem to be an issue either. I used to have hot spots that moved from disk to disk, and had to move datafiles around. I don't have to do that anymore. hooray. It works for us. It may not work so well for a smaller database, or one that has higher write activity. But are we using SAME? According to one recent post on this list, the answer is no because we're not really mirroring on RAID-5. According to others we're not using SAME because I've multiplexed off to separate spindles. We don't follow the advice in the SAME paper of using the outer half of the disks for heavily accessed data. Seems to me that defeats one of the biggest benefits to SAME, for us, which is to stop worrying about micromanagement of disk. Here's my personal feeling about it. SAME, unlike for example relational database theory, is not a theory. It is an empirical method of getting acceptable throughput and dependability of disk I/O with minimal management overhead. If we're not running SAME, then I suppose I could advocate SAREISM (Strip and RAIDify Everything Including Some Multiplexing) or EMOGATADODIWMMO (see sentence above). -Chris -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Subject: SAME technology question . A couple years ago, Juan Louiza(sp) of Oracle Corporation put out a white paper regarding SAME (Stripe and Mirror Everything).I have read the comments from Steve Adams regarding this methodology. I am curious if anyone else is or is not using the SAME methodology and what has been your experience so far. Oracle Corporation has locked into this methodology as recently one of our DBA's reported that they are teaching this in classes, but that others have not exactly climbed on board. Excluding Oracle employees if you could respond regarding your thoughts and experiences I would greatly appreciate it. Thanks For Your Time in Advance. LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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: How to Uninstall apps1
Forrest, Apologies for not getting back to u sooner. Cloning on Nt (adv. Server) works very well when u have a SINGLE instance on each box. Also, O/S does not support multi to single clones (per the Feb 12 white paper). Our env is1157, nt Adv srvr)runningautoconfig for cloning, via Feb 12white paper. Bugs, we have seenon Single Instance Boxes are: Following past papers. There's ALLOT of conflicting information from Oracle on this. Make sure registry setting ADJVAPRG=f:\oracle\prodora\8.0.6\jdk\bin\java.exe (ie prod-'SID') under HKLM\S\ORACLE\APP\11.5.0\'SID' is correct icx_parameter record gets propagated incorrectly (only one record) adconfig does Not create apps listener.ora file or hangs at apps lister process. Work around is to make sure apps lsnr is up when running adconfig If there's service issues rebuild the services thru Oracles documented cmd files and REBOOT. Still having problems, side issues, rebuild jar files, C/M (adsvcm.cmd), reboot. Do NOT update env, system env settings. This causes many many problems and is for multiple instances Cloning challengesOnly. Having said that, Bugs for multi-instance installs/cloning are Lengthier and a different issue (Its not clean like UINX). Between having to update the user, system env's, customize the registry (which is not supported or documented by Oracle untill 1158 and rapidclone (as stated to me by Oracle devl.)) and dealing with multi-ple services that are problematic Its less risky (notice the wordsmithing here..) than If u perform single instance installs, clones etc... It can be done though... The real problem with multiple instances/cloningis that registry settings are hard-coded. HTH's Chris BlaisPrincipal DBA BlazingPathways Inc. PS. The following weremy opinion only. Oracle RDBMS Community Forum [EMAIL PROTECTED] wrote: From: "Forrest Payne" <[EMAIL PROTECTED]>Date: Fri, 6 Jun 2003 09:32:26 -0700Subject: Re: How to Uninstall apps1Chris,Could you share the 11i install/cloning challenges you are facingon W2000AS. We just installed AS and installing/cloning arenot behaving as they have in the past.## Do you Yahoo!? Free online calendar with sync to Outlook(TM).
Re: How to Uninstall apps1
Forrest, Apologies for not getting back to u sooner. Cloning on Nt (adv. Server) works very well when u have a SINGLE instance on each box. Also, O/S does not support multi to single clones (per the Feb 12 white paper). Our env is1157, nt Adv srvr)runningautoconfig for cloning, via Feb 12white paper. Bugs, we have seenon Single Instance Boxes are: Following past papers. There's ALLOT of conflicting information from Oracle on this. Make sure registry setting ADJVAPRG=f:\oracle\prodora\8.0.6\jdk\bin\java.exe (ie prod-'SID') under HKLM\S\ORACLE\APP\11.5.0\'SID' is correct icx_parameter record gets propagated incorrectly (only one record) adconfig does Not create apps listener.ora file or hangs at apps lister process. Work around is to make sure apps lsnr is up when running adconfig If there's service issues rebuild the services thru Oracles documented cmd files and REBOOT. Still having problems, side issues, rebuild jar files, C/M (adsvcm.cmd), reboot. Do NOT update env, system env settings. This causes many many problems and is for multiple instances Cloning challengesOnly. Having said that, Bugs for multi-instance installs/cloning are Lengthier and a different issue (Its not clean like UINX). Between having to update the user, system env's, customize the registry (which is not supported or documented by Oracle untill 1158 and rapidclone (as stated to me by Oracle devl.)) and dealing with multi-ple services that are problematic Its less risky (notice the wordsmithing here..) than If u perform single instance installs, clones etc... It can be done though... The real problem with multiple instances/cloningis that registry settings are hard-coded. HTH's Chris BlaisPrincipal DBA BlazingPathways Inc. PS. The following weremy opinion only. Oracle RDBMS Community Forum [EMAIL PROTECTED] wrote: From: "Forrest Payne" <[EMAIL PROTECTED]>Date: Fri, 6 Jun 2003 09:32:26 -0700Subject: Re: How to Uninstall apps1Chris,Could you share the 11i install/cloning challenges you are facingon W2000AS. We just installed AS and installing/cloning arenot behaving as they have in the past.## Do you Yahoo!? Free online calendar with sync to Outlook(TM).
Re: How to Uninstall apps1
From: "Forrest Payne" <[EMAIL PROTECTED]> Date: Fri, 6 Jun 2003 09:32:26 -0700 Subject: Re: How to Uninstall apps1Forrest, I had a 'few' emails on this so I'll list the steps here. Please note these are for our env (1157, NT Adv Srvr).We usea DR drive (operating system with ALL needed 3rd party apps / settings no Oracle users. When rebuilding we like to keep the registry clean and the OUI fresh. 1. Replace, with a prebuilt DR drive, the op sys. (ie no Oracle users, no Reg conflicts, no software to de-install, system/winnt32 file potential problems, no OUI issues). Note the OUI needs to de-install Oracle installs,doing so viathe registry will corrupt the OUI 2. Delete ALL data files 3. reboot Done. Before we used an op sysDR drivewe had to delete via OUI (if u did not delete the user), then update/mod the registry (FYI, the HKLM\SYSTEM\Constrolset 001,2 is NOT updatablecausing registry to grow) HTH's Chris blais Principal DBA BlazingPathways Inc. Do you Yahoo!? Free online calendar with sync to Outlook(TM).
RE: How to Uninstall apps1
Kumar, If u sendme youremail address and I can send u a paper that describes how to completely clean up an NT system (i.e de-install).I've successfullytested multi instance and single instance de-installs for NT (adv server). Due to multi-instance Apps 11i install cloning challenges on NT advancd server,we've had to become fairlyefficient at de-installing -) HTH's, Chris Blais Principal DBA BlazingPathways Inc. [EMAIL PROTECTED]--- RE: How to Uninstall apps11i "Senthil Kumar D" <SENTHILKUMARDFrom: "Senthil Kumar D" <[EMAIL PROTECTED]>Date: Wed, 4 Jun 2003 14:48:35 +0530Subject: RE: How to Uninstall apps11iHi stephen,Thanks.I'm using Win2K. I want to remove all the oracle products, including myapps.I need to prepare a installation doc with the snapshots. So I need toreinstall all the oracle products.TIA,Senthil. Do you Yahoo!? Free online calendar with sync to Outlook(TM).
Oracle text question
Title: Oracle text question I briefly looked over the documentation and wasn't able to find what I was looking for so I thought I would check here before I spend the rest of my day searching Anyone familiar enough with Oracle Text to give some estimates on the total amount of storage required to store a given number of documents of a given size? .i'm (I think obviously) looking for a way to estimate the size of the 'index' (which from what I can tell is a set of tables...any explanation there would be tremendously appreciated also) based on what's being stored. I hope this is clear. Thanks for any input. Happy Friday!!! Chris
RE: Unix host name change - what happens to db?
We've juggled names several times here. The tricky part is network connections to the database. You need to make sure that tnsnames.ora files point to the right server. Also, if people are using database connections in other programs (e.g. perl, Pro*C, java, python) they need to make sure they are pointing to the right place. We originally set up our system to either connect to the local database or to specify the server name. When we moved the db to a dedicated server, we had to search around to ferret out all the hardcoded values and replace them with more stable names. We actually wrote an API for each language so programs could grab a connection without having to know anything about server names. Once this is done, the only thing to change is the tnsnames.ora files, and subsequent changes are much easier. To answer your specific questions, it shouldn't have any effect on your installation, except the listener/network configuration files. -Original Message- Sent: Tuesday, June 03, 2003 11:25 AM To: Multiple recipients of list ORACLE-L My boss has decided to change the name of the Sun OS 2.8 host of my Oracle 8i databases. Question: how does this name change affect my Oracle software installation and my databases? Has this happened to any of you? Thanks, Carmen Rusu LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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: linux intel support matrix
From: Weaver, Walt [EMAIL PROTECTED] They make you work in the afternoon --Walt Weaver Bozeman, Montana You mean sometimes you aren't at work? Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry 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: dbshut script - shutdown or shutdown immediate
From: Joan Hsieh [EMAIL PROTECTED] Chris, We hang on shutdown immediate, not startup. That's why I choose to use shutdown abort. Well, in that case of course you'd use it, but personally, if it was me, I'd want to find out why it was hanging, and fix that instead. I'm not suggesting shutdown abort never be used, I'm just saying use the right tool for the right job when you have a choice. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry 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: Remote DBA
From: Nelson Flores [EMAIL PROTECTED] VNC and OpenSSH are slow Anything cross platform isn't going to have the same kind of optimization as a single platform solution. I find them fast enough to be useable, but you're right terminal server on windows is faster for windows boxes. and VNC is still a little unstable (IMHO), What kind of trouble did you have, mine has been rock solid. I personally manage my windows 2000 Oracle DB with a VPN and then a Terminal server window direct to my desktop - from there I have all the tools that I usually have - notepad, mspaint, dir :). That's a good solution, but costs money for those terminal server licenses. My department has little or no budget for non-critical purchases (and sometimes none for those either hehe) so I have to go with the free option, and besides, this lets me manage my linux stations from my win2k boxes and vice versa. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry 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).