bijgaa.blogspot.com
ORACLE : DATABASE قاعدة بيانات Base de données: juillet 2014
http://bijgaa.blogspot.com/2014_07_01_archive.html
ORACLE, Performances, PL/SQL, SQL, TUNING, Upgrade. Collected posts: Oracle, SQL, PL/SQL, Performance, Security.(More than 300 blogs). Ask Tom MOST RECENT ARTICLES. Oracle 11g Database , and Weblogic Server 11g Forms , Reports and facing dead slow. I am using Oracle 11g Database , and Weblogic Server 11g Forms , Reports and facing dead slow issue at developers level as well as user level. i test 6i fo. Il y a 2 heures. Joords Oracle DBA blog. Single Database High Available with Oracle Clusterware. Server...
uhesse.com
Data Guard | The Oracle Instructor
https://uhesse.com/tag/data-guard
Explain, Exemplify, Empower. Posts Tagged Data Guard. Another reason why you should use the Data Guard Broker for your #Oracle Standby. Posted by Uwe Hesse. On May 18, 2016. The Data Guard Broker is recommended for various reasons,. This one is less obvious: It prevents a Split-Brain problem that may otherwise occur in certain situations. Let me show you:. Oracle@uhesse ]$ dgmgrl sys/oracle@prima. Oracle@uhesse ]$ ps -ef grep smon. Oracle 6279 1 0 08:30? 00:00:00 ora smon prima oracle 6786 1 0 08:32?
uhesse.com
Exadata | The Oracle Instructor
https://uhesse.com/exadata
Explain, Exemplify, Empower. This page lists my Exadata related postings. I’m a certified Oracle Exadata Database Machine X3 Administrator. Exadata Part I: Smart Scan. Exadata Part II: Storage Index. Exadata Part III: Compression. Exadata Part IV: Flash Cache. Exadata Part V: Monitoring with Database Control. Exadata Part VI: Cell Administration with dcli. CELL PARTITION LARGE EXTENTS now obsolete. No DISK REPAIR TIME on Exadata Cells. Invisible Indexes & Exadata. Exadata Quarter Rack Architecture Picture.
uhesse.com
Invisible Indexes & Exadata | The Oracle Instructor
https://uhesse.com/2011/05/05/invisible-indexes-exadata
Explain, Exemplify, Empower. Laquo; Now OCM for 10g AND 11g. My Exadata Series made it into the OU Newsletter. Invisible Indexes & Exadata. You may have noticed that we introduced. As an 11g New Feature. Their main benefit is that we can test whether performance differs if we would drop an index. Without actually dropping it. This is particular useful after an Exadata Migration because we expect that some conventional indexes migrated are now obsolete and may be substituted by Storage Indexes. Index alte...
uhesse.com
Uwe Hesse | The Oracle Instructor
https://uhesse.com/author/uhesse
Explain, Exemplify, Empower. This user hasn't shared any biographical information. Homepage: http:/ uhesse.com. How to fix a problem with the spfile in #Oracle. On August 31, 2016. An invalid entry in the spfile may prevent the instance from starting up:. SQL alter system set sga target=500m scope=spfile;. System altered. SQL shutdown immediate. Database closed. Database dismounted. ORACLE instance shut down. SQL startup. The instance doesn’t come up! File created. SQL startup. On August 9, 2016. ADAM@pd...
uhesse.com
OU course formats | The Oracle Instructor
https://uhesse.com/ou-course-formats
Explain, Exemplify, Empower. Oracle University (OU) course formats explained. Over the years, we have developed various different course formats, each for a good reason. This can be sometimes confusing for (potential) attendees as I know from many events where I talked about that topic with participants of my courses. If you want to get Education from Oracle University or if you are an OU Sales person or Reseller, you may find the following brief explanation helpful. ILT comes in two formats:. Means we h...
uhesse.com
Reorganizing Tables in Oracle – is it worth the effort? | The Oracle Instructor
https://uhesse.com/2010/08/23/reorganizing-tables-in-oracle-is-it-worth-the-effort
Explain, Exemplify, Empower. Laquo; Using Flashback in a Data Guard Environment. Data Guard and Oracle Restart in 11gR2. Reorganizing Tables in Oracle – is it worth the effort? This topic seems to be some kind of “Evergreen”, since it comes up regularly in my courses and also in the OTN Discussion Forum. I decided therefore to cover it briefly here in order to be able to point to this post in the future. Short answer: Probably not. SQL select * from v$version;. CORE 11.2.0.1.0 Production. SQL delete from...
bijgaa.blogspot.com
ORACLE : DATABASE قاعدة بيانات Base de données: novembre 2014
http://bijgaa.blogspot.com/2014_11_01_archive.html
ORACLE, Performances, PL/SQL, SQL, TUNING, Upgrade. Collected posts: Oracle, SQL, PL/SQL, Performance, Security.(More than 300 blogs). Ask Tom MOST RECENT ARTICLES. Oracle 11g Database , and Weblogic Server 11g Forms , Reports and facing dead slow. I am using Oracle 11g Database , and Weblogic Server 11g Forms , Reports and facing dead slow issue at developers level as well as user level. i test 6i fo. Il y a 2 heures. Joords Oracle DBA blog. Single Database High Available with Oracle Clusterware. Server...
uhesse.com
TOI | The Oracle Instructor
https://uhesse.com/category/toi
Explain, Exemplify, Empower. Archive for category TOI. How to fix a problem with the spfile in #Oracle. Posted by Uwe Hesse. On August 31, 2016. An invalid entry in the spfile may prevent the instance from starting up:. SQL alter system set sga target=500m scope=spfile;. System altered. SQL shutdown immediate. Database closed. Database dismounted. ORACLE instance shut down. SQL startup. ORA-00821: Specified value of sga target 512M is too small, needs to be at least 1392M. File created. SQL startup.
uhesse.com
Multiple invisible indexes on the same column in #Oracle 12c | The Oracle Instructor
https://uhesse.com/2015/07/28/multiple-invisible-indexes-on-the-same-column-in-oracle-12c
Explain, Exemplify, Empower. Laquo; AUDIT SYS OPERATIONS defaults to TRUE in #Oracle 12c. Less Performance Impact with Unified Auditing in #Oracle 12c. Multiple invisible indexes on the same column in #Oracle 12c. After invisible indexes got introduced in 11g,. They have now been enhanced in 12c: You can have multiple indexes on the same set of columns with that feature. Why would you want to use that? Oracle@uhesse ]$ sqlplus adam/adam. SQL select index name,index type,visibility from user indexes;.