I don’t like the ‘C’ word, it’s offensive to some people and gets used way too much. I mean “cloud” of course. Across all of I.T. it’s the current big trend that every PR department seems to feel the need to trump about and it’s what all Marketing people are trying to sell us. I’m not just talking Oracle here either, read any computing, technical or scientific magazine and there are the usual adds by big I.T. companies like IBM and they are all pushing clouds (and the best way to push a cloud is with hot air).
One of the simplest tuning techniques to encapsulate PL/SQL used in APEX within packages, minimising the size of anonymous blocks. This applies to any PL/SQL within the page, including computations, processes, plugins, dynamic actions, validations, shortcuts and dynamic PL/SQL regions.
This change can make a big impact in the execution time of PL/SQL as it's processed at compile time instead of being parsed and compiled at runtime as dynamic PL/SQL.
I’ve previously evaluated MariaDB’s 10.1 implementation of data encryption at rest (
href="https://www.pythian.com/blog/data-encryption-rest">https://www.pythian.com/blog/data-encryption-rest), and recently did the same for Oracle’s implementation (
href="https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.html">https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.html) in their MySQL 5.7.
This Log Buffer Edition rounds up blog posts from Oracle, SQL Server and MySQL.
jq is a
href="http://dbaharrison.blogspot.com/2016/04/jq-really-useful-unix-utility.html">unix utility that can parse json files and pull out individual elements – think of it as sed/awk for json files.
href="https://amitzil.wordpress.com/2016/04/13/analyzing-performance/">thoughts about analyzing performance problems.
Following up from the previous post, given the current sizes of the Partitions (The underlying Tablespace is AUTOALLOCATE) :
SQL> col segment_name format a30 SQL> col partition_name format a12 SQL> l 1 select segment_name, partition_name, segment_type, bytes/1024 2 from user_segments 3 where segment_name like 'MY_PART_%' 4* order by 1,2
Today is a significant day. Well, to me it is – to the rest of you it’s just a Wednesday in the latter half of April, in the mid 20-10’s. Because we count in 10s (probably due to the number of flexible pointy bits on our front limbs, but that is a much debated argument) we have “magic” numbers of 10, 100, 1000 and multiples thereof. As geeks we also have 2,4,8,16,32 etc. And as nerds (but nerds who appreciate certain literature) we have 42. But today is not significant to me for any of those magic numbers.