Recent content by sjwales

We have PTF 4 at the moment with the ifix and have just received word from Mincom this morning that we need to apply PTF 6 to correct another problem that we're having in another region. So that's on the slate here pretty darn quick :) Also, the message is usually something like this...

Thanks for the followup. We upped our maxssiz last reboot anyway - seems to have reduced the aborts, but hasn't eliminated them. As a curiosity, what is your maxssiz set to? We have a couple of other parameters less than what yours are set to, I might have to do a little more research on them...

Well, well, I had another look this morning, and now both program and module are reporting "CVORA8.EXE", which gives me something to play with. Now, writing login triggers is not something I've done before - would someone have an example of a trigger at login that checks the program and/or...

One of the application administrators set foot in my office today (how dare he!) and started off a question with "In the SQL Server World....". Apparently, in SQLServer, there is a way to say that if user Bob is trying to connect through MS-Excel, then we allow it, but if he tries to connect in...

(This is probably more Perl related, and I've posted the same message in the Perl forum, but in case anyone here uses the tool and has come across this before - or a similar problem) I use a tool called OracleTool (http://www.oracletool.com) to help with certain DBA functions on my Oracle...

I use a tool called OracleTool (http://www.oracletool.com) to help with certain DBA functions on my Oracle databases. I had been happily plodding along on oracletool 2.0 for that last 2 years, I visited the site and saw that there was a newer version, version 2.2. So I downloaded and installed...

We run CICS/TX-Series 5 (CICS at PTF 4, Encina to PTF 3) on HP-UX 11.11 with Oracle 9. In one of our regions, we keep getting core dumps in /var/cics_regions/<region> for that region. We've been wondering what's been causing them and I think I finally found a connection yesterday. I was...

Have you tried Oracletool? It's free, completely server based and has a page to enter executable SQL. Speaking of which, it's time to update my copy to the latest version. Steve

Dave, Thanks for the reply. Actually, you are right, we are using DMT. I'm in the process of doing a reorg for LMT with uniform extent sizes over several different tablespaces based upon size of the objects. I ended up going to see a play this afternoon, after I posted the first message in...

I've got two tables in one of my databases each currently with 102,650 extents. At one stage, they had a lot of rows in them, but now they have very few. I want to reclaim this space drop exporting, dropping, recreating and importing them. However, it's the truncate and delete that I'm...

On a lark, I went to this page and did a little research. if you're really keen to read it do this: Go here: http://world.altavista.com/ Enter the web address above into the "Translate Web Page" field, select Russian to English and go. It presented me a page in English - don't know how good...

I did a little test on this. Looks like you can escape the "\" to pass a "\" through to your script: Report1 MSR010 MSR010 -Description Table_File_Report -Report A Report1 MSR010 EXEC -PARAM sjwtest 'c:\\program files' The script sjwtest looks like this: echo $1 $2 $3 >...

Yeah, I had the rm *mmap* epiphany on Saturday evening before I'd seen this post. That was the missing link in my puzzle. Thanks stephen.wales@riotinto.com

I'm doing some work on an old machine that is running HPUX 10.20, Oracle 733, MIMS 4.1 and TP 2o (told you it was old :)) Was trying to copy to a testing machine - and couldn't get the 2o to compile. Had a tar of a 1r TP lying about so I thought to myself "Self, let's try to install that"...

As an aside, each of the views in the above query is made up of, effectively: select * from table a, security_view b where a.dstrct_code = b.dstrct_code which makes sure that each user can only select data from authorized districts. Running the query against the base table runs in < 1 minute...