Re: Catching errors on inserts

2002-08-17 Thread Tim Gorman
Dang! You are *good*!!! Kind of cumbersome to have a full stack trace (i.e. several dozens or hundreds of Kbytes of text to a .trc file) produced for each ORA-1, but that's one helluva cool idea! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

Re: compile invalid objects

2002-08-17 Thread Tim Gorman
Script "gen_recompile.sql" online at http://www.EvDBT.com/tools.htm... As written, it will not execute the generated "run_recompile.sql" script; you'll have to uncomment the HOST command at the bottom to do that. I like to leave it with it's teeth pulled however -- at least at first -- so I

RE: RE: Dba tools on NT

2002-08-17 Thread Cary Millsap
Perl comes with Oracle for Unix too, with 9iAS. Side comment: I think an important part of why Perl is so useful (and so widely used) is the existence of two of the best technical books ever written: * Wall, Christiansen, Orwant: Programming Perl (O'Reilly) * Christiansen, Torkington: Perl

RE: compile invalid objects

2002-08-17 Thread Vergara, Michael (TEM)
I have written scripts like this in the past, but the problem I run into is that recompiling some objects invalidates others, sometimes in a circular loop. What I'd like to find/see/learn-how-to-do is a script that compiles things in dependency order. So far, this capability eludes me. I

Re: compile invalid objects

2002-08-17 Thread Tim Gorman
Circular dependencyoccur inPL/SQL packages only. Circular dependencies are not possible with other types of PL/SQL modules (i.e. functions, procedures, triggers, etc). Think about it - there is a chicken-and-egg problem. Circular dependencies in a compiled environment are impossible unless

Linking during instllations

2002-08-17 Thread ltiu
Linking. During installation of Oracle on Unix/Linux, the installer links 'things'. What are these things that are being linked and why link them during installation? Thanks for any tips. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL

Re: Linking during instllations

2002-08-17 Thread Ray Stell
Note:131321.1 Relinking Oracle Background: Applications for UNIX are generally not distributed as complete executables. Oracle, like many application vendors who create products for UNIX, distribute individual object files, library archives of object files, and some

Re: Linking during instllations

2002-08-17 Thread ltiu
I do not understand? Why is this unecessary on the Windows platform? Thanks for any input. ltiu On Saturday 17 August 2002 18:43, Ray Stell wrote: Note:131321.1 Relinking Oracle Background: Applications for UNIX are generally not distributed as complete executables.

Out of Memory

2002-08-17 Thread ltiu
I am getting: SQL startup nomount ORA-27102: out of memory Machine Specs: 0) Oracle 8i 8.1.7 1) Sun Solaris 8 fully patched 2) SparcStation5 70Mhz 3) 128MB Ram 4) 256B Swap 5) /etc/system set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set

RE: Out of Memory

2002-08-17 Thread Ji, Richard
Your db_block_buffers=1048576 times your db_block_size. If your db_block_size is 8k, you need 8gb of RAM. If db_block_size is 4k, you need 4gb of RAM. Richard -Original Message- Sent: Saturday, August 17, 2002 11:13 PM To: Multiple recipients of list ORACLE-L I am getting: SQL

Re: Out of Memory

2002-08-17 Thread ltiu
Aha!!! I actually copied the init.ora file over from a Oracle9i database and I had to rename db_cache_size to db_block_buffers. Guess, what, now I remember - db_block_buffers are in blocks and db_cache_size are in bytes. So I simply renamed the parameter without changing the number : Thanks