Tag Archives: database
Eliminate Idle Redundancy in Your Data Center
Oracle Active Data Guard, with Oracle Database 11g Enterprise Edition, enhances quality of service by offloading resource-intensive activities from a production database to one or more synchronized standby databases. Oracle Active Data Guard enables read-only access to a physical standby … Continue reading
Posted in Database
Tagged Auto, complexity, compromise, Data, database, database oracle, date, disaster protection, Draft, incremental backups, intensive activities, management complexity, online, oracle database, production, production database, replication, replication solutions, Simplify, standby database, standby databases, Technology, test, unplanned outages, unpredictable workloads, use
Leave a comment
Viewing Who’s Using Transaction Undo / Rollback Segment
Here is a script to identify the active transaction are currently using rollback segments or undo segments. Conditions, log into the database as user SYS or SYSTEM or a user who has been in the grant DBA. col o format … Continue reading
Posted in Script
Tagged addr, blinklist, blogmarks, col, Conditions, database, DBA, digg, Draft, format a8, google, grant, netvouz, order, Rollback, rollback segment, rollback segments, script, Segment, segment name, space, SYS, System, technorati, time, time format, Transaction, txt, Undo, user, username, username format, Viewing, xidusn, YES
Leave a comment