Since 4/5/2012 6:26:45 AM, ctcgag has written 7 articles and participated in 108 conversations. ctcgag signature: ctcgag
ctcgag's articles:
Items(7) /1
behavior of run_on_wait in Parallel::ForkManager063 (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 swap1066 (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 Map157 (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 #2225 (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 updates022 (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 labels1064 (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-circuit330 (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
why db block gets = 0?432 (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!1017 (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 transaction634 (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 works540 (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 ...1330 (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 ?!?324 (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)
Unique constraint and NULL values3630 (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 Oracle733 (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)