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:
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
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
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
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 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
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
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.
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
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
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
11 matches
Mail list logo