Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


TUNED_UNDORETENTION


hi. Oracle 10g Is  t true When we set the undo_retention=0, the new UNDO RETENTION will be set to TUNED_UNDORETENTION.  TUNED_UNDORETENTION = MAXQUERYLEN + 300 Sec.

Hi,  According to Note:240746.1, if UNDO_MANAGEMENT=AUTO (no matter the setting for UNDO_RETENTION) automatic undo tuning will be used. If UNDO_RETENTION is set > 0, the value specified acts as a minimum setting ... In addition, Mr. Laurent Schneider has been written an article at his old blog about TUNED_UNDORETENTION  Cheers  Legatti


Related Links

When index lock contention occurs how would I know which index is causing
cannot recreate unique constraint in 11gR2
Login to database takes long time
Moving tables to different tablespace
DBLINK
Index reclaim space.
ORA-01154: On Open After Cold Backup - No DataGuard
Materialized Views
execution plan are different on production and local
Performance Issue : Select Statement
Subquery factoring and DB Link
Extract privileges
Oracle Client 11gR2 11.2.03 - OCI.dll version ?
CPU System Time (%) for multi core system
listner.ora
Better scalability and availability through Oracle DB