Recent content by TimG

We're on HPUX 11.11 and debugging some Apache/BRIO On-demand-server issues. We think the Apache CGI engine has gotten all balled up, so we just want to understand what processes are currently attached to which sockets. Is there a flavor of "netstat" which should do this? The...

Oracle8i has the ALTER TABLE ... MOVE command, which runs in PARALLEL with NOLOGGING.&nbsp;&nbsp;Can't beat it, and it comes with the database.&nbsp;&nbsp;However, if you're not on 8i, then this doesn't help.<br><br>Buying a reorg product perpetuates the original problem.&nbsp;&nbsp;The solution...

Whew! No fun!<br> <br> There's no telling what caused the corruption, but your approach toward fixing it can depend on exactly what object that database block is sitting in the middle of.<br> <br> First of all, the generic approach to fixing any database corruption is to restore from backup...

Jules,<br> <br> Have you tested this? I've never witnessed any difference in performance between explicitly naming a partition in the FROM clause and implicitly specifying it via the WHERE clause. Verify it; it would be a real shame to hard-code something like this for no reason.<br> <br> One...

Yup, you're missing something...<br> <br> The &quot;rollback_segments&quot; parameter in the &quot;init.ora&quot; file is only used for naming those rollback segments to be brought &quot;online&quot; by the instance upon startup. It does not create rollback segments and it does not represent a...

SQL Tracing and TKPROF are certainly your best bet. Another useful indicator is the &quot;session wait&quot; interface, which is comprised of the following V$ views:<br> <br> V$SESSION_WAIT: which is a &quot;real-time&quot; view of sessions and what they might be waiting upon. There is only 1...

Jules,<br> <br> Why do you think that you have to name the specific partition?<br> <br> If you specify the columns comprising the partition key in the predicates of your WHERE clause, it will prune partitions appropriately, automatically.<br> <br> So, if your WHERE clause logically limits the...

Clement,<br> <br> Remember to treat it like either a &quot;cold&quot; or &quot;hot&quot; backup. If you are not in ARCHIVELOG mode, you'd have to make sure that the database is shutdown cleanly and completely first. If the database is in ARCHIVELOG mode, you can go either way...

Update on my previous answer: I recently had the pleasure of using "external procedures" on two recent engagements, and it's great! It's well-documented ("Oracle8 PL/SQL Reference", chapter 10 and "Oracle8 Administration", chapter on "Managing Processes" and demos in "$ORACLE_HOME/plsql/demo")...

The "Installation & Configuration Guide" (ICG) has the correct settings. It's not a size issue; there are very specific Solaris errors in the event that Oracle is requesting too much SHM space. This appears more like Solaris permissions. Log a TAR with Oracle Support, and keep calling them...

Two ways to do this: the old way and the new way.<br> <br> The old way involved using the DBMS_PIPE pipe between the PL/SQL procedure/function/trigger and a "C" program. This package became part of the Oracle RDBMS with 7.0, but there were lots of bugs prior to 7.1.6. It's not very documented...

My experience has been good, as long as the target version of Oracle is 8.0.4.2 or above. 8.0.3 has too many problems, and while 8.0.4.0.0 fixed most of them, it introduced two known problems (with RMAN and Parallel Server) that weren't fixed until 8.0.4.2.<br> <br> 8.0.5 is best; very much...