In situ structural determination of 3d and 5d perovskite oxides under high pressure by synchrotron x-ray diffraction