To Technology...

As a computer professional it is a good thing to actively embrace technology which in my opinion very few people do. A Common practice i've seen and faced in this Industry is 'Learn It Your Self', People don readily teach the tricks of the trade. Though a fair deal of the things i write are posted all around, I think it would be a good idea to express things from a learners view. I also have a couple of friends really passionate about technology and who very soon will be a very active part of this blog.

[bitecode]

Obtaining an Overseas License is Melbourne

THIS IS A WORK IN PROGRESS:

There is a lot of information available online on converting an overseas (Indian) license to a Victorian driver license. The idea behind this post is to make things simpler for those who want to pursue obtaining a license without much hassle.

In most scenarios obtaining a Victorian Driver License using your overseas license is very straight forward. 

1. Verify your overseas license with VicRoads:

Call VicRoads and book your appointment. This usually takes 15~30 Days from the day you call in to make an appointment, so make sure you book in advance. Get your license verified. 

One of the pages in VicRoads’ Roads to Solo Driving Manual States that: 

If there is a difference in names between the category A and B evidence documents or if you have changed your name, one document that shows your correct name, for example a marriage or Change of Name certificate.

Just make sure the name on your Passport and Driver License is the same.

If at all it is an option try to get it changed from India, because its a lot of work from here.

In south India we prefer initials over a surname. Read up about the culture of using initials in Southern India. This added a whole new level of complexity. Well, I would be a good living / walking example: name on the license could be Mithun S and the name on the Passport could be Mithun Selvan. In most cases this will be rejected by the License Verification Officer at vicRoads.

So in order to get this right:

a. Get a Notarized document stating that the person on the Drivers License and the Passport are the same. Notary and Attesting of documents will cost you any around $88 to $132 in Melbourne CBD area. This will take around a days time.

b. Next, you will have to apostille the document along with the attested copies of passport and overseas driver license. More info about how to apostille a document here. This will take about 5 working days.

Well, I did seek assistance from a gentleman by the name Charles Reichman who was very helpful and assisted me in doing both steps a and b for me. Contact his office here. This whole process took me about 4 working days.

c. Book an appointment with VFS Global, this process is required because as per VicRoads you will have to get the notarized / apostille document attested by Indian Consulate. You can usually get an appointment the following day. This process will take about 15~30 Minutes of your time. Just make sure you take additional copies of your attested passport copy. This process took us about 3 working days.

d. Yet to attend the License Verification.

2. Road Law Knowledge Test

Call VicRoads, book your Test, clear it and get your learner license.

I booked my test a week after license verification.

<TODO>

3. Hazard Perception Test (HPT)

<TODO>

4. The Drive Test - Overseas Licence Conversion

<TODO>

Disclaimer: Very possible that laws are updated from time to time, these are the steps I had to go through, chances are you may not have to undergo the following, kindly consult VicRoads for more details. 

[thecodinglove]

Rockstar Developer.

View On WordPress

[fishmech]

Attention Australians!

A computer museum warehouse in Sydney is being bulldozed on August 10th and the owners can’t afford warehouse space to house the whole thing. So they’re inviting anyone who cares to drive to Sydney to come by and bring some of the stuff back home with you to do as you please so long as you promise to not let it get wrecked:

https://www.crn.com.au/news/australian-computer-museum-society-collection-faces-bulldozers-499454

Looks like they have a lot of old systems that could be good for slapping in stuff you already have and having a neat vintage system at the least, an dit’s literally just going to get bulldozed otherwise. Plenty of nice vintage monitors for free in among there, and looks to be at least a bit of straight up video game stuff mixed in too

[bitecode]

Hi, Bro... Can you help me? by providing some query for a table which has 5 column as date, ref, debit credit and cumulative balance. what should be the query for cumulative balance column. or cumulative balance query for report building. Please help me. I am a very new learner. My email address is - 'suchandanb@gmaildotcom'

I’m sorry, i hadn't checked my blog in a while, are you still looking for this answer?

[computersciencetumbld]

A Map of World Wide Internet

The top image shows what the Internet looks like in all of its gorgeous motion. The map was generated with a botnet that sent ping requests to large GNU/Linux servers (servers running GNU/Linux comprise about 85%-90% of all internet servers and nodes). This map only includes servers that communicate with IPv4, which most computers still use even though IPv6 is the new standard. As a result, this map is on its way to becoming outdated.

The middle image is me demonstrating a simple ping command in a bash prompt. I show you my Linux Operating system and then ping google’s servers. This map was made in a similar way with ping requests, only it was automated.

The bottom image is a static map of what the botnet itself looks like with concentrations of its 420,000 nodes represented by different colors (red being a greater concentration and blue being a lower concentration).

Credit: Motherboard/Wikipedia

