05 | 03 | 2024
Latest Articles
Popular Articles

Administration

Administration

Display # 
Title Created Date Hits
About nologging and direct path load 22 September 2016 5921
About Transaction Slots, initrans and v$transaction 07 March 2012 7644
ADR Automatic Diagnostic Repository 21 March 2010 5699
Archivelogs in the flash recovery area 05 July 2009 28654
ASM 11G enhancements 25 March 2010 4333
Automatic Memory Management 21 March 2010 5626
Bigfile tablespaces 17 March 2010 4884
Cursor (no) invalidation after refreshed optimizer stats 13 October 2011 7734
Database Control Configuration 21 March 2010 10127
Datapump 17 March 2010 6251
Datapump : Enhanced granularity with "EXCLUDE" and "INCLUDE 24 April 2013 21398
Datapump Consistent 17 March 2010 13784
Datapump feature : Attach to and Manage a running Datapump job 03 May 2011 33985
Datapump New 11G options & features 04 May 2011 6729
Deferred Segment Creation 08 August 2010 5216
Detect Oracle Block Corruption 24 March 2010 7116
Discovery of physical layout (database files, temp files, control files redo log files ) 18 March 2010 4439
Dump file headers 18 March 2010 6236
Editions 27 July 2010 8000
Flashback Database 05 July 2009 5889
Flashback database using guaranteed restore points 05 October 2011 2944
Flashback Query 19 September 2010 4064
Flashback Table to a previous state 20 September 2010 6657
Flashback Table to before drop 17 March 2010 4939
Flashback Technology : Overview 12 September 2010 3370
Flashback Versions Query and Flashback Transaction Query 20 July 2011 5385
Get DDL using DBMS_METADATA 18 March 2010 7506
How to change the database characterset ? 22 April 2011 15926
How to create indexes on big tables, fast index creation with the unusable attribute 26 September 2011 13965
How to stop a query or transaction in another session without killing the session 04 January 2013 7098
Instance Discovery 16 March 2012 4556
IPS : Incident Packaging Service 21 March 2010 7674
Lob Segment Administration 18 March 2010 10535
Multibyte characterset and length semantics 18 March 2010 9483
ORA-00054 : resource busy and acquire with nowait specified 13 April 2010 5716
Partition Administration 18 March 2010 6538
PL/SQL invalidations when you enable row movement 22 September 2011 8346
Reclaim wasted space (almost) online 17 March 2010 5823
Reclaim wasted temp space online 03 October 2013 6482
Replace and mirror online redo logs 21 March 2011 6732
Shared Server 05 July 2009 4435
Succeeding with online table redefinition 23 July 2015 9821
Time and SCN functions in the Oracle Database 12 September 2010 8467
Upgrade to 11G R2 25 March 2010 6881
Using DBMS_ROWID to mine the ROWID pseudocolumn 21 March 2011 5212
Validate online physical and logical consistency of the Oracle Database 24 March 2010 12723
Which DDL & DML is possible in read only databases, read only tablespaces and read only tables 10 August 2011 7640