Re: tracing error stack - finding the cause of a ORA-00917 error
You might want to look at dbms_system.set_ev Parameters: sid serial event number level event name -- leave null in your case . Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 20 December 2002 19:28 I am working on figuring out an error in an application caused by dynamically generated sql. I've set init parameters in the past to generate a trace file for a specific error and its been very helpful in finding the source of this sort of error. Is there a way to run this sort of trace on a session or the system without setting it in the init file and restarting? -- Glenn Stauffer [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Row cache locks on INSERTs with a sequence
On the information as supplied you are correct, the sequence does seem to be the most likely problem. It has occurred to me, though, that the original poster showed us a couple of lines from v$session_wait - without showing the STATE (or is it STATUS) column. It is a common error to assume that v$session_wait is showing a wait time - however if the STATE is __not__ WAITING then the SECONDS_IN_WAIT column is the time since the last wait ended. So perhaps the OP was seeing lots of 'latch wait' recorded as the previous wait whilst the system was busy burning CPU on something else. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- From: Khedr, Waleed [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 20 December 2002 21:11 Subject: RE: Row cache locks on INSERTs with a sequence -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TNSPING another question
At 12:28 PM 12/20/2002, John Shaw wrote: It's probably in the fine manual somewhere - but I haven't found it yet From my pc: I can ping the IP address of the server and response time is 10 ms ping the name of the server and response time is 10 ms tnsping of IP is 10 ms but tnsping of the name is 1000 ms any reason why this would be? Note that for most people ping hostname and tnsping hostname are rather different animals. ping hostname resolves hostname through DNS (generally). tnsping hostname looks up hostname in your tnsnames.ora file and then resolves the server name specified there through DNS (generally). Assuming you're aware of these differences, the first thing I'd look at is how you've set up TNS, particularly the order you've specified to try to resolve things. I would guess that TNS is set up to try to resolve a host name through some method other than DNS (assuming ping hostname is resolved by DNS and not some other protocol, /etc/hosts, etc) and then to use DNS. For example, if you set up TNS to use Oracle Names first and DNS second, and the hostname in question wasn't in your Oracle Names server, you'd have to wait for the Names server to come back saying it couldn't find the host name before querying DNS. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Happy Holidays!!
'cause I've met her --- Sony kristanto [EMAIL PROTECTED] wrote: How do you know that Rachel ? -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Saturday, December 21, 2002 4:45 AM To: Multiple recipients of list ORACLE-L Subject:RE: Happy Holidays!! Ruth Gramolini is definitely female --- Weaver, Walt [EMAIL PROTECTED] wrote: Perhaps you're thinking of Guy Ruth Hammond. --Walt Weaver Bozeman, Montana -Original Message- Sent: Friday, December 20, 2002 1:38 PM To: Multiple recipients of list ORACLE-L I have never met RUTH and I apologize in advance if I am wrong but I thought I remember a post long ago indicating Ruth G is male? Again a big oops if incorrect. Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@y cc: ahoo.comSubject: RE: Happy Holidays!! Sent by: [EMAIL PROTECTED] om 12/20/2002 02:28 PM Please respond to ORACLE-L from this list: Ruth Gramolini and April Wells are going, they are presenting. I don't know if I am presenting or not, I was accepted as an alternate and today is the cutoff for the speakers to confirm they are going. But I'll be there whether or not I present --- [EMAIL PROTECTED] wrote: No offense guys, but having only small boy children (whom I love dearly), working in a 90% male IT support organization (cause I like men) - can't help feeling like what I really need now is some good woman friends - preferably ones that both work and are raising children. Are any of them going to IOUG? -Original Message- Sent: Friday, December 20, 2002 11:40 AM To: Multiple recipients of list ORACLE-L from what Jared tells me, in the first 50 names on the list (alphabetical?) he found 11 out of 50 names that were obviously female first names. not the best statistic (1/5 of an admittedly small sample). but better than it was a few years ago. What I really like seeing is that more and more women are answering questions here as well --- Lisa Corell Auerbach [EMAIL PROTECTED] wrote: Hi Rachel - you wrote - I'm more interested in the numbers to see if this field is less male-centric than others. I don't post very often, but I'm another in the orawoman category. Lisa (now the DBA at Henrico County Public Schools) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lisa Corell Auerbach INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
RE: Happy Holidays!!
Stephen, Unless you are doing one of the Expert Technical Sessions (otherwise known as the mini-lessons) I'm not in contention as an alternate for your slot :) Rachel --- Stephen Andert [EMAIL PROTECTED] wrote: Lisa, Good news. REGISTER FOR LIVE! 2003 APRIL 27 - MAY 1 ORLANDO, FLORIDA WALT DISNEY WORLD DOLPHIN HOTEL I'm not orawoman, so I won't plan on join a girls night out, but I hope there will be a list-wide gettogether with no gender discrimination. Rachel, I hope you get in as an alternate, but I did get my form faxed back in time, so you can't have my slot grin. Stephen Andert [EMAIL PROTECTED] 12/20/02 12:38PM Not until it comes back to Orlando. But when it does, I'll be there. I found the best way to deal with being in a nearly-all-male work situation is to become one of the guys. Of course I am very much a tomboy so this came naturally to me. This may not be the right way to go about it but it kept the working relationship very smooth. The only problems were with men who couldn't handle a woman disagreeing with them. There have only been a few so far. That doesn't mean I don't thoroughly enjoy a girls' night out and a strong martini :) Lisa Koivu Oracle Datababy Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- Sent: Friday, December 20, 2002 1:46 PM To: Multiple recipients of list ORACLE-L No offense guys, but having only small boy children (whom I love dearly), working in a 90% male IT support organization (cause I like men) - can't help feeling like what I really need now is some good woman friends - preferably ones that both work and are raising children. Are any of them going to IOUG? -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, December 20, 2002 11:40 AM To: Multiple recipients of list ORACLE-L from what Jared tells me, in the first 50 names on the list (alphabetical?) he found 11 out of 50 names that were obviously female first names. not the best statistic (1/5 of an admittedly small sample). but better than it was a few years ago. What I really like seeing is that more and more women are answering questions here as well --- Lisa Corell Auerbach [EMAIL PROTECTED] wrote: Hi Rachel - you wrote - I'm more interested in the numbers to see if this field is less male-centric than others. I don't post very often, but I'm another in the orawoman category. Lisa (now the DBA at Henrico County Public Schools) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Lisa Corell Auerbach INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
help me find out why rac instance died
Hi, I have a rac 9.2.0.2 Database running on RedHat AS2.1,it has been up and running for about 4 monthes(One month ago, i patched it to 9202). Last night, one instance died unexpectedly,while another instance still running.Though not much business is affected, I want to know why it died, But i am unable to find it out, so looking for your help. Here is some information, I tested the interconnect and the service Network card, both running fine(at 7:00 am), and the disk system is also ok. Alert log file: quote: Fri Dec 20 23:38:24 2002 Thread 2 advanced to log sequence 265 Current log# 3 seq# 265 mem# 0: /dev/raw/raw8 Sat Dec 21 04:04:29 2002 Errors in file /home/oracle/admin/rac/bdump/rac2_lmon_1634.trc: ORA-29740: evicted by member 0, group incarnation 7 Sat Dec 21 04:04:29 2002 LMON: terminating instance due to error 29740 Sat Dec 21 04:04:31 2002 Trace dumping is performing id=[cdmp_20021221040431] Sat Dec 21 04:04:34 2002 Instance terminated by LMON, pid = 1634 Sat Dec 21 07:38:36 2002 Starting ORACLE instance (normal) Sat Dec 21 07:38:36 2002 and this is from the trace file: quote: [oracle@rac2 bdump]$ cat /home/oracle/admin/rac/bdump/rac2_lmon_1634.trc /home/oracle/admin/rac/bdump/rac2_lmon_1634.trc Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production ORACLE_HOME = /home/oracle/9.2.0 System name: Linux Node name: rac2 Release: 2.4.9-e.3smp Version: #1 SMP Fri May 3 16:48:54 EDT 2002 Machine: i686 Instance name: rac2 Redo thread mounted by this instance: 0 Oracle process number: 4 Unix process pid: 1634, image: oracle@rac2 (LMON) *** SESSION ID:(3.1) 2002-11-22 03:29:38.649 Batch msg size = 2048 Batching factor: enqueue replay 48, ack 53 Batching factor: cache replay 34 size per lock 56 kjxggin: receive buffer size = 32768 kjxgmin: SKGXN ver (2 1 Oracle 9i Reference CM) CMCLI WARNING: CMInitContext: init ctx(0xacc37e8) *** 2002-11-22 03:29:42.243 kjxgmrcfg: Reconfiguration started, reason 1 kjxgmcs: Setting state to 0 0. *** 2002-11-22 03:29:42.243 Name Service frozen kjxgmcs: Setting state to 0 1. kjfcpiora: publish my weight 152022 kjxgmps: proposing substate 2 kjxgmcs: Setting state to 6 2. Performed the unique instance identification check kjxgmps: proposing substate 3 kjxgmcs: Setting state to 6 3. Name Service recovery started Deleted all dead-instance name entries kjxgmps: proposing substate 4 kjxgmcs: Setting state to 6 4. Multicasted all local name entries for publish Replayed all pending requests kjxgmps: proposing substate 5 kjxgmcs: Setting state to 6 5. Name Service normal Name Service recovery done *** 2002-11-22 03:29:43.397 kjxgmps: proposing substate 6 kjxgmcs: Setting state to 6 6. *** 2002-11-22 03:29:43.507 *** 2002-11-22 03:29:43.508 Reconfiguration started Synchronization timeout interval: 660 sec List of nodes: 0,1, Global Resource Directory frozen node 0 release 9 2 0 2 node 1 release 9 2 0 2 res_master_weight for node 0 is 152022 res_master_weight for node 1 is 152022 Total master weight = 304044 Dead inst Join inst 0 1 Exist inst Active Sendback Threshold = 50 % Communication channels reestablished Master broadcasted resource hash value bitmaps Non-local Process blocks cleaned out Resources and enqueues cleaned out Resources remastered 0 0 GCS shadows traversed, 0 cancelled, 0 closed 0 GCS resources traversed, 0 cancelled set master node info Submitted all remote-enqueue requests kjfcrfg: Number of mesgs sent to node 0 = 0 Update rdomain variables Dwn-cvts replayed, VALBLKs dubious All grantable enqueues granted *** 2002-11-22 03:29:43.868 0 GCS shadows traversed, 0 replayed, 0 unopened Submitted all GCS cache requests 0 write requests issued in 887 GCS resources 0 PIs marked suspect, 0 flush PI msgs *** 2002-11-22 03:29:44.116 Reconfiguration complete *** 2002-11-22 03:29:51.261 kjxgrtmc2: Member 1 thread 2 mounted *** 2002-12-21 04:02:05.645 kjxgrgetresults: Detect reconfig from 0, seq 6, reason 2 *** 2002-12-21 04:01:57.014 kjxgrrcfgchk: Initiating reconfig, reason 2 *** 2002-12-21 04:01:57.014 kjxgmrcfg: Reconfiguration started, reason 2 kjxgmcs: Setting state to 6 0. *** 2002-12-21 04:01:57.021 Name Service frozen kjxgmcs: Setting state to 6 1. *** 2002-12-21 04:04:29.911 kjxgrdtrt: Evicted by 0, seq (7, 6) error 29740 detected in background process ORA-29740: evicted by member 0, group incarnation 7 ksuitm: waiting for [5] seconds before killing DIAG -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
RE: help me find out why rac instance died
Hi Chao: THe Instance 2 in your Cluster (rac2) was dead during the fast reconfiguration (Check the reason in the alert log file.. which says reason 2). You generally do a reconfig (or fast reconfig) when you add/remove instances from the Cluster setup, which is not (I hope) in your case. THere are some kernel events to trace the reconfigurations, and an underscore parameter (I think it is _imr_active !) to disable the 29740 usually not recommended. For investigation , review the check point, LMON trace files and check the OS log files. Best Regards, K Gopalakrishnan -Original Message- Sent: Saturday, December 21, 2002 4:54 AM To: Multiple recipients of list ORACLE-L Hi, I have a rac 9.2.0.2 Database running on RedHat AS2.1,it has been up and running for about 4 monthes(One month ago, i patched it to 9202). Last night, one instance died unexpectedly,while another instance still running.Though not much business is affected, I want to know why it died, But i am unable to find it out, so looking for your help. Here is some information, I tested the interconnect and the service Network card, both running fine(at 7:00 am), and the disk system is also ok. Alert log file: kjxgrtmc2: Member 1 thread 2 mounted *** 2002-12-21 04:02:05.645 kjxgrgetresults: Detect reconfig from 0, seq 6, reason 2 *** 2002-12-21 04:01:57.014 kjxgrrcfgchk: Initiating reconfig, reason 2 *** 2002-12-21 04:01:57.014 kjxgmrcfg: Reconfiguration started, reason 2 kjxgmcs: Setting state to 6 0. *** 2002-12-21 04:01:57.021 Name Service frozen kjxgmcs: Setting state to 6 1. *** 2002-12-21 04:04:29.911 kjxgrdtrt: Evicted by 0, seq (7, 6) error 29740 detected in background process ORA-29740: evicted by member 0, group incarnation 7 ksuitm: waiting for [5] seconds before killing DIAG -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cardinality of indexed columns... how to discover? What is the ma
(Even if you have seen an article in Oracle Magazine that might suggest otherwise). Cheeky :-) --- Jonathan Lewis [EMAIL PROTECTED] wrote: The answer to the question you asked is to check the dba_indexes view for columns distinct_keys and num_rows. HOWEVER - It is not sensible to change a b-tree index into a bitmap index simply because it has a relatively small number of distinct values. (Even if you have seen an article in Oracle Magazine that might suggest otherwise). Bitmap indexes tend to degrade catastrophically as the underlying table suffers inserts and deletes or gets updates to the indexed column. And the probability of contention and deadlock on concurrent inserts/updates/deletes is very high. Before going much further down your current path, you might like to read a couple of articles I've written about bitmap indexes at www.dbazine.com Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 20 December 2002 20:16 the ma I'm constantly finding, in the database that I'm developing/supporting, b-tree indexes on columns with low-cardinality. I generally re-create said index as a bitmap; however I'd like to go through the entire db and identify these cases proactively. Is there a way to determine the cardinality of an index's columns via the dictionary? Also, what recommendations do you have for determining the cardinality percentage that indicates when a bitmap should be used? 10%? 20%? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: password
If this were to be used as a serious security tool, you would be better off studying some of the well known password crackers and duplicating the algorithms in PL/SQL. Sounds like a project to add to my todo list. Actually it's one I've had on the backburner for some time. This can also be done with Perl, of course. If anyone is interested, I would suggest starting with one of the best Unix password crackers, John the Ripper: http://www.openwall.com/john/ TTL, Sean -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: From INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: password
why isn't there a program available that can reverse engineer the code used to encrypt passwords... if username XYZ always has password (encrypted) CBA, you think that it would be easy to figure out the pattern... once you have the pattern it's easy to go back and forth with the password and the encrypted password. Nick: Password encryption is a one-way algorithm. I'm no math genius, but these guys know how to create math such that you can encrypt a string of text, but *CAN'T* reverse the process. This is an age-old method. In fact for years, the unix password file was plainly readable by anyone on the system. In those days, computers weren't fast enough to run dictionary cracker programs. When they became fast enough, people would just go through a dictionary file, and encrypt each word, and simple permutations thereof. When you found an encrypted string which matched your string from the password file, you had a match. Then shadow password files were invented. Anyway, security in Oracle is implemented in somewhat the same way. And just as in the Unix world, if you have the encrypted passwords, you can run a dictionary hack like John the Ripper (http://www.openwall.com/john/) and find passwords which are based on dictionary words. This is an endless game of cat and mouse. Users can't remember complex strings like $rs^tvzH(9, so they either use passwords they can remember, which is insecure, or write them on a post-it. Some people have devised small electronic versions of a post-it with a password, some attached to a keychain, or a program for the palm pilot. But the same problem remains, they're only as good as the password that secures all the others. If you want to go further to the cutting edge, you run into the new field of biometrics. Bruce Schneir has a lot to say about this: http://www.counterpane.com/crypto-gram-9808.html A Japanese researcher named Tsutomu Matsumoto managed to hack fingerprint readers 80% of the time with Jelly Babies!!! http://www.zdnet.com.au/newstech/security/story/0,224985,20265318-1,00.htm http://www.counterpane.com/crypto-gram-0205.html#5 I actually requested a copy of this paper through the mail. It was *VERY* interesting. So don't expect these problems to be solved anytime soon. :-) HTH, Sean -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: From INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Row cache locks on INSERTs with a sequence
It is a common error to assume that v$session_wait is showing a wait time - however if the STATE is __not__ WAITING then the SECONDS_IN_WAIT column is the time since the last wait ended. It's actually the time since the last wait *began*, right? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- Lewis Sent: Saturday, December 21, 2002 3:49 AM To: Multiple recipients of list ORACLE-L On the information as supplied you are correct, the sequence does seem to be the most likely problem. It has occurred to me, though, that the original poster showed us a couple of lines from v$session_wait - without showing the STATE (or is it STATUS) column. It is a common error to assume that v$session_wait is showing a wait time - however if the STATE is __not__ WAITING then the SECONDS_IN_WAIT column is the time since the last wait ended. So perhaps the OP was seeing lots of 'latch wait' recorded as the previous wait whilst the system was busy burning CPU on something else. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- From: Khedr, Waleed [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 20 December 2002 21:11 Subject: RE: Row cache locks on INSERTs with a sequence -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB
Ian, Could you explain how ASSM could be detrimental in a single instance environment ? Vivek, Could you provide details on the issues [BugNos, description of the problem, your findings] you had with ASSM in 9iRAC ? Hemant At 07:09 AM 19-12-02 -0800, you wrote: As part of a RAC benchmark with 9.2 we had faced severe LOCKING on setting segment space management AUTO had to REMOVE it HTH -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 15, 2002 8:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB quotes from Oracle Manuals deleted Bottomline : Either it was a bug or a restriction, it was not possible in 9.0.1 and supposed to be possible in 9.2.0 --- definitely works in 9.2.0.2 Why do you say In a single instance environment unless you are doing something out of the ordinary, use of the clause will probably be detrimental. ? Hemant At 03:03 PM 14-12-02 -0800, you wrote: Was the prohibitition on placing LOB's into tablespaces with automatic segment space management only a bug. I ask because the description of auto segment space management includes the following restrictions quote from 9.0.1 manual deleted One usually associates a bug with something the manual says one can do, but one cannot. I've not seen the 9.0.2 manual. Are the restrictions lifted? In a single instance environment unless you are doing something out of the ordinary, use of the clause will probably be detrimental. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, December 13, 2002 7:19 PM To: Multiple recipients of list ORACLE-L The first time we tried importing our 8.1.5 [OPS] database into 9.0.1 and 9.2.0.1 with EXTENT_MANAGEMENT Local for ALL tablespaces SEGMENT_SPACE_MANAGEMENT Auto we found that tables with LOB segments could not be created. This was a 9.0.1 bug which was expected to have been fixed in 9.2 [I believe it was Bug 1626182, referenced in Note 159078.1] However, after going to 9.2.0.2, I WAS able to create such tables in the database. [the Patchset Notes include a reference to Bug 2326066. Unfortunately, I can't see either bug on MetaLink to verify if both are the same issue] 9iRAC strongly recommends SEGMENT_SPACE_MANAGEMENT Auto instead of using Free_Lists and Free_List_Groups. [Part 3, Appendix B of the 9iRAC Deployment and Performance manual]. Are there any real-life experiences / gotchas with LOB Segments in Locally Managed Tablespaces and Segment_Space_Management Auto ? There seem to be a number of bug-fixes for Segment_Space_Management=AUTO in the 9.2.0.2 PatchSet Release Notes. Hemant K Chitale My web site page is : http://hkchital.tripod.com Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).