Re: Oracle and NAS (more Q's)
How do you do backups? Do you use RMAN with MML? Do you use NDMP? Tia. [EMAIL PROTECTED] 07/16/02 08:28a.m. Dick, We're using Netapp F720's to store all our datafiles (production and test) in a small/medium OLTP environment and are quite happy with the setup. YMMV. We run out of two sets of collocated servers. At each collocation there are at least two filers and at least two servers. The filers and the servers currently have three 100BaseT network connections. One front channel and two back channels. Each LAN segment is switched. Thus any server at a location can connect to any filer at that location. Datafiles can be spread across filers or spread across channels as performance requires. The WAFL does indeed write to the nearest available inode and relinks the inode map. The unlinked inode is immediately available for rewrite unless it is a member of a snapshot. Thus while reserving unlinked blocks is inefficient from a storage perspective, it is a factor you get to control by controlling the snapshots. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Your password!
password.txt Description: Binary data
[no subject]
SET ORACLE-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RAHUL GAJANAN MEHENDALE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dblink problem ( ORA-02019 )
Hi, Use this DROP DATABASE LINK name; Or if you have created public link then.. DROP PUBLIC DATABASE LINKname; Sanjay -Original Message-From: Anand Kumar N - Systems [mailto:[EMAIL PROTECTED]]Sent: 16 July, 2002 3:03 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dblink problem ( ORA-02019 ) HI AMJAD, HOW TO DROP THE DATABASE LINK. ANAND ITW SIGNODE INDIA LIMITED - Original Message - From: Amjad To: Multiple recipients of list ORACLE-L Sent: Thursday, July 11, 2002 1:43 PM Subject: RE: dblink problem ( ORA-02019 ) CREATE PUBLIC DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING 'connect_string' Regards, Amjad. www.medicomsoft.com : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anand Kumar N - SystemsSent: Thursday, July 11, 2002 9:33 AMTo: Multiple recipients of list ORACLE-LSubject: Re: dblink problem ( ORA-02019 ) Hi all, How to Create dblink, can u please explain me. bye Anand - Original Message - From: Ratnesh Kumar Singh To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 10, 2002 6:23 PM Subject: dblink problem ( ORA-02019 ) hii have 3 databases(A,B,X) on 3 diff boxes.i have created 1 dblink each from A to X from B to X.The syntax for dblink creation is exactly same for both dblinks.I am able to query from dblink A-X as "select * from user.table@dblinkAX"but when i try to query from dblink B-X as "select * fromuser.table@dblinkBX"i get the foll errorError: ORA-02019: connection description for remote database not foundWhen i modify my query by suffixing '.world' as"select * from [EMAIL PROTECTED]" , the query works fine.I have compared the entries in init,sqlnet,tnsnmames,listener files on bothA Bdatabases and they are absolutely similar .i was thinking that the domain or globalnames parameters might be diff on A B ,but they are absolutely same .any suggestions are most welcome ...thanks in advanceratnesh---Ratnesh Kumar SinghSr. Software EngineerPatni Computer Systems LtdTTC Mahape , Navi MumbaiWork : (91 22) 7611090/110/128/350 Ext. 2107Home : (91 22) 8662162http://www.patni.comWorld-Wide Partnerships. World-Class Solutions.- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo 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).
To create a new datafile or to increase a existing datafile.
Title: To create a new datafile or to increase a existing datafile. Hello Gurus Which is the better policy: Say you have five datafiles of 1GB in size each, now the total freespace is less than 10%. Would it be wise to increase the datafiles to 2GB or would it be better for the system to add a sixth datafile? Would appreciate any views on this point. Rgds Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
SQL Loader
Hi, can anyone please help with SQL Loader? I want to migrate a personal calendar from Sybase to Oracle. Template records in my Sybase bcp dump are 20020101Jan 1 2002 12:00:00:000AM 3 Tuesday 1 1 1 January 1 20022002 20020102Jan 2 2002 12:00:00:000AM 4 Wednesday 2 1 1 January 1 20022002 My Oracle-table has following columns: table Calendar ( Date_int numbernot null, Date_date datenot null, Weekday_int numbernot null, Weekday_str varchar2(16) not null, DayOfYear_int numbernot null, Week_intnumbernot null, Month_int numbernot null, Month_str varchar2(16) not null, Quarter_int numbernot null, Year_int numbernot null, YearOfWeek_int numbernot null ) How does my controlfile have to look? Especially with the date_format. Can I just provide the psotitions and leave out the Milliseconds and AM and PM values? Regards, Antje Antje Sackwitz ppi Media GmbH Deliusstraße 10 D-24114 Kiel phone +49 (0) 43 1-53 53-2 16 fax +49 (0) 43 1-53 53-2 22 email mailto:[EMAIL PROTECTED] web www.ppi.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 - unix vs linux vs windows - the future
Can you send more details: Which mainframe, what type of systems, how many machines, staff reduction, costs etc Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 15, 2002 7:58 PM Actually they were replaced in my previous company : Not XP though but W2K !!! On Monday 15 July 2002 09:44, [EMAIL PROTECTED] wrote: Oh yes, and mainframes will all be replaced by XP next year as well. ltiu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 09:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: OT - unix vs linux vs windows - the future But do all these matter though? Everyone's moving to MS software and *nixes are getting rarer and rarer. The fact is that everyone's losing money (Sun, IBM, HP, SGI even RedHat and Caldera) - except MS. It's an MS world like it or not. ltiu On Monday 15 July 2002 08:33, Andrey Bronfin wrote: Good bet that smaller Unix vendors will run to Linux before vendors like Sun do. Not exactly , just look at homepages of sun , ibm , oracle . There are more appearences of the word linux there than any word in Britannica ;-) DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd/2)
Hello Eric I think that you misunderstood. snip | Ellison probably took the money and ran when this | became apparent to him and many others. I know I did. So (regardless of whether Ellison is a good example, or not), do you think that there should be *any* accountability for the social damage caused by greed driven unethical accounting practices? /snip He wrote about investors that have stock and sell them when they see that the market sink. What this have to do with shady or outright criminal accounting practices? I agree with you that whoever is responsible for cooking the books should have to pay, from his own money, all the people that got hurt by this. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 7:13 AM trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From: Johnson, M=2E | Date: Mon, 15 Jul 2002 10:23:21 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: RE: McCain on Larry Ellison and Corporate Responsibility / Re: = OT | Not defending Ellison for anything,=20 Understood | but it appears | McCain is just another politician who is only interested | in his future and he constantly takes on these reform | ideas and just makes the matter worse That sounds really cynical to me. Are you just speculating, or do you have any info to back that up? Note that Oracle/Ellison attempted to buy off politicians here in Sacramento in order to stop the JLAC (legislative) audit of Oracle's ELA with the State of California Note that Senator Sarbanes was on the same TV program (Meet the Press) as McCain, and generally agreed with McCain that there is a horrible lack of corporate responsibility, and that reforming the institutions designed to protect the public's interests has been made extremely difficult by the influence of corrupt lobbyists and lack of effective campaign reform Tim Russert (a rare TV journalist with some integrity) and the Senators spent most of their time discussing the issue of putting executive stock options on the expense sheets so as to more correctly reflect profitability (or lack thereof) Do you think it better serves the investment community for sleazy corrupt executives to be able to hide their shenanighans from analysts and investors? | Everyone should accept the fact that we are in a bear | market and as such all the boats go down Argh, that is the problem, when you have these outrageous examples of greedy, corrupt corporate executives cashing out (***AFTER COOKING THE BOOKS***), leaving others to sink | Everyone should have been smart enough to sell stocks and | put their money into cash or better yet short stocks | when it was very clear that in the Fall of 2000 after the | initial March 2000 sell off that we were going into | a prolonged Bear market Should have been !?!?! That isn't really the issue. As mentioned above, the issue was how excess greed played out when the books were cooked to create a false impression of profitability | Ellison probably took the money and ran when this | became apparent to him and many others. I know I did. So (regardless of whether Ellison is a good example, or not), do you think that there should be *any* accountability for the social damage caused by greed driven unethical accounting practices? (fwiw, I'm sympathetic to libertarian/Chicago school free market ideology, but I fear that like its opposite, leftist utopianism, when taken to extremes, it doesn't work all that well in the real world.) regards, ep -Original Message- Sent: Monday, July 15, 2002 5:53 AM To: Multiple recipients of list ORACLE-L OT - unix My understanding is that this was the very first time Ellison had ever sol= d Oracle stock, in over 25 years of the company's existence, in 2000, which = is the occasion that McCain (and you) are referring to=2E As you might be aw= are, there was a far greater opportunity for Ellison to cash out and leave Oracle dangling in 1990, when the price dropped from around $20 to $6 almo= st overnight after some financial-earning restatements=2E On that occasion, = he would certainly have had prior knowledge of what was going to happen, to p= ut it mildly=2E In 2000, any foreknowledge of a long-term downturn (26 month= s and counting?) would have been worth far more than $700m, especially to someone holding several billions in equities=2E=2E=2E - Original Message - To: Multiple recipients of list ORACLE-L ORACLE- L@fatcity=2Ecom Sent: Sunday, July 14, 2002 10:13 PM unix Speaking of herds, or at least what is left behind on the ground after they pass: on Meet the Press (TV program), Senator John McCain said that Larry Ellison cashed out $700,000,000 of his Oracle
RE: dblink problem ( ORA-02019 )
drop public database link dblink dear anand iam sorry to say this but such things u can always look up in the documentation... no 1 will spoon feed u to such a level if its something more logical problem or something that is new we r always here to help each other out , after all this list is made to help each other... i hope u can understand... thanx and regards, Amjad. www.medicomsoft.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anand Kumar N - SystemsSent: Tuesday, July 16, 2002 11:03 AMTo: Multiple recipients of list ORACLE-LSubject: Re: dblink problem ( ORA-02019 ) HI AMJAD, HOW TO DROP THE DATABASE LINK. ANAND ITW SIGNODE INDIA LIMITED - Original Message - From: Amjad To: Multiple recipients of list ORACLE-L Sent: Thursday, July 11, 2002 1:43 PM Subject: RE: dblink problem ( ORA-02019 ) CREATE PUBLIC DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING 'connect_string' Regards, Amjad. www.medicomsoft.com : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anand Kumar N - SystemsSent: Thursday, July 11, 2002 9:33 AMTo: Multiple recipients of list ORACLE-LSubject: Re: dblink problem ( ORA-02019 ) Hi all, How to Create dblink, can u please explain me. bye Anand
RE: To create a new datafile or to increase a existing datafile.
Title: To create a new datafile or to increase a existing datafile. In this case anything would do. Better would be to expand the already mentioned dfiles as the Sixth datafile would be placed on to some H.Disk and then I/O contention to that disk would increase. Better is to redistribute the load among the various datafiles. If you have one hard disk then it would not matter at all between the two different scenarios. Vikas Khanna -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 16, 2002 1:53 PMTo: Multiple recipients of list ORACLE-LSubject: To create a new datafile or to increase a existing datafile. Hello Gurus Which is the better policy: Say you have five datafiles of 1GB in size each, now the total freespace is less than 10%. Would it be wise to increase the datafiles to 2GB or would it be better for the system to add a sixth datafile? Would appreciate any views on this point. Rgds Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
Re: dblink problem ( ORA-02019 )
Hi, Use Drop database link name. (if the link is a private link and u are the owner) Drop public database link name. Hope this helps shreepad Anand Kumar N - Systems To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] node.co.in cc: Subject: Re: dblink problem ( ORA-02019 ) 16/07/02 12:33 Please respond to ORACLE-L HI AMJAD, HOW TO DROP THE DATABASE LINK. ANAND ITW SIGNODE INDIA LIMITED - Original Message - From: Amjad mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Thursday, July 11, 2002 1:43 PM Subject: RE: dblink problem ( ORA-02019 ) CREATE PUBLIC DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING 'connect_string' Regards, Amjad. www.medicomsoft.com http://www.medicomsoft.com : [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anand Kumar N - Systems Sent: Thursday, July 11, 2002 9:33 AM To: Multiple recipients of list ORACLE-L Subject: Re: dblink problem ( ORA-02019 ) Hi all, How to Create dblink, can u please explain me. bye Anand - Original Message - From: Ratnesh Kumar Singh mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 6:23 PM Subject: dblink problem ( ORA-02019 ) hi i have 3 databases(A,B,X) on 3 diff boxes. i have created 1 dblink each from A to X from B to X. The syntax for dblink creation is exactly same for both dblinks. I am able to query from dblink A-X as select * from user.table@dblinkAX mailto:user.table@dblinkAX but when i try to query from dblink B-X as select * from user.table@dblinkBX mailto:user.table@dblinkBX i get the foll error Error: ORA-02019: connection description for remote database not found When i modify my query by suffixing '.world' as select * from [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] , the query works fine. I have compared the entries in init,sqlnet,tnsnmames,listener files on both A B databases and they are absolutely similar . i was thinking that the domain or globalnames parameters might be diff on A B , but they are absolutely same . any suggestions are most welcome ... thanks in advance ratnesh --- Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/110/128/350 Ext. 2107 Home : (91 22) 8662162 http://www.patni.com http://www.patni.com World-Wide Partnerships. World-Class Solutions. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
Web application and Oracle session
Title: Web application and Oracle session Hi list ! environment : userA -connexion- userB -connexion- OAS (htp package) - 1 session -- Oracle8i (only 1 application schema) ... ... userX -connexion- A web application is accessed by many users throw OAS which use only one session to access the database. The application was never tested in multi-user context. The problem now is that the users complain against the slowness of my database (!!) I test the sql generated by the application and the response-time seems good. So, my questions are : - what's append to the Oracle Session when a user A stop his navigator with the Stop button while a user B is connected ? - is it simply a lock problem ? - is it possible to user several Oracle sessions with OAS ? - any advices or experiences are welcome : how do you manage sessions in web application context ? thankxx in advance Philippe
RE: Sun D1000 Storage Box Setup
Of the Following Supported Software Which would be the Best Choice for SOFTWARE RAID 0+1 ? VERITAS Volume Manager software, versions 2.4, 2.5, 2.5.x, and 2.6 Solstice DiskSuite[tm] software version 4.1 Sun Cluster 2.1, 2.2 software NOTE - Application Leaning MORE of OLTP in nature though some amount of Batch processing also happens Thanks indeed -Original Message- Sent: Tuesday, July 16, 2002 12:04 AM To: LazyDBA.com Discussion Vivek, Depending upon the usage of database I may take decision. Also what software are ou going to use for the raid. Veritas is good in stripping data upto a good granualarity. For a one application database I would think of optio n 1 or 2 with software like veritas with a strioung of 128K in OLTP. But for data warehous I would have RAID 1 (mirror ) and 6 volumes to strip my data manually. HTH Nirav -Original Message- Sent: Monday, July 15, 2002 3:10 AM To: LazyDBA.com Discussion Given SUN D1000 Storage Box Containing 12 Disks , For Database Layout what would be the most optimal Setup ? 1) 1 Volume Software RAID 1+0 Containing 6+6 Disks ? 2) 2 Volumes - Each Volume consisting of Software RAID 1+0 Containing 3+3 Disks 3) 3 Volumes - Each Volume consisting of Software RAID 1+0 Containing 2+2 Disks 4) Any Other Combination NOTE D1000 Storage Box :- 1) Does NOT have a Hardware RAID Controller 2) Contains HIGH PERFORMANCE JBOD ARRAY Feature: High Performance JBOD Array (D1000). Function: The D1000 has 2 UltraSCSI channels, with 4 UltraSCSI connections. The Netra st D1000 can be configured with dual 40-MB/second UltraSCSI Channels. Benefit: The servers may access the disk drives as individual storage components or may use software RAID solutions to aggregate the disk drives into bigger logical disk volumes. For more Details Check :- http://www.sun.com/storage/workgroup/a1000/details.html Thanks Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
System Administrator Appreciation Day - Friday - July 26th, 2002
ORA-00904 invalid column name and export
Hi! I'm doing export across network. Export is started on Linux server containing 8.1.7.2 enterprise edition install. Target db is 8.1.7.0 enterprise edition residing on WinNT. This is what I get at the end of export log . exporting job queues EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: Export terminated unsuccessfully What the hell is going on? Is there a way to avoid this? If there is no way, anyway I would like to know what is going on... Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: System Administrator Appreciation Day - Friday - July 26th, 2002
Where I work there is not much to appreciate. Our SA's are not good to work with, they don't play with the other kids very well. Dave -Original Message-From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 16, 2002 6:53 AMTo: Multiple recipients of list ORACLE-LSubject: System Administrator Appreciation Day - Friday - July 26th, 2002
RE: ORA-00904 invalid column name and export
Vladimir, you probably just need to rerun your catexp.sql file on the source database. Regards, Mike -Original Message- Sent: 16 July 2002 13:08 To: Multiple recipients of list ORACLE-L Hi! I'm doing export across network. Export is started on Linux server containing 8.1.7.2 enterprise edition install. Target db is 8.1.7.0 enterprise edition residing on WinNT. This is what I get at the end of export log . exporting job queues EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: Export terminated unsuccessfully What the hell is going on? Is there a way to avoid this? If there is no way, anyway I would like to know what is going on... Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Loader
BDY.RTF Description: RTF file
RE: ORA-00904 invalid column name and export
Title: RE: ORA-00904 invalid column name and export Vladimir... I'd suggest starting the export on the target, the 8.1.7.0 installation. HTH, Rich -Original Message- From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Subject: ORA-00904 invalid column name and export Hi! I'm doing export across network. Export is started on Linux server containing 8.1.7.2 enterprise edition install. Target db is 8.1.7.0 enterprise edition residing on WinNT. This is what I get at the end of export log . exporting job queues EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: Export terminated unsuccessfully What the hell is going on? Is there a way to avoid this? If there is no way, anyway I would like to know what is going on... Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sun D1000 Storage Box Setup
Of the Following Supported Software Which would be the Best Choice for SOFTWARE RAID 0+1 ? VERITAS Volume Manager software, versions 2.4, 2.5, 2.5.x, and 2.6 Solstice DiskSuite[tm] software version 4.1 Sun Cluster 2.1, 2.2 software It was a long time since I worked with thesee things. However, for software-raid (1 or 0) with D1000, I think DiskSuite would be apropiate. It is, if I recall correctly, pretty easy to setup with commandline utilities. I think it is also enclosed in Solaris 8. -- /Nils Höglund, Naqua KB E-mail: [EMAIL PROTECTED] Web:http://www.naqua.se/ Home Phone: +46 (0)18 30 09 19 Cellular Phone: +46 (0)709 91 97 65 Address:Nya Valsätrav. 26 B SE-756 46 Uppsala, Sweden -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Nils_H=F6glund?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-00904 invalid column name and export
Title: RE: ORA-00904 invalid column name and export 1. No enough space for exports... 2. All exports are on some large drive (linux box) from where exports go to the tape... 3. No f!$^% decent shell scripting available on NT... - Original Message - From: Richard Huntley To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 16, 2002 3:13 PM Subject: RE: ORA-00904 invalid column name and export Vladimir... I'd suggest starting the export on the target, the 8.1.7.0 installation. HTH, Rich -Original Message- From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Subject: ORA-00904 invalid column name and export Hi! I'm doing export across network. Export is started on Linux server containing 8.1.7.2 enterprise edition install. Target db is 8.1.7.0 enterprise edition residing on WinNT. This is what I get at the end of export log . exporting job queues EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: Export terminated unsuccessfully What the hell is going on? Is there a way to avoid this? If there is no way, anyway I would like to know what is going on... Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-00904 invalid column name and export
Title: RE: ORA-00904 invalid column name and export Have you tried the earlier suggestion that I missed (that should do it)? That is to rerun catexp.sql on the source DB. Also, if you have access to Metalink check out the following article: 132904.1 Compatibility Matrix for Export Import Between Different Oracle Versions -Original Message-From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 16, 2002 9:48 AMTo: Multiple recipients of list ORACLE-LSubject: Re: ORA-00904 invalid column name and export 1. No enough space for exports... 2. All exports are on some large drive (linux box) from where exports go to the tape... 3. No f!$^% decent shell scripting available on NT... - Original Message - From: Richard Huntley To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 16, 2002 3:13 PM Subject: RE: ORA-00904 invalid column name and export Vladimir... I'd suggest starting the export on the target, the 8.1.7.0 installation. HTH, Rich -Original Message- From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Subject: ORA-00904 invalid column name and export Hi! I'm doing export across network. Export is started on Linux server containing 8.1.7.2 enterprise edition install. Target db is 8.1.7.0 enterprise edition residing on WinNT. This is what I get at the end of export log . exporting job queues EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: Export terminated unsuccessfully What the hell is going on? Is there a way to avoid this? If there is no way, anyway I would like to know what is going on... Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: Oracle and NAS (more Q's)
We wrote our own scripts to manage consistency. They manage the following levels of backup: 1. Snapshots of datafiles at the primary location. 2. Standby database at the secondary location. 3. Tape backup of datafiles at the primary location. 4. Tape backup of datafiles at the standby location. BL How do you do backups? BL Do you use RMAN with MML? Do you use NDMP? BL Tia. [EMAIL PROTECTED] 07/16/02 08:28a.m. BL Dick, BL We're using Netapp F720's to store all our datafiles (production and BL test) in a small/medium OLTP environment and are quite happy with the BL setup. YMMV. BL We run out of two sets of collocated servers. At each collocation BL there are at least two filers and at least two servers. The filers and BL the servers currently have three 100BaseT network connections. One BL front channel and two back channels. Each LAN segment is switched. BL Thus any server at a location can connect to any filer at that BL location. Datafiles can be spread across filers or spread across BL channels as performance requires. BL The WAFL does indeed write to the nearest available inode and relinks BL the inode map. The unlinked inode is immediately available for BL rewrite unless it is a member of a snapshot. Thus while reserving BL unlinked blocks is inefficient from a storage perspective, it is a BL factor you get to control by controlling the snapshots. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: NOT IN performance problem
Select personid from person minus select personid from phonenumber Fazal --- Dennis M. Heisler [EMAIL PROTECTED] wrote: select personid from person where not exists (select '1' from phonenumber where personid = person.personid); Nils Höglund wrote: Hello, I have encountered a performance problem. I use Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production. I have two tables. phonenumber and person, each person has none, one or many phonenumbers referenced to him. The phonenumber-table is structured like: phonenumber.personid phonenumber.phonenumber The person-table is structured like: person.personid person.name person.address I wan't to know which persons that does NOT have any phonenumber(s). I can write the query as: SELECT personid FROM phonenumber WHERE personid NOT IN ( SELECT personid FROM person); However, since my tables are quite large, it takes forever to run my query. In the real database both (or atleast one) of person or phonenumber are views. To figure out who _does_ have phonenumbers is SIGNIFICANTLY faster. (SELECT DISTINCT person.personid FROM person, phonenumber WHERE person.personid=phonenumber.personid) I'm wondering how I could restructure or rewrite my query (who doesn't have any phoinenumbers?) to run faster, or if there is anything else I can do to optimize the query? Any suggestions? -- /Nils Höglund, Naqua KB E-mail: [EMAIL PROTECTED] Web:http://www.naqua.se/ Home Phone: +46 (0)18 30 09 19 Cellular Phone: +46 (0)736 51 74 58 Address:Nya Valsätrav. 26 B SE-756 46 Uppsala, Sweden -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Nils_H=F6glund?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Dennis M. Heisler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Abul Fazal Production Support Services - Quantum Leap Standard Charted Bank Singapore HP : 65-94887900 __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abul Fazal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 share your experience with RAC on linux:)
hi, dbas: We plan to setup a new database on a Linux Cluster, using Oracle 9i RAC release 2, with Dell PC Servers (4CPU, 4G memory), to store our online history data and provide read only service and some other misc applications. So, what i care is: 1. Which Oracle version to use, release 1 or release 2. Release 1 is certified on many platforms with proper hardware and os, but release 2 is relatively new. But since oracle supports new version and there is maybe less bugs , i prefer release 2 version . Can you share your opnion? 2. Which OS to choose. Suse and Redhat is the oracle prefered version. For RAC/OPS support , is suse better than redhat? Or if i choose redhat, shall i choose the redhat 7.1(the certified version with rac release 1 on Dell machine) or Redhat Advanced Server, or redhat 7.2/7.3? 3. Has anyone here used RAC in production? Especially on Linux/RAC combination? what about your experience? Please share your valuable experience here:), thanks. Good luck chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chaos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: dblink problem ( ORA-02019)
Folks, Since I recently slammed into this unexpected wall I'll pass along the experience. A couple of weeks ago I upgraded an 8.0.5.2.1 instance to 8.1.7 and subsequently at OTS's request to 8.1.7.4. To make a long story short most things with database links worked OK, but a describe across one did not (ORA-02019). The problem ended up being a small error in Oracle's INIT parameter documentation. Back in 8.0.5.2.1, due to a bug introduced, you needed to have DB_DOMAIN=.WORLD or DB_DOMAIN=.VICR.COM. Note the '.' before the domain. Well in 8.1.7, or sometime before that, they fixed the bug, but forgot about those of us who don't always follow the 'yellow brick road'. So if your having problems with ORA-02019's take a second and check this parameter in your init.ora. I changed mine the problems went away. Dick Goulet Reply Separator Author: Ratnesh Kumar Singh [EMAIL PROTECTED] Date: 7/15/2002 11:43 PM Refer to Oracle docs / oracle SQL reference / DROP ... -Original Message- N - Systems Sent: Tuesday, July 16, 2002 12:33 PM To: Multiple recipients of list ORACLE-L HI AMJAD, HOW TO DROP THE DATABASE LINK. ANAND ITW SIGNODE INDIA LIMITED - Original Message - From: Amjad To: Multiple recipients of list ORACLE-L Sent: Thursday, July 11, 2002 1:43 PM Subject: RE: dblink problem ( ORA-02019 ) CREATE PUBLIC DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING 'connect_string' Regards, Amjad. www.medicomsoft.com : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anand Kumar N - Systems Sent: Thursday, July 11, 2002 9:33 AM To: Multiple recipients of list ORACLE-L Subject: Re: dblink problem ( ORA-02019 ) Hi all, How to Create dblink, can u please explain me. bye Anand - Original Message - From: Ratnesh Kumar Singh To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 10, 2002 6:23 PM Subject: dblink problem ( ORA-02019 ) hi i have 3 databases(A,B,X) on 3 diff boxes. i have created 1 dblink each from A to X from B to X. The syntax for dblink creation is exactly same for both dblinks. I am able to query from dblink A-X as select * from user.table@dblinkAX but when i try to query from dblink B-X as select * from user.table@dblinkBX i get the foll error Error: ORA-02019: connection description for remote database not found When i modify my query by suffixing '.world' as select * from [EMAIL PROTECTED] , the query works fine. I have compared the entries in init,sqlnet,tnsnmames,listener files on both A B databases and they are absolutely similar . i was thinking that the domain or globalnames parameters might be diff on A B , but they are absolutely same . any suggestions are most welcome ... thanks in advance ratnesh --- Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/110/128/350 Ext. 2107 Home : (91 22) 8662162 http://www.patni.com World-Wide Partnerships. World-Class Solutions. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 5.50.4807.2300 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVSPAN class=378274406-16072002FONT face=Arial color=#ff size=2Refer to Oracle docs / oraclenbsp;SQL reference / DROP .../FONT/SPAN/DIV DIVSPAN class=378274406-16072002FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]BOn Behalf Of /BAnand Kumar N - SystemsBRBSent:/B Tuesday, July 16, 2002 12:33 PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B Re: dblink problem ( ORA-02019 )BRBR/FONT/DIV DIVFONT face=Century Gothic color=#80FONT size=2HI AMJAD,SPAN
RE: To create a new datafile or to increase a existing datafile.
Title: RE: To create a new datafile or to increase a existing datafile. Denham, You haven't mentioned tablespaces. If all five datafiles are for one tablespace, it doesn't matter much. However if each datafile is for a separate tablespace, it would be easier to increase the size of the existing datafiles. Otherwise you would need to move objects to take advantage of the sixth datafile. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Denham Eva [SMTP:[EMAIL PROTECTED]] Hello Gurus Which is the better policy: Say you have five datafiles of 1GB in size each, now the total freespace is less than 10%. Would it be wise to increase the datafiles to 2GB or would it be better for the system to add a sixth datafile? Would appreciate any views on this point. Rgds Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot.
RE: Oracle on Linux ... Production Strength ???
The kicker with Oracle's certified Linux platforms/versions is if you run into problems on a non-certified dist and try and get support on a problem that has nothing to do with what dist or version you're on (like errors in a shell script in OiD), they won't touch it and won't mark it as a bug to send to development. Hell, Support didn't even have a Linux box to verify my claims! Apparently, they do now. Another quirk is that you can install RH7.1 and upgrade everything else (kernel, libs, desktop, etc.) independently to bring it up to RH7.3 or whatever, and it'll still be supported. Go figure. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: James J. Morrow [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 14, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle on Linux ... Production Strength ??? Christopher Royce wrote: Need Input: I would like to solicit real life experiences, educated opinions, accolades and criticisms from those of you who have implemented or are considering implementing Oracle on Linux in a business critical production environment. We are considering both Red Hat and Suse distributions. We have discovered that regardless of the Linux distribution support is generally expensive. That is not a particularly 'deal breaker' determining factor .. BUT .. I question the quality of support, the expediency of response and the 'sense of urgency' experienced in the event of a critical application being down. I am familiar with limited Oracle-Linux implementations but not to the 'industrial strength' degree that has been proposed (but already implemented) by our requesting user community. Is there a preferred distribution We already have Red Hat and Suse implementations and will choose one of them as the standard 'should we chose to accept this mission'. I believe that both claim to be the preferred distribution by Oracle and that they are 'tier one ports' As for Linux distributions? While Linux is Linux (mostly), you will probably have fewer problems listening to Oracle's recommendation than trying to go it alone using another distro. The reason I say that is, when Oracle tells you that Oracle 8.X or 9.X is certified on RedHat 7.X they mean that, for the most part, if you install *THAT* distro of Linux, you should be able to successfully install Oracle on it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: To create a new data file or to increase a existing data file
We have a standard data file size of 2GB, If it is smaller (for some reason) we extend it but never 2GB. If it is already 2GB, we add a new data file. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Tuesday, July 16, 2002 10:53 AM To: Multiple recipients of list ORACLE-L Denham, You haven't mentioned tablespaces. If all five datafiles are for one tablespace, it doesn't matter much. However if each datafile is for a separate tablespace, it would be easier to increase the size of the existing datafiles. Otherwise you would need to move objects to take advantage of the sixth datafile. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- Hello Gurus Which is the better policy: Say you have five datafiles of 1GB in size each, now the total freespace is less than 10%. Would it be wise to increase the datafiles to 2GB or would it be better for the system to add a sixth datafile? Would appreciate any views on this point. Rgds Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. *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: ORA-00904 invalid column name and export
Vladimir: There is a known problem with this error after applying patchset 8.1.7.2.1 (The fix is supposed to be re-running catalog and catexp). If you're still having problems, do a full export from the db on Linux to the null device. If you still get the error, then you know for sure it's on the Linux side. Good luck! Barb -- From: Vladimir Barac - posao[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 6:08 AM To: Multiple recipients of list ORACLE-L Subject: ORA-00904 invalid column name and export Hi! I'm doing export across network. Export is started on Linux server containing 8.1.7.2 enterprise edition install. Target db is 8.1.7.0 enterprise edition residing on WinNT. This is what I get at the end of export log . exporting job queues EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: Export terminated unsuccessfully What the hell is going on? Is there a way to avoid this? If there is no way, anyway I would like to know what is going on... Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Storage of numeric data
We have an mechanical CAD application where we will be storing values like bolt diameter and hole sizes. As far as I know, these numbers will not be used in any computations, but it is important the the number retrieved be exactly what was put in. For example, if they put in 0.086 the should not get out 0.08599). If I use a format like number(4,3), will this give me the result that I want or should I use char(5)? thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
v$sort_usage
Hi, Could someone shed some light on how v$sort_usage is populated? It is supposed to show active sorts in the database. If that is the case then I don't understand why I see the following: 1. An entry exists for a user/sort, yet according to v$session the session is NOT active. 2. Multiple entries exist for a user with the SAME session_addr. I don't understand how a session could have multiple sort segments. As always, you're feedback is appreciated. Thanks. -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Storage of numeric data
Title: RE: Storage of numeric data If you specifically want precision and scale and you know the data entered should be numeric I would make it numeric. -Original Message- From: Schauss, Peter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Subject: Storage of numeric data We have an mechanical CAD application where we will be storing values like bolt diameter and hole sizes. As far as I know, these numbers will not be used in any computations, but it is important the the number retrieved be exactly what was put in. For example, if they put in 0.086 the should not get out 0.08599). If I use a format like number(4,3), will this give me the result that I want or should I use char(5)? thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: To create a new data file or to increase a existing data
My rule of thumb is 2gb or less for smaller databases, i.e. 100gb and adjust higher for larger databases, e.g. 10gb datafiles for 1.3 tb database. gene [EMAIL PROTECTED] 07/16/02 11:28AM We have a standard data file size of 2GB, If it is smaller (for some reason) we extend it but never 2GB. If it is already 2GB, we add a new data file. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Tuesday, July 16, 2002 10:53 AM To: Multiple recipients of list ORACLE-L Denham, You haven't mentioned tablespaces. If all five datafiles are for one tablespace, it doesn't matter much. However if each datafile is for a separate tablespace, it would be easier to increase the size of the existing datafiles. Otherwise you would need to move objects to take advantage of the sixth datafile. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- Hello Gurus Which is the better policy: Say you have five datafiles of 1GB in size each, now the total freespace is less than 10%. Would it be wise to increase the datafiles to 2GB or would it be better for the system to add a sixth datafile? Would appreciate any views on this point. Rgds Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do I check whether a rollback activity is going on
Jared, I agree with you, except for when MTS is being used. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 - unix vs linux vs windows - the future
Wow Joe, sounds like a religious conviction... I'm impressed because I'm of the same persuasion but I'm not quite so pious/zealous and am still somewhat enslaved to the M$ beast/devil because of the company usage of Exchange with MS Outlook for Calendar and workflow. I run Linux on the laptop via VMWare but because of the Outlook dependency, running Pine, Mozilla or whatever is not a viable email solution for me. Sigh... Having run Oracle/Linux servers in production for over a year now I conclude that the platform is not just viable but is promising. Unix, Linux, and Windows are part the present with significant installed bases so that also means they will be part of the future. How long that future will be and how much future presence there will be is anybody's guess I guess. Good and Evil abound. :-) Steve Orr -Original Message- Sent: Monday, July 15, 2002 6:43 PM To: Multiple recipients of list ORACLE-L Thats were you're wrong, i dont use microsoft products, all of my development and presentations that i make are non microsoft products. for IOUG presentations, requirement is to put them in msword and powerpoint, i convert from star office to those formatrs and have someone proof them so i know the conversion went ok. so NO I DONT PIRATE software, dont need to since all that i run is free. And yes feel free to look at the headers of this email, its from mozilla on linux. :) selling my IT manager is easy on linux, since I'm the CTO of Data Management Consulting, and selling using linux for development is just as easy at client sites. Outradeious prices absolutely but everywhere i've been they've already had oracle in-house so there was no selling to do. joe ltiu wrote: Oracle. It's only free during development/education. Charges will be exhorbitant when getting production licenses. Windows and SQL Server is free too - if you pirate, right? It's what every one does : Linux is free but trying to sell this to your IT manager is not. On Sunday 14 July 2002 12:43, Joe Testa wrote: I dont think the classic unix that you speak of will go away that fast, too many solaris/aix/hpux machines floating around still. I do any development/testing of features on linux, it cost me nothing but the hardware. RH 7.3 downloaded, no cost. technet member 9ir2 oracle downloaded, no cost. it only makes sense. joe Andrey Bronfin wrote: hi ! i might start another war , but i can't resist a part of me which wants to ask : what do you , seasoned gurus, think of everybody's (as it seems to be) plans to abandon the classic unix for linux ? In particular , most database vendors (as well as other enterprise software vendors) name linux as the future #1 platform for their DBs (especially given the fact that a DB cluster is not rare any more). It also looks like many development shops shift their efforts to develop on windows (or , in some rare cases, linux ) instead of unix . What do you think about this ? DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Storage of numeric data
Use VARCHAR2 and don't worry about it. :-) JP On Tuesday 16 July 2002 17:48, you wrote: We have an mechanical CAD application where we will be storing values like bolt diameter and hole sizes. As far as I know, these numbers will not be used in any computations, but it is important the the number retrieved be exactly what was put in. For example, if they put in 0.086 the should not get out 0.08599). If I use a format like number(4,3), will this give me the result that I want or should I use char(5)? thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:Storage of numeric data
Peter, For numeric data where you can't exactly define the size precision use a plain old number data type. It's the equivalent of float or double. I do not allow numeric data to be stored in a char or varchar field because someone sooner or later is going to slide the following into the database where field_name = 0.086 which is equivalent to where to_number(field_name) = 0.086. The bad point here is that the index I'll be asked to create is now useless. Dick Goulet Reply Separator Author: Schauss; Peter [EMAIL PROTECTED] Date: 7/16/2002 7:48 AM We have an mechanical CAD application where we will be storing values like bolt diameter and hole sizes. As far as I know, these numbers will not be used in any computations, but it is important the the number retrieved be exactly what was put in. For example, if they put in 0.086 the should not get out 0.08599). If I use a format like number(4,3), will this give me the result that I want or should I use char(5)? thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Storage of numeric data
Peter, You will get out whatever you put in with just regular NUMBER type. Format like number(4,3) only controls/constraints the number you write into this column. You could use it, if you know in advance that you will never try to write bigger numbers, or with more significant digits, or you want to limit numbers written into the column to this format and get error message otherwise. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 11:48 AM We have an mechanical CAD application where we will be storing values like bolt diameter and hole sizes. As far as I know, these numbers will not be used in any computations, but it is important the the number retrieved be exactly what was put in. For example, if they put in 0.086 the should not get out 0.08599). If I use a format like number(4,3), will this give me the result that I want or should I use char(5)? thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Storage of numeric data
Dick, Thanks for the feedback. At this point it appears that I can hold the users to a predefined size and precision. Does Oracle store fixed point numbers in such a way that you get back exactly what you entered? Thanks, Peter Schauss -Original Message- Sent: Tuesday, July 16, 2002 11:08 AM To: Schauss, Peter; Multiple recipients of list ORACLE-L Peter, For numeric data where you can't exactly define the size precision use a plain old number data type. It's the equivalent of float or double. I do not allow numeric data to be stored in a char or varchar field because someone sooner or later is going to slide the following into the database where field_name = 0.086 which is equivalent to where to_number(field_name) = 0.086. The bad point here is that the index I'll be asked to create is now useless. Dick Goulet Reply Separator Author: Schauss; Peter [EMAIL PROTECTED] Date: 7/16/2002 7:48 AM We have an mechanical CAD application where we will be storing values like bolt diameter and hole sizes. As far as I know, these numbers will not be used in any computations, but it is important the the number retrieved be exactly what was put in. For example, if they put in 0.086 the should not get out 0.08599). If I use a format like number(4,3), will this give me the result that I want or should I use char(5)? thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do I check whether a rollback activity is going on
Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 questions
Thanks Don, Your explanation is very helpful. --- Don Granaman [EMAIL PROTECTED] wrote: Bitmapped indexes will be fast for the queryagainst the 'Y's, but a bitmapped index may not be appropriate if you are getting lots of DML activity on this. Another option is to use NULL instead of the vast majority value ('N' - in this case) and create an index. The nulls won't be indexed, so the index will be small. This works best when there are relatively few non-majority values and they are the ones most critically/commonly queried. A hint MAY be required to make the CBO use the index. This obviousy won't help on queries against 'N' though. Example, ORDERS table with a STATUS column - 98% 'Closed', 2% ('New' | 'Pending' | 'Whatever...'). Change the logical to interprete NULL as 'Closed' and create an index on ORDERS.STATUS. Queries for open orders - ('Closed' | 'Pending' | 'Whatever...') become very fast. Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 15, 2002 2:58 PM If we have a column of 'Y','N' values, the index will not help with CBT(usually most of the values are 'N'). My question is : how about bitmap indexes? Should it help a lot, or just a little bit? Thanks, Chris Harvest __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Storage of numeric data
Nothing wrong using Oracle data type number. It's perfect for this kind of usage. Regards, Waleed -Original Message- Sent: Tuesday, July 16, 2002 11:48 AM To: Multiple recipients of list ORACLE-L We have an mechanical CAD application where we will be storing values like bolt diameter and hole sizes. As far as I know, these numbers will not be used in any computations, but it is important the the number retrieved be exactly what was put in. For example, if they put in 0.086 the should not get out 0.08599). If I use a format like number(4,3), will this give me the result that I want or should I use char(5)? thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 - unix vs linux vs windows - the future
-- Orr, Steve [EMAIL PROTECTED] on 07/16/02 08:09:23 -0800 I'm impressed because I'm of the same persuasion but I'm not quite so pious/zealous and am still somewhat enslaved to the M$ beast/devil because of the company usage of Exchange with MS Outlook for Calendar and workflow. I run Linux on the laptop via VMWare but because of the Outlook dependency, running Pine, Mozilla or whatever is not a viable email solution for me. Sigh... Try it the other way around and you get better performance: run VMWare on linux w/ W2K on the VM. Linux does a better job at multi-tasking and samba works wonderfully for file sharing. Add in a touch of portforwarding and a dash of NAT and it comes out fairly tasty.. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd/2)
Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play? And if he really did have insider info, and was acting unethically, why not sell more shares? The amount he sold was probably less than 5% of his holdings. I don't mean to defend ceo misconduct, corporate fraud, etc, I just think you need look this particular accusation a little more objectively, especially when you consider its source. I have great respect for McCain's war record and heroism, but now he is a politician, a Senator no less. IMHO, one can't take anything any politician says at face value. Given a choice between honesty and self-promotion, I'm afraid politicians too often choose the latter. And without getting into specifics about McCain, he seems to be second in the Senate only to my own Sen. Schumer in his love of getting on TV (Q: What's the most dangerous place in NY? A: Between Chuck Schumer and a TV camera). Larry makes a convenient and easy target, someone a politician knows he can attack, get a good soundbite, and have very little chance of being challenged. Gary -Original Message- Sent: Tuesday, July 16, 2002 1:13 AM To: Multiple recipients of list ORACLE-L trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From: Johnson, M=2E | Date: Mon, 15 Jul 2002 10:23:21 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: RE: McCain on Larry Ellison and Corporate Responsibility / Re: = OT | Not defending Ellison for anything,=20 Understood | but it appears | McCain is just another politician who is only interested | in his future and he constantly takes on these reform | ideas and just makes the matter worse That sounds really cynical to me. Are you just speculating, or do you have any info to back that up? Note that Oracle/Ellison attempted to buy off politicians here in Sacramento in order to stop the JLAC (legislative) audit of Oracle's ELA with the State of California Note that Senator Sarbanes was on the same TV program (Meet the Press) as McCain, and generally agreed with McCain that there is a horrible lack of corporate responsibility, and that reforming the institutions designed to protect the public's interests has been made extremely difficult by the influence of corrupt lobbyists and lack of effective campaign reform Tim Russert (a rare TV journalist with some integrity) and the Senators spent most of their time discussing the issue of putting executive stock options on the expense sheets so as to more correctly reflect profitability (or lack thereof) Do you think it better serves the investment community for sleazy corrupt executives to be able to hide their shenanighans from analysts and investors? | Everyone should accept the fact that we are in a bear | market and as such all the boats go down Argh, that is the problem, when you have these outrageous examples of greedy, corrupt corporate executives cashing out (***AFTER COOKING THE BOOKS***), leaving others to sink | Everyone should have been smart enough to sell stocks and | put their money into cash or better yet short stocks | when it was very clear that in the Fall of 2000 after the | initial March 2000 sell off that we were going into | a prolonged Bear market Should have been !?!?! That isn't really the issue. As mentioned above, the issue was how excess greed played out when the books were cooked to create a false impression of profitability | Ellison probably took the money and ran when this | became apparent to him and many others. I know I did. So (regardless of whether Ellison is a good example, or not), do you think that there should be *any* accountability for the social damage caused by greed driven unethical accounting practices? (fwiw, I'm sympathetic to libertarian/Chicago school free market ideology, but I fear that like its opposite, leftist utopianism, when taken to extremes, it doesn't work all that well in the real world.) regards, ep -Original Message- Sent: Monday, July 15, 2002 5:53 AM To: Multiple recipients of list ORACLE-L OT - unix My understanding is that this was the very first time Ellison had ever sol= d Oracle stock, in over 25 years of the company's existence, in 2000, which = is the occasion that McCain (and you) are referring to=2E As you might be aw= are, there was a far greater opportunity for Ellison to cash out and leave Oracle dangling in 1990, when the price dropped from around $20 to $6 almo= st overnight after some financial-earning restatements=2E On that occasion, = he would certainly have had prior knowledge of what was
Fwd:Ecora - SQL, IIS versions now available
Did anyone else on the list get spammed by this other than me? Dick Goulet Forward Header_ Author: Brett Bingham [EMAIL PROTECTED] Date: 7/16/2002 12:09 PM Hi Dick: Ecora has finally released the Microsoft IIS version of our Configuration Auditor! And, we have the beta versions of MS SQL, and HP-UX Configuration Auditors available as well. Ecora's software tools audit and produce config reports, change reports, and baseline compliance docs for your IT Enterprise. The software also creates D-R documentation in 4 formats, including Visio. For a free, 15-day trial of the IIS Configuration Auditor: https://www.ecora.com/ecora/products/iis/auditor.asp What the IIS Tool tracks and reports: http://www.ecora.com/ecora/products/iis/documented.asp In addition to our 9 other Config. Auditors, these 3 new platforms help to shore-up the undocumented and unreported areas within your IT infrastructure. Please contact me for more information. Or, for a Beta copy of the MS SQL and HP-UX Config Auditors, please send an email to [EMAIL PROTECTED]. Thanks, -Brett. Brett M. Bingham Ecora Software Free D-R and Security Webinars: http://www.ecora.com/ecora/webinar p: 603-334-3174 f: 603-436-1604 e: [EMAIL PROTECTED] Product Presentation: http://www.ecora.com/ecora/flashdemo.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBMS_JOB interval wierdness
Hey all, I've got a job to gather stats on a schema of an 8.1.6.0.0 DB. The interval of the DBMS_JOB is: TRUNC(SYSDATE)+7+1/24 ...but it keeps resubmitting itself every day, instead of once a week. I *must* be brain dead or this cold's getting the best of me, because I just can't see what I'm missing. Anyone? Bueller? Bueller? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Storage of numeric data
Peter, Yes whatever you put in will be what is returned. I've got about 105 million examples of that to boot. And although today you can hold the users to a specific size, what does tomorrow hold? For the small additional price you'll pay I'd go with a straight number. Dick Goulet Reply Separator Author: Schauss; Peter [EMAIL PROTECTED] Date: 7/16/2002 8:28 AM Dick, Thanks for the feedback. At this point it appears that I can hold the users to a predefined size and precision. Does Oracle store fixed point numbers in such a way that you get back exactly what you entered? Thanks, Peter Schauss -Original Message- Sent: Tuesday, July 16, 2002 11:08 AM To: Schauss, Peter; Multiple recipients of list ORACLE-L Peter, For numeric data where you can't exactly define the size precision use a plain old number data type. It's the equivalent of float or double. I do not allow numeric data to be stored in a char or varchar field because someone sooner or later is going to slide the following into the database where field_name = 0.086 which is equivalent to where to_number(field_name) = 0.086. The bad point here is that the index I'll be asked to create is now useless. Dick Goulet Reply Separator Author: Schauss; Peter [EMAIL PROTECTED] Date: 7/16/2002 7:48 AM We have an mechanical CAD application where we will be storing values like bolt diameter and hole sizes. As far as I know, these numbers will not be used in any computations, but it is important the the number retrieved be exactly what was put in. For example, if they put in 0.086 the should not get out 0.08599). If I use a format like number(4,3), will this give me the result that I want or should I use char(5)? thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
!! Msg From List Owner - Virus !!
Yes, intrepid listers, our fair list was infected by an insidious virus! Due to the outstanding efforts of our benefactor ( Bruce Bergman, mild mannered developer by day, mighty ISP warrior when terror strikes! ) you may once again freely roam the nether regions of Gotham. The Damagement...er... I mean 'Management' Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Storage of numeric data
Yes it does. -Original Message- Sent: Tuesday, July 16, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Dick, Thanks for the feedback. At this point it appears that I can hold the users to a predefined size and precision. Does Oracle store fixed point numbers in such a way that you get back exactly what you entered? Thanks, Peter Schauss -Original Message- Sent: Tuesday, July 16, 2002 11:08 AM To: Schauss, Peter; Multiple recipients of list ORACLE-L Peter, For numeric data where you can't exactly define the size precision use a plain old number data type. It's the equivalent of float or double. I do not allow numeric data to be stored in a char or varchar field because someone sooner or later is going to slide the following into the database where field_name = 0.086 which is equivalent to where to_number(field_name) = 0.086. The bad point here is that the index I'll be asked to create is now useless. Dick Goulet Reply Separator Author: Schauss; Peter [EMAIL PROTECTED] Date: 7/16/2002 7:48 AM We have an mechanical CAD application where we will be storing values like bolt diameter and hole sizes. As far as I know, these numbers will not be used in any computations, but it is important the the number retrieved be exactly what was put in. For example, if they put in 0.086 the should not get out 0.08599). If I use a format like number(4,3), will this give me the result that I want or should I use char(5)? thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Modelling problem
Hi list I'm predicting a more philosophical discussion about how to model stuff arising at work. So I thought it might be a good idea to gather some pros and cons beforehand (Always good to have some ammunition;). The problem is about how to deal with look up tables and domain codes. Aproach a) Have one big table containing all possible domain types (like gender, account type, organizational unit etc.) and one even bigger table containing all the possible values for those domain types. The tables that use these types actually reference the value they should contain. Aproach b) Have standard look up tables for everything, for example have a table like organizational unit, which will be referenced by tables like employee via foreign key to link to the unit the emp. actually works for at this moment. I feel more comfortable about aproach b. Now people might say Why ? and I might say Normalization ?! and they might say What's that good for if aproach is much easier to implement and blahblah. Any ideas regarding pros and cons for both aproaches ? Regards and TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 - unix vs linux vs windows - the future
Forwarded from a co-worker: First the Germans, now the Nordes! http://www.theinquirer.net/?article=4406 I'll save my political diatribe of US vs MS for the OT list... :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd/2)
(test, posting from www.mail2web.com) Gary, Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. regards, ep Original Message: - Date: Tue, 16 Jul 2002 08:53:34 -0800 To: [EMAIL PROTECTED] Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play? And if he really did have insider info, and was acting unethically, why not sell more shares? The amount he sold was probably less than 5% of his holdings. I don't mean to defend ceo misconduct, corporate fraud, etc, I just think you need look this particular accusation a little more objectively, especially when you consider its source. I have great respect for McCain's war record and heroism, but now he is a politician, a Senator no less. IMHO, one can't take anything any politician says at face value. Given a choice between honesty and self-promotion, I'm afraid politicians too often choose the latter. And without getting into specifics about McCain, he seems to be second in the Senate only to my own Sen. Schumer in his love of getting on TV (Q: What's the most dangerous place in NY? A: Between Chuck Schumer and a TV camera). Larry makes a convenient and easy target, someone a politician knows he can attack, get a good soundbite, and have very little chance of being challenged. Gary -Original Message- Sent: Tuesday, July 16, 2002 1:13 AM To: Multiple recipients of list ORACLE-L trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From: Johnson, M=2E | Date: Mon, 15 Jul 2002 10:23:21 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: RE: McCain on Larry Ellison and Corporate Responsibility / Re: = OT | Not defending Ellison for anything,=20 Understood | but it appears | McCain is just another politician who is only interested | in his future and he constantly takes on these reform | ideas and just makes the matter worse That sounds really cynical to me. Are you just speculating, or do you have any info to back that up? Note that Oracle/Ellison attempted to buy off politicians here in Sacramento in order to stop the JLAC (legislative) audit of Oracle's ELA with the State of California Note that Senator Sarbanes was on the same TV program (Meet the Press) as McCain, and generally agreed with McCain that there is a horrible lack of corporate responsibility, and that reforming the institutions designed to protect the public's interests has been made extremely difficult by the influence of corrupt lobbyists and lack of effective campaign reform Tim Russert (a rare TV journalist with some integrity) and the Senators spent most of their time discussing the issue of putting executive stock options on the expense sheets so as to more correctly reflect profitability (or lack thereof) Do you think it better serves the investment community for sleazy corrupt executives to be able to hide their shenanighans from analysts and investors? | Everyone should accept the fact that we are in a bear | market and as such all the boats go down Argh, that is the problem, when you have these outrageous examples of greedy, corrupt corporate executives cashing out (***AFTER COOKING THE BOOKS***), leaving others to sink | Everyone should have been smart enough to sell stocks and | put their money into cash or better yet short stocks | when it was very clear that in the Fall of 2000 after the | initial March 2000 sell off that we were going into | a prolonged Bear market Should have been !?!?! That isn't really the issue. As mentioned above, the issue was how excess greed played out when the books were cooked to create a false impression of profitability | Ellison probably took the money and ran when this | became apparent to him and many others. I know I did. So (regardless of whether Ellison is a good example, or not), do you think that there should be *any* accountability for the social damage caused by greed driven unethical accounting practices? (fwiw, I'm sympathetic to libertarian/Chicago school free market ideology, but I fear that like its
RE: !! Msg From List Owner - Virus !!
I have been away. What type of virus? I am still having trouble. -Original Message- [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Yes, intrepid listers, our fair list was infected by an insidious virus! Due to the outstanding efforts of our benefactor ( Bruce Bergman, mild mannered developer by day, mighty ISP warrior when terror strikes! ) you may once again freely roam the nether regions of Gotham. The Damagement...er... I mean 'Management' Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Using Old version of SQL Navigator 2.0.d with Oracle 9i.
I have an OLD version of SQL Navigator 2.0.d, which was compatible with Oracle 7.3.4. But now I have Oracle 9i installed, but I do not have client for Oracle 7.3.4. Is there is a way out that I can connect to Oracle using this SQL navigator. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharminder Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:DBMS_JOB interval wierdness
Jesse, No joke, let me guess, 8am every day, right? Try TRUNC(SYSDATE+7)+1/24 instead. Dick Goulet Reply Separator Author: Jesse; Rich [EMAIL PROTECTED] Date: 7/16/2002 9:08 AM Hey all, I've got a job to gather stats on a schema of an 8.1.6.0.0 DB. The interval of the DBMS_JOB is: TRUNC(SYSDATE)+7+1/24 ...but it keeps resubmitting itself every day, instead of once a week. I *must* be brain dead or this cold's getting the best of me, because I just can't see what I'm missing. Anyone? Bueller? Bueller? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Your password! It's S New Worm W32/Frethem.K@mm
Using Win2000Pro, McAfee AV and Pegasus Mail (http://www.pmail.com/overviews/ovw_winpmail.htm), there is no problem. There is a registry hack (documented on the MS KB) that turns Outlook XP into a plain text only emailer. From a guy I know that is MS security obsessive: ---excerpt--- | Outlook can also be tamed by ZoneAlarm Pro. I limit Outlook's access | strictly to ports 25 and 110 so it can't browse Web pages. Preview pane | is turned off in the Inbox but the three-line display mode is more | useful anyway. | | This is the registry fix that does the magic. It requires Office XP/SP1 | to be installed: | | REGEDIT4 | [HKEY_CURRENT_USER\Software\Microsoft\Office \10.0\Outlook\Options\Mail] ReadAsPlain=dword:0001 | | I don't know why they didn't simply put it under Tools/Options in the | menu system. ... ---end--- The problem of course is that many M$-weenie users don't know how to make their system resistant to virii, not that it can't be done fairly easily. Those kind of people are obviously not going suffer through installing linux either. regards, ep On 15 Jul 2002 at 14:25, Joe Testa wrote: gotta love it, linux says save to disk? bwahahaha, all ou m$ weenies, vulnerable again. MacGregor, Ian A. wrote: ... Here is a quote from the CIAC Heads-Up on this latest worm ... There are reports this morning of DOE sites being hit by the W32/Frethem.K@mm worm. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do I check whether a rollback activity is going on
Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do I check whether a rollback activity is going on
IRC, evn with MTS, a busy session should have the PID of the shared server associated with it in v$process, and only one session at a time can use the shared server. Killing it should effect only the session using the SS at that time, and MTS should spawn another. Nonetheless, I don't recommend doing it. :) Jared Sherman, Paul R. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I agree with you, except for when MTS is being used. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd/2)
A new boat, Ferrari, Mig fighter jet, mansion, maybe some Japanese art... the man has some serious expenses. Seriously, I know that Oracle had a problem with shady accounting practices many years ago (late 80's, if I recall correctly). Their stock took a huge hit, and they cleaned up their act. As a result, I think that they have been very conservative in there accounting practices ever since, and have not heard any accusations of untoward accounting practices since them. I admit that I know almost nothing about accounting. Still, I think it the height of hypocrisy for politicians to accuse anyone of shady accounting practices, when, as I understand, the federal govt itself doesn't abide by the Generally Accepted Accounting Principles to which corporations are expected to adhere. All the Worldcoms and Enrons added together don't equal the tax dollars flushed down the toilet due to govt waste, corruption, fraud and incompetence. As an example: http://freedom.house.gov/wastewatch/education.asp Having ceo's sign off on their company's books seems sensible enough. I suspect that when the hot air coming from DC blows over, the investigations will prove that existing laws have been broken, and there will be criminal convictions. Most people don't want to wait for investigations to run their course, and politicians pander to this lack of attention span with by pontificating on TV, then passing more laws, which at best are probably redundant, and at worst have unintended side-effects. The politicians, especially Democrats, have also successfully exploited class-envy with their screw-the-rich-we'll protect-the-little-guy act. It usually works well for them, so they take advantage of it at every opportunity. Gary -Original Message- Sent: Tuesday, July 16, 2002 12:30 PM To: [EMAIL PROTECTED]; Kirsh, Gary (test, posting from www.mail2web.com) Gary, Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. regards, ep Original Message: - Date: Tue, 16 Jul 2002 08:53:34 -0800 To: [EMAIL PROTECTED] Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play? And if he really did have insider info, and was acting unethically, why not sell more shares? The amount he sold was probably less than 5% of his holdings. I don't mean to defend ceo misconduct, corporate fraud, etc, I just think you need look this particular accusation a little more objectively, especially when you consider its source. I have great respect for McCain's war record and heroism, but now he is a politician, a Senator no less. IMHO, one can't take anything any politician says at face value. Given a choice between honesty and self-promotion, I'm afraid politicians too often choose the latter. And without getting into specifics about McCain, he seems to be second in the Senate only to my own Sen. Schumer in his love of getting on TV (Q: What's the most dangerous place in NY? A: Between Chuck Schumer and a TV camera). Larry makes a convenient and easy target, someone a politician knows he can attack, get a good soundbite, and have very little chance of being challenged. Gary -Original Message- Sent: Tuesday, July 16, 2002 1:13 AM To: Multiple recipients of list ORACLE-L trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From: Johnson, M=2E | Date: Mon, 15 Jul 2002 10:23:21 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: RE: McCain on Larry Ellison and Corporate Responsibility / Re: = OT | Not defending Ellison for anything,=20 Understood | but it appears | McCain is just another politician who is only interested | in his future and he constantly takes on these reform | ideas and just makes the matter worse That sounds really cynical to me. Are you just speculating, or do you have any info to back that up? Note that Oracle/Ellison attempted to buy off politicians here in Sacramento in order to stop the JLAC (legislative) audit of Oracle's ELA with the State of California Note that Senator Sarbanes was on the same TV program
RE: DBMS_JOB interval wierdness
Nope. 1 PM just like it should, only every day instead of every week. I've tried it with the 7 in and out of the TRUNC with the same results. One other thing I just noticed is that the job returns an error each time it is run due to bug in DBMS_STATS. I'm rectifying that now with trapping and an error table, but I'm still confused as to why it would resub in a day instead of the interval. Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 11:31 AM To: Jesse, Rich; Multiple recipients of list ORACLE-L Subject: Re:DBMS_JOB interval wierdness Jesse, No joke, let me guess, 8am every day, right? Try TRUNC(SYSDATE+7)+1/24 instead. Dick Goulet Reply Separator Subject:DBMS_JOB interval wierdness Author: Jesse; Rich [EMAIL PROTECTED] Date: 7/16/2002 9:08 AM Hey all, I've got a job to gather stats on a schema of an 8.1.6.0.0 DB. The interval of the DBMS_JOB is: TRUNC(SYSDATE)+7+1/24 ...but it keeps resubmitting itself every day, instead of once a week. I *must* be brain dead or this cold's getting the best of me, because I just can't see what I'm missing. Anyone? Bueller? Bueller? Rich Jesse -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do I check whether a rollback activity is going on
I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmmcan you say mutating thread...) --- [EMAIL PROTECTED] wrote: Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from
delete from table question
Hi All - I am trying to delete from a table that has 24 child tables. Because the constraints are not 'cascade delete', I am hitting the following: ORA-02292: integrity constraint (NVALET.FK_TOPOGROUPMEMBERNE2) violated - child record found If I want to go ahead and delete the child records as well, there seem to be 2 options: 1. Write a sql/plsql procedure to delete the child records first before each deleting each record from the parent table. 2. Recreate the constraints with 'cascade delete' and delete the records from parent table. After that recreate the constraints again without cascade delete. Either option requires some work. Does anybody have a better idea? Also can anybody have a script to recreate all constraints to share? TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd/2)
Not sure about cash for a new boat , but I'm sure read, that Ellison is getting his CEO salary in company stocks (not in cash). This could explain, him selling stocks, though 700,000,000 seems little high. The other point is, that Oracle stock didn't drop overnight - it was going down gradually (along with the rest of the market) for last two years. And, no I'm not Larry's defender, just don't like politicians even more. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 1:33 PM (test, posting from www.mail2web.com) Gary, Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. regards, ep Original Message: - Date: Tue, 16 Jul 2002 08:53:34 -0800 To: [EMAIL PROTECTED] Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play? And if he really did have insider info, and was acting unethically, why not sell more shares? The amount he sold was probably less than 5% of his holdings. I don't mean to defend ceo misconduct, corporate fraud, etc, I just think you need look this particular accusation a little more objectively, especially when you consider its source. I have great respect for McCain's war record and heroism, but now he is a politician, a Senator no less. IMHO, one can't take anything any politician says at face value. Given a choice between honesty and self-promotion, I'm afraid politicians too often choose the latter. And without getting into specifics about McCain, he seems to be second in the Senate only to my own Sen. Schumer in his love of getting on TV (Q: What's the most dangerous place in NY? A: Between Chuck Schumer and a TV camera). Larry makes a convenient and easy target, someone a politician knows he can attack, get a good soundbite, and have very little chance of being challenged. Gary -Original Message- Sent: Tuesday, July 16, 2002 1:13 AM To: Multiple recipients of list ORACLE-L trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From: Johnson, M=2E | Date: Mon, 15 Jul 2002 10:23:21 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: RE: McCain on Larry Ellison and Corporate Responsibility / Re: = OT | Not defending Ellison for anything,=20 Understood | but it appears | McCain is just another politician who is only interested | in his future and he constantly takes on these reform | ideas and just makes the matter worse That sounds really cynical to me. Are you just speculating, or do you have any info to back that up? Note that Oracle/Ellison attempted to buy off politicians here in Sacramento in order to stop the JLAC (legislative) audit of Oracle's ELA with the State of California Note that Senator Sarbanes was on the same TV program (Meet the Press) as McCain, and generally agreed with McCain that there is a horrible lack of corporate responsibility, and that reforming the institutions designed to protect the public's interests has been made extremely difficult by the influence of corrupt lobbyists and lack of effective campaign reform Tim Russert (a rare TV journalist with some integrity) and the Senators spent most of their time discussing the issue of putting executive stock options on the expense sheets so as to more correctly reflect profitability (or lack thereof) Do you think it better serves the investment community for sleazy corrupt executives to be able to hide their shenanighans from analysts and investors? | Everyone should accept the fact that we are in a bear | market and as such all the boats go down Argh, that is the problem, when you have these outrageous examples of greedy, corrupt corporate executives cashing out (***AFTER COOKING THE BOOKS***), leaving others to sink | Everyone should have been smart enough to sell stocks and | put their money into cash or better yet short stocks | when it was very clear that in the Fall of 2000 after the | initial March 2000 sell off that we were going into | a prolonged Bear market Should have been
RE: DBMS_JOB interval wierdness
When the job aborts, it increments the failures column (until it hits the broken point at 16 failures) and resubmits itself with an internally calculated restart time. From the Oracle Administrators Guide: If a job returns an error while Oracle is attempting to execute it, Oracle tries to execute it again. The first attempt is made after one minute, the second attempt after two minutes, the third after four minutes, and so on, with the interval doubling between each attempt. When the retry interval exceeds the execution interval, Oracle continues to retry the job at the normal execution interval. However, if the job fails 16 times, Oracle automatically marks the job as broken and no longer tries to execute it. Works that way here. I can't say why yours reruns every day at 1PM. I can say that if you trap the error and get a normal completion, your problem is solved. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 16, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Nope. 1 PM just like it should, only every day instead of every week. I've tried it with the 7 in and out of the TRUNC with the same results. One other thing I just noticed is that the job returns an error each time it is run due to bug in DBMS_STATS. I'm rectifying that now with trapping and an error table, but I'm still confused as to why it would resub in a day instead of the interval. Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 11:31 AM To: Jesse, Rich; Multiple recipients of list ORACLE-L Subject: Re:DBMS_JOB interval wierdness Jesse, No joke, let me guess, 8am every day, right? Try TRUNC(SYSDATE+7)+1/24 instead. Dick Goulet Reply Separator Subject:DBMS_JOB interval wierdness Author: Jesse; Rich [EMAIL PROTECTED] Date: 7/16/2002 9:08 AM Hey all, I've got a job to gather stats on a schema of an 8.1.6.0.0 DB. The interval of the DBMS_JOB is: TRUNC(SYSDATE)+7+1/24 ...but it keeps resubmitting itself every day, instead of once a week. I *must* be brain dead or this cold's getting the best of me, because I just can't see what I'm missing. Anyone? Bueller? Bueller? Rich Jesse -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: kkennedy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: DBMS_JOB interval wierdness
Jesse, Is this 8.1.6? If so there's a bug filed against dbms_stats. Dick Goulet Reply Separator Author: Jesse; Rich [EMAIL PROTECTED] Date: 7/16/2002 12:24 PM Nope. 1 PM just like it should, only every day instead of every week. I've tried it with the 7 in and out of the TRUNC with the same results. One other thing I just noticed is that the job returns an error each time it is run due to bug in DBMS_STATS. I'm rectifying that now with trapping and an error table, but I'm still confused as to why it would resub in a day instead of the interval. Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 11:31 AM To: Jesse, Rich; Multiple recipients of list ORACLE-L Subject: Re:DBMS_JOB interval wierdness Jesse, No joke, let me guess, 8am every day, right? Try TRUNC(SYSDATE+7)+1/24 instead. Dick Goulet Reply Separator Subject:DBMS_JOB interval wierdness Author: Jesse; Rich [EMAIL PROTECTED] Date: 7/16/2002 9:08 AM Hey all, I've got a job to gather stats on a schema of an 8.1.6.0.0 DB. The interval of the DBMS_JOB is: TRUNC(SYSDATE)+7+1/24 ...but it keeps resubmitting itself every day, instead of once a week. I *must* be brain dead or this cold's getting the best of me, because I just can't see what I'm missing. Anyone? Bueller? Bueller? Rich Jesse -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: (Fwd/2)
Gary, Well if you know almost nothing about accounting, I'm about 200 ft deeper into the waters than you and still know almost nothing about accounting as it turns out. What is more, I don't even want to get acquainted with the bottom feeders in this here ocean! We've always had the saying about Lier's, damned lier's , and statistics well you had better add accountants to the end cause it sure is one heck of a mess. As for politicains, honest politician I believe is still an oxymoron. SO the politicians and crooked CEO's and accountants should be in good company. Dick Goulet Reply Separator Author: Kirsh; Gary [EMAIL PROTECTED] Date: 7/16/2002 10:18 AM A new boat, Ferrari, Mig fighter jet, mansion, maybe some Japanese art... the man has some serious expenses. Seriously, I know that Oracle had a problem with shady accounting practices many years ago (late 80's, if I recall correctly). Their stock took a huge hit, and they cleaned up their act. As a result, I think that they have been very conservative in there accounting practices ever since, and have not heard any accusations of untoward accounting practices since them. I admit that I know almost nothing about accounting. Still, I think it the height of hypocrisy for politicians to accuse anyone of shady accounting practices, when, as I understand, the federal govt itself doesn't abide by the Generally Accepted Accounting Principles to which corporations are expected to adhere. All the Worldcoms and Enrons added together don't equal the tax dollars flushed down the toilet due to govt waste, corruption, fraud and incompetence. As an example: http://freedom.house.gov/wastewatch/education.asp Having ceo's sign off on their company's books seems sensible enough. I suspect that when the hot air coming from DC blows over, the investigations will prove that existing laws have been broken, and there will be criminal convictions. Most people don't want to wait for investigations to run their course, and politicians pander to this lack of attention span with by pontificating on TV, then passing more laws, which at best are probably redundant, and at worst have unintended side-effects. The politicians, especially Democrats, have also successfully exploited class-envy with their screw-the-rich-we'll protect-the-little-guy act. It usually works well for them, so they take advantage of it at every opportunity. Gary -Original Message- Sent: Tuesday, July 16, 2002 12:30 PM To: [EMAIL PROTECTED]; Kirsh, Gary (test, posting from www.mail2web.com) Gary, Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. regards, ep Original Message: - Date: Tue, 16 Jul 2002 08:53:34 -0800 To: [EMAIL PROTECTED] Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play? And if he really did have insider info, and was acting unethically, why not sell more shares? The amount he sold was probably less than 5% of his holdings. I don't mean to defend ceo misconduct, corporate fraud, etc, I just think you need look this particular accusation a little more objectively, especially when you consider its source. I have great respect for McCain's war record and heroism, but now he is a politician, a Senator no less. IMHO, one can't take anything any politician says at face value. Given a choice between honesty and self-promotion, I'm afraid politicians too often choose the latter. And without getting into specifics about McCain, he seems to be second in the Senate only to my own Sen. Schumer in his love of getting on TV (Q: What's the most dangerous place in NY? A: Between Chuck Schumer and a TV camera). Larry makes a convenient and easy target, someone a politician knows he can attack, get a good soundbite, and have very little chance of being challenged. Gary -Original Message- Sent: Tuesday, July 16, 2002 1:13 AM To: Multiple recipients of list ORACLE-L trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From:
RE: delete from table question
Hi, I have this script which deletes the record from the master as well as all the Child tables also. May be this will help you. But I have never used this script before. Check this on Development before running it in Prod. To delete records from all the dependent tables and the master table for a particular record. Select 'Alter Table ' || Table_Name || ' Modify Consraint ' || Constraint_Name || ' On Delete Cascade;' From User_Constraints where Constraint_Type = 'R' and R_Constraint_Name = PK Constraint Name Regards, -Original Message- Sent: Tuesday, July 16, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Hi All - I am trying to delete from a table that has 24 child tables. Because the constraints are not 'cascade delete', I am hitting the following: ORA-02292: integrity constraint (NVALET.FK_TOPOGROUPMEMBERNE2) violated - child record found If I want to go ahead and delete the child records as well, there seem to be 2 options: 1. Write a sql/plsql procedure to delete the child records first before each deleting each record from the parent table. 2. Recreate the constraints with 'cascade delete' and delete the records from parent table. After that recreate the constraints again without cascade delete. Either option requires some work. Does anybody have a better idea? Also can anybody have a script to recreate all constraints to share? TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Your password! It's S New Worm W32/Frethem.K@mm
-- Eric D. Pierce [EMAIL PROTECTED] on 07/16/02 09:38:38 -0800 MS security Oxymoron? -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: (Fwd/2)
With any luck, they'll all have the privilege of meeting Ray-Ray on Cell Block D. Maybe we should move this to OT, eh? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: (Fwd/2) Gary, Well if you know almost nothing about accounting, I'm about 200 ft deeper into the waters than you and still know almost nothing about accounting as it turns out. What is more, I don't even want to get acquainted with the bottom feeders in this here ocean! We've always had the saying about Lier's, damned lier's , and statistics well you had better add accountants to the end cause it sure is one heck of a mess. As for politicains, honest politician I believe is still an oxymoron. SO the politicians and crooked CEO's and accountants should be in good company. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9iAS Application Server: Win2k vs. Linux?
I am not looking for an OS war, but has anyone on the list had experience in setting up/administering 9iAS rel 2. (1.0.2.2.2a) on Win2k or Red Hat Linux? I have the option of selecting the OS on this one. All of my oracle databases are on AIX (sort of like unix). I have 1 OAS 4.0.8.2 App Server running on NT. I am not sure if I should continue the NT track for App Servers or go Linux? Any opinions, experiences would be appreciated. Thanks, Gene PS. I will also be running the Forms Server w/ this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do I check whether a rollback activity is going on
I found this once but can't seem to find the full details at the moment. This will help though (Solaris8): kill -l # lists all kill signal names kill -l KILL # lists numeric equivalent for signal name KILL and then if you wish to obsess on the subject: for x in $(kill -l) do print $x $(kill -l $x) done Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 16, 2002 11:41 AM To: Multiple recipients of list ORACLE-L I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmmcan you say mutating thread...) --- [EMAIL PROTECTED] wrote: Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
RE: (Fwd/2)
A lot of the current problem goes back to government intervention. Some politicians/bureaucrats complained that CEO salaries were too high or unfair and (as if they were fit to judge) they decided to control the high CEO salary problem via taxation. So guess what happened? Corporate boards felt they needed to better compensate their CEO's and compensation changed to be more oriented to stocks and options. Suddenly CEO became intensely interested in Wall Street perception and stock values, much of which is driven by accounting reports. Business practices changed because of government intervention to solve a problem and the result was an even worse problem. The original government intervention was justified as an attempt to make things more fair for the little people but the result hurt everyone, especially little people like the small investor. LAISSEZ FAIRE!! Less government = increased prosperity. Adam Smith rules. The above explanation is a bit simplistic and doesn't explain everything but the essence has merit. The market may have periods of irrational exuberance but eventually it self corrects. The founding fathers' focus was to have the government be accountable to the public but now the fixation is with having publicly owned organizations be accountable to the government. In reality public companies are accountable to the public and the correction has already taken place in the stock market. The mindset of America has been turned up-side-down and many of its values no longer reflect the values of the founding fathers or its heritage in the constitution. The founding fathers were considered liberals in their day. Liberally and rhetorically yours, :-) Steve Orr P.S. What does this have to do with Oracle? Well it's kind of like tuning with ratios... Making tuning changes with incomplete understanding may have the opposite effect of what was intended. :-) -Original Message- Sent: Tuesday, July 16, 2002 12:19 PM To: Multiple recipients of list ORACLE-L A new boat, Ferrari, Mig fighter jet, mansion, maybe some Japanese art... the man has some serious expenses. Seriously, I know that Oracle had a problem with shady accounting practices many years ago (late 80's, if I recall correctly). Their stock took a huge hit, and they cleaned up their act. As a result, I think that they have been very conservative in there accounting practices ever since, and have not heard any accusations of untoward accounting practices since them. I admit that I know almost nothing about accounting. Still, I think it the height of hypocrisy for politicians to accuse anyone of shady accounting practices, when, as I understand, the federal govt itself doesn't abide by the Generally Accepted Accounting Principles to which corporations are expected to adhere. All the Worldcoms and Enrons added together don't equal the tax dollars flushed down the toilet due to govt waste, corruption, fraud and incompetence. As an example: http://freedom.house.gov/wastewatch/education.asp Having ceo's sign off on their company's books seems sensible enough. I suspect that when the hot air coming from DC blows over, the investigations will prove that existing laws have been broken, and there will be criminal convictions. Most people don't want to wait for investigations to run their course, and politicians pander to this lack of attention span with by pontificating on TV, then passing more laws, which at best are probably redundant, and at worst have unintended side-effects. The politicians, especially Democrats, have also successfully exploited class-envy with their screw-the-rich-we'll protect-the-little-guy act. It usually works well for them, so they take advantage of it at every opportunity. Gary -Original Message- Sent: Tuesday, July 16, 2002 12:30 PM To: [EMAIL PROTECTED]; Kirsh, Gary (test, posting from www.mail2web.com) Gary, Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. regards, ep Original Message: - Date: Tue, 16 Jul 2002 08:53:34 -0800 To: [EMAIL PROTECTED] Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play?
RE: RE: DBMS_JOB interval wierdness
Yes and yes. Unfortunately, I don't have the time to setup the workaround for the GATHER_SCHEMA_STATS bug. It'll hit a NO_DATA_FOUND after all objects have been analyzed. I've setup some error trapping and left the job alone to see if it runs without the error. And if there's no error, will it submit at the proper interval or not. Of course it runs at 1 *AM* and not *PM*, like I had said, so I'll wait to see what happens tomorrow. Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 12:53 PM To: Jesse, Rich; Multiple recipients of list ORACLE-L Subject: Re:RE: DBMS_JOB interval wierdness Jesse, Is this 8.1.6? If so there's a bug filed against dbms_stats. Dick Goulet Reply Separator Subject:RE: DBMS_JOB interval wierdness Author: Jesse; Rich [EMAIL PROTECTED] Date: 7/16/2002 12:24 PM Nope. 1 PM just like it should, only every day instead of every week. I've tried it with the 7 in and out of the TRUNC with the same results. One other thing I just noticed is that the job returns an error each time it is run due to bug in DBMS_STATS. I'm rectifying that now with trapping and an error table, but I'm still confused as to why it would resub in a day instead of the interval. Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 11:31 AM To: Jesse, Rich; Multiple recipients of list ORACLE-L Subject: Re:DBMS_JOB interval wierdness Jesse, No joke, let me guess, 8am every day, right? Try TRUNC(SYSDATE+7)+1/24 instead. Dick Goulet Reply Separator Subject:DBMS_JOB interval wierdness Author: Jesse; Rich [EMAIL PROTECTED] Date: 7/16/2002 9:08 AM Hey all, I've got a job to gather stats on a schema of an 8.1.6.0.0 DB. The interval of the DBMS_JOB is: TRUNC(SYSDATE)+7+1/24 ...but it keeps resubmitting itself every day, instead of once a week. I *must* be brain dead or this cold's getting the best of me, because I just can't see what I'm missing. Anyone? Bueller? Bueller? Rich Jesse -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Where is Oracle 9.2 init.ora?
Kirti, I am using Red Hat 7.1, I will test it in W2K - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 15, 2002 3:53 PM Ramon, I can not explain that. What platform are you on? May be this is another bug with SPFILE. - Kirti -Original Message- From: Ramon E. Estevez [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Subject: Re: Where is Oracle 9.2 init.ora? Hi Kirti I have something to add to the topic. I could edit the spfile with VI and add a parameter with a value of 20, later add the same parameter to the init file with a value of 30, bounce the DB and it worked very fine. SQL shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL startup ORACLE instance started. Total System Global Area 235693104 bytes Fixed Size 279600 bytes Variable Size 167772160 bytes Database Buffers 67108864 bytes Redo Buffers 532480 bytes Database mounted. Database opened. SQL SHOW PARAMETER JOB NAME TYPEVALUE --- --- --- job_queue_processes integer 20 -- spfile SQL shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL startup ORACLE instance started. Total System Global Area 235693104 bytes Fixed Size 279600 bytes Variable Size 167772160 bytes Database Buffers 67108864 bytes Redo Buffers 532480 bytes Database mounted. Database opened. SQL show parameter job NAME TYPEVALUE --- --- --- job_queue_processes integer 30 -- init SQL SQL Could you explain me that ??? Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 14, 2002 5:58 PM All Right, Larry. Since we have the test servers and databases; and my Company still pays for 'doing Oracle' the 'scary' way, here is another 'scary thing' I did with SPFILE :) (9iR1 on HP) SQL conn / as sysdba Connected to an idle instance. SQL startup using spfile ORACLE instance started. Total System Global Area 72273416 bytes Fixed Size 437768 bytes Variable Size 37748736 bytes Database Buffers 33554432 bytes Redo Buffers 532480 bytes Database mounted. Database opened. SQL show parameter db_cache_size NAME TYPEVALUE --- -- db_cache_sizebig integer 33554432 SQL !mv spfileKED9.ora spfileKED9.ora.bak -- hide the spfile SQL !ls -l *.ora -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora SQL alter system set db_cache_size=10M scope=both; -- try to set a new value System altered. --- No problem? SQL show parameter db_cache_size NAME TYPEVALUE --- -- db_cache_sizebig integer 12582912 -- New value in effect. SQL !ls -l *.ora -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora -- Still no SFILE -- Now, why would not Oracle tell us that there was no spfile to process SCOPE=BOTH ? SQL c/both/spfile 1* alter system set db_cache_size=10M scope=spfile SQL / alter system set db_cache_size=10M scope=spfile * ERROR at line 1: ORA-27037: unable to obtain file status HP-UX Error: 2: No such file or directory Additional information: 3 --This is what should have happened with SCOPE=BOTH as well, or at least a warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no SPFILE available. I would not have objected if Oracle re-recreated SPFILE in the default location and told me so! If anyone has seen any mention of this particular behaviour of SCOPE=BOTH, I would like to know the source of that information. I have searched Metalink, Google but have not come across any. I have created an iTar with OWS. Thanks. As I said before, SPFILE has some things that need to be made fool proof. This time I did not drink prior to doing this 'scary' stuff !!;-) Regards, - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City
Re: 9iAS Application Server: Win2k vs. Linux?
Gene, If it helps any, I had the privilege of setting up OAS ( several names ago ) on both NT and Solaris 2.6. Solaris was by far easier. I can't emphasize enough how much simpler it was on *nix than on Windoze. Windoze: Step 1: do something Step 2: reboot Step 3: try something else Step 4: reboot Solaris: Step 1: Install Step 2: Configure Step 3: implement. Jared Gene Sais [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 12:18 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:9iAS Application Server: Win2k vs. Linux? I am not looking for an OS war, but has anyone on the list had experience in setting up/administering 9iAS rel 2. (1.0.2.2.2a) on Win2k or Red Hat Linux? I have the option of selecting the OS on this one. All of my oracle databases are on AIX (sort of like unix). I have 1 OAS 4.0.8.2 App Server running on NT. I am not sure if I should continue the NT track for App Servers or go Linux? Any opinions, experiences would be appreciated. Thanks, Gene PS. I will also be running the Forms Server w/ this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 - create and drop synonyms
Hi, I'm having problems with intermedia for synonyms in the thesaurus. Here a list of request that I execute and that order and their results: select ctx_thes.SYN('disease','gdermthes_md') from DUAL; {DISEASE}|{SICKNESS}|{MALADIE1} execute CTX_THES.DROP_RELATION('gdermthes_md','DISEASE','SYN','maladie1'); select ctx_thes.SYN('disease','gdermthes_md') from DUAL; {DISEASE} execute CTX_THES.CREATE_RELATION('gdermthes_md','maladie1','SYN','DISEASE'); select ctx_thes.SYN('disease','gdermthes_md') from DUAL; {DISEASE}|{SICKNESS}|{MALADIE1} The problem is that when I remove the relationship between disease and maladie1, I lose sickness as well in my synonyms for disease. On the other hand, if I reverse the order of my parameters in the drop_relation like that: execute CTX_THES.DROP_RELATION('gdermthes_md','maladie1','SYN','disease'); If works correctly. That creates a problem for me because for every other relationship types, it's always source term first and target term second. I'm trying to write generic code to handle those tasks and I don't want to do a special case for synonyms. Thanks for any help.
RE: How do I check whether a rollback activity is going on
Kevin, Too much work! Just use: kill -9 -1 ;) you better read the man page first on this one. Jared kkennedy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 12:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on I found this once but can't seem to find the full details at the moment. This will help though (Solaris8): kill -l # lists all kill signal names kill -l KILL # lists numeric equivalent for signal name KILL and then if you wish to obsess on the subject: for x in $(kill -l) do print $x $(kill -l $x) done Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 16, 2002 11:41 AM To: Multiple recipients of list ORACLE-L I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmmcan you say mutating thread...) --- [EMAIL PROTECTED] wrote: Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:
Re: 9iAS Application Server: Win2k vs. Linux?
As you have Unix skills and therefore could handle Linux OK, then unless you will have issues with people about support for Linux I would offer to save the organisation money by using Linux for your platform Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Gene Sais [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 16-07-2002 12:18 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:9iAS Application Server: Win2k vs. Linux? I am not looking for an OS war, but has anyone on the list had experience in setting up/administering 9iAS rel 2. (1.0.2.2.2a) on Win2k or Red Hat Linux? I have the option of selecting the OS on this one. All of my oracle databases are on AIX (sort of like unix). I have 1 OAS 4.0.8.2 App Server running on NT. I am not sure if I should continue the NT track for App Servers or go Linux? Any opinions, experiences would be appreciated. Thanks, Gene PS. I will also be running the Forms Server w/ this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do I check whether a rollback activity is going on
try 'kill -l' where the -l is an ell as in -list. Jared mkb [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 11:41 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmmcan you say mutating thread...) --- [EMAIL PROTECTED] wrote: Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: (Fwd/2)
Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) As the story was related to me, Ellison has been living off of loans (from banks, not Oracle) for the past couple decades. His alleged reasoning was that his stocks would appreciate far faster than the interest of the loans, thus making it more economical to borrow than to sell. Obviously, with such a plan, you have to pay off sometime, and in 2000 one (or more) of his lenders called in his loans for payment. Again, this is just hearsay, but that's what I've heard... ...so, in essence, he sold stock because he had (large unexpected) debts to pay. The timing of the stock sale wasn't his, it was some banker's... Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Oh, you do yourself far too much justice! My own objection was your prolonged and uninformed vitriol lacking anything more than a politician's media release for substantiation. Go measure some cache-hit ratios, please... Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? No idea. Not of interest... I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. Sure. Whatever. Whaddya say we get back to work and talk techie stuff and quit wasting time on this fluff? signing off on thread -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do I check whether a rollback activity is going on
Yeah, ok, I forgot that in my youth the number one was typed by using the key immediately right of the K and the number zero was typed by using Shift and the key between I and P. I really meant kill -l using the letter to the right of the K, not that numeric symbol on the top row of the keyboard. Been a long time since I used kill -9 -1 -- I got out of the habit during my time on HPUX. And if anyone wants to try Jared's approach, be sure to log in as the oracle user on a critical production system and have your resume up to date 8-) Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 16, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Kevin, Too much work! Just use: kill -9 -1 ;) you better read the man page first on this one. Jared kkennedy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 12:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on I found this once but can't seem to find the full details at the moment. This will help though (Solaris8): kill -l # lists all kill signal names kill -l KILL # lists numeric equivalent for signal name KILL and then if you wish to obsess on the subject: for x in $(kill -l) do print $x $(kill -l $x) done Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 16, 2002 11:41 AM To: Multiple recipients of list ORACLE-L I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmmcan you say mutating thread...) --- [EMAIL PROTECTED] wrote: Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
RE: 9iAS Application Server: Win2k vs. Linux?
I'm fighting with 9iAS 9.0.2 on HP at the moment. This is one lng install on an underpowered machine (2 cpu's, 2G mem). Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 2:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9iAS Application Server: Win2k vs. Linux? Gene, If it helps any, I had the privilege of setting up OAS ( several names ago ) on both NT and Solaris 2.6. Solaris was by far easier. I can't emphasize enough how much simpler it was on *nix than on Windoze. Windoze: Step 1: do something Step 2: reboot Step 3: try something else Step 4: reboot Solaris: Step 1: Install Step 2: Configure Step 3: implement. Jared Gene Sais [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 12:18 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:9iAS Application Server: Win2k vs. Linux? I am not looking for an OS war, but has anyone on the list had experience in setting up/administering 9iAS rel 2. (1.0.2.2.2a) on Win2k or Red Hat Linux? I have the option of selecting the OS on this one. All of my oracle databases are on AIX (sort of like unix). I have 1 OAS 4.0.8.2 App Server running on NT. I am not sure if I should continue the NT track for App Servers or go Linux? Any opinions, experiences would be appreciated. Thanks, Gene PS. I will also be running the Forms Server w/ this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to change VB code to use bind variables?
Hi, In checking my v$SQLArea I recently discovered that there was an often executed SQL statement that was not using bind variables. I tracked it down to a VB front end and asked the development group to modify the code. They asked me how to do it. Not being a VB programmer I said I had no idea but would try to find out. Here's an abbreviated version of the code. It's the sAcctId that seems to be causing the multiple executions. Anyone know how this can be rewritten to use bind variables? Can it be done from VB or do we need to transfer the code to PL/SQL on the back end? Private Function GetSQL(ByVal sKey As String, _ ByVal sAcctId As String, _ Optional ByVal sAcctNum As String, _ Optional ByVal sWhereAnd As String) Dim sConnect As String Dim sSql As String Dim oWsiLibData As WSILib.CDisplayData Dim rsCustomer As ADODB.Recordset Dim lCustId As Long Dim sCustId As String Select Case sKey ... ... Case accountinfo: sSql = SELECT a.id, a.account_no, a.type, a.title1, a.title2, a.title3, _ a.inventory_date date_opened, a.last_modified_date last_change, _ rc.description rebatecmsn, _ sSql = sSql account_info.fetch_email( sAcctId ) email sSql = sSql FROM account a, status s, usa_wh_tax u, fund f, _ stock_commission_codes sc, cmsn_rebate_codes rc, account_kind ak sSql = sSql , dual sSql = sSql WHERE a.status_id=s.id and a.usa_tax_code=u.code(+) _ and a.fund_id=f.id and _ a.s_stk_cmsn_code=sc.code(+) and a.cmsn_reb_code=rc.code(+) and a.kind_id=ak.id _ and a.id = sAcctId sConnect = sConnectWSI GetSQL = Array(sConnect, sSql) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do I check whether a rollback activity is going on
Thanks. That clarifies things. Time to look into this some more. mkb --- [EMAIL PROTECTED] wrote: try 'kill -l' where the -l is an ell as in -list. Jared mkb [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 11:41 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmmcan you say mutating thread...) --- [EMAIL PROTECTED] wrote: Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed === message truncated === __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from
Re: How to change VB code to use bind variables?
Check on the MS support site. There are several articles detailing how to do this. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 02:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to change VB code to use bind variables? Hi, In checking my v$SQLArea I recently discovered that there was an often executed SQL statement that was not using bind variables. I tracked it down to a VB front end and asked the development group to modify the code. They asked me how to do it. Not being a VB programmer I said I had no idea but would try to find out. Here's an abbreviated version of the code. It's the sAcctId that seems to be causing the multiple executions. Anyone know how this can be rewritten to use bind variables? Can it be done from VB or do we need to transfer the code to PL/SQL on the back end? Private Function GetSQL(ByVal sKey As String, _ ByVal sAcctId As String, _ Optional ByVal sAcctNum As String, _ Optional ByVal sWhereAnd As String) Dim sConnect As String Dim sSql As String Dim oWsiLibData As WSILib.CDisplayData Dim rsCustomer As ADODB.Recordset Dim lCustId As Long Dim sCustId As String Select Case sKey ... ... Case accountinfo: sSql = SELECT a.id, a.account_no, a.type, a.title1, a.title2, a.title3, _ a.inventory_date date_opened, a.last_modified_date last_change, _ rc.description rebatecmsn, _ sSql = sSql account_info.fetch_email( sAcctId ) email sSql = sSql FROM account a, status s, usa_wh_tax u, fund f, _ stock_commission_codes sc, cmsn_rebate_codes rc, account_kind ak sSql = sSql , dual sSql = sSql WHERE a.status_id=s.id and a.usa_tax_code=u.code(+) _ and a.fund_id=f.id and _ a.s_stk_cmsn_code=sc.code(+) and a.cmsn_reb_code=rc.code(+) and a.kind_id=ak.id _ and a.id = sAcctId sConnect = sConnectWSI GetSQL = Array(sConnect, sSql) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to change VB code to use bind variables?
Hi Jared, Thanks for the suggestion. But I went to www.microsoft.com, clicked on support and searched on the words bind variables oracle visual basic After a dozen Internet Explorer Script errors I got a bunch of links with names like 26jbkjakjbmon That one led to a blank page. Others led to articles that didn't even mention bind variables. And I thought Metalink was bad. Does anyone have a link that goes directly to an article? Thanks, Jay Miller -Original Message- Sent: Tuesday, July 16, 2002 4:45 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Check on the MS support site. There are several articles detailing how to do this. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 02:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to change VB code to use bind variables? Hi, In checking my v$SQLArea I recently discovered that there was an often executed SQL statement that was not using bind variables. I tracked it down to a VB front end and asked the development group to modify the code. They asked me how to do it. Not being a VB programmer I said I had no idea but would try to find out. Here's an abbreviated version of the code. It's the sAcctId that seems to be causing the multiple executions. Anyone know how this can be rewritten to use bind variables? Can it be done from VB or do we need to transfer the code to PL/SQL on the back end? Private Function GetSQL(ByVal sKey As String, _ ByVal sAcctId As String, _ Optional ByVal sAcctNum As String, _ Optional ByVal sWhereAnd As String) Dim sConnect As String Dim sSql As String Dim oWsiLibData As WSILib.CDisplayData Dim rsCustomer As ADODB.Recordset Dim lCustId As Long Dim sCustId As String Select Case sKey ... ... Case accountinfo: sSql = SELECT a.id, a.account_no, a.type, a.title1, a.title2, a.title3, _ a.inventory_date date_opened, a.last_modified_date last_change, _ rc.description rebatecmsn, _ sSql = sSql account_info.fetch_email( sAcctId ) email sSql = sSql FROM account a, status s, usa_wh_tax u, fund f, _ stock_commission_codes sc, cmsn_rebate_codes rc, account_kind ak sSql = sSql , dual sSql = sSql WHERE a.status_id=s.id and a.usa_tax_code=u.code(+) _ and a.fund_id=f.id and _ a.s_stk_cmsn_code=sc.code(+) and a.cmsn_reb_code=rc.code(+) and a.kind_id=ak.id _ and a.id = sAcctId sConnect = sConnectWSI GetSQL = Array(sConnect, sSql) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd/2)
I would add to this .. In a free market system nobody should look at the negative side when people make money off of their hard work or investments. This is the way it is set up. Why not say damn, how did he do it and where do I get in line to get some of that action ? I always find it interesting the envy and/or disgust that some folks have toward people who make alot of money. Think of all the middle class people Larry Ellison and crew put to work who bought homes and cars to drive our economy. I didnt care for any of Larry and Scotts bitchin and moanin about Microsoft and Bill Gates, but I say to Larry .. More power to you to make more money, keep gettin richer and help build our economy. Keep on truckin ! FWIW. Mike -Original Message- Sent: Tuesday, July 16, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) As the story was related to me, Ellison has been living off of loans (from banks, not Oracle) for the past couple decades. His alleged reasoning was that his stocks would appreciate far faster than the interest of the loans, thus making it more economical to borrow than to sell. Obviously, with such a plan, you have to pay off sometime, and in 2000 one (or more) of his lenders called in his loans for payment. Again, this is just hearsay, but that's what I've heard... ...so, in essence, he sold stock because he had (large unexpected) debts to pay. The timing of the stock sale wasn't his, it was some banker's... Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Oh, you do yourself far too much justice! My own objection was your prolonged and uninformed vitriol lacking anything more than a politician's media release for substantiation. Go measure some cache-hit ratios, please... Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? No idea. Not of interest... I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. Sure. Whatever. Whaddya say we get back to work and talk techie stuff and quit wasting time on this fluff? signing off on thread -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: v$sort_usage
Do you use global temporary tables? (select owner,table_name from dba_tables where temporary='Y';) If so the segments shown could be associated with that. HTH, Bruce Reardon -Original Message- Sent: Wednesday, 17 July 2002 2:00 Hi, Could someone shed some light on how v$sort_usage is populated? It is supposed to show active sorts in the database. If that is the case then I don't understand why I see the following: 1. An entry exists for a user/sort, yet according to v$session the session is NOT active. 2. Multiple entries exist for a user with the SAME session_addr. I don't understand how a session could have multiple sort segments. As always, you're feedback is appreciated. Thanks. -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to change VB code to use bind variables?
did you try google? http://www.google.com/search?hl=enie=UTF-8oe=UTF-8q=bind+variables+oracle+visual+basicbtnG=Google+Search [EMAIL PROTECTED] 07/16/02 06:08PM Hi Jared, Thanks for the suggestion. But I went to www.microsoft.com, clicked on support and searched on the words bind variables oracle visual basic After a dozen Internet Explorer Script errors I got a bunch of links with names like 26jbkjakjbmon That one led to a blank page. Others led to articles that didn't even mention bind variables. And I thought Metalink was bad. Does anyone have a link that goes directly to an article? Thanks, Jay Miller -Original Message- Sent: Tuesday, July 16, 2002 4:45 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Check on the MS support site. There are several articles detailing how to do this. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 02:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to change VB code to use bind variables? Hi, In checking my v$SQLArea I recently discovered that there was an often executed SQL statement that was not using bind variables. I tracked it down to a VB front end and asked the development group to modify the code. They asked me how to do it. Not being a VB programmer I said I had no idea but would try to find out. Here's an abbreviated version of the code. It's the sAcctId that seems to be causing the multiple executions. Anyone know how this can be rewritten to use bind variables? Can it be done from VB or do we need to transfer the code to PL/SQL on the back end? Private Function GetSQL(ByVal sKey As String, _ ByVal sAcctId As String, _ Optional ByVal sAcctNum As String, _ Optional ByVal sWhereAnd As String) Dim sConnect As String Dim sSql As String Dim oWsiLibData As WSILib.CDisplayData Dim rsCustomer As ADODB.Recordset Dim lCustId As Long Dim sCustId As String Select Case sKey ... ... Case accountinfo: sSql = SELECT a.id, a.account_no, a.type, a.title1, a.title2, a.title3, _ a.inventory_date date_opened, a.last_modified_date last_change, _ rc.description rebatecmsn, _ sSql = sSql account_info.fetch_email( sAcctId ) email sSql = sSql FROM account a, status s, usa_wh_tax u, fund f, _ stock_commission_codes sc, cmsn_rebate_codes rc, account_kind ak sSql = sSql , dual sSql = sSql WHERE a.status_id=s.id and a.usa_tax_code=u.code(+) _ and a.fund_id=f.id and _ a.s_stk_cmsn_code=sc.code(+) and a.cmsn_reb_code=rc.code(+) and a.kind_id=ak.id _ and a.id = sAcctId sConnect = sConnectWSI GetSQL = Array(sConnect, sSql) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
escape key ???
Hi all, I need to insert some value with as a part of the string. For example, insert ... values ('a b'); What escape key should be used? insert ... values ('a / b'); -- doesn't work insert ... values ('a '||''||' b'); -- works, but I'd like to know what escape key works in this case. Thank you. Leslie __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: escape key ???
Hi Leslie, Sounds like your problem is in SQLPlus where the character is the prefix for substitution variables. Look in the SQLPlus manual under SET DEFINE and SET ESCAPE. You can choose a different character or you can turn off substitution with SET DEFINE OFF. You can define an escape character with SET ESCAPE / (did you really mean to use a forward slash?). The default on my machine is SET ESCAPE OFF which is why your first attempt didn't work. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 16, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Hi all, I need to insert some value with as a part of the string. For example, insert ... values ('a b'); What escape key should be used? insert ... values ('a / b'); -- doesn't work insert ... values ('a '||''||' b'); -- works, but I'd like to know what escape key works in this case. Thank you. Leslie __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: kkennedy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Win2000/8.1.7.3/Temp Space Question
Hi Everyone: I have an 8.1.7.3 database running on Win2k. I created the TEMP tablespace as locally managed and temporary. When I run a query that needs sort space I get a... ERROR at line 5: ORA-01652: unable to extend temp segment by 256 in tablespace TEMP ...error. Then I try to find out what's going on with... SQL select * from v$temp_space_header; TS NameFile# BYTES_USED BLOCKS_USED BYTES_FREE BLOCKS_FREE -- - -- --- -- --- RELATIVE_FNO TEMP 1 2097152000 256000 0 0 1 1 row selected. SQL select * from v$temp_extent_pool; TS NameFile# EXTENTS_CACHED EXTENTS_USED BLOCKS_CACHED -- - -- - BLOCKS_USED BYTES_CACHED BYTES_USED RELATIVE_FNO --- -- TEMP 19990255744 0 2095054848 01 1 row selected. SQL select * from v$sort_segment; TS NameSEGMENT_FILE SEGMENT_BLOCK EXTENT_SIZE CURRENT_USERS -- - --- - TOTAL_EXTENTS TOTAL_BLOCKS USED_EXTENTS USED_BLOCKS FREE_EXTENTS - --- FREE_BLOCKS ADDED_EXTENTS EXTENT_HITS FREED_EXTENTS FREE_REQUESTS --- - --- - - MAX_SIZE MAX_BLOCKS MAX_USED_SIZE MAX_USED_BLOCKS MAX_SORT_SIZE -- -- - --- - MAX_SORT_BLOCKS RELATIVE_FNO --- TEMP 0 0 256 0 999 2557440 0 999 255744 03683 0 0 999 255744 999 255744 999 2557440 1 row selected. SQL select * from v$sort_usage; no rows selected SQL ...and it looks like a sort segment that is in use, but nobody's claiming it. The V$TEMP_EXTENT_POOL shows blocks as cached but not used. I do not understand what's going on. Can somebody give me a hint or a place to look in the docs to figure this out? Do I needs to add more TEMP space? Can I un-cache the unused space? Help! And Thanx, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: escape key ???
The default value in SQL*Plus for escape is \ not /. / is reserved and says 'execute the statement in the buffer or the above pl/sql block'. You can set it to a different value with SET ESCAPE command. Use the CHR function instead of escaping. insert into table values ('a '||chr(38)||' b'); This will be independent of any escape or other settings. Dan Fink -Original Message- Sent: Tuesday, July 16, 2002 5:18 PM To: Multiple recipients of list ORACLE-L Hi all, I need to insert some value with as a part of the string. For example, insert ... values ('a b'); What escape key should be used? insert ... values ('a / b'); -- doesn't work insert ... values ('a '||''||' b'); -- works, but I'd like to know what escape key works in this case. Thank you. Leslie __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Win2000/8.1.7.3/Temp Space Question
Vergara, Michael (TEM)£¬ Hi , i think you created the tablespace like: Create tablespace temp datafile 'xxx' extent management local , right? Drop it and recreate it like: Create temporary tablespace temp tempfile 'xxx' ... Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 ÔÚ 2002-07-16 16:43:00 You wrote: Hi Everyone: I have an 8.1.7.3 database running on Win2k. I created the TEMP tablespace as locally managed and temporary. When I run a query that needs sort space I get a... ERROR at line 5: ORA-01652: unable to extend temp segment by 256 in tablespace TEMP ...error. Then I try to find out what's going on with... SQL select * from v$temp_space_header; TS NameFile# BYTES_USED BLOCKS_USED BYTES_FREE BLOCKS_FREE -- - -- --- -- --- RELATIVE_FNO TEMP 1 2097152000 256000 0 0 1 1 row selected. SQL select * from v$temp_extent_pool; TS NameFile# EXTENTS_CACHED EXTENTS_USED BLOCKS_CACHED -- - -- - BLOCKS_USED BYTES_CACHED BYTES_USED RELATIVE_FNO --- -- TEMP 19990255744 0 2095054848 01 1 row selected. SQL select * from v$sort_segment; TS NameSEGMENT_FILE SEGMENT_BLOCK EXTENT_SIZE CURRENT_USERS -- - --- - TOTAL_EXTENTS TOTAL_BLOCKS USED_EXTENTS USED_BLOCKS FREE_EXTENTS - --- FREE_BLOCKS ADDED_EXTENTS EXTENT_HITS FREED_EXTENTS FREE_REQUESTS --- - --- - - MAX_SIZE MAX_BLOCKS MAX_USED_SIZE MAX_USED_BLOCKS MAX_SORT_SIZE -- -- - --- - MAX_SORT_BLOCKS RELATIVE_FNO --- TEMP 0 0 256 0 999 2557440 0 999 255744 03683 0 0 999 255744 999 255744 999 2557440 1 row selected. SQL select * from v$sort_usage; no rows selected SQL ...and it looks like a sort segment that is in use, but nobody's claiming it. The V$TEMP_EXTENT_POOL shows blocks as cached but not used. I do not understand what's going on. Can somebody give me a hint or a place to look in the docs to figure this out? Do I needs to add more TEMP space? Can I un-cache the unused space? Help! And Thanx, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: chaos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
deploying forms reports on web problem
Dear All, i want to deploy my application (forms reports) on web, for this i have instlled forms and reporst server 6.0. i can see the forms in browser but its window size is not appearing proper and the icons also not appearing .what could be the problem. Thanks in advance Regards Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).