gplivna.blogspot.com
Gints Plivna blog: March 2011
http://gplivna.blogspot.com/2011_03_01_archive.html
These are my thoughts. Mostly about Oracle. Saturday, March 12, 2011. Indexes cannot be used for inequalities? For years and years I thought it was true. Now I'd say it's only partially true. OK it is. True for b-tree indexes (at least there isn't any reasonable effect of using an index for "not eaquals to"), but for bitmaps it's a different answer though. And I mean generally YES, they can be used :). SQL CREATE TABLE test (. 2 id NUMBER PRIMARY KEY,. 3 txt VARCHAR2(10) NOT NULL);. SQL INSERT INTO test.
gplivna.blogspot.com
Gints Plivna blog: February 2010
http://gplivna.blogspot.com/2010_02_01_archive.html
These are my thoughts. Mostly about Oracle. Wednesday, February 17, 2010. Yes, that's the fact - everyone knowing the real situation will start Homeric laughter. It is down, down, down and down again. To be true sometimes it is also up and running. Unfortunately "sometimes" seems to be more and more rarely. Just now the popular entry point tahiti.oracle.com. You don't have permission to access "http:/ www-portal-stage.oracle.com/splash/www/index.html" on this server. Chris Warticki in his blog. Probably ...
gplivna.blogspot.com
Gints Plivna blog: June 2008
http://gplivna.blogspot.com/2008_06_01_archive.html
These are my thoughts. Mostly about Oracle. Friday, June 27, 2008. During my holidays I've been in a 4 days trip to Estonia. For Oracle adepts this is the country where Tanel Poder. Comes from ;). The trip was made up by myself and my wife, during it we drove 1700 km. The general idea was to drive around all Estonia (it is not very big country) and look at some (hopefully) most interesting places. Here are 26 most interesting photos:. A view from Munamagi hill, the highest point in Baltics. Jagala waterf...
gplivna.blogspot.com
Gints Plivna blog: February 2009
http://gplivna.blogspot.com/2009_02_01_archive.html
These are my thoughts. Mostly about Oracle. Saturday, February 07, 2009. Time after time I'm doing something different than databases and Oracle :) One of these things is woodwork. So around the New Year I finished the most recent one - a shelf. Requirements, design and implementation. Fully by me. Here it is just attached to the wall. And now full with stuff. Most of pottery in this shelf is produced by my cousin and her husband. Links to this post. Subscribe to: Posts (Atom). Natural joins are evil.
gplivna.blogspot.com
Gints Plivna blog: December 2007
http://gplivna.blogspot.com/2007_12_01_archive.html
These are my thoughts. Mostly about Oracle. Saturday, December 08, 2007. I've thought for a while about creating an article about the resources available in Oracle problem solving process. Meanwhile Oracle wiki. Was born and already exists for about two months. As it is supposed to be shared and editable resource by everyone in Oracle community I thought that it would be a perfect place for my eventual article for two reasons:. 1) more people hopefully will read it and probably get some help;.
gplivna.blogspot.com
Gints Plivna blog: October 2008
http://gplivna.blogspot.com/2008_10_01_archive.html
These are my thoughts. Mostly about Oracle. Tuesday, October 14, 2008. Mortgage calculator using SQL Model clause. Recently we had local Latvian Oracle day conference. So here is fully functional mortgage calculator using SQL Model clause. There are two variants:. With variable payment each month and. With fixed monthly payment. I've used this site. To get formula for fixed monthly payment required to fully amortize a loan over a term of fixed months at a fixed monthly interest rate. SELECT m 1 month,.
msutic.blogspot.com
Truncating, Rotating, Flushing Listener.log file | Marko Sutic's Database Blog
http://msutic.blogspot.com/2009/06/truncating-rotating-flushing.html
Marko Sutic's Database Blog. Truncating, Rotating, Flushing Listener.log file. Saturday, June 27, 2009. Posted by Marko Sutic. Listener Log file audits trail information which enables us to analyze network statistics, client connection requests, service registration events or other stuff. So it is obvious that listener log can contain very useful information for troubleshooting network related problems. I asked on OTN forums why it stopped on 4 GB's and here is the link to that question:. Oracle 11g intr...
msutic.blogspot.com
MariaDB - Measure Replicaton Lag and Check / Fix Replication Inconsistencies using Percona tools | Marko Sutic's Database Blog
http://msutic.blogspot.com/2015/02/mariadb-measure-replicaton-lag-and.html
Marko Sutic's Database Blog. MariaDB - Measure Replicaton Lag and Check / Fix Replication Inconsistencies using Percona tools. Thursday, February 5, 2015. Posted by Marko Sutic. Percona Toolkit is collection of command-line tools to perform many MySQL tasks like creating backups, finding duplicate indexes, managing replication, etc. In this post I will talk about how to measure replication lag and check/fix replication inconsistencies with this tools:. I am using environment from previous blog post.
nascento.wordpress.com
bobert87 | Bobert
https://nascento.wordpress.com/author/bobert87
Mayo 27, 2014. Mayo 31, 2014. Move (temporally) to another country: Checked, I have lived in The Netherlands for a year. Learn another language: As you might notice, all the other entries of this blog are in spanish. English is my second language. Do a backflip: Yes! I can do a backflip, not only a backflip but a full twist backflip. Well… I don’t know if still can but I did it and caught it on video. Become a video game programmer: YES! Live on my own: Yes, it sucks though. You can do whatever you w...
