ctcgag's articles:

Items(7) /1

behavior of run_on_wait in Parallel::ForkManager 0 63 (11/2/2004 7:01:05 PM) comp.lang.perl.misc Parallel::ForkManager allows one to set a code-ref to be run when the parent program has to wait for children to exit (because the limit on number of active children has been met or exceeded). One can set a ti... ctcgag

Materializing an indirect sort using only swap 10 66 (8/16/2004 9:40:09 PM) comp.lang.perl.misc Good day, all. I have a object which has sub-objects. The object only provides one way to re-order sub-objects: a somewhat expensive swap operation. I have code that does an indirect sort of the sub-objects:... ctcgag

Preserve aliasing with Map 1 57 (5/27/2004 3:25:26 PM) comp.lang.perl.misc I had a script whose inner workings (greatly simplified) worked like this: foreach my $r (@record) { my @codes=something($r); foreach my $entry ( grep foo($_), @entry_hash{@codes} ) { next unless defin... ctcgag

very inefficient lob updates #2 2 25 (4/26/2004 6:20:09 PM) comp.databases.oracle.server (Sorry for the wrap on previous version of post) I'm doing a lob update based on primary key, and I get an exorbitant number of consistent gets per execution, 1161 on average: update a_table set clob_column=:p... ctcgag

very inefficient lob updates 0 22 (4/26/2004 6:15:02 PM) comp.databases.oracle.server I'm doing a lob update based on primary key, and I get an exorbitant number of consistent gets per execution, 1161 on average: update a_table set clob_column=:p1 where the_pk=:p2 call count cpu ... ctcgag

scoping, sig handlers, and labels 10 64 (4/6/2004 10:17:30 PM) comp.lang.perl.misc I expect the program below to go into an infinite loop after print 9, but instead it errors out. Why can't it find the label REDO? I plead guilty to leaving a sub through redo, but the rest of it I swear I'm ... ctcgag

NVL doesn't short-circuit 3 30 (11/3/2003 7:49:37 PM) comp.databases.oracle.server I did the experiment below (9.2.0.2, SunOS 5.8), and was very surprised to see that the second expression of the nvl is evaluated even when it's result will be thrown away (i.e., when the first expression is no... ctcgag

ctcgag's replies:

Items(69) /7 Next >> Last >|

why db block gets = 0? 4 32 (10/8/2004 8:02:47 PM) comp.databases.oracle.server 9.2.0.5 version when I connect as hr and turn trace on: select * from regions; output: ....... Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optim... niy38 (57)

My DBA says this can't be done! 10 17 (9/30/2004 11:03:18 AM) comp.databases.oracle.server I can't believe my request for a couple of rows to be added to a view can't be done through Oracle 9.2. But then again, I am application developer and don't know the full limitation of Oracle. So I would like... none4976 (4)

oracle redo log transaction 6 34 (11/12/2004 10:06:27 AM) comp.databases.oracle.server hi, i've read the guides from oracle but don't understand fully how redo logs works exactly. i'm coming from sqlserver world and i know i can't make a comparaison but .... I know that when a redolog is full, t... test9808 (4)

How does spin count really works 5 40 (11/7/2004 7:55:52 PM) comp.databases.oracle.server I have a question on how spin counting really works. Lets assume the default of 2000 on _spin_count. So a latch miss session starts kernel code loop for 2000 times and try it again. My question is does it che... bchorng (22)

Default optimizer_index_caching value DUMB ... 13 30 (10/26/2004 2:01:47 PM) comp.databases.oracle.server Why does Oracle use such silly default values for optimizer_index_caching and optimizer_index_cost_adj? With optimizer_index_caching set to ZERO, we're to assume no index blocks are ever in memory? This is si... domenicg (67)

Rowid generated by Oracle Server ?!? 3 24 (10/25/2004 8:42:23 PM) comp.databases.oracle.server My application doesn�t have any rowid in select list. But, in a deadlock problem detected, the query that was locked had a rowid in the select list and a for update. Can oracle server generated it?!? ... jtoaldo (2)

trying to understand transaction control in pl/sql 19 26 (10/25/2004 12:44:05 PM) comp.databases.oracle.server Hi, I'm observing behavior in 9i about transactions in pl/sql unnamed blocks that seems undocumented (altho I find the existing doc. hard to understand anyway), and I wonder if anyone can explain it in terms o... kquirici (87)

Unique constraint and NULL values 36 30 (10/21/2004 12:45:56 PM) comp.databases.oracle.server I want to enforce such a constraint on a column that would ensure that the values be all unique, but this wouldn't apply to NULL values. (I.e. there may be more than one NULL value in the column.) How can I ach... gusz1 (24)

most frequent error messages in Oracle 7 33 (10/20/2004 10:20:55 AM) comp.databases.oracle.server Hi I'm a student and for a project I need to know what are the most frequent error messages. Is there anyone who knows any surveys done or is it possible to get this information from the data dictionary of som... thjertaas (4)

Determine exact cause of deadlock based on trace file 3 74 (10/19/2004 2:45:05 AM) comp.databases.oracle.server Hi, Below is a deadlock graph from the trace file generated. Kindly help me to derive exact cause and recommended changes in database to reduce the probability of these happening. - The tablespaces are loca... gautrak (8)