Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TimG

  1. TimG

    How to detect which processes use which sockets?

    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...
  2. TimG

    Tools for large/fast reorgs

    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...
  3. TimG

    ORACLE data block corrupted

    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...
  4. TimG

    Dynamic Partition Names in PL/SQL (8.1.5)

    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...
  5. TimG

    Number of Rollback segments does not exceed 29

    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...
  6. TimG

    Tracing a Process

    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...
  7. TimG

    Dynamic Partition Names in PL/SQL (8.1.5)

    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...
  8. TimG

    Server Replication

    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...
  9. TimG

    Calling a C program from PL/SQL

    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")...
  10. TimG

    shared memory

    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...
  11. TimG

    Calling a C program from PL/SQL

    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...
  12. TimG

    Oracle 7 -&gt; 8 Migration Issues

    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...
See more

Part and Inventory Search

Back
Top