Just a simple knowledge base

Find directory with biggest number of files / directories

2011-12-19T22:07:00.003-02:00

Today we had a problem related with a number of files in a directory. We needed to find directories with a biggest number of files / directories in it. Here is a small shell script that will list directories and a number of files/directories in each directory. find . -type d|awk {'print "echo -n "$1".\"\t\"; ls "$1"|wc -l"'} > /tmp/do; . /tmp/do|sort -k 2 -n -r |more Explaining it a little bit

iPhone takes too long to sync

2010-02-22T14:23:00.000-03:00

After changing a notebook I got a following problem. My iPhone was taking an eternity to sync with iTunes. I made a restore - no solution. I made a restore as new iPhone - same problem. After googling a little bit I found that this can be related with "Sync Photos" option. At the moment that I disabled "sync photos" - my iPhone was synced in a couple of minutes. Problem: iPhone is taking too

VMware crashes after updating (upgrading) of host OS (to CentOS 5.4)

2009-11-08T02:38:00.006-02:00

If you have in your hostd.log something like this:Nov 07 21:19:12.648: Worker#23| Caught signal 6 -- tid 31543this can be related with update(upgrade) of host OS.After upgrading of a host OS (CentOS 5.3->CentOS 5.4) I got an issue - a guest OS started to crash. Searching around for a possible cause I found bug post in CentOS bug tracker. Seems that issue is related to glibc update (last version

Twitter tip

2009-08-04T13:48:00.001-03:00

RT @ryancarson: Top tip: You can put a "+" on the end of any http://bit.ly link and see, real time, the pace at which that link is getting shared and clicked

VMware troubles

2009-07-07T10:32:00.004-03:00

Well, I'm not a hardware guru, but from my experience I figured out the following:Dell Servers + QLogic HBA + IBM Storage = troublesDell Servers + Emulex HBA + IBM Storage = working okDell Servers + QLogic HBA + EMC Storage = working okOther one issue is:Any server + Any HBA + Any storage - Fiber Channel Switch = troubles (unclean filesystem on Linux guests with EXT3 filesystem)

"Network Connection Closed Unexpectedly" error while using svn+ssh

2009-05-25T20:26:00.004-03:00

If you got a "Network Connection Closed Unexpectedly" error while using svn+ssh (here is a nice HOWTO) then you should comment (or remove) "mesg y" in /etc/bashrc or in $HOME/.bashrc Worked for me as a charm :)

iPhone speaker too low

2009-02-16T12:24:00.003-03:00

Well, I got a simple accident - "Mozart Chocolate Liqueur" were split over my iPhone 3G. I quickly clean it out, but... Next day I noticed that my iPhone speaker was too low. I was not able to hear it ringing. After looking around for solution I found a post telling that this can be caused by dust. Seems that this is my case (ok, not dust, but a creamy liqueur...). So, I put some music on my

How to sync Google Contacts and Calendar with iPhone

2008-12-03T14:33:00.002-02:00

I've been looking for some simple solution to sync Google Contacts & Calendar with my iPhone on the air (without syncing with my notebook). Finally I found a solution that seems to be working like a charm.https://www.nuevasync.com/Setup process is quite simple and straigh forward.

cfmenu and cfgrid overlap

2008-08-22T17:47:00.003-03:00

If you are using <cfmenu> and <cfgrid> and you have an overlapping of the menu items by cfgrid header (a part of menu is hidden behind cfgrid header) you must add to your CSS a following style:#myMenuId .yuimenu { z-index: 300003;}This problem is caused by some "yui" CSS style with z-index set to 1, while grid related styles have z-index bigger than 200000.

ESX host not connecting to Virtual Center

2008-07-25T12:31:00.005-03:00

We got following problem some days ago:One of our ESX (version 3.5) hosts, after crash, was not connecting to Virtual Center (version 2.5).Solution:Restart management service on ESX hostservice mgmt-vmware stopservice mgmt-vmware startRestart Virtual Center service on Virtual Center server (stop/start on service VMware Virtual Center in Services)One more stuff - if you have a lot of memory on

Creating a copy of the disk (vmdk) in VMware

2008-06-25T16:19:00.005-03:00

When you need to have the a copy of the disk from one VM on the other:Power off source VM, copy your .vmdk files to destination VM (probably you would like to change disk name and flat name - just rename your files and edit smaller .vmdk file to set correct name for flat file).Set new UUID for your copy of your original .vmdk file/usr/sbin/vmkfstools -J setuuid path_to_destination_VM/

Oracle analog of MySQL GROUP_CONCAT function

2008-06-16T16:07:00.004-03:00