[thingsprogrammersshout]

Things Programmers Shout #72

"My code worked on the first try? Something very, very bad is about to happen.." //submitted by -randomuser-

[bitecode]

Feeling Good @ TR

[foodffs]

Friday…

Really nice recipes. Every hour.

[tylerperryfightclub-deactivated]

yo mama tech jokes fuckin kill me

yo mama so fat she can’t save files bigger than 4GB

yo mama so fat that storing her weight was the driving force behind 64-bit addressable memory

yo mama so fat that her ass made the parallel bus go perpendicular

yo mama is like a global variable, used by everyone

yo mama so dumb she thought MAC addresses were the addresses of Kraft distribution centers

yo mama so ugly PNGs refuse to display her picture losslessly

Yo mama so fat, she programs in C+++

[thethingaboutprogramming]

The thing about programming is that just when you think you’ve solved a problem, things will blow up in a whole new and unexpected direction.

(via thethingaboutprogramming)

[bitecode]

Long Running Queries

Ever had a scenario where a Query ran for days? I had a similar situation where I had to merge a table with precisely 369886655 records to an other table. During this time all I ever heard was a continuous narccisitic question: "when is this going to be over?" I am not the DB server; There is no progress bar, I have no idea!

Consider this use-case: The following is a screen-shot of a query I executed a few days ago... If you took a closer look, You'll notice that the query has been executing for a good 14021 Minutes and 27 Seconds.

So how will I know the completion time? Step 1: Check if the query executed is Active.

This query will check all the active SQL statements...

/*This one shows SQL that is currently "ACTIVE"*/ SELECT S.SID, S.USERNAME NAME, S.OSUSER, T.SQL_ID, SQL_TEXT FROM V$SQLTEXT_WITH_NEWLINES T, V$SESSION S WHERE T.ADDRESS = S.SQL_ADDRESS AND T.HASH_VALUE = S.SQL_HASH_VALUE AND S.STATUS = 'ACTIVE' AND S.USERNAME <> 'SYSTEM' ORDER BY S.SID, T.PIECE;

SL SID NAME OSUSER SQL_ID SQL_TEXT 1 293 IBBS mithun a28gmk7vv5dt4 "/*This one shows SQL that is currently ""ACTIVE""*/SELECT S.SID, " 2 293 IBBS mithun a28gmk7vv5dt4 "S.USERNAME, S.OSUSER, T.SQL_ID, SQL_TEXT FROM V$SQLTEXT_WITH_N" 3 293 IBBS mithun a28gmk7vv5dt4 "EWLINES T, V$SESSION S WHERE T.ADDRESS = S.SQL_ADDRESS AND T" 4 293 IBBS mithun a28gmk7vv5dt4 ".HASH_VALUE = S.SQL_HASH_VALUE AND S.STATUS = 'ACTIVE' AND" 5 293 IBBS mithun a28gmk7vv5dt4 " S.USERNAME <> 'SYSTEM' ORDER BY S.SID, T.PIECE" 6 301 SYSMAN 2b064ybzkwf1y BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END; 7 321 IBBS mithun fnwzpbb6rzwdg "/****IMP****//****PASS_SHEET****/INSERT INTO PASS_SHEET (SEL" 8 321 IBBS mithun fnwzpbb6rzwdg "ECT B.DPCD, B.FACILITY, B.ACID, substr(B.VALUE_DATE, 1, 8), " 9 321 IBBS mithun fnwzpbb6rzwdg "ROW_NUMBER() OVER(PARTITION BY B.ACID ORDER BY B.VALUE_DATE) " 10 321 IBBS mithun fnwzpbb6rzwdg "AS GROUPSEQUENCE1, B.TRAN_PARTICULAR, CASE WHEN B.PART_TRAN_TYPE " 11 321 IBBS mithun fnwzpbb6rzwdg "= 'D' THEN TO_NUMBER(B.TRAN_AMT) END AS DEBIT, CASE WHEN " 12 321 IBBS mithun fnwzpbb6rzwdg "B.PART_TRAN_TYPE = 'C' THEN TO_NUMBER(B.TRAN_AMT) END AS CREDIT, " 13 321 IBBS mithun fnwzpbb6rzwdg "SUM(CASE WHEN B.PART_TRAN_TYPE = 'D' THEN TO_NUMBER(B.TRAN_AMT) WHEN " 14 321 IBBS mithun fnwzpbb6rzwdg "B.PART_TRAN_TYPE = 'C' THEN -TO_NUMBER(B.TRAN_AMT) ELSE 0 END) OVER " 15 321 IBBS mithun fnwzpbb6rzwdg "(PARTITION BY B.ACID ORDER BY B.VALUE_DATE) AS BALANCE FROM " 16 321 IBBS mithun fnwzpbb6rzwdg "B2K_DAILY_TRAN B --ORDER BY 3,4 "

