try 'www.databee.com'
gs.natesh@iflexsolutio
ns.com
Frighteningly enough, Damian Conway has produced some wonderfully hideous
Perl modules that allows you to write your code in Klingon. It even does
it in object-oriented style (method overloading in Klingon - ack!).
Shell - I have used Unix Shell Programming revised Edition by Kochan and
Wood extensively. It's really all I use for shell programming problems.
It's well-written and not a dry read.
Perl - most everyone I can think of will point you to the O'Reilly library
of Perl books, starting with Learning
We've run into this with Backtrack 3.3, which is also supposed to support
8.1.7.x. If I recall correctly, the temp tablespace is there, but offline.
We usually have the create scripts for the database in question, so we just
drop the tablespace and recreate it. We usually create it as locally
Consider yourself lucky. We've got a 71:1 ratio here.
Chuck Hamilton
We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP
to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size
from very small (1 GB) to production-sized. About 1/3 of the production
databases have at least 1 (usually more) development effort going on at
We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP
to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size
from very small (1 GB) to production-sized. About 1/3 of the production
databases have at least 1 (usually more) development effort going on at
Depends on what you consider to be 'real' production issues. We get pages
for production and development, for things that really should be planned
change control, for idiot user stuff, as well as the regular db/listener
down, ora-0600 and the other standard stuff.
With most of the applications
'Programming the Perl DBI'. The DBI and DBD::Oracle man pages/perldoc is
probably sufficient for basic (unoptimized) stuff. There's multiple
tutorials on the web, as well. Check dbi.perl.org
Does this mean the 'use Oraperl' and the oraperl subroutine syntax (like
ora_login) would be deprecated?
I wouldn't ordinarily care, as I haven't used that syntax for years.
However, quite a few of our application areas wrote entire applications
using oraperl. Just getting them to plug a 'use
Question:
If some idiot decides to circumvent Oracle's referential integrity and
re-implement it by using triggers (insert, update, delete) that checks the
foreign (parent/child) key fields in other tables like this,
declare numrows INTEGER;
begin
-- ApplicationForm is used if the state and
I thought as much, from what I've heard and read. Does anyone know if
there's a way to figure out how much overhead the switches generate? I'm
guessing they would show up in trace files in the 'other CPU' category.
Our storage team won't even respond to me anymore when I ask for the
manufacturer's rating for non-cached I/Os per second number of
controllers, RAID level, striping, etc... All I get is 'why do you want to
know that' and 'what application is this for'... BARRF will stop the
debilitating
We have used names for about 7 years or so, starting with 7.3. We have
400+ databases that everyone (around 6000 clients from all over the U.S.)
connects to via names. We are running one names database (hotcopied to DR
every night) and 4 names servers. Names is fast - it cahces all of the
I seem to recall from Jonathan Lewis' book that moving a LOB index after
creation was possible in some versions of 8.0, but no longer possible in
8i. Unfortunately, I don't have the book in front of me right now so I
can't say for sure.
Whatever the book, try www.bestbookbuys.com. It does a nice price
comparison between different online obbkstores.
David Wagoner
I'm doing some departed user cleanup and the 'drop user cascade' hangs
for 2 -3 minutes before completeing. I ran a 10046 trace and it does a lot
of waiting for 'library cache pin' - 100 times for 308 centiseconds each
time. Dropped two different users, 100 library cache pin waits per user.
The date has not been announced. I contacted The OCP folks late last month
and they said that there has been no date set for ending the 8i OCP tests,
nor was he aware of anything being said about it.
18 matches
Mail list logo
