Like Angus and JavaMac are saying, if you write multithreaded code the OS can schedule different threads on different CPUs without you having to do anything else. So what kind of information are you looking for for G4's specifically?
The assembly level coordination instructions (unnecessary if you use a higher level like Java, mutexes, NSLock)? Specifics about G4 cache coherency / cache size / etc to try to optimize your app to avoid cache aliasing during multiprocessing? Altivec code, maybe?