Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Migration and Modernization
E-Business Suite
PeopleSoft Enterprise
JD Edwards World
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
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums



General Questions


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

how create index file seperatly on exporting DMP
Problems in Improting data from DMP File
Whose responsibility is this?
Spifile or pfile to use... issues
oracle JOB or Cron jobs????
QUERY needed
tnsnames with Database and client on same machine?
Setting the UNIFORM size of a tablespace in OracleDB10g....
oracle backup automatic
Why resetlogs after incomplete recovery with rman ?
system trigger
Urgent !! OEM Agent
list backup of archivelog sequence between 7748 and 7750;
Shutdown abort with lost data file
Row and Column Level Select Permission
deleted data