Re: Hotsos Clinic 101 Feedback
Attending a Hotsos Clinic and Hotsos Symposium was very worthwhile. If an employer cannot afford the training time, flexing work hours (or using vacation) may be possible. Note: if you do attend a Hotsos event on your own time, your company name can be removed from your name tag ;) Looks like some Hotsos Clinics have been scheduled in 4 countries: Apr 8 - 10 Chicago, IL, USA May 13 - 15 London area, UK Jun 2 - 4 Reykjavik, Iceland Jun 10 -12 Ottawa, ON, CA Aug 12 - 14 Denver, CO, USA Personally, I enjoy listening and learning from Cary, Jeff, and Gary. Have Fun :) Michael Brown wrote: I've taken it twice (one of the first public classes and again the when they started offering the reduced alumni rate), and stand by my quote on Hotsos's website. If you have the time to take a class, take the Hotsos Clinic. It was the absolute best performance tuning resource that I have ever invested time in. Of course, I would change tuning to optimization since we are making tuning a dirty word. For those of you who were not at the Hotsos Symposium in Dallas, you missed a fantastic conference. You should make your plans to be in Las Vegas next year. I am not affiliated in any way with Hotsos, just am impressed by both the knowledge Cary and Jeff have and their ability to convey it to others. -- Michael Brown Glen Raven, Inc./Info Services Senior Oracle DBA 1831 N. Park Ave Phone: (336)586-1146Glen Raven, NC 27217 Fax: (336)586-1382 [EMAIL PROTECTED] -Original Message- Stefick Sent: Wednesday, March 26, 2003 2:09 PM To: Multiple recipients of list ORACLE-L I haven't taken it yet, but I am signed up for the Chicago Clinic on April 8-10Can't Wait! I've heard really good things about it. At 08:04 AM 3/26/03 -0800, you wrote: Anybody take this course before. Any comments, good or bad. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow 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). ** Scott Stefick Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick 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: Chip 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 Licences Req on Intel Xeon CPU
http://www.microsoft.com/windows2000/server/evaluation/performance/reports/hyperthread.asp has a link to an article that has the BIOS requirement for logical CPU numbering (and start-up order). Note: since Windows 2000 Server does support up to four CPU's, the task manager does display 4 CPU's on a hyperthreaded dual XEON computer. Have Fun :) david hill wrote: Yes Redhat Advanced Server 2.1 does support hyperthreading. Its not to bad either. I ran some tests and we get about a 15% increase in performance with hyperthreading turned on. -Original Message- From: Michael Brown [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Licences Req on Intel Xeon CPU 2000 only shows 2 CPUs because it cannot take advantage hyperthreading. From what I have read (Intel's website, some others), hyperthreading requires both BIOS and OS support to be utilized. Currently, XP and the newer Linux releases are all that I have seen that will take advantage of it. My research on this was fairly light since I was just after can Redhat Advanced Server support it, but I do remember seeing that W2K would not. -- Michael Brown Glen Raven, Inc./Info Services Senior Oracle DBA 1831 N. Park Ave Phone: (336)586-1146Glen Raven, NC 27217 Fax: (336)586-1382 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 26, 2003 3:44 AM To: Multiple recipients of list ORACLE-L Depending on the OS, Microsoft has different CPU counts. The Windows 2000 family counts each hyper thread as 1 CPU. In contrast, Windows XP and Windows 2003 Server count each CPU instead of each hyper thread. Thus, the task manager in Windows XP Professional show 4 CPU's (on a dual XEON CPU computer with hyper threading enabled) while Windows 2000 Professional only shows 2 CPU's in the task manager. Have Fun :) [EMAIL PROTECTED] wrote: Hi all For those that are running or intending on running Oracle on Intel's Xeon CPU, the following information may be of interest to you. The Xeon CPU has a feature called Hyper Threading with double the number of registers. This feature when turned will present to the Operating Systems an additional virtual CPU. As far as the O/S is concern, it looks like there are _two_ CPUs. What does this mean to your software licensing? Microsoft says that it is one CPU. What does Oracle say? Well, it depends on who you speak to and what day of the week it is. Seriously, you will need to get some confirmation in writing from your account manager the next time you purchase Oracle S/w for Intel's Xeon ta tony _ / |Tony Jambu, DatabaseWeb Consultant /_ _/_ __ / |Wizard Consulting Pty Ltd /(_)/ )(_/ \_/(///(/_)/_( |IOUG's Select Asia-Pacific Tech. Editor \___/ |EMAIL: TJambu @ wizard.cx (REMOVE Spaces from email ) |PHONE: +61-419-TJAMBU(852628) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip 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: Chip 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: OT: PLSQL question, JAVA, JDBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:986230504001 Have Fun :) Darrell Landrum wrote: I'd take a look on http://java.sun.com, there are some great forums there. Also try http://devtrends.oracle.com. [EMAIL PROTECTED] 03/27/03 11:03AM Hi list, this is a question for JAVA/PLSQL programmers. I need to pass an array object from my code in Java using JDBC to a stored procedure in Oracle. I do not know how to do that, could you give me a call example so I can figure out how to achieve this ? TIA Gabriel Aragon __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip 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 encouraging Linux software developers
IBM is loudly touting how much money they will be spending on Linux. Has anyone seen any sales statistics for DB2 on non-IBM platforms? I feel that IBM has a challenge to convince buyers to consider DB2 on Linux. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] Dennis, Humourously ... at least in Oz, the number one Unix platform for DB2 is Solaris. IBM will probably turn this around ... they are being quite clever with the 5L releases of AIX, by enabling compatibility with both AIX and Linux binaries. So they feed you a little Linux box, wait for you to decide you need something bigger, ease you on to an AIX 5L box still running your linux code (but now you're paying AIX licencing), and then roll in with the usual IBM steamroller. That said, I've just had a free 3-day training course from them, so nothing like biting the hand that feeds, so to speak :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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: Which process is taking up so much CPU???
Tim, I think you may be right actually! :) I have a sub directory that contains the scripts that you zipped up on your site, this script seemed to have found it's way in to my main SQL directory, and as it didn't have any notes on author I plain forgot. It was indeed called SessionTopCPU.sql. All comments/praises to Tim! ;) Welcome back to the list by the way! :) Cheers Mark -Original Message- Sent: 27 March 2003 17:14 To: Multiple recipients of list ORACLE-L Hey, it could well be one of mine (or something derived from the same source as I started with) - got all the same words, syntax and style as something I call SessionTopCPU and use to be available off my web site. I think the original inspiration was from Dave Ensor, but I no longer use the report and have long since forgotten almost everything about it (ie I won't be of much help in answering questions). _ Tim Onions Head of Oracle and Web Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message- Sent: 27 March 2003 15:59 To: Multiple recipients of list ORACLE-L Prompt Prompt Show total CPU and statement CPU for current session (requires TIMED STATISTICS = TRUE) Prompt set verify off col UNAM format a20 word heading 'User' col STMT format a56 word heading 'Statement' col RUNT format a08 word heading 'CPU Time' col ltim format a20 word heading 'Logon Time' col etim format a20 word heading 'Connect Time' col PROG format a30 word heading 'Program|Client Terminal Details' col SID format a10 word heading 'SID/|Serial#' col DR format 9 heading 'Disk Reads' col BG format 9 heading 'Buffer Gets' col EX format 9 heading 'Executions' col rsecs format 999,999,999.00 heading CPU time|(seconds) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Onions 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: 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).
RE: Oracle connection through Crystal Reports
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Juan Antonio Félix Sarabia Sent: Thursday, March 27, 2003 21:49 To: Multiple recipients of list ORACLE-L Subject: Oracle connection through Crystal Reports Hi All. I´m trying to connect to a oracle database 8i for using it with crystal reports 9. I have win2000 professional, I tried to use 'CR Oracle ODBC Driver 4.10' but it appears a error system with the number 126 when i try to do a test connection. The message is something like that 'can´t load driver ...'. I tried to use 'More Data Sources' option in Crystal reports but it not appears the option to choose an oracle data source. I have installed oracle SQL *Net Client 2.3.2.1.6A because i use Oracle developer 2000. would somebody help me please ? Thanks. Juan, Your crystal reports bin directory (or equivalent) is probably not on the path. Add it, and it should work. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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).
AW: Database Modeling- Normalization - Dinosaurs or What?
Title: RE: Database Modeling- Normalization - Dinosaurs or What? Hi What I don't understand is: If your development department want to go with a VSAM like approach, why do they invest in Oracle. Why not just get a zSeries and stick to VSAM or IMS ? PS: Your working environment sounds like an actual implementation of Purgatory Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht-Von: April Wells [mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 25. März 2003 14:09An: Multiple recipients of list ORACLE-LBetreff: RE: Database Modeling- Normalization - Dinosaurs or What? Hi Paula Hey... I live in your world. Our "data warehouse" was designed by someone who had never dealt with ANYTHING relational... but based it on VSAM files and tried to make the leap. We have a table with 873 columns in our data warehouse... they call it a FACT table. It has client name and address (well... they are "facts", right... ?). You don't have foreign keys... we don't have PRIMARY keys. We call unique indexes primary keys... but after 10 years of not understanding why queries didn't return data that made sense, they allowed me to put not null constraints on the columns in the unique index (when I told them that they either do that or they answer to the clients). Historically, the DBAs in this company have done little more than implement what programmers designed and then tried to make it work. They WON'T use stored procedures, they don't understand them. THEY write code that sits in files on the OS and call those "programs" via shell scripts. They heard once that it was faster that way in Oracle 2 and so it must be still true, cause COBOL never changes so Oracle must not change. The part I like best, though, is... we have a ONE column table with ONE row... SystemDate... because they can't figure how to get sysdate from dual into a variable and use it in their programs... so they start their data warehouse load run with a truncate to that table, and an insert of the date passed in from the OS so they can load the DW tables. DON'T stop fighting. I think that is what they want. I have been told (in meetings where I have been requested for my DBA input) to sit down and shut up unless I am asked a question when I tried to point out things like... you can't have 1500 columns in a table no matter how fast it will make the queries fly... you can't have table names of 72 characters for descriptive sake... you really can't call a column DATE just because that is what is in it, an arbitrary date... Make them hear you even if they don't listen. Be the biggest pain they can imagine, eventually it will slowly start to pay off, because eventually they will realize (again VERY slowly) that you are right. It is how I got the reputation of being a DBA (Dat Bi#$h April) April -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Monday, March 24, 2003 6:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database Modeling- Normalization - Dinosaurs or What? Guys, The emphasis in many places I have worked is developing quick and dirty systems as quickly as possible and working with developers that don't seem to have very much understanding of Relational Database Theory but who prefer to program using flat files in relational databases - calling it "object-oriented" when it truly is not. Let us just say that it is highly denormalized. As a DBA I care about data integrity, extensibility and scalability but the up and coming esp. SQL Server developer types seem to operate in a world where this doesn't matter - just buy more hardware, denormalize to make the programming easier, etc. I have been losing this battle. So - what is your
RE: Database Modeling- Normalization - Dinosaurs or What?
Hi Stefan On the Data Warehouse project, the technical lead didn't understand Oracle. She was a mainframe programmer and once, in another job, she used VSAM files. WE don't support VSAM files, but she wanted to use them anyway... take data out of Oracle on Unix, pipe it to the mainframe to do some Tranformations (in the ETL), pipe it BACK to Unix and load it in to the Oracle tables... because that's how she knew how to do it... and the technical lead should know everything about EVERY detail of how the project is implimented. We are doing better... After I got told to sit down and shut up in a couple meetings, and lectured for 2 hours on my attitude in meetings being less than helpful, I quit going and started just rejecting what wouldn't work after they had spent hours or days writing it. They are starting to consider (not use in most cases, but consider) stored procedures. I don't look on it (most of the time) so much as Purgatory, but as a personal challenge. Besides, I have done IMS (DB/DC) and know that Purgatory is having virtual bi-directional pointers interconnecting 6 tables in every imaginable configuration, one of them with the only thing that makes it unique in the world being a sequece number and load routines that don't remember where they were in the file when the operators restart the process after an abend. April -Original Message- To: Multiple recipients of list ORACLE-L Sent: 3/28/2003 4:23 AM Hi What I don't understand is: If your development department want to go with a VSAM like approach, why do they invest in Oracle. Why not just get a zSeries and stick to VSAM or IMS ? PS: Your working environment sounds like an actual implementation of Purgatory Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de http://www.bov.de/ subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] . Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: April Wells [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. März 2003 14:09 An: Multiple recipients of list ORACLE-L Betreff: RE: Database Modeling- Normalization - Dinosaurs or What? Hi Paula Hey... I live in your world. Our data warehouse was designed by someone who had never dealt with ANYTHING relational... but based it on VSAM files and tried to make the leap. We have a table with 873 columns in our data warehouse... they call it a FACT table. It has client name and address (well... they are facts, right... ?). You don't have foreign keys... we don't have PRIMARY keys. We call unique indexes primary keys... but after 10 years of not understanding why queries didn't return data that made sense, they allowed me to put not null constraints on the columns in the unique index (when I told them that they either do that or they answer to the clients). Historically, the DBAs in this company have done little more than implement what programmers designed and then tried to make it work. They WON'T use stored procedures, they don't understand them. THEY write code that sits in files on the OS and call those programs via shell scripts. They heard once that it was faster that way in Oracle 2 and so it must be still true, cause COBOL never changes so Oracle must not change. The part I like best, though, is... we have a ONE column table with ONE row... SystemDate... because they can't figure how to get sysdate from dual into a variable and use it in their programs... so they start their data warehouse load run with a truncate to that table, and an insert of the date passed in from the OS so they can load the DW tables. DON'T stop fighting. I think that is what they want. I have been told (in meetings where I have been requested for my DBA input) to sit down and shut up unless I am asked a question when I tried to point out things like... you can't have 1500 columns in a table no matter how fast it will make the queries fly... you can't have table names of 72 characters for descriptive sake... you really can't call a
copying datafile nt4-w2k
hi all We are planning an upgrade from NT4 to W2K. I am considering to create a new instance on another server with W2K installed and copying the datafiles from the server with NT4 on it. Is this possible ? Or do i have to use the exp/imp strategy ? thanks vr.gr. Geo Kor Sr. System Engineer IDM Db RDW Voertuiginformatie en -toelating Holland -- 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: OT: uuencode adding characters
Thanks. I guess this would be a good time to learn Perl :) -Original Message- Berry Sent: March 27, 2003 4:39 PM To: Multiple recipients of list ORACLE-L From: Saira Somani [EMAIL PROTECTED] AIX 4.3.3 ORACLE 8.1.7.0.0 I have a spooled report from an SQL script which I am e-mailing, also from a script using the uuencode utility. The spooled report looks fine but once it is e-mailed, it looks funny with carriage return characters added everywhere (I have line feeds in the report for ease of readability). I think maybe the uuencode is messing it up(?) Users of this report will likely open it up in Notepad and get confused - or worse, complain. Anyone else have the same issues? No, but you could easily write a perl script to clean it up, take about 3 lines of code. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: OT: uuencode adding characters
Chris, Can you give me a hint? So I use Perl to rid the file of these characters and then uuencode it and then use mail utility to send to people? Won't uuencode do the same thing again and add those characters back? Thanks! -Original Message- Berry Sent: March 27, 2003 4:39 PM To: Multiple recipients of list ORACLE-L From: Saira Somani [EMAIL PROTECTED] AIX 4.3.3 ORACLE 8.1.7.0.0 I have a spooled report from an SQL script which I am e-mailing, also from a script using the uuencode utility. The spooled report looks fine but once it is e-mailed, it looks funny with carriage return characters added everywhere (I have line feeds in the report for ease of readability). I think maybe the uuencode is messing it up(?) Users of this report will likely open it up in Notepad and get confused - or worse, complain. Anyone else have the same issues? No, but you could easily write a perl script to clean it up, take about 3 lines of code. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: Which process is taking up so much CPU???
Thank you all for your help. I wonder where I should set TIMED STATISTICS = TRUE, if any of you has the time to answer I'd be grateful, but I will look for it in the docs. Fermin. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS WILLIAMS Enviado el: jueves, 27 de marzo de 2003 18:49 Para: Multiple recipients of list ORACLE-L Asunto: RE: Which process is taking up so much CPU??? Fermin The spid column in the v$process column matches the Unix process i.d. You may need to track it back through the Oracle shadow process. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 9:14 AM To: Multiple recipients of list ORACLE-L I usually track our HP-UX 11.0 system with the 'top' command so I can notice when the system is under slow performance. If that happens, I use Toad to look for any active Oracle SQL query which may be heavy enough for degrading the performance. I think my question is simple, but since I am a newbie on this... how can I see who is executing an Oracle SQL that is taking all our CPU provided that I only see his PID with the TOP command? I only see the oracle process, but I don't know how to get the username and the SQL beside him. Thank you for your answers! Fermin. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fermin Bernaus Berraondo 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: Fermin Bernaus Berraondo 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: index on null column
Title: RE: index on null column Here is an idea ... Create a function that returns NULL if the value is null or any other acceptable value that can be ignored. And the function should return valid values otherwise. Then create a function based index on this and see if that helps you. To put in other words, you are merely indexing a subset of rows that match your criteria, while ignoring others that you don't want to deal with. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 27, 2003 9:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: index on null column AK Yes, it will benefit the non-null records. Just remember that the null values aren't indexes. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 5:19 PM To: Multiple recipients of list ORACLE-L I have a table with column A. there are 100 records in table out of which 500o records has not null in column A rest are null. if i created an index on A, will it benefit . thanks, ak -- 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: create interMedia index problem
Guang,
Is your RESINDEX tablespace a Locally-Managed Tablespace with Uniform
Extents of less than 3 database blocks? If so, that's your problem.
InterMedia indexes consist of some LOB segments and those require extents
of at least 3 database blocks - at least in 8i.
If not, I don't know.
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]
Guang Mei
[EMAIL PROTECTED]To: Multiple recipients of list
ORACLE-L
Sent by: [EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
Subject: create interMedia index
problem
03/27/2003 10:53
PM
Please respond to
ORACLE-L
Hi:
I have this problem on our production server and I don't know too much
about InterMedia stuff. We have oracle 8173 on Sun Solaris 2.8.
[EMAIL PROTECTED] desc DRUGDATA;
Name Null?Type
-
IDNOT NULL NUMBER
DRUGREPID NOT NULL NUMBER
FIELD NOT NULL NUMBER
TEXT VARCHAR2(4000)
DRUGTERMID NUMBER
DATATYPEIDNOT NULL NUMBER
ADD_FILE NOT NULL VARCHAR2(32)
ADD_DATE NOT NULL DATE
DEL_FILE VARCHAR2(32)
DEL_DATE DATE
STATUSNOT NULL CHAR(1)
ORDERBY NOT NULL NUMBER
[EMAIL PROTECTED] select count(*) from DRUGDATA;
COUNT(*)
--
0
TABLESPACE_NAME USED-Kb ALLOC-KbUSED% SEGS EXT NEXTEXT
--- --- -- - -
DATA 3,000 1,048,576 .3 1 1 504
INDEXES 10,664,424 14,680,064 72.6 48011 693,080
PERFSTAT 105,728 2,097,1525.056 150 128
PROTEOME 164,872 1,048,576 15.75219 25,600
RBS5,131,360 8,388,608 61.2 6 8002,048
RESCTX43,832 6,803,456 .66628 504
RESDATA 34,470,408 46,137,344 74.7 361 2319
RESINDEX 41,046,376 69,206,016 59.3 300 1063 512,000
SYSTEM74,320 153,600 48.4 401 1151,120
TEMP 10,224,960 10,240,000 99.9 1 20455,000
YPD 12,769,224 16,777,216 76.1 249 # 292,976
TABLESPACE_NAME USED-Kb ALLOC-KbUSED% SEGS EXT NEXTEXT
--- --- -- - -
YPDCUST0 1,048,576 .0 0 00
Then I ran
create index DRUGDATAINDEX_TEXT on DRUGDATA (TEXT)
indextype is ctxsys.context
parameters ('LEXER ctxsys.ISILEX WORDLIST ctxsys.ISIWORDLIST
STOPLIST ctxsys.ISISTOP storage isistore memory 50M');
I got
create index DRUGDATAINDEX_TEXT on DRUGDATA (TEXT)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-2: interMedia Text error:
DRG-50857: oracle error in drixtab.create_index_tables
ORA-01658: unable to create INITIAL extent for segment in tablespace
RESINDEX
ORA-06512: at CTXSYS.DRUE, line 126
ORA-06512: at CTXSYS.TEXTINDEXMETHODS, line 78
ORA-06512: at line 1
and I got from alert_log file:
ORA-1652: unable to extend temp segment by 128000 in tablespace
RESINDEX
I did coalesce on all tablespace and added another 2G datafile on RESINDEX
tablespace, I still got the same
Week - Date function!
Hi, Given a week between (1 - 52) for a particular year can we get all the dates within that week. Is there a function to do this in SQL??? Thanks a lot. Regards Sesi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sesi Odury 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: Which process is taking up so much CPU???
Alter system set timed_statistics=true; or/and - init.ora - timed_statistics=true HTH CP [EMAIL PROTECTED] wrote: Thank you all for your help. I wonder where I should set TIMED STATISTICS = TRUE, if any of you has the time to answer I'd be grateful, but I will look for it in the docs. Fermin. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS WILLIAMS Enviado el: jueves, 27 de marzo de 2003 18:49 Para: Multiple recipients of list ORACLE-L Asunto: RE: Which process is taking up so much CPU??? Fermin The spid column in the v$process column matches the Unix process i.d. You may need to track it back through the Oracle shadow process. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 9:14 AM To: Multiple recipients of list ORACLE-L I usually track our HP-UX 11.0 system with the 'top' command so I can notice when the system is under slow performance. If that happens, I use Toad to look for any active Oracle SQL query which may be heavy enough for degrading the performance. I think my question is simple, but since I am a newbie on this... how can I see who is executing an Oracle SQL that is taking all our CPU provided that I only see his PID with the TOP command? I only see the oracle process, but I don't know how to get the username and the SQL beside him. Thank you for your answers! Fermin. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CP 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).
Intermedia tag problem
Hi Gurus, We are working with Intermedia Text 8.1.6. We created a intermedia index on a search field. We also created 2 sections in this field. Table name : S01 Filed name : S01_search Sections name : SY,MAN Here is an example of data in this field: SYCyane/SYMANPhibro Energy */MAN This example works fine. But we have a problem when there is a character in the data. Intermedia thinks it's a new tag and tries to find a section but it cannot. Exemple: SYCyane 10 /SYMANPhibro Energy */MAN Question : 1- Should we do something with the in our data ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche 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: Week - Date function!
SQL l 1 select x.d 2 from (select to_date(rownum, 'DDD') d, 3 to_number(to_char(to_date(rownum, 'DDD'), 'IW')) week 4from all_objects 5where rownum 366) x 6* where x.week = week_num You may have a problem with leap years, but it's basically the idea. Anything smarter, somebody ? Given a week between (1 - 52) for a particular year can we get all the dates within that week. Is there a function to do this in SQL??? Thanks a lot. Regards Sesi -- Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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: Which process is taking up so much CPU???
Fermin Add this line to your init.ora file. timed_statistics = true Then shutdown, startup your Oracle instance. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 6:24 AM To: Multiple recipients of list ORACLE-L Thank you all for your help. I wonder where I should set TIMED STATISTICS = TRUE, if any of you has the time to answer I'd be grateful, but I will look for it in the docs. Fermin. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS WILLIAMS Enviado el: jueves, 27 de marzo de 2003 18:49 Para: Multiple recipients of list ORACLE-L Asunto: RE: Which process is taking up so much CPU??? Fermin The spid column in the v$process column matches the Unix process i.d. You may need to track it back through the Oracle shadow process. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 9:14 AM To: Multiple recipients of list ORACLE-L I usually track our HP-UX 11.0 system with the 'top' command so I can notice when the system is under slow performance. If that happens, I use Toad to look for any active Oracle SQL query which may be heavy enough for degrading the performance. I think my question is simple, but since I am a newbie on this... how can I see who is executing an Oracle SQL that is taking all our CPU provided that I only see his PID with the TOP command? I only see the oracle process, but I don't know how to get the username and the SQL beside him. Thank you for your answers! Fermin. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fermin Bernaus Berraondo 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: Fermin Bernaus Berraondo 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).
RE: Week - Date function!
Stephane There are days when I just feel lucky if I can understand your code, let alone come up with something smarter. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 8:39 AM To: Multiple recipients of list ORACLE-L SQL l 1 select x.d 2 from (select to_date(rownum, 'DDD') d, 3 to_number(to_char(to_date(rownum, 'DDD'), 'IW')) week 4from all_objects 5where rownum 366) x 6* where x.week = week_num You may have a problem with leap years, but it's basically the idea. Anything smarter, somebody ? Given a week between (1 - 52) for a particular year can we get all the dates within that week. Is there a function to do this in SQL??? Thanks a lot. Regards Sesi -- Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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).
RE: Which process is taking up so much CPU???
On Fri, 28 Mar 2003, DENNIS WILLIAMS wrote: Fermin Add this line to your init.ora file. timed_statistics = true Then shutdown, startup your Oracle instance. I would hasten to point out that this parameter can be set dynamically using alter system from at least 8.1.x forward. Thus, restarting the instance is unnecessary and only reduces availability. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- Sent: Friday, March 28, 2003 6:24 AM To: Multiple recipients of list ORACLE-L I wonder where I should set TIMED STATISTICS = TRUE, if any of you has the time to answer I'd be grateful, but I will look for it in the docs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: big disks..OFA??
Peter Welcome to the modern DBA's challenge. - Consider RAID - Pay attention to your cache size (battery-backed, of course) - Test - Eternally the System administrator would prefer you to use fewer devices, makes his/her life easier. The DBA wants many devices. Negotiate. Share. - What performance is required of this database? As was discussed yesterday on this list, a lower-performance database will be okay on a single device. Put control files, redo on separate devices. If really good performance / high transaction rates are required, then lobby for more devices. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 8:49 PM To: Multiple recipients of list ORACLE-L Hi Friends Now a days the disks are coming with 36/73Gb sizes for AIX, How can I make small filesystems to put data and indexes separately?? Although I have FastT700 controller, Is it okay putting all dbf files under one filesytem?? Does it affect performance, How about putting rbs/temp/redo?? Do I need to put under different filesystems?? Suppose I have two controller, How can I know, How many channels are there?? I have 25Gb table, what is the methodology for setting initial and next extents?? My DB is OLTP its conitousely growing on AIX 5L with Oracle 817. TIA peter. _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R 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).
RE: Which process is taking up so much CPU???
ALTER SYSTEM SET TIMED_STATISTICS=TRUE; You don't need to bounce the database ;) Best Regards, K Gopalakrishnan -Original Message- WILLIAMS Sent: Friday, March 28, 2003 6:49 AM To: Multiple recipients of list ORACLE-L Fermin Add this line to your init.ora file. timed_statistics = true Then shutdown, startup your Oracle instance. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 6:24 AM To: Multiple recipients of list ORACLE-L Thank you all for your help. I wonder where I should set TIMED STATISTICS = TRUE, if any of you has the time to answer I'd be grateful, but I will look for it in the docs. Fermin. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS WILLIAMS Enviado el: jueves, 27 de marzo de 2003 18:49 Para: Multiple recipients of list ORACLE-L Asunto: RE: Which process is taking up so much CPU??? Fermin The spid column in the v$process column matches the Unix process i.d. You may need to track it back through the Oracle shadow process. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 9:14 AM To: Multiple recipients of list ORACLE-L I usually track our HP-UX 11.0 system with the 'top' command so I can notice when the system is under slow performance. If that happens, I use Toad to look for any active Oracle SQL query which may be heavy enough for degrading the performance. I think my question is simple, but since I am a newbie on this... how can I see who is executing an Oracle SQL that is taking all our CPU provided that I only see his PID with the TOP command? I only see the oracle process, but I don't know how to get the username and the SQL beside him. Thank you for your answers! Fermin. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fermin Bernaus Berraondo 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: Fermin Bernaus Berraondo 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: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
RE: veritas backup via RMAN troubles
Title: veritas backup via RMAN troubles I had a remarkably similar experience a few months ago with Legato NetWorker and performed all of the steps you listed with the same results. The problem turned out to be very simple. The SA installed the 64-bit version of the Legato Networker client because it is a 64-bit server. However, we were running a 32-bit version of Oracle on it. Installing the 32-bit client solved the problem. I am mentioning this since your post did not indicate if you are using 64-bit Oracle on that server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Testa, Joe Sent: Wednesday, March 26, 2003 1:04 PM To: Multiple recipients of list ORACLE-L Subject: veritas backup via RMAN troubles AIX 5.1, oracle 9ir2(9.2.0.1), veritas 4.5 followed instructions for installing veritas on disk, got the agent, did NOT relink oracle executable, but ran the oracle install script so the link from /usr/openv/netbackup/bin/libobk.a64 is linked to $ORACLE_HOME/lib/libobk.a Set(and unset multiple times), LIBPATH, LD_LIBRARY_PATH. Continue to get ORA-27211 Failed to load media management library. Been thru RMAN chapters multiple times, I'm totally out of ideas(and read every damn document on metalstink about this error). I've also tried to use the dummy MML library and that works fine. What the heck am I doing wrong? thanks, joe
OEM 4
Hi all, Is anyone aware of when OEM 4 will be available. I've been looking around on Metalink and can't seem to find anything about it. It was used at the Oracle Tech Day here in Greensboro this week and the web interface looks to have been really improved. TIA, John P Weatherman Oracle Database Administrator Replacements, Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Weatherman 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: Intermedia tag problem
Hi, You will have to change your input data and replace the with lt;. This is one of the standard 5 XML entity references. Really you need to make sure that you have no double quotes, single quotes, less than , greater than or ampersands in your data and if you do replace then with the appropriate entity reference: - amp; - quot; ' - apos; - lt; - gt; Regards Pete -Original Message- Sent: 28 March 2003 14:34 To: Multiple recipients of list ORACLE-L Hi Gurus, We are working with Intermedia Text 8.1.6. We created a intermedia index on a search field. We also created 2 sections in this field. Table name : S01 Filed name : S01_search Sections name : SY,MAN Here is an example of data in this field: SYCyane/SYMANPhibro Energy */MAN This example works fine. But we have a problem when there is a character in the data. Intermedia thinks it's a new tag and tries to find a section but it cannot. Exemple: SYCyane 10 /SYMANPhibro Energy */MAN Question : 1- Should we do something with the in our data ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche 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). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, 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).
Re: index on null column
It means if I do a query with where clause with A=:x its going to go for index . Does oracle go to table if :x is null. It looks like it does . ??? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 6:33 PM AK Yes, it will benefit the non-null records. Just remember that the null values aren't indexes. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 5:19 PM To: Multiple recipients of list ORACLE-L I have a table with column A. there are 100 records in table out of which 500o records has not null in column A rest are null. if i created an index on A, will it benefit . thanks, ak -- 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: 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).
RE: Unable to lock file
Rivaldi Try to figure out what is different when cron starts the instance vs. your starting the instance. Some parameter is getting set or not getting set. For most Unix versions the env command dumps all environment variables. Do that for your interactive session and then add that to the script cron is executing and then manually execute the script. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Hi Listers, Oracle 8174, HP 11.00 I got the following error when starting up the database thru crontab job at 2 am in the morning. It happened after we shutdown the unix machine. Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc: ORA-01157: cannot identify/lock data file 13 - see DBWR trace file ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf' ORA-27086: skgfglk: unable to lock file - already in use HP-UX Error: 46: No locks available I increased the nflocks parameter from 200 to 1000 as Metablink said. But still got the error. Any idea why ? At 8 am when I get in the office, I startup the database manually and everything was OK. Thanks. Rivaldi This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) 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).
Re: core dump for tkprof
It's 8.1.6 db . I ran tkprof succesfully on same box with same version 3 days back . But now it's geting core dump . -ak - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, March 27, 2003 3:28 PM Subject: RE: core dump for tkprof remove a line that starts with APPNAME or something like that ... in the very beginning of the trace file. Raj -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Thursday, March 27, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: core dump for tkprof when I am trying to execute tkprof on 10046 output file ( level 8 ) , i am getting core dump . any idea why ? thanks, ak
Re: oracle job
8.1.6 -ak - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, March 27, 2003 3:28 PM Subject: RE: oracle job Which version "rubs" the job? -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Thursday, March 27, 2003 2:29 PMTo: Multiple recipients of list ORACLE-LSubject: oracle job If the package which is going to be rub by oracle job gets compiled , does it invalids the job also ? thanks, -ak
RE: Which process is taking up so much CPU???
Thanks Jeremiah. My bad. T early on Friday. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 9:19 AM To: Multiple recipients of list ORACLE-L On Fri, 28 Mar 2003, DENNIS WILLIAMS wrote: Fermin Add this line to your init.ora file. timed_statistics = true Then shutdown, startup your Oracle instance. I would hasten to point out that this parameter can be set dynamically using alter system from at least 8.1.x forward. Thus, restarting the instance is unnecessary and only reduces availability. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- Sent: Friday, March 28, 2003 6:24 AM To: Multiple recipients of list ORACLE-L I wonder where I should set TIMED STATISTICS = TRUE, if any of you has the time to answer I'd be grateful, but I will look for it in the docs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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).
RE: Configuring Oracle with RAID and OFA
I *knew* I should have explained that more. I had some verbage that I just deleted for the sake of simplicity. And it sounded much more impressive by leaving things hanging... :) After talking with the contractor that I worked with in setting this up, I was wrong about our physical layout. I was thinking it was a 6-wide mirrored stripe for the 6GB of datafiles. That would be silly. It's 11-wide. Yes. That's 22 total disks for just the datafiles. A full Photon (11 drives on the front, 11 on back). The redos and archives and their respective mirrors are spread across another 10 on a D1000. 32 disks in all. Da-roo-ul, da-roo-ul. Our hotbacks are nothing special. We use a home-grown, partially plagarized, simple shell/SQL script combo that serially puts each tablespace into backup mode, copies the underlying datafiles *to another disk*, then ends the backup. Pretty generic stuff. The key is that our hotbacks are disk-to-disk. Why disk-to-disk instead of disk-to-tape for us? 1) Cost. We currently use OmniBack and a custom program for tape backups across HP/UX and Solaris, and we may be moving towards Tivoli. OmniBack and Tivoli charge at least 5 figures for their Oracle, and the custom tape backup we have would have to use a script similar to the one we use for disk-to-disk. If we throw even 4 figures at systems for more disks, we're still ahead of the game dollar-wise. I won't get back into the SAN argument for the sake of brevity. I should add that our DBs are relatively small in the Oracle World. Our largest is our 28GB ERP system. 2) Reliability. To subvert to the Old Milwaukee commericals: Boys, it don't get no better than this. There's no worry about whether or not the latest patch on the backup software will work with this version or that version of Oracle. 3) Simplicity. Set TS for backup, copy files, end TS backup. K.I.S.S. (no, not the Gene Simmons kind) See Reliability. 4) Control. For each platform and each system, we have complete control over how and when the hotbacks work. 5) Potential speed of recovery. I'd consider this a by-product advantage of disk-to-disk rather than a selling point because for us the disks are on the same system as the database, giving less weight to this point. I've been writing too long on this -- need to get back to work! Hopefully, this will explain my previous message a little better. :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, March 27, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Rich, How did you manage to take hot backups in 90 seconds for 6 GB db size? If you could shed light on the technique, it would be helpful to us. We might also consider your approach, if feasible on our systems. TIA, Rao -Original Message- Sent: Thursday, March 27, 2003 4:19 PM To: Multiple recipients of list ORACLE-L FWIW, we've got an 8.1.7 system set up on Solaris8. The whole whopping 6GB of datafiles are spread across a 6-wide RAID 0+1, with redos and archives on their own 0+1s. Our hotbacks take 90 seconds. OTOH, our 28GB ERP system on an HP AutoRAID 12H takes over 2.5 hours. I'd like to be done with that in 7 minutes, extrapolating from our other system, not to mention the performance increase for our users (system-wide waits average in the 100s during the day due to physical I/O, but that's a whole other kettle of worms). :) Rich -- 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).
RE: Intermedia tag problem
Thank you Peter and Jan. Luc --- Hitchman, Peter [EMAIL PROTECTED] wrote: Hi, You will have to change your input data and replace the with lt;. This is one of the standard 5 XML entity references. Really you need to make sure that you have no double quotes, single quotes, less than , greater than or ampersands in your data and if you do replace then with the appropriate entity reference: - amp; - quot; ' - apos; - lt; - gt; Regards Pete -Original Message- Sent: 28 March 2003 14:34 To: Multiple recipients of list ORACLE-L Hi Gurus, We are working with Intermedia Text 8.1.6. We created a intermedia index on a search field. We also created 2 sections in this field. Table name : S01 Filed name : S01_search Sections name : SY,MAN Here is an example of data in this field: SYCyane/SYMANPhibro Energy */MAN This example works fine. But we have a problem when there is a character in the data. Intermedia thinks it's a new tag and tries to find a section but it cannot. Exemple: SYCyane 10 /SYMANPhibro Energy */MAN Question : 1- Should we do something with the in our data ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche 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). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, 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). = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche 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 job
if you compile package spec, then all dependent objects will be invalid, if you compile package body, then there will be no invalids. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Friday, March 28, 2003 11:04 AMTo: Multiple recipients of list ORACLE-LSubject: Re: oracle job 8.1.6 -ak - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, March 27, 2003 3:28 PM Subject: RE: oracle job Which version "rubs" the job? -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Thursday, March 27, 2003 2:29 PMTo: Multiple recipients of list ORACLE-LSubject: oracle job If the package which is going to be rub by oracle job gets compiled , does it invalids the job also ? thanks, -ak This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: utl_smtp error
Chris, Thanks for explantion. I asked the smtp mail admin. He said The relays are running Exim-4.10. Is that help? Joan Chris Berry wrote: From: Joan Hsieh [EMAIL PROTECTED] Chris, you got me, what MTA stand for? Mail Transfer Agent, its the program that uses SMTP to send or recieve mail. Examples: Sendmail Courier Postfix Exim qmail MS Exchange Don't confuse this with an MUA (mail user agent) which allows you to compose and read email without using telnet manually. Examples: Mutt Pine Mozilla Outlook If you're getting smtp errors, perhaps your MTA is misconfigured, unavailable, overloaded, etc. SMTP stands for Simple Mail Transfer Protocol. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ Help STOP 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). -- 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).
Oracle Jobs not restarting after upgrade
Solaris 5.8 Oracle 8.1.6 upgrade to 9.2 We are testing an upgrade of Oracle from 8.1.6 to 9.2. There are several oracle jobs scheduled on this DB. Before we started the upgrade, all the jobs were broken (execute dbms_job.broken(201, true). The upgrade to 8.1.7 was done and then the migrate/upgrade to 9.2.0 was done. The jobs were then unbroken execute dbms_job.broken(201, false). But the jobs are not running. A select shows that the jobs are no longer broken, but is also shows that the last date they ran was just before the upgrade, with the next_date showing as the time it would have been scheduled before the upgrade. (I.e, if it ran on the first and was a daily job, it's next_date would be the second). We have tried issuing a change for the next date, but all that does is show a new next_date, it does not make the jobs run. Is there a way to make these jobs start running again. I have looked in the manuals, but either I am missing something obvious, or am not looking in the right place. Any help or suggestions are appreciated. TIA. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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 job
I don't think, that job calling stored procedure from the package gets invalidated (at leastaccording tomy experience: I was recompiling packages and didn't have anything to do with the jobs calling stored procedures from recompiled packages, unless call to the stored procedure changed, like new or different types of parameters passed to stored procedure). The only issue here: make sure, that job is not running, when you are recompiling the package. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, March 28, 2003 11:43 AM Subject: RE: oracle job if you compile package spec, then all dependent objects will be invalid, if you compile package body, then there will be no invalids. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Friday, March 28, 2003 11:04 AMTo: Multiple recipients of list ORACLE-LSubject: Re: oracle job 8.1.6 -ak - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, March 27, 2003 3:28 PM Subject: RE: oracle job Which version "rubs" the job? -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Thursday, March 27, 2003 2:29 PMTo: Multiple recipients of list ORACLE-LSubject: oracle job If the package which is going to be rub by oracle job gets compiled , does it invalids the job also ? thanks, -ak
RE: Oracle Jobs not restarting after upgrade
Title: RE: Oracle Jobs not restarting after upgrade Run them manually for the first time, or try dropping and recreating them. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- From: Ball, Terry [mailto:[EMAIL PROTECTED]] Sent: Friday, March 28, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Jobs not restarting after upgrade Solaris 5.8 Oracle 8.1.6 upgrade to 9.2 We are testing an upgrade of Oracle from 8.1.6 to 9.2. There are several oracle jobs scheduled on this DB. Before we started the upgrade, all the jobs were broken (execute dbms_job.broken(201, true). The upgrade to 8.1.7 was done and then the migrate/upgrade to 9.2.0 was done. The jobs were then unbroken execute dbms_job.broken(201, false). But the jobs are not running. A select shows that the jobs are no longer broken, but is also shows that the last date they ran was just before the upgrade, with the next_date showing as the time it would have been scheduled before the upgrade. (I.e, if it ran on the first and was a daily job, it's next_date would be the second). We have tried issuing a change for the next date, but all that does is show a new next_date, it does not make the jobs run. Is there a way to make these jobs start running again. I have looked in the manuals, but either I am missing something obvious, or am not looking in the right place. Any help or suggestions are appreciated. TIA. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Oracle Jobs not restarting after upgrade
dbms_job.run ? -Original Message- Sent: 28 March 2003 17:09 To: Multiple recipients of list ORACLE-L Solaris 5.8 Oracle 8.1.6 upgrade to 9.2 We are testing an upgrade of Oracle from 8.1.6 to 9.2. There are several oracle jobs scheduled on this DB. Before we started the upgrade, all the jobs were broken (execute dbms_job.broken(201, true). The upgrade to 8.1.7 was done and then the migrate/upgrade to 9.2.0 was done. The jobs were then unbroken execute dbms_job.broken(201, false). But the jobs are not running. A select shows that the jobs are no longer broken, but is also shows that the last date they ran was just before the upgrade, with the next_date showing as the time it would have been scheduled before the upgrade. (I.e, if it ran on the first and was a daily job, it's next_date would be the second). We have tried issuing a change for the next date, but all that does is show a new next_date, it does not make the jobs run. Is there a way to make these jobs start running again. I have looked in the manuals, but either I am missing something obvious, or am not looking in the right place. Any help or suggestions are appreciated. TIA. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Nicoll, Iain 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: utl_smtp error
From: Joan Hsieh [EMAIL PROTECTED] Thanks for explantion. I asked the smtp mail admin. He said The relays are running Exim-4.10. Is that help? What is it you're trying to mail from the database? Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ -- 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: may not be necessary -- was RE: Oracle DB Backups on SAN with
We use the 'shadow mirror' process on a Hitachi SAN (with Oracle 8.1.7 on Solaris 8 and Veritas VxFS) successfully to refresh our development db without a suspend, or even hot backup mode. After the hair that I didn't pull out turned gray (though I am not willing to detail the incompetence on a semi-public list), we got the hardware/file system set up correctly and we have done this several times with no trouble. One issue I had with Hitachi support was that they insisted I had to suspend the database at the time of the split when we were seeing data corruption that was clearly unrelated to Oracle behavior. It turned out to be low level misconfiguration, I believe at the Veritas file system level. I never got a satisfactory explanation. Here is my current (possibly inaccurate) understanding of the process. I would be more than happy to be corrected on any of the details. The shadow mirror process is 'atomic' in the sense that there is some kind of journaling so that when the mirror is split, it is done so that the shadow is a copy of the disk at a particular time, so it looks like the disk would look after a crash or a shutdown abort. Oracle crash recovery has worked as advertised, which is sufficient for our development db needs. If we do get a bad mirror, we would be able to resync and resplit quickly. But as I said, we've done this without incident at least 8 or 9 times. The only times we've had to resync and resplit were due to human error. If you are using Shadow mirror, and this is for backup purposes, you may want the extra security of hot backup. But the mirror split should not cause split blocks, so I'm not sure that it would actually do much for you. To be honest, I haven't thought through all the ramifications of using this as a backup method. If you're not using Shadow mirror, but some other mirror method, the above may not apply. Hope this helps. -Chris -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Subject: may not be necessary -- was RE: Oracle DB Backups on SAN with Jeremiah / Deborah, My understanding is/was that the Snapshot creation wasn't atomic -- it can take a little bit of time and, therefore, it becomes necessary to suspend I/O. Now, I haven't had a chance yet to speak to the Sun/Hitachi engineers and I am going by what management has understood and conveyed to me -- that the database must be quiesced. Hopefully, next week, I will be allowed to speak to the engineers before they set up the SAN. Reading Oracle's documentation in the Backup and Recovery guide Using the Oracle8i SUSPEND/RESUME functionality, you can suspend I/O to the database, then split the mirror and make a backup of the split mirror. This feature, which complements the hot backup functionality, allows you to quiesce the database so that no new I/O can be performed. You can then access the suspended database to make backups without I/O interference. Note: Some RAID devices benefit from suspending writes while the split operation is occurring; your RAID vendor can advise you on whether your system would benefit from this feature. and After a successful database suspension, you can back up the database to disk or break the mirrors. Because suspending a database does not guarantee immediate termination of I/O, Oracle recommends that you precede the SUSPEND statement with a BEGIN BACKUP statement to place the tablespaces in hot backup mode. You must use conventional operating system backup methods to back up split mirrors. RMAN cannot make database backups or copies because these operations require reading the datafile headers. After the database backup is finished or the mirrors are re-silvered, then you can resume normal database operations using the RESUME statement. Backing up a suspended database without splitting mirrors can cause an extended database outage because the database is inaccessible during this time. If backups are taken by splitting mirrors, however, then the outage is nominal. The outage time depends on the size of cache to flush, the number of datafiles, and the time required to break the mirror I did get the impression that a SUSPEND was necessary. However, I have read a Hitachi document at http://www.hds.com/pdf/ods.pdf and I think that a SUSPEND is not mandatory. I will come back to the list when I get more information from the Sun/Hitachi engineers and see the scripts/script-templates that they will be providing. Hemant 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
RE: Oracle Jobs not restarting after upgrade
Check you have the init.ora parameters set up in your new DB Brian -Original Message- Sent: Friday, March 28, 2003 12:35 PM To: Multiple recipients of list ORACLE-L dbms_job.run ? -Original Message- Sent: 28 March 2003 17:09 To: Multiple recipients of list ORACLE-L Solaris 5.8 Oracle 8.1.6 upgrade to 9.2 We are testing an upgrade of Oracle from 8.1.6 to 9.2. There are several oracle jobs scheduled on this DB. Before we started the upgrade, all the jobs were broken (execute dbms_job.broken(201, true). The upgrade to 8.1.7 was done and then the migrate/upgrade to 9.2.0 was done. The jobs were then unbroken execute dbms_job.broken(201, false). But the jobs are not running. A select shows that the jobs are no longer broken, but is also shows that the last date they ran was just before the upgrade, with the next_date showing as the time it would have been scheduled before the upgrade. (I.e, if it ran on the first and was a daily job, it's next_date would be the second). We have tried issuing a change for the next date, but all that does is show a new next_date, it does not make the jobs run. Is there a way to make these jobs start running again. I have looked in the manuals, but either I am missing something obvious, or am not looking in the right place. Any help or suggestions are appreciated. TIA. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Nicoll, Iain 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: Spears, Brian 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).
snapshot too old
why a select statement can give snapshot too old erorr . there is no update , yes but its a long running query . what is fix for this ? -ak
Re: Configuring Oracle with RAID and OFA
We back this up daily, with an additional archive log backup. The amount of space dedicated to redo is due to the size of the disks, 36 gig. Not much I can do about that. Now that I think of it, might be a good idea to setup so that archive logs will go to redo disks should the archive disk fill up for some reason. Not great for performance, but poor performance is always better than none at all. :) Jared On Thursday 27 March 2003 13:28, Niall Litchfield wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jared Still Sent: 27 March 2003 15:59 To: Multiple recipients of list ORACLE-L Subject: Re: Configuring Oracle with RAID and OFA We're installing a new SAN at this moment. I get to specify the disks I want. 4 RAID1 disks for redo 1 RAID1 for archive logs 1 RAID1 for executables 5 RAID10's of ~100 gig each for data. Ahh, life is good. ;) How often do you backup? You seem to have 4 times the amount of space (and indeed number of devices) dedicated to redo that you do for archives? Not that I could exacty call it a bad setup you understand :( (whats the emoticon for rampant jealousy again) Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: snapshot too old
AK Take a look at this. It explains it better than I could. http://home.clara.net/dwotton/dba/snapshot2.htm http://home.clara.net/dwotton/dba/snapshot2.htm Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 12:19 PM To: Multiple recipients of list ORACLE-L why a select statement can give snapshot too old erorr . there is no update , yes but its a long running query . what is fix for this ? -ak -- 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).
RE: OT: uuencode adding characters
From: Saira Somani [EMAIL PROTECTED]
Can you give me a hint? So I use Perl to rid the file of these
characters and then uuencode it and then use mail utility to send to
people? Won't uuencode do the same thing again and add those characters
back?
I haven't used uuencode, but basically what you need to do is:
1) Generate the file
2) Run uuencode
3) Clean it up with perl script
4) Email it
If you want to send me a copy of the uuencoded file, I'd be happy to take a
look at it. Your perl code will look something like this:
#!perl
open INPUT_FILE, infile.txt;
open OUTPUT_FILE, outfile.txt;
while (INPUT_FILE) {
regex
}
close INPUT_FILE;
close OUTPUT_FILE;
sub regex {
}
Where the regex subroutine will contain the code which finds and eliminates
the nasty characters you want to remove. If you're a minimalist, you could
probably rewrite the whole thing to be a single inline statement using perl
-p -i -e
Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates
Without change, something sleeps inside us, and seldom awakens. The
sleeper must awaken. -- Duke Leto Atreides
_
The new MSN 8: smart spam protection and 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).
Re: copying datafile nt4-w2k
Certainly possible. I'm currently copying 8.0 files on NT to Win2k servers with 8.1.7 installed. Rebuild the controlfile, open the database and upgrade. Works great. Jared On Friday 28 March 2003 03:28, [EMAIL PROTECTED] wrote: hi all We are planning an upgrade from NT4 to W2K. I am considering to create a new instance on another server with W2K installed and copying the datafiles from the server with NT4 on it. Is this possible ? Or do i have to use the exp/imp strategy ? thanks vr.gr. Geo Kor Sr. System Engineer IDM Db RDW Voertuiginformatie en -toelating Holland -- 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).
Followup to jobs not running
I changed the job_queue_processes (thanks Barbara), and the jobs all started running, but they are not successful from within the job_queue. They are jobs to gather schema stats using dbs_stats and are run as the system user. I can run the what of the jobs within sqlplus successfully, but whether I run the job manually or the job_queue runs the job, it is still failing. The error I see is insuffient privileges, but I have tried specifically granting execute on dbms_stats to system. Is there anything else I should look for? Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: copying datafile nt4-w2k
Presuming this is a coldbackup.I recall trying it about a year or so ago with a hot backup and had a problem with recovery not knowing when to stop - it kept wanting more log files. [EMAIL PROTECTED] 3/28/03 1:43:41 PM Certainly possible.I'm currently copying 8.0 files on NT to Win2k servers with8.1.7 installed. Rebuild the controlfile, open the databaseand upgrade. Works great.JaredOn Friday 28 March 2003 03:28, [EMAIL PROTECTED] wrote: hi all We are planning an upgrade from NT4 to W2K. I am considering to create a new instance on another server with W2K installed and copying the datafiles from the server with NT4 on it. Is this possible ? Or do i have to use the exp/imp strategy ? thanks vr.gr. Geo Kor Sr. System Engineer IDM Db RDW Voertuiginformatie en -toelating Holland-- 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.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: snapshot too old
AK... this happens with LONG queries too... this means that you do not have enough rollback segments... or... that they are very small... HTH JL --- AK [EMAIL PROTECTED] wrote: why a select statement can give snapshot too old erorr . there is no update , yes but its a long running query . what is fix for this ? -ak __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado 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: create interMedia index problem
Hi:
The problem has been fixed. It turned out that we have very big storage
clause for isistore. All these Intermedia tables will be created when
InterMedia index gets created. So it would try to allocate six 1000M initial
extents. And we don't have that many empty block in RESINDEX tablespace.
begin
ctx_ddl.create_preference('isistore', 'BASIC_STORAGE');
ctx_ddl.set_attribute('isistore', 'I_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'K_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'R_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'N_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'I_INDEX_CLAUSE',
'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'P_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)');
end;
So I run the following to reduce the initial setting to 100M. After that
everything is OK.
begin
-- ctx_ddl.create_preference('isistore', 'BASIC_STORAGE');
ctx_ddl.set_attribute('isistore', 'I_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'K_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'R_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'N_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'I_INDEX_CLAUSE',
'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'P_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)');
end;
Guang
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, March 28, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L
Guang,
Is your RESINDEX tablespace a Locally-Managed Tablespace with Uniform
Extents of less than 3 database blocks? If so, that's your problem.
InterMedia indexes consist of some LOB segments and those require extents
of at least 3 database blocks - at least in 8i.
If not, I don't know.
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]
Guang Mei
[EMAIL PROTECTED]To: Multiple recipients
of list ORACLE-L
Sent by: [EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
Subject: create interMedia
index problem
03/27/2003 10:53
PM
Please respond to
ORACLE-L
Hi:
I have this problem on our production server and I don't know too much
about InterMedia stuff. We have oracle 8173 on Sun Solaris 2.8.
[EMAIL PROTECTED] desc DRUGDATA;
Name Null?Type
-
IDNOT NULL NUMBER
DRUGREPID NOT NULL NUMBER
FIELD NOT NULL NUMBER
TEXT VARCHAR2(4000)
DRUGTERMID NUMBER
DATATYPEIDNOT NULL NUMBER
ADD_FILE NOT NULL VARCHAR2(32)
ADD_DATE NOT NULL DATE
DEL_FILE VARCHAR2(32)
DEL_DATE DATE
STATUSNOT NULL CHAR(1)
ORDERBY NOT NULL NUMBER
[EMAIL PROTECTED] select count(*) from DRUGDATA;
COUNT(*)
--
0
TABLESPACE_NAME USED-Kb ALLOC-KbUSED% SEGS EXT NEXTEXT
--- --- -- - -
DATA 3,000 1,048,576 .3 1 1 504
INDEXES 10,664,424 14,680,064 72.6 48011 693,080
PERFSTAT 105,728 2,097,1525.056 150 128
PROTEOME 164,872 1,048,576 15.75219 25,600
RBS5,131,360 8,388,608 61.2 6 8002,048
RESCTX43,832 6,803,456 .66628 504
RESDATA 34,470,408 46,137,344 74.7 361 2319
RESINDEX 41,046,376 69,206,016 59.3 300 1063 512,000
SYSTEM74,320 153,600 48.4 401 1151,120
TEMP
*Oracle DBA with 8i, OPS, and some SQL Server exp. needed-Los
Los Angeles area company (Torrance) needs an Oracle / SQL DBA to join their IT staff. This person will be the Oracle DBA and will be a backup for the SQL Server DBA. *Candidates in the Greater Los Angeles area will be given first priority. There are no relocation expenses provided, however if a qualifed candidate is within 4-5 hours driving distance of Torrance and willing to pay their own interview and relocation expenses, they will be considered. Salary Range: $85-95K.. depends on experience. Please do not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. *Requirements: -BSCS degree -Combination of 4+ years Oracle 8i and/or 9i DBA experience. -MUST have Oracle Parallel Server (OPS) or Informatica experience. -Solid skills in logical and physical database design database tuning, data backup, recovery, security processes / procedures,etc -Knowledge/experience with SQL Server 7.0 and 2000 DBA experience is a big plus. -Data Warehouse experience is a plus. -U.S. citizenship or permanent residency is required. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/LA area/DBA/Bob ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff 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: Followup to jobs not running
Privileges should be granted to the user, who created the job. Was it system? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:13 PM I changed the job_queue_processes (thanks Barbara), and the jobs all started running, but they are not successful from within the job_queue. They are jobs to gather schema stats using dbs_stats and are run as the system user. I can run the what of the jobs within sqlplus successfully, but whether I run the job manually or the job_queue runs the job, it is still failing. The error I see is insuffient privileges, but I have tried specifically granting execute on dbms_stats to system. Is there anything else I should look for? Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Igor Neyman 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: index on null column
AK, I'd still do some testing with a bitmap index on that column. You have 1,000,000 records. 500 records have value in that column. That means the absolute most distinct values in that column is 501. This is at least one criteria for bitmap candidacy. What I see in testing is select * from table where A = 'some value' can use the bitmap index. Also I see select * from table where A is null also uses the bitmap index. I'm definitely not saying this as 'end all', just saying it might be worth playing with. Darrell Landrum Database Administrator Zale Corporation [EMAIL PROTECTED] 03/28/03 09:59AM It means if I do a query with where clause with A=:x its going to go for index . Does oracle go to table if :x is null. It looks like it does . ??? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 6:33 PM AK Yes, it will benefit the non-null records. Just remember that the null values aren't indexes. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 5:19 PM To: Multiple recipients of list ORACLE-L I have a table with column A. there are 100 records in table out of which 500o records has not null in column A rest are null. if i created an index on A, will it benefit . thanks, ak -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum 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).
SCN scheme 3
List, does anybody know what this means: SCN scheme 3 It occurs it the alert log upon startup. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: import problem - newbie question
LeRoy, Even though you start your import as system, when the process starts to import tables owned by (for example) 'appuser' it will switch to that user. What I'm thinking is that you should create the user in advance of starting the import and give the user adequate tablespace quota. I may be missing something on this and perhaps someone else will correct if so, but this is what I would try if it were me. Darrell [EMAIL PROTECTED] 03/28/03 11:03AM I am exporting data from production to test database. I receive error of 'no privledges on tablespace'. I dropped the user from the test box and trying import full from the schema export I created. Not sure what I am doing wrong. I am running 8.1.7 on Unix. imp system/* file=uwsa.dmp log=import.log full=y ignore=y LeRoy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz 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: Darrell Landrum 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: Followup to jobs not running
Yes. System is the job owner/creator. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, March 28, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Privileges should be granted to the user, who created the job. Was it system? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:13 PM I changed the job_queue_processes (thanks Barbara), and the jobs all started running, but they are not successful from within the job_queue. They are jobs to gather schema stats using dbs_stats and are run as the system user. I can run the what of the jobs within sqlplus successfully, but whether I run the job manually or the job_queue runs the job, it is still failing. The error I see is insuffient privileges, but I have tried specifically granting execute on dbms_stats to system. Is there anything else I should look for? Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Igor Neyman 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: Ball, Terry 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: Followup to jobs not running
That did not help. It takes longer to error out, but it is still failing. I can set the same jobs up for the sys user and they run without problems. I am not sure why the system user is the owner of the jobs and since I am the only DBA here this afternoon, I will have to wait until next week to find out if there is a reason for not moving them to sys. If anyone else has any ideas, I am still open to suggestions. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 1:42 PM To: Ball, Terry GRANT ANALYZE ANY TO SYSTEM; Ball, Terry [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Followup to jobs not running 03/28/2003 11:13 AM Please respond to ORACLE-L I changed the job_queue_processes (thanks Barbara), and the jobs all started running, but they are not successful from within the job_queue. They are jobs to gather schema stats using dbs_stats and are run as the system user. I can run the what of the jobs within sqlplus successfully, but whether I run the job manually or the job_queue runs the job, it is still failing. The error I see is insuffient privileges, but I have tried specifically granting execute on dbms_stats to system. Is there anything else I should look for? Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Ball, Terry 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: Unable to lock file
Dennis, I had set user profile prior to submit the job. It works fine for other databases. Is there any unix command to know the number of files locks currently used ? I have nflocks = 1000 (unix command : kmtune -q nflocks) and wondering how many locks currently available. Thanks Rivaldi -Original Message- Sent: Friday, March 28, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Rivaldi Try to figure out what is different when cron starts the instance vs. your starting the instance. Some parameter is getting set or not getting set. For most Unix versions the env command dumps all environment variables. Do that for your interactive session and then add that to the script cron is executing and then manually execute the script. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Hi Listers, Oracle 8174, HP 11.00 I got the following error when starting up the database thru crontab job at 2 am in the morning. It happened after we shutdown the unix machine. Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc: ORA-01157: cannot identify/lock data file 13 - see DBWR trace file ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf' ORA-27086: skgfglk: unable to lock file - already in use HP-UX Error: 46: No locks available I increased the nflocks parameter from 200 to 1000 as Metablink said. But still got the error. Any idea why ? At 8 am when I get in the office, I startup the database manually and everything was OK. Thanks. Rivaldi This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) 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). This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: Followup to jobs not running
Title: RE: Followup to jobs not running login as sys and grant analyze any table to system. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- From: Ball, Terry [mailto:[EMAIL PROTECTED]] Sent: Friday, March 28, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Followup to jobs not running Yes. System is the job owner/creator. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, March 28, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Privileges should be granted to the user, who created the job. Was it system? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:13 PM I changed the job_queue_processes (thanks Barbara), and the jobs all started running, but they are not successful from within the job_queue. They are jobs to gather schema stats using dbs_stats and are run as the system user. I can run the what of the jobs within sqlplus successfully, but whether I run the job manually or the job_queue runs the job, it is still failing. The error I see is insuffient privileges, but I have tried specifically granting execute on dbms_stats to system. Is there anything else I should look for? Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Igor Neyman 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: Ball, Terry 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Unable to lock file
Another question, After change the kernel parameter (thru kmtune), to make the change take effect, do we need to relink the unix or just shutdown / reboot the machine ? Thanks. -Original Message- Sent: Friday, March 28, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Dennis, I had set user profile prior to submit the job. It works fine for other databases. Is there any unix command to know the number of files locks currently used ? I have nflocks = 1000 (unix command : kmtune -q nflocks) and wondering how many locks currently available. Thanks Rivaldi -Original Message- Sent: Friday, March 28, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Rivaldi Try to figure out what is different when cron starts the instance vs. your starting the instance. Some parameter is getting set or not getting set. For most Unix versions the env command dumps all environment variables. Do that for your interactive session and then add that to the script cron is executing and then manually execute the script. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Hi Listers, Oracle 8174, HP 11.00 I got the following error when starting up the database thru crontab job at 2 am in the morning. It happened after we shutdown the unix machine. Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc: ORA-01157: cannot identify/lock data file 13 - see DBWR trace file ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf' ORA-27086: skgfglk: unable to lock file - already in use HP-UX Error: 46: No locks available I increased the nflocks parameter from 200 to 1000 as Metablink said. But still got the error. Any idea why ? At 8 am when I get in the office, I startup the database manually and everything was OK. Thanks. Rivaldi This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) 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). This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list
RE: Unable to lock file
The error is not specific to that database. At other time, the same error occured when starting other database. (I shutdown some small databases for daily cold backup). That's my question too, so far, why I'm able to start manually at daytime. May be less number of locks ? Thanks. -Original Message- Sent: Friday, March 28, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Rivaldi That requires way more Unix knowledge than I have and we don't run HP anyway. If it was simply the number of locks, why would you be able to start the database manually? In your cron job, is this the last database that is started? If it is the number of locks, I would think the last database started would consistently have the problem. Just some thoughts for you to consider. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Dennis, I had set user profile prior to submit the job. It works fine for other databases. Is there any unix command to know the number of files locks currently used ? I have nflocks = 1000 (unix command : kmtune -q nflocks) and wondering how many locks currently available. Thanks Rivaldi -Original Message- Sent: Friday, March 28, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Rivaldi Try to figure out what is different when cron starts the instance vs. your starting the instance. Some parameter is getting set or not getting set. For most Unix versions the env command dumps all environment variables. Do that for your interactive session and then add that to the script cron is executing and then manually execute the script. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Hi Listers, Oracle 8174, HP 11.00 I got the following error when starting up the database thru crontab job at 2 am in the morning. It happened after we shutdown the unix machine. Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc: ORA-01157: cannot identify/lock data file 13 - see DBWR trace file ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf' ORA-27086: skgfglk: unable to lock file - already in use HP-UX Error: 46: No locks available I increased the nflocks parameter from 200 to 1000 as Metablink said. But still got the error. Any idea why ? At 8 am when I get in the office, I startup the database manually and everything was OK. Thanks. Rivaldi This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) 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). This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of
Oracle Grid,Streams
Hi List What are the Pros and Cons of the above?. Has anyone in the industry implemented the above successfully?. Are there any pitfalls / restrictions to using the above technology? TIA GovindanK -- * *YOU SHOULD TREAT OTHERS THE WAY YOU WANT TO BE TREATED - MAHATMA GANDHI* * __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promos=380455 -- 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: Unable to lock file
You get this when another process has a lock on the file. Are you sure your shutdown was clean? Allan -Original Message- Sent: Friday, March 28, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Hi Listers, Oracle 8174, HP 11.00 I got the following error when starting up the database thru crontab job at 2 am in the morning. It happened after we shutdown the unix machine. Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc: ORA-01157: cannot identify/lock data file 13 - see DBWR trace file ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf' ORA-27086: skgfglk: unable to lock file - already in use HP-UX Error: 46: No locks available I increased the nflocks parameter from 200 to 1000 as Metablink said. But still got the error. Any idea why ? At 8 am when I get in the office, I startup the database manually and everything was OK. Thanks. Rivaldi This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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: Unable to lock file
On HP you must rebuild the kernel for the change to take effect. Allan -Original Message- Sent: Friday, March 28, 2003 3:09 PM To: Multiple recipients of list ORACLE-L Rivaldi That requires way more Unix knowledge than I have and we don't run HP anyway. If it was simply the number of locks, why would you be able to start the database manually? In your cron job, is this the last database that is started? If it is the number of locks, I would think the last database started would consistently have the problem. Just some thoughts for you to consider. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Dennis, I had set user profile prior to submit the job. It works fine for other databases. Is there any unix command to know the number of files locks currently used ? I have nflocks = 1000 (unix command : kmtune -q nflocks) and wondering how many locks currently available. Thanks Rivaldi -Original Message- Sent: Friday, March 28, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Rivaldi Try to figure out what is different when cron starts the instance vs. your starting the instance. Some parameter is getting set or not getting set. For most Unix versions the env command dumps all environment variables. Do that for your interactive session and then add that to the script cron is executing and then manually execute the script. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Hi Listers, Oracle 8174, HP 11.00 I got the following error when starting up the database thru crontab job at 2 am in the morning. It happened after we shutdown the unix machine. Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc: ORA-01157: cannot identify/lock data file 13 - see DBWR trace file ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf' ORA-27086: skgfglk: unable to lock file - already in use HP-UX Error: 46: No locks available I increased the nflocks parameter from 200 to 1000 as Metablink said. But still got the error. Any idea why ? At 8 am when I get in the office, I startup the database manually and everything was OK. Thanks. Rivaldi This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) 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). This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received
Re: copying datafile nt4-w2k
Yes, the database is down while doing this. Opening the database and creating a controlfile works, but I really didn't expect recovery on an 8.0 database to work with 8i executables. Jared On Friday 28 March 2003 11:38, Jeffrey Beckstrom wrote: Presuming this is a cold backup. I recall trying it about a year or so ago with a hot backup and had a problem with recovery not knowing when to stop - it kept wanting more log files. [EMAIL PROTECTED] 3/28/03 1:43:41 PM Certainly possible. I'm currently copying 8.0 files on NT to Win2k servers with 8.1.7 installed. Rebuild the controlfile, open the database and upgrade. Works great. Jared On Friday 28 March 2003 03:28, [EMAIL PROTECTED] wrote: hi all We are planning an upgrade from NT4 to W2K. I am considering to create a new instance on another server with W2K installed and copying the datafiles from the server with NT4 on it. Is this possible ? Or do i have to use the exp/imp strategy ? thanks vr.gr. Geo Kor Sr. System Engineer IDM Db RDW Voertuiginformatie en -toelating Holland Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML -- 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).
optimal set up of tablespaces on disks??
Hi Friends, Again I need help from you guys! I have 28 x 36.4Gb mirrored disks on AIX 5L, Would you guys suggest best way of arranging tablespaces across disks!! I have tablespaces like rbs,temp,tools,index,data etc. expecting with RAID 2 x 36.4 gb RAID-I 26 x 36.4 gb RAID -I + 0 Any ideas will greately appreciated. peter. _ Help STOP 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: Peter R 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: Week - Date function!
Maybe a slight improvement. I borrowed heavily from Jonathan Gennicks pivot table article for this. :) http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html select x.d from ( select to_date(rownum, 'DDD') d, to_number(to_char(to_date(rownum, 'DDD'), 'IW')) week from TABLE(pivot_package.pivot(365)) ) x where x.week = week_num / The package and types appear below. This doesn't seem to know how to deal with the 53rd week in the year. I stayed home sick today, and just don't seem to be motivated enough to fix that last bit. Jared drop package pivot_package; drop type pivot_table; drop type pivot_row; CREATE OR REPLACE TYPE pivot_row AS OBJECT ( x NUMBER ); / CREATE OR REPLACE TYPE pivot_table AS TABLE OF pivot_row; / CREATE OR REPLACE PACKAGE pivot_package AS FUNCTION pivot (num_rows IN NUMBER) RETURN pivot_table PARALLEL_ENABLE PIPELINED; END; / CREATE OR REPLACE PACKAGE BODY pivot_package AS FUNCTION pivot (num_rows IN NUMBER) RETURN pivot_table PARALLEL_ENABLE PIPELINED IS outrow pivot_row := pivot_row (0); BEGIN FOR x IN 1..num_rows LOOP outrow.x := x; PIPE ROW(outrow); END LOOP; RETURN; END; END; / On Friday 28 March 2003 06:38, Stephane Faroult wrote: SQL l 1 select x.d 2 from (select to_date(rownum, 'DDD') d, 3 to_number(to_char(to_date(rownum, 'DDD'), 'IW')) week 4from all_objects 5where rownum 366) x 6* where x.week = week_num You may have a problem with leap years, but it's basically the idea. Anything smarter, somebody ? Given a week between (1 - 52) for a particular year can we get all the dates within that week. Is there a function to do this in SQL??? Thanks a lot. Regards Sesi -- Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Grid,Streams
I think you're confusing something here, or maybe that's just the way the title of your email reads. Oracle has technology that fits in the grid computing paradigm, and Streams is obviously part of that. But there is no Oracle Grid product that you can buy that I'm aware of. Have you looked at the marketing bumph at http://otn.oracle.com/products/oracle9i/grid_computing/content.html? That might clarify things for you somewhat. And yes, there are customers who have implemented Streams successfully. If you want more details about how Oracle fits in the grid computing space, contact me offline and I can point you to the right contacts in Oracle. 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- [EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Hi List What are the Pros and Cons of the above?. Has anyone in the industry implemented the above successfully?. Are there any pitfalls / restrictions to using the above technology? TIA GovindanK -- * *YOU SHOULD TREAT OTHERS THE WAY YOU WANT TO BE TREATED - MAHATMA GANDHI* * __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promos=380455 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Followup to jobs not running
You may have already got the answer, but if your job is selecting candidate tables or schemas from dba_tables or dba_???, then you have to grant select on them to system specifically. System gets the select privilege from the role DBA and not directly. I have a similar job that runs under a different user than sys. and I had to grant select on dba_tables to user grant analyze any to user Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:29 PM Yes. System is the job owner/creator. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, March 28, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Privileges should be granted to the user, who created the job. Was it system? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:13 PM I changed the job_queue_processes (thanks Barbara), and the jobs all started running, but they are not successful from within the job_queue. They are jobs to gather schema stats using dbs_stats and are run as the system user. I can run the what of the jobs within sqlplus successfully, but whether I run the job manually or the job_queue runs the job, it is still failing. The error I see is insuffient privileges, but I have tried specifically granting execute on dbms_stats to system. Is there anything else I should look for? Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Igor Neyman 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: Ball, Terry 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: Steve Perry 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: OEM 4
John, EM 4.0 is currently in beta and is available only to customers who are part of the beta program. Cheers, Gaja --- John Weatherman [EMAIL PROTECTED] wrote: Hi all, Is anyone aware of when OEM 4 will be available. I've been looking around on Metalink and can't seem to find anything about it. It was used at the Oracle Tech Day here in Greensboro this week and the web interface looks to have been really improved. TIA, John P Weatherman Oracle Database Administrator Replacements, Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - = __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha 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: Unable to lock file
I strongly suspect the problem involves environmental variables. One way to test this is from your interactive session do - env | sort -o /tmp/int.env Within your cron script do env | sort -o /tmp/cron.env Next do cd /tmp diff int.env cron.env Then make you cron environment match your interactive environment. HTH YMMV HAND! Bahar, Rivaldi (BBASSI-CHQ)To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: assi.comSubject: RE: Unable to lock file Sent by: [EMAIL PROTECTED] 03/28/2003 02:03 PM Please respond to ORACLE-L The error is not specific to that database. At other time, the same error occured when starting other database. (I shutdown some small databases for daily cold backup). That's my question too, so far, why I'm able to start manually at daytime. May be less number of locks ? Thanks. -Original Message- Sent: Friday, March 28, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Rivaldi That requires way more Unix knowledge than I have and we don't run HP anyway. If it was simply the number of locks, why would you be able to start the database manually? In your cron job, is this the last database that is started? If it is the number of locks, I would think the last database started would consistently have the problem. Just some thoughts for you to consider. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Dennis, I had set user profile prior to submit the job. It works fine for other databases. Is there any unix command to know the number of files locks currently used ? I have nflocks = 1000 (unix command : kmtune -q nflocks) and wondering how many locks currently available. Thanks Rivaldi -Original Message- Sent: Friday, March 28, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Rivaldi Try to figure out what is different when cron starts the instance vs. your starting the instance. Some parameter is getting set or not getting set. For most Unix versions the env command dumps all environment variables. Do that for your interactive session and then add that to the script cron is executing and then manually execute the script. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Hi Listers, Oracle 8174, HP 11.00 I got the following error when starting up the database thru crontab job at 2 am in the morning. It happened after we shutdown the unix machine. Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc: ORA-01157: cannot identify/lock data file 13 - see DBWR trace file ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf' ORA-27086: skgfglk: unable to lock file - already in use HP-UX Error: 46: No locks available I increased the nflocks parameter from 200 to 1000 as Metablink said. But still got the error. Any idea why ? At 8 am when I get in the office, I startup the database manually and everything was OK. Thanks. Rivaldi
Re: optimal set up of tablespaces on disks??
It depends: for maximum IO on redo, with mirrored redo logs: 4 2 x 36 RAID 1 for redo 1 2 x 36 for archive logs 1 2 x 36 for executables 2 8 x 36 RAID 10 for data/indexes ( about 250 gig usable ) If you choose not to let oracle mirror the redo logs, you could take four of those drives and add: 1 4 x 36 RAID 10. It really depends on your requirements. Do you need more room for data? Is this OLTP, DW, Hybrid? Anyway, this is a starting point. You would be wise to purchase and study 'Oracle Performance Tuning 101', available at an Amazon.com near you. Jared On Friday 28 March 2003 15:43, Peter R wrote: Hi Friends, Again I need help from you guys! I have 28 x 36.4Gb mirrored disks on AIX 5L, Would you guys suggest best way of arranging tablespaces across disks!! I have tablespaces like rbs,temp,tools,index,data etc. expecting with RAID 2 x 36.4 gb RAID-I 26 x 36.4 gb RAID -I + 0 Any ideas will greately appreciated. peter. _ Help STOP 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent: restore from hot backup w/o archivelogs
Well If you don't mind possibly destroying the database you are trying to restore, you can use: alter session set events 'IMMEDIATE trace name ADJUST_SCN level 1'; We had a strange failure / recovery situation and I was given this command. The description posted in the TAR was: A data block SCN is ahead of the current SCN. The ORA-600 [2662] occurs when an SCN is compared to the dependent SCN (which is stored in a UGA variable). If the SCN is strictly less than the dependent SCN, then we signal the ORA-600 [2662] internal error, and print out the SCN, the dependent SCN, and the dependent SCN block. *** this can corrupt the database *** I later used it in another case, where the Sys Admin had restored the wrong version or combination of files and used level 100 instead of 1 to do a bigger increase. This was on a test instance and I didn't want to rebuild if I had a way around in the meantime. - Babette -Original Message- Chitale Sent: Thursday, March 27, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Well, My mind seems to have stopped working now. Can you do an ALTER DATABASE OPEN RESETLOGS if log switches have occurred and some of the database files have been updated between the first ALTER TABLESPACE tbs1 BEGIN BACKUP and the last ALTER TABLESPACE tbsN END BACKUP wouldn't you get ORA-01194: file 1 needs more recovery to be consistent Do you issue an ALTER DATABASE OPEN RESETLOGS without even attempting a RECOVER DATABASE UNTIL CANCEL ? Or does it work if *ALL* the Tablespaces are put in BACKUP mode and the hot backup is provided to you without archive logs, irrespective of the number of archive logs generated and NOT work if the Tablespaces are in BACKUP mode sequentially ? Hemant At 11:14 AM 26-03-03 -0800, you wrote: Well thanx a lot, Rachel and Jose. At 12 midnight the mind seems to have stopped working :-) Regards Naveen -Original Message- Sent: Thursday, March 27, 2003 12:21 AM To: Multiple recipients of list ORACLE-L alter database open resetlogs; you won't be able to apply the archived logs he sends over later on (yes Jeremiah I know there is a way to recover through a resetlogs but they will be doing work against the database in the interim!) but if data loss is not a problem, that's the way to go Rachel --- Naveen Nahata [EMAIL PROTECTED] wrote: I have got a set of datafiles backed up from the client but he didn't send me the required archive logs now for testing purpose we need to get the DB up at our site but the archive logs are not there, the client will send the same but it will take time Is there any way to get the DB up without applying the archive logs DATA LOSS IS NOT A PROBLEM Regards Naveen __ [snipped] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood 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: Week - Date function!
Hello!
Sesi Odury wrote:
Given a week between (1 - 52) for a particular year can we get all the
dates within that week. Is there a function to do this in SQL???
Using the simple statement below you can get the first date of the week
(according to ISO standard). Then you can either add 6 to get the last
day of the week and use ranges for your task or using any 'pivot'-approach
(you need 7 rows) you can get all 7 days/dates of the week.
DEFINE yr=1998
DEFINE wk=5
SELECT TRUNC(TO_DATE('2711yr', 'DDMM'), 'IYYY') + (wk - 1) * 7 AS date_from
, TRUNC(TO_DATE('2711yr', 'DDMM'), 'IYYY') + (wk - 1) * 7 + 6 AS date_to
FROM sys.dual
/
Ranges can be used in case one does not have a possibility to use FBI, for
example.
The statement below is a bit more complicated. This one does a simple
check and returns nothing in case week number is out of range.
DEFINE yr=1998
DEFINE wk=53
SELECT TRUNC(TO_DATE('2711yr', 'DDMM'), 'IYYY') + (wk - 1) * 7 AS date_from
, TRUNC(TO_DATE('2711yr', 'DDMM'), 'IYYY') + (wk - 1) * 7 + 6 AS date_to
FROM sys.dual
WHERE TO_NUMBER(
TO_CHAR(
TO_DATE('3112yr', 'DDMM')
+ DECODE(TO_CHAR(TO_DATE('3112yr', 'DDMM'), 'IW')
, '01', -7
, 0
)
, 'IW'
)
) = wk
AND wk 0
/
HTH[, if I did not make a mistake].
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
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).
