I believe someone else had asked this question before, but I did not see a
reply. Does anyone know the number of transaction slots in the rollback
segment header for block sizes of 4k, 8k, et all?
>From what I have read, for a block size of 2K, its 21 transaction slots.
(Steve Adams at www.ixora.
One of the application users has been complaining that someone keeps
dropping one of his tables. He imports it back, and after a few hours, its
gone again. I tried to turn on auditing for this table when its dropped. I
thought this was possible but looks like its not. I turned on full auditing
fo
Been there... Done that. After we estimated coalescing free space would
take 10 hours.
drop all the objects in the tablespace
delete from fet$ for that tablespace
add a single row in fet$ for the entire tablespace
drop the tablespace (reduced from 10 hours to couple of seconds).
recreate the tab
Forwading an email from a fellow DBA, for your assistance.
hi,
I have a situation over here. Here the environment:
We have a database on hp cluster and the cluster package is not monitoring
the database. Their contention is that if the database goes down due to any
reason the dba should take a l
dgoulet@vicr.
com To: Rajesh Rao/CHASE@CHASE, Multiple
recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Operating System: Windows NT 4.0 with SP 6a
Oracle Version : 8.1.7
We recently migrated an Oracle database from one Windoze NT box to another.
The NT administrators claim that the NT boxes are indentical in all
respects, except that the old one had Service Pack 4. We have recreated the
databa
Thanks Jack. I am aware of this limitation under NT. But what I dont have
an answer for, is why it never happened on the old server. As per business,
there's no drastic increase in the number of connections. Previously, there
used to be about 300-350 connections, but on the new server, it wont go
Hi Gurus,
What's the difference between System Commit Number, and System Change
Number? I know they are not the same. I am looking to read more about them
and how they are incremented viz. Commits, updates to rows, checkpoints, et
all.. Any Good books, sites And not Oracle Docs please...
Tha
"The fact that the industry is trending to a managed service model for
database administration is NOT A BAD thing for salaried DBAs out there. I
think the opposite is true."
So, let us all second the Oracle sales pitch about them managing our
databases for us, and hope to sneak into Oracle ;-)
And how much time will my database take? The database size is 118Gb, the
disk transfer rate is 1 Mbps, the physical memory is 64Mb and two 486's ;-)
Anne
The 'ALTER SYSTEM ARCHIVELOG CURRENT' is the preferred one that should be
used for backup scripts.
The reason being, if you have noticed when you do an 'ALTER SYSTEM SWITCH
LOGFILE', you get the prompt back immediately. This command performs a
database checkpoint, switches to the next log, signa
And I charge less than Steve Adams or Jonathan Lewis (3.5 times lesser),
for 'comparable' features (could be physical). So, hire me, and Save a
million in 5 years.
Who buys that? ;-)
Raj
Hi Fellow DBAs,
I and a fellow DBA are currently debating about how insufficient space in
the archive destination freezes up the DB. He claims that as soon as the
ARCH process is unable to write to the disk, the db freezes. I am of the
opinion that it does not. It will only report an error (Any
201 - 213 of 213 matches
Mail list logo
