Pros
If you get in a good team with a good manager you can find out there will be good work life balance, manager who will communicate your achievements to higher ups and get you good recognition etc. You will be able to negotiate flexible work timings, taking work from home etc. as long as you add good value to the team and manager has confidence in your work there will be no micro management. Since most of the teams work as product based teams, there will be really no tracking of hours / stuff that happens in service based companies.
Kontras
Work locations : 1) Do not expect much facilities like you might get in a MAANG company. Oracle facilities only provide bare minimum. Food is mostly purchased by employees using their own money, you will get parle biscuits / cool drinks etc for free in some campuses and this too varies greatly. 2) There are old and new campuses , some locations in india are basically shared workspaces, all these have varied experiences. 3) Food choices are really limited and management really does not care about food quality even though employees buy and eat. 4) Working in cubicles in disturbance throughout the day , space allocated for 100 people 5 years ago is now allocated to 300 people for example leading to over crowding of campuses. Manager related : If due to your bad luck you have bad manager then life can feel like hell. There will be no work life balance, lot of micro management, too many i mean like 10 hours of daily meetings etc. It all depends on your luck and the team / org you get placed. There are different kinds of teams within same org also it will be a lottery where one starts working. Salary and compensation : Oracle usually offers competitive salary for both campus and lateral hires on par with the market. However for lateral hires folks have to properly negotiate. Once you join for 2 - 3 years there will be no revision of salary as such in most of the teams, even then the amount of revision will depend on your team/ product / manager how they communicate your work. So folks have to be really careful. Most like 99% of the teams will not have any concept of on site opportunities as they are product based teams. If you are looking to switch from service based to oracle you have to consider the point that there will be no on site opportunity and along with that there will be minimal revision of your compensation across the years.