Step 2: Yes, The query is Active. Check for Locks!

Some times the query is executing indefenitely because it may be locked...

/*This shows locks. Sometimes things are going slow, but it's because it is blocked waiting for a lock*/ SELECT SESSION_ID, OBJECT_NAME, OBJECT_TYPE, TYPE, -- TYPE OR SYSTEM/USER LOCK LMODE, -- LOCK MODE IN WHICH SESSION HOLDS LOCK REQUEST, BLOCK, CTIME -- TIME SINCE CURRENT MODE WAS GRANTED FROM V$LOCKED_OBJECT, ALL_OBJECTS, V$LOCK WHERE V$LOCKED_OBJECT.OBJECT_ID = ALL_OBJECTS.OBJECT_ID AND V$LOCK.ID1 = ALL_OBJECTS.OBJECT_ID AND V$LOCK.SID = V$LOCKED_OBJECT.SESSION_ID ORDER BY SESSION_ID, CTIME DESC, OBJECT_NAME;

SESSION_ID OBJECT_NAME OBJECT_TYPE TYPE LMODE REQUEST BLOCK CTIME 321 PASS_SHEET TABLE TM 3 0 0 846312

The LOCK_TYPE is TM which means that it is a Table-level lock and is primarily used to do concurrency control with concurrent DDL operations, such as preventing a table from being dropped in the middle of a DML operation. Read the following for more details on Locks... Locks, During DML Operations The LMODE is the Lock mode in which the session holds the lock: 3 means row-X (SX) Also, Check out the following... v$lock

Step 3: No, The query is not Locked. Check for Total Work/Blocks Pending/Completed.

You can find the total Work Completed from V$SESSION_LONGOPS

SELECT SID, TO_CHAR(START_TIME, 'HH24:MI:SS') STIME, MESSAGE, (SOFAR / TOTALWORK) * 100 PERCENT FROM V$SESSION_LONGOPS WHERE SOFAR / TOTALWORK < 1;

SID STIME MESSAGE PERCENT 321 18:03:53 Sort Output: 958495 out of 1003172 Blocks done 95.5464267343985

Step 4: Time left for the operation to complete.

You could find out the time left for the operation to complete from V$SESSION_LONGOPS

SELECT SID,TARGET, SUM(TOTALWORK) TOTWORK, SUM(SOFAR) DONE, SUM(TOTALWORK - SOFAR) "TO DO", SUM(TIME_REMAINING) "TIME LEFT" FROM V$SESSION_LONGOPS WHERE TOTALWORK <> SOFAR AND SID = 321 GROUP BY SID,TARGET ORDER BY TARGET;

SID TARGET TOTWORK DONE TO DO TIME LEFT 321 1003172 958506 44666 39308

To answer the Narcistic Question: It will roughly take about 39308 Seconds (655.1333333333333 Minutes or 10.91888888888889 Hours) as there are 44666 more blocks in queue...

Further Reading & Credits...

OracleRecipies

stackoverflow1

stackoverflow2

[bitecode]

LOLOL

[bitecode]

Understanding JVM memory

Further Reading & Credits...

Maximum Java heap size of a 32-bit JVM on a 64-bit OS

Understanding max JVM heap size - 32bit vs 64bit

32-bit vs. 64-bit systems

6 Common Errors in Setting Java Heap Size

Java -Xmx settings

Increasing the JVM maximum heap size for memory intensive applications

Maximum Java heap size of a 32-bit JVM on a 64-bit OS

[bitecode]

visualVM unable to detect tomcat at startup

For visualVM 1.3.6

its a bug! check this bug report too!!

By Default JMX is disabled in tomcat

you could download the JMX Remote jar from tomcat extras Or simply add the following code in the Java tab of tomcat7w.exe console

-Dcom.sun.management.jmxremote.port=8082 -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticate=false

As Shown...

Further Reading & Credits...

mattwoodward

[bitecode]

PermGen Java heap

Most Likely Exceptions Are :-

java.lang.OutOfMemoryError: PermGen space

java.lang.OutOfMemoryError: Java heap space

For tomcat 7.0.52

I Think Tomcat's Defaults are lowered in-order to enable developers optimize code as much as possible...

The Default Memory Space Assigned Is :-

Heap Space - Max: 268,435,456 B PermGen Space - Max: 67,108,864 B

This code will be helpful if you are using a non-service-windows-based tomcat deployment...

The following code will exist in the catalina.bat file in case it does not exist, add the same. for starters catalina.bat is the script that is actually responsible for starting Tomcat Locate this file in the Tomcat/bin folder and add the following if this line already exists ignore this...

