stephen.odonnell's articles:

Items(31) /4 Next >> Last >|

MView fast refresh taking long time 4 261 (12/2/2009 3:07:06 PM) comp.databases.oracle.server I have a large table that is replicated from Oracle 10.2.0.4 to and Oracle 9i database using MView replication over the network. The master table is about 50GB, 160M rows and there are about 2 - 3M new or u... stephen

Instantiate different class based on variable contents 4 33 (4/8/2009 8:38:05 PM) comp.lang.ruby Lets say I have a two classes, Foo and Bar. In some code, I have a variable that can either contain the test 'Foo' or the text 'Bar'. If it contains Foo, I would like to call Foo.new (v1, v2), if it contains ... stephen

Hopefully simple regex 4 23 (12/17/2008 10:15:05 PM) comp.lang.ruby Hi, I am trying to make a regex that will capture strings that look like '@string' surrounded by whitespace or at the start or end of a line - here is the spec: require 'test/unit' class RegexTest < Test::U... stephen

enq: tx - contention on selects 7 40 (9/16/2008 11:19:17 AM) comp.databases.oracle.server Oracle 10G R2 on HPUX 64 bit. I see a lot of occurrences in our application waiting on the event enq: TX - contention. What is puzzling me, is that these waits are all generally on select statements (at least... stephen

Analytics question maybe - combine over lapping date rows 5 27 (6/27/2008 4:01:22 PM) comp.databases.oracle.server On Oracle 10G, lets say I have a table that looks like this: create table t1 (key varchar2(10), start_dtm date, end_dtm date); and I have data some of which over laps: insert into t1 values ('1234', to_date(... stephen

same query, different parsing users, different plans ... 9 24 (6/5/2008 1:36:09 PM) comp.databases.oracle.server Oracle 10.2.0.2 on HPUX. I have a fairly simple query that queries from a table T1 and a view V2 (which is just a straight select * from T2). All objects are owned by the same user. If I explain/run my query... stephen

Ruby, HPUX and rubygems 2 29 (5/12/2008 4:05:02 PM) comp.lang.ruby So I have the less than enjoyable of installing Ruby on a PA-RISC HPUX box - HPUX never makes it easy! I managed to get Ruby 1.8.4 installed from the HPUX ports site, but in the installation guide it says they... stephen

Dropping partition, effect on library cache sql 1 33 (4/21/2008 7:52:56 PM) comp.databases.oracle.server I have a feeling I know the answer to this question, but I am struggling to find a confirmation. Oracle 9.2.0.8. If I have a partitioned table (list partitioned), several local indexes and 1 global index and ... stephen

rowid hint in 10G? 3 33 (3/7/2008 2:59:00 PM) comp.databases.oracle.server All, I am trying to prove a test case, and I want to show the different between Oracle doing a full scan in one case, and an index by rowid in another (in my case I know that Oracle is making the correct choic... stephen

Insufficient privs connecting as sysdba on local machine 3 32 (3/4/2008 2:34:19 PM) comp.databases.oracle.server I just cannot get to the bottom of this problem - hopefully someone will have solved it before. I have the dba group added to my osuser (not as a primary group, but as a secondary one): $/env/balaply1>groups ... stephen

stephen.odonnell's replies:

Items(43) /5 Next >> Last >|

Ruby, HPUX and rubygems 2 29 (5/12/2008 4:05:02 PM) comp.lang.ruby So I have the less than enjoyable of installing Ruby on a PA-RISC HPUX box - HPUX never makes it easy! I managed to get Ruby 1.8.4 installed from the HPUX ports site, but in the installation guide it says they... stephen.odonnell (97)

partitioned index problem 2 53 (6/5/2008 8:02:44 AM) comp.databases.oracle.server hi, I've got composite range partitioned index and I want to move it to another tablespace. From dba_ind_partitions - partition X is in tablespace_A From dba_ind_subpartitions - subpartitions of partition ... jacek.rak (1)

same query, different parsing users, different plans ... 9 24 (6/5/2008 1:36:09 PM) comp.databases.oracle.server Oracle 10.2.0.2 on HPUX. I have a fairly simple query that queries from a table T1 and a view V2 (which is just a straight select * from T2). All objects are owned by the same user. If I explain/run my query... stephen.odonnell (97)

Net::SSH problems 4 27 (6/6/2008 11:33:46 AM) comp.lang.ruby I am trying to connect to one of our UNIX servers. I can connect and can validate myself but I cant seem to figure out how to 'cd' to another directory besides my '/home' directory and then execute commands fro... bobsmyph (1)

Hash Clustered Table Question 6 35 (6/10/2008 12:20:34 AM) comp.databases.oracle.server I'm reading Tom Kyte's Expert Oracle Database Architecture about Hash Clusted Tables and have a question about something I'm obviously overlooking. I've never used hash tables before but wanted to experiment... dietzdl (223)

Analytics question maybe - combine over lapping date rows 5 27 (6/27/2008 4:01:22 PM) comp.databases.oracle.server On Oracle 10G, lets say I have a table that looks like this: create table t1 (key varchar2(10), start_dtm date, end_dtm date); and I have data some of which over laps: insert into t1 values ('1234', to_date(... stephen.odonnell (97)

Dynamic Variables 11 25 (7/1/2008 9:45:48 AM) comp.lang.ruby Is there any way in ruby to create dynamic variables? counter = 52 box#{counter} = "cat and dogs" There would be then a new variable box52 Note that this is not a question whether someone should do it or not... shevegen (524)

enq: tx - contention on selects 7 40 (9/16/2008 11:19:17 AM) comp.databases.oracle.server Oracle 10G R2 on HPUX 64 bit. I see a lot of occurrences in our application waiting on the event enq: TX - contention. What is puzzling me, is that these waits are all generally on select statements (at least... stephen.odonnell (97)

Hopefully simple regex 4 23 (12/17/2008 10:15:05 PM) comp.lang.ruby Hi, I am trying to make a regex that will capture strings that look like '@string' surrounded by whitespace or at the start or end of a line - here is the spec: require 'test/unit' class RegexTest < Test::U... stephen.odonnell (97)

Instantiate different class based on variable contents 4 33 (4/8/2009 8:38:05 PM) comp.lang.ruby Lets say I have a two classes, Foo and Bar. In some code, I have a variable that can either contain the test 'Foo' or the text 'Bar'. If it contains Foo, I would like to call Foo.new (v1, v2), if it contains ... stephen.odonnell (97)