I was looking for Oracle analog of MySQL GROUP_CONCAT function. There is a solution on Ask Tom site. So here it is:create or replace type string_agg_type as object ( total varchar2(4000), static function ODCIAggregateInitialize(sctx IN OUT string_agg_type ) return number, member function ODCIAggregateIterate(self IN OUT string_agg_type, value IN varchar2 ) return number, member function

List number of file handles (open files) for each process

2008-05-13T10:40:00.002-03:00

Here is a simple script that will show you a number of file handles (open files) used by each process on your Linux system:ps -e|grep -v TTY|awk {'print "echo -n \"Process: "$4"\tPID: "$1"\tNumber of FH: \"; lsof -p "$1"|wc -l"'} > out; . ./out

& in Oracle insert or update statements

2008-04-28T11:02:00.003-03:00

If you have & or % in your Oracle insert or update statements - you probably would like to do the following:SQL> set define offSQL> [your insert or update query containing & and %]SQL> set define on

Export from Oracle table to CSV file

2008-04-23T19:27:00.004-03:00

Sometimes you need to export result of the query to CSV file. Here is a nice example of how to do this kind of operations.SQL> SET LINESIZE 500 FEEDBACK OFF TRIMSPOOL ON TERMOUT OFF HEAD OFF PAGESIZE 0 TERM OFFSQL> spool outfile.csvSQL> select '"'|| column_1 || '",' || column_2 || ',' || column_3 from mytable where [your where statement]......SQL> spool offSQL> exitIn this case column_1 data will

Cent OS 5.1 + Oracle 10g

2008-04-08T10:12:00.002-03:00

Apart of modifying /etc/redhat-release to "redhat-4", there are a couple of packages that you will need to install in order to make Oracle 10g work with Cent OS 5.1:yum install \compat-db-4.2.52-5.1 \glibc-devel-2.5-18.el5_1.1 \libX11-devel-1.0.3-8.0.1.el5 \libXau-devel-1.0.1-3.1 \libXdmcp-devel-1.0.1-2.1 \libXmu-1.0.2-5 \libXtst-devel-1.0.1-3.1 \mesa-libGL-devel-6.5.1-7.5.el5 \openmotif-2.3.0-

Mac OS & Database development

2008-02-20T18:51:00.002-03:00

Since switching to Mac I was looking for good DB modeling/editing tool that will support Oracle and MySQL databases. Finally I got one... SQL4X Manager J from dbSuite Seems to be a really nice tool.

Leopard terminal and Midnight Commander

2008-02-13T19:03:00.001-02:00

If you use mc while connected to some linux server and you need to select some files - use Ctrl+T

Perl: CPAN or RPM packages?

2008-01-31T01:20:00.000-02:00

Maybe this is just CentOS 5.1 related issue, but... For those of you who will install MailScanner - just a small tip to avoid problems. Spend some time and install required perl modules from CPAN. This will save you some time on fixing SpamAssassin and some other perl modules.

Manually configure Enterprise Manager Console

2008-01-22T13:26:00.000-02:00

Run emca -config dbcontrol db and follow the instructions.

Redo log size & performance

2008-01-21T09:07:00.000-02:00

We got a performance issue with our Oracle 10g. Suddenly the performance was going down and we was getting a significant increase on wait times. After sniffing around and asking a friend we found that:All our performance pick were related with time when our Oracle was writing the archive log.There is a direct relationship between log_buffer, redo log file size and performance.So, here is a tip.

Ctrl+click with two fingers

2008-01-16T22:51:00.000-02:00

Enable Ctrl+click with two fingers click in System Preferences -> Keyboard & Mouse -> Trackpad -> Tap trackpad using two fingers for secondary click. Believe me, it's quite comfortable.

List of all Max OS X keyboard shortcuts

2008-01-16T21:15:00.000-02:00

Will be useful for all Mac users. A kind of 'print-it-and-put-in-front-of-you-until-you-remember'.Mac OS X keyboard shortcuts

Taking screenshots in Leopard

2008-01-16T20:38:00.000-02:00

To take a screenshot in Leopard just press Cmd + Shif + 3 if you want to take a full screen or Cmd + Shift + 4 if you want to take a screenshot of some region. Cmd + Shift + 3 or 4 will make the same, but instead of saving a PNG file to your Desktop will copy a screenshot to clipboard. After pressing Cmd + Shit + 4 you can use:Spacebar - to take a screenshot of window (active or background)Shift

Reverse tunnel with SSH

2008-01-16T20:33:00.001-02:00

When you need to create a reverse tunnel with SSH, just use the following: ssh -R PORT_ON_REMOTE_SERVER:localhost:PORT_ON_LOCAL_SERVER -l LOGIN REMOTE_SERVER