rem Get standard environment variables if not exist "%CATALINA_BASE%\bin\setenv.bat" goto checkSetenvHome call "%CATALINA_BASE%\bin\setenv.bat" goto setenvDone :checkSetenvHome if exist "%CATALINA_HOME%\bin\setenv.bat" call "%CATALINA_HOME%\bin\setenv.bat" :setenvDone

By default the setenv script file is absent.

Go ahead and add the setenv.bat file which will set the respective user defined environment variables

i.e add setenv.bat and add the following code

set JAVA_OPTS=-Dfile.encoding=UTF-8 -Xms512m -Xmx1024m -XX:PermSize=128m -XX:MaxPermSize=512m

Further Reading & Credits...

MyKong 12Robots stackoverflow stackoverflow for windows service based deployments

[bitecode]

SQL For deriving Running Balance/Total

Create Table as Follows

create table TRAN ( ACID VARCHAR2(11), TRAN_DATE VARCHAR2(20), TRAN_TYPE VARCHAR2(1), TRAN_AMT NUMBER(12,4), TRAN_PARTICULAR VARCHAR2(50) );

Insert The Following Values

insert into TRAN values ('000001', to_date('15-03-2014', 'dd-mm-yyyy'), 'C', 100, 'CREDIT'); insert into TRAN values ('000001', to_date('16-03-2014', 'dd-mm-yyyy'), 'D', 100, 'DEBIT'); insert into TRAN values ('000001', to_date('17-03-2014', 'dd-mm-yyyy'), 'D', 300, 'DEBIT'); insert into TRAN values ('000002', to_date('14-03-2014', 'dd-mm-yyyy'), 'C', 100, 'CREDIT'); insert into TRAN values ('000002', to_date('15-03-2014', 'dd-mm-yyyy'), 'C', 200, 'CREDIT'); insert into TRAN values ('000002', to_date('16-03-2014', 'dd-mm-yyyy'), 'D', 300, 'DEBIT');

This is how the table looks (Select All Values)

SELECT * FROM TRAN; ACID TRAN_DATE TRAN_TYPE TRAN_AMT PARTICULAR 000001 15-03-2014 C 100.00 CREDIT 000001 16-03-2014 D 100.00 DEBIT 000001 17-03-2014 D 300.00 DEBIT 000002 14-03-2014 C 100.00 CREDIT 000002 15-03-2014 C 200.00 CREDIT 000002 16-03-2014 D 300.00 DEBIT

Calculate Running Total

SELECT B.ACID, B.TRAN_DATE, B.TRAN_PARTICULAR as PARTICULARS, CASE WHEN B.TRAN_TYPE = 'D' THEN B.TRAN_AMT END AS DEBIT, CASE WHEN B.TRAN_TYPE = 'C' THEN B.TRAN_AMT END AS CREDIT, SUM(CASE WHEN B.TRAN_TYPE = 'D' THEN B.TRAN_AMT WHEN B.TRAN_TYPE = 'C' THEN -B.TRAN_AMT ELSE 0 END) OVER(PARTITION BY B.ACID ORDER BY B.TRAN_DATE) AS BALANCE FROM TRAN B

The above Query return's the following result

ACID TRAN_DATE PARTICULARS DEBIT CREDIT BALANCE 000001 15-03-2014 CREDIT 100.00 -100.00 000001 16-03-2014 DEBIT 100.00 0.00 000001 17-03-2014 DEBIT 300.00 300.00 000002 14-03-2014 CREDIT 100.00 -100.00 000002 15-03-2014 CREDIT 200.00 -300.00 000002 16-03-2014 DEBIT 300.00 0.00

Further Reading & Credits...

asktom

[bitecode]

log4j minute-wise & day-wise logging

works well with log4j v1.2.17

This code makes the log file rotate either minute-wise(for testing) or day-wise and archive/zip up the old logs...

### Root logger ### log4j.rootLogger=file ### Logger zips file every min ### log4j.appender.file=org.apache.log4j.rolling.RollingFileAppender log4j.appender.file.rollingPolicy=org.apache.log4j.rolling.TimeBasedRollingPolicy log4j.appender.file.rollingPolicy.ActiveFileName=/logs/log.log #uncomment the underlying line to log every day #log4j.appender.file.rollingPolicy.FileNamePattern=/logs/log_%d{yyyy-MMM-dd}.log.gz #this line backs up log file at the end of every minute log4j.appender.file.rollingPolicy.FileNamePattern=/logs/log_%d{dd-MMM-yyyy-HHmm}.log.gz log4j.appender.file.layout=org.apache.log4j.PatternLayout log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c:%L - %m%n

Prerequisites

log4j-1.2.17 log4j-extras-1.2.17

Further Reading & Credits...

Apache API 2min