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.
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.
Whatever the book, try www.bestbookbuys.com. It does a nice price
comparison between different online obbkstores.
David Wagoner
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.
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
entrie
Call me a boy scout... I still try to overplan and get rid of kinks in
advance (when I get more than one 32 or 64 GB LUN, that is) as the storage
folks really get tired of:
Oh, my I/O problem COULDN'T be caused by how you guys placed stuff on the
frame!! You said it didn't matter where I put thi
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 headac
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.
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 o
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
'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
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 b
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 any
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 any
Consider yourself lucky. We've got a 71:1 ratio here.
"Chuck Hamilton"
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
ma
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
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!).
try 'www.databee.com'
T
19 matches
Mail list logo
