Hello guys, my colleague said he's facing issues with his client's Oracle database. He said it took his team 8 weeks to query the database. Database size is 3TB. Eventually, he wants to delete all data from the database and then shrink the database. The deletion will probably take forever to happen too. How can he optimize queries to the database? And how can he eventually delete all data fast and shrink the database successfully?

like
Posting as :
works at
You are currently posting as works at

Related Posts

Hi guys
I am a front end developer with 5.7 years of experience. I have two offers in hand
1) cropin technologies prod based company in Bangalore offering 27lpa all fixed
2) ciklum service based but client I will work on is VMware and offering 30 lpa all fixed with joining bonus of 1 lpa
Kindly suggest which should I choose?

Hi Fishes,
Please suggest a good project for java and spring boot developer in ibm ..Am looking for good tech stack and WLB

like

Hi Guys, I have 15 years of experience in IT..the experience is in different domains including project management.Now i am getting offer for both project management and technical roles.I am confused, should I go for PM role or technical role as an cloud architect.

like

Hi People,
Please let me know if teams in Novartis are helpful to newbies! Does Novartis have an agile or a standalone working environment.

Do people get help in code if they get stuck anywhere in any project?

Await replies🙂

Let's say you work remotely full time in private/group practice. Mental health or Wellness.
What's your maximum client load for a week? 20? 30? ... 10?

like

I am a contract employee that was just brought on a month ago. I have done well with onboarding and learning their tech. I have now been asked to design an architecture for an upcoming project, and document it all. Nothing at this company has been well documented before. I have a feeling they just planning to use my previous experience and then let me go since my pay is high. Is there a way I can safeguard against this?

I join tcs by changing my profile and my previous exp was in 5 yr pre-sales.
I am giving my best in work but still escalations are raised against me by client.
My husband is also in tcs he is moving to onsite in Jan and my travel is also planned mid next year.
I am giving 12hour daily in my job to adjust in new profile. And affecting my health now.
Shall I quit the job and move with my husband with on dependant visa? Or i shall continue to get pressurized and wait for my onsite?
Plz suggest.

What are some brands with an in-house agency? Looking to make a move to client side.

Hi Guys,

I have an OL from LTI with a CTC-20 Lpa..As my mother had brain surgery, i need to be with her. i have asked HR to provide WFH. Does LTI support in these kinds of cases?? I have also asked HR to set up a call with the Project Manager.

Comments pls ..

like
like

What matters more early in your career, agency name recognition or project experience?

Anyone has insights into NASCO project for Pega in IBM ? How is the work, WLB and management? Also how much hike can be expected per year in IBM ?

Got my Veteran Business Enterprise and Small Business Certification through California today for my LLC. Marketing my Freelance/Contracting service as a business to help brand myself in this freelance market.

If your agency would like to contract my Art Direction / Senior Art Direction / Content Creation services feel free to message me. My "book" won't be ready with my updated client work until the start of 2022 but you can check the LinkedIn for now if you'd like.

like

Hello! I am a Technical Sourcer/Recruiter at a reputable FinTech company. I would like to transition into Project Coordination/Management within the tech space. Any tips for the transition? Recruiters: I am open to entry level & contract roles to gain experience! Thanks in advance for the assist!

How does project allocation happens for lateral joiners? Is it forced upon or do we get a choice to choose or apply for a project? Accenture

like

💡 Did you know: a pro se litigant has a fool for a client.

like

Hi Fishes,

I have offer from both nagaroo and Publicis sapeint. Project is not decided in PS but Nagarro hire me for the ZS Client itself.

I am looking for job security, wlb and good project to work on.

Fishes, can you please suggest which should I join?

like

The thing I struggle with the most on a project is being able to quickly understand the business process of the clients across different industries. Any tips or resources I can use to improve that?

like

How is optum for java 6 years of experience interms of wlb. I want to know the sprint howmany days and howmany days release will happening in project?

like

More Posts

Any REIT ETFs that people like?

like

What is the best advice you would give to a junior account manager?

like

I’ve been in tech sales for 20+ years. Have an opportunity to take a position at a tech company in Sales Enablement. Anyone have some insight into this type of role? Is it interesting, challenging, collaborative?
Thinking about coaching others in sales could be fun for me at this stage.
Would love some input as this is a new field unfamiliar with.

like

Guys - A seasoned BSA looking for PO / PrM opportunities in asset and wealth management firms. Is anyone willing to refer me to their team or forward me to their acquaintances? Appreciate it.

like

Has anyone talked to their employer about being out of state until next year (because they have moved elsewhere during WFH)? I have been out of state for a few months and considering whether to break my lease and formally move. Do employers care?

like

Citiustech Healthcare Technologies

How is Citiustech to work with and how is the work Life balance and security aspects here?

Looking for remote healthcare opportunities in business ops or project management. Recommendations welcome.

like

Looking to make a career move. Pros and cons for going into the music space- go

