laimisnd.wordpress.com
January | 2014 | Laimis Oracle blog
https://laimisnd.wordpress.com/2014/01
Oracle database issues diary. Monthly Archives: January 2014. Nls length semantics=CHAR again. January 22, 2014. Check nls length semantics=BYTE again. And again. And again. When collecting statistics got ORA-20002: Version of statistics table … is too old.Please try upgrading it with dbms stats.upgrade stat table Know why? Because the statistics table was created with nls length semantics=CHAR. Oracle compares etalon table … Continue reading →. SQL directives beat SPM. Oracle database on Amazon RDS.
laimisnd.wordpress.com
unaccounted time in v$sql elapsed_time >> cpu_time + user_io_wait_time + concurrency_wait_time + etc | Laimis Oracle blog
https://laimisnd.wordpress.com/2014/06/05/unaccounted-time-in-vsql-elapsed_time-cpu_time-user_io_wait_time-concurrency_wait_time-etc
Oracle database issues diary. Recovery, incomplete, consistency, datafile headers, checking, minimum SCN. Log writer latency →. Unaccounted time in v$sql elapsed time cpu time user io wait time concurrency wait time etc. June 5, 2014. Regarding unaccounted time in v$sql, when elapsed time is much bigger than cpu time user io wait time concurrency wait time etc. One reason: Log writer waits are not included into user io wait time – it is truly a USER io time. This entry was posted in Uncategorized. Orri o...
laimisnd.wordpress.com
August | 2013 | Laimis Oracle blog
https://laimisnd.wordpress.com/2013/08
Oracle database issues diary. Monthly Archives: August 2013. Upgrade to 11g: 11g raises error but Oracle 10g not for ambiguous ANSI joins. August 22, 2013. Beware: Metalink note: Bug 5368296 ANSI join SQL may not report ORA-918 for ambiguous column Long story short: Oracle 10g does not raise error for ambiguous columns missing aliases. Oracle 11g catches the ambiguity meaning that for good or for … Continue reading →. Upgrade to 11g: XML function ExtractValue: Additional Spaces and Line Feed. Orri on OMO...
laimisnd.wordpress.com
February | 2014 | Laimis Oracle blog
https://laimisnd.wordpress.com/2014/02
Oracle database issues diary. Monthly Archives: February 2014. 11g ora-1555 on activated standby after migration from 10g. February 27, 2014. Switched over or failed over Standby is compromised by ora-1555. Version 11.2.0.4 Migrated from 10.2.0.4 Thousands of standby index pages (blocks) corrupted by “Page 424697 failed with check code 6056” as reported by dbv and the corrupted page count increasing. … Continue reading →. Licensing: force collection of dba feature usage statistics. February 25, 2014.
laimisnd.wordpress.com
April | 2013 | Laimis Oracle blog
https://laimisnd.wordpress.com/2013/04
Oracle database issues diary. Monthly Archives: April 2013. OMON: analysis of one incident. April 18, 2013. Storage syncronization to mirror took too long at 11’th Apr. Omon “physical reads” graphs indicated a clear peek of physical reads. 24 hours graph: A few weeks graph: A few weeks graph aggregated into 200 bars: AWR … Continue reading →. SQL directives beat SPM. Oracle database on Amazon RDS. Unaccounted time in v$sql elapsed time cpu time user io wait time concurrency wait time etc.
laimisnd.wordpress.com
November | 2013 | Laimis Oracle blog
https://laimisnd.wordpress.com/2013/11
Oracle database issues diary. Monthly Archives: November 2013. LIKE operator and Underscore. November 12, 2013. Performance problem to be expected with LIKE-operator and underscore character being part of the query parameter, see a new example: Assuming absolute majority of peoples are good, some are bad and few are ugly: select * from folks where personality type … Continue reading →. 11g slow drop tablespace including contents and…. November 7, 2013. SQL directives beat SPM. Build a website with WordPr...
laimisnd.wordpress.com
OMON – a browser based tool to browse AWR/PERFSTAT | Laimis Oracle blog
https://laimisnd.wordpress.com/2012/11/23/omon-a-browser-based-tool-to-browse-awrperfstat
Oracle database issues diary. Excessive transaction tables consistent reads – undo records applied in 11.2.0.3 – Part II. Bugs series: Skip using IGNORE ROW ON DUPKEY INDEX Hint in 11.2. Wait until 12c →. OMON – a browser based tool to browse AWR/PERFSTAT. November 23, 2012. Omon is a tool to output in graphical form AWR/PERFSTAT data. All it needs is a running Oracle HTTP server in any form (as long as it supports mod plsql) and 10g database to hold OMON PL/SQL stored procedures and few tables. Bugs ser...
laimisnd.wordpress.com
May | 2014 | Laimis Oracle blog
https://laimisnd.wordpress.com/2014/05
Oracle database issues diary. Monthly Archives: May 2014. Diag and Tuning Pack: disable. May 29, 2014. Disable Diag and Tuning pack (oracle 10g and 11g) – Baselines must not be used: begin for m in (select * from dba hist baseline where baseline name! 8216;SYSTEM MOVING WINDOW’) loop sys.dbms workload repository.drop baseline(baseline name= m.baseline name,cascade= true); end loop; end ; / – Manual Snapshots must not be … Continue reading →. SMON rollback/transaction recovery disable, drop object.
datavirtualizer.com
Data Virtualizer » Oaktable World
http://datavirtualizer.com/oaktable-world
Free your data and the rest will follow! Oaktable World past years. Delphix & Oracle 12c. J Lewis on Delphix. February 17th, 2016. Follow us on twitter. Planning for Oaktable World 2015. Planning starts earlier and earlier each year. The first year 2012, I started up the conference two week before the event! Thanks to all the help from Oaktable members we pulled off an awesome conference. Wow. Every year we try something something different. What will 2016 hold? And of course still have all the great bit...
ofirm.wordpress.com
The end of the classical MPP databases era | Big Data, Small Font
https://ofirm.wordpress.com/2013/07/28/the-end-of-the-classical-mpp-databases-era
Big Data, Small Font. Ofir's random thoughts of data technologies. Skip to primary content. The end of the classical MPP databases era. July 28, 2013. Over the years, enterprises realized that their many isolated systems generate a vast amount of data. What if they could put all that massive data into one centralized platform, correlate it and analyze it? Surely that would uncover a wealth of relevant, hidden business insights. Of course, those were the eighties ( actually earlier. So, what happened?