I've been tagged 3 times; 8 things about me

Few busy days without any blog reading and after I've gone through my feeds it occurred that I've been tagged 3 times:

1. By Eddie Awad
2. By H.Tonguç YILMAZ
   
3. By Jorrit Nijssen (Jornica)
   

Thanks You for tagging.
Now I feel that I really need to write something about me:

1. I was born and grow up in Krosno in south-east Poland (see satellite picture),
2. I 15th when Communism fall down in Poland. At this moment Poland is member of Schengen Agreement, and I can travel around Europe without passport. Lot of changes in last 19 years,
3. I'm Thawte Web of Trust Notary,
   
4. In 1993 I took 2nd place in Nation Contest in Programming for College Students. Unfortunately I was 6 month too old to take part in international final :(
5. In 1990 I've sold my first program; small DB written in Clipper. I did not think that this program will be used for so many years. In 1999 I had to do some changes to support year 2000,
6. My first program was written in Basic and was run on PSP-80 (page in Polish)
   
7. I'm married and we have 2 daughters (6 and 2 years old),
8. My favourite TV show is Top Gear with Jeremy Clarkson , Richard Hammond and James May.
   

I will not invite anyone directly as I do not want to accused of spam. All my readers that have blogs are welcome to post 8 things about themselves.

Cheers,
Paweł

One Year Blogging

It's one year since I started blogging. It's time for some statistics and summary. During last year:

1. I've published 69 posts - it's 1 post every 6 days (on average)
2. 51 post are about Oracle (74%)
3. Over 29200 page views
4. 84% of traffic comes from Google
5. 35% of traffic is from US, Next on list are: UK (8%), India (7%), Germany (5%) and Poland (4%)

Top 10 of most often visited pages:

1. Oracle 11g new features
2. Restore CONTROLFILE and/or SPFILE from autobackup
3. ORA-03297 on empty datafile
4. ORA-30625 and XMLType
5. Visual SourceSafe - Invalid DOS Path
6. Empty String IS NOT NULL?
7. Oracle XMLType: exctractvalue vs. extract
8. Applying Oracle 10.2.0.3 patch
9. XMLType and Namespace problem
10. UTL_MATCH - String Similarity in Oracle

Most commented posts:

1. Visual SourceSafe - Invalid DOS Path
2. Yet another tokenizer in Oracle
3. Log Buffer #48
4. What tool do you use to make blog backup?
5. Rolling Back the DDL

And finally post that I think are valuable but not so often seen or commented:

1. Moving domain index to another tablespace
2. Monitor progress of long running processes
3. Extracting Data to Excel using only SQL*Plus
4. Rows to single string or aggregating strings
5. Flashback Table and Materialized View – not working together
6. Group Comparison Conditions
7. Search Oracle Blogs - I was before Eddie with this idea; but Eddie has more readers...
8. Binding list variable
9. Blogger Beta Backup tool
10. Moving/Adding Control file when using SPFile
11. Table that cannot be deleted

I hope that in next months I will find time and good subjects to blog about.

Cheers, Paweł

Oracle Blog Aggregators and Bloggers Community

Today I've noticed that my blog became aggregated on official Oracle Blogs site. For me it is really good news as it can bring me more readers. My blog is also aggregated at OraNA.info by Eddie Awad (Oracle blogger of the year 2006) and on orablogs.com by Brian Duff (Oracle employee). Unfortunately I cannot find any of my post on OTN Semantic Web. I hope it will change in near future, as this is still beta release...
For me it seems that latest discussions about Oracle Bloggers community have positive impact. Official list of Oracle blogs not maintained by Oracle employees is more complete now. Also The Pythian Group is doing great job for Oracle community by publishing series of Log Buffer.

Cheers, Paweł

Technorati

I've just created my Technorati Profile, so this post is just to interrelate this blog with my Technorati account.
Paweł

13 – Happy or Unhappy Number?

This is my 13 post. So I’ve decided to make some digression. Usually number 13 is considered as unhappy. It seems not a rule for me. This year 13 is my happy number. On 13th January I’ve signed new job contract. It was just about 13:15 (or might be it was exactly at 13:13). What is more interesting, sum of digits in that date (13-01-2006) is equal to 13 (1+3+0+1+2+0+0+6=13). Number of building I’m now working in is also 13. As for now I’m quite happy in my new job.
Also according to Walter Schneider 13 is definitely happy number. I’ve observed that for me the unhappiest day in month is 26th. In fact it is 2*13. When I use Walters method to it gives me: 26 => 40 (2*2+6*6) => 16 => 37 => 58 => 89 => 145 => 42 => 20 => 4. So 26 is unhappy number and it confirms my observations :).
More on Happy Numbers in Wikipedia.

Cheers, Paweł

About Blog and Me

Hi All Readers! I'm a Software Engineer with many years of experience in developing computer software. I'm mostly working on software that uses Database Systems. In past I was using dBase and Clipper. Since 1996 it is Oracle. I was working on all version since Oracle 7.3 and on many platforms: Novel, Sun Solaris, IBM AIX, Compaq Tru64, Windows. On this blog I want to share my knowledge and experience with all visitors. I hope You will find some interesting and useful topics here. I'll be writing about my current problems and solutions, tricks I use in everyday work, bugs and workarounds, and thinks that are interesting to me, and You might find interesting too. Cheers, Paweł