Hi Fishes, I've accepted offer from Accenture from their portal.. But now got new offer from EY and wants to join at EY. So how can I tell Accenture Accenture India that I'm not going to join them. Rather than not showing up on the date of joining? Can you please guide me? How do I let them know? My talent coach is not reachable

like

Hi HSBC sharks, my CCTC is 17.4LPA (Fixed). I have been offered a position at HSBC for Senior Analyst position. They are not offering a single rupee more than 30% i.e., 22.6LPA. What can I do to ask for more? Or it is their maximum at this position? Please help

like

How are the projects related to .Net,.NetCore and .Net azure in IBM ? Can we easily get after joining IBM ?

like

Thoughts on moving from SAP implementations to FP&A role? Has anyone gone down this path? What would career progression look like if I start out as an FP&A analyst/manager? TIA!

like

Hi All,

I'm looking for referral in data engineering.
I'm having 2 year of relevant experience in data engineering.

like

Hi folks,

Please let me know if your organization have senior position opening for SAP CFIN professional with 8.5 YOE .

like

Hello, I am looking for a job change. Preferred position Clinical data Manager/ lead data manager. Any leads would be helpful

like

To ZSers who got onsite: How to get onsite opportunities as BTSA?

like

Wife has a services startup and in addition, has a great idea for a product / app that has the potential to be a B2B hit and B2C as well. Large market, creative idea and not too much competition. Will need sophisticated tech development. Given we are not dev / engg, what advice can you share with regards to getting someone tech hands-on with expertise on board? What are the different ways non tech founders approach this? Any ideas will be very helpful. Looking for a starting point. Thank you.

like

Let's vote! Which startup type is most likely to have a dysfunctional or toxic work culture:

Helpful: Single founder bootstrapped startups
Smart: Single founder funded startups
Uplifting: Multiple founder bootstrapped startups
Funny: This poll is dumb.

Comment if you would have selected multiple founder funded startups!

funnyhelpfulupliftingsmartlike

Hello Everyone,
Would someone be willing to refer me for a position in Salesforce at Hyderabad ? I am looking at Program Manager roles currently with 9 years of experience.

Many many thanks in advance

like

If you've worked at multiple FAANG companies, what's your secret?

like

Additional Posts in Oracle Consultants

Recently accepted a job in oracle/financial systems consulting. I have some experience in systems but mostly FP&A and operations. I have a few cloud certifications as well.

How tough will it be for me to get up to speed and are there any recommended trainings I should do? Please let me know!

like

Any views or feedback on companies like Beamery, Smash Fly. They have reached out to me for product consulting roles.

Does anybody have any trusted site for exam dumps for the General ledger 2022 certification?

likesmart
like

I have Oracle financials implemented experience but I have been on the IT audit side for several years. I would now like to brush up on my implementation skills. I would like to do this outside of my company. Any advice on where to find formal training?

like

Genuinely curious, do people actually enjoy working in the Oracle EPM system? Been working in it for 2 years and it’s miserable. I can’t imagine anyone waking up and looking forward to implementing that system, but that could just be me.

like

Invite code for this oracle HCM bowl: 2a3xm

Have seen a lot of Accenture and Deloitte postings out there on LinkedIn for Oracle Financial and HCM. Any ACN or D consultants out there care their insights on their practices?

like

Any fish fam looking for a change? 2 open jobs for Oracle sales/consultants. DM me if you want more info

likehelpful

Just got an offer to ZS as a SIP Associate consultant. I am coming out of undergrad with 3 years of full time experience in life sciences research project management and institutional strategy and development. What is a good compensation package? Total comp and base comp?

like

How would you explain what SAP's cost & profit center are to someone from the Oracle world?

like

Can anyone help me find a site on Oracle EPM cloud? I guess there used to be a page where you could plug in metadata around business industry, revenue, number of users in finance... And then it would give the business case/value of implementation in dollars. It was an interface that had plug and play functionality. Anyone know what I'm talking about?

like

Does anyone have a Procurement exam dump they would be willing to share by chance?

likesmart

Looking for strong OCM lead who is comfortable managing customer expectations during cloud implementation as well providing scalable strategy, detailed impact analysis and risk management. About 25%.

Hey Fb family! I was very interested in the Population Health Consultant role that Oracle is hiring for but don’t know who to contact for help. Anyone here willing to reach out? Thanks!

likefunny

What technologies can one be expected to use in the position of senior application engineer at Oracle India IDC department. Got an offer for this role with product development as the outlook, but not really get what tools would be required, can someone shed some light on this?

TIA
Oracle

like

Has anyone passed the 2021 Oracle Receivables certification exam?

like

Has anyone had any luck with in getting a specific answer on what licensing is required for specific “edge” features (e.g. shared HCM or supplier model for FIN. How far into either can you go?).

Is anyone able to expand on the bonus structure at NetSuite, specifically as an ERP implementation consultant? I heard bonuses are quarterly, but I am curious about the typical percentages or amount.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal