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

Any one in netcracker product devlopment rnd dept. Can you please help me with reviews ?i have joining of nc for java dev tomorrow
yoe8.8yr.
Got good technology stack overview from management and product devlopement but still confused bet netcracker and mastercard
Mastercard 30.8lpa including vatiable
Netcracker 32 fixed
Please help
Not sure on mastercard project
Java dev microservice

funny

How to answer “what would be your ideal project?”

like

Wanted to get some opinions here. I’m an M2 in Cyber looking to eventually make a move to big tech or an SM or Dir at a big industry client. Have an offer of 190K base with 20% bonus to be a Mgr at Accenture. Reason to leave - want more technical exp before moving to Big tech and better comp. although PwC increased salary this year, it’s not in the same ball park at this point. Don’t see myself staying to make partner/MD at either firm. Welcome all suggestions on what I should do.

like

Hi all , I am currently working at Deloitte as a QA lead . I manage a team of 10 . I want to break into roles at meta , google as a program manager / project manager ?

I freaking hate when colleagues use the term “ Pull Up”. For example, “ I wanted to pull up with you in XYZ client”. What TF happened to “meet with you” or “touch base”?

likefunny

Before you muster up the courage to run facebook ads to generate more leads as a realtor, figure out who is your ideal client. I mean really really think. Do you know what they’re eating? Do you know if they’re a fan of binge watching tiny home videos? Where do they currently live?

like

Can someone refer me, I'm a project lead with 9 years of experience, looking for a lead role.

Skills : Splunk, basic of tailwind css, html...

Notice period 3 months

like

Given the option of (A) running a small-mid size recruiting dept in a smaller agency, or (B) recruiting client-side / in-house marketing department — which would be preferred, and why?

like

Any physicians/researchers in here specializing in multiple myeloma? Working on a project and had a few questions

ECD: we need edgy groundbreaking ideas
AD & Me: *works for two weeks on edgy ideas”
ECD & Account: *picks only safe ideas*
Client: these are nice but we want edgy ideas
ECD to us: I need edgy ideas

likefunnyupliftingsmart

Looking for practical advice on improving my attitude to work.

So imagine an imaginary scale where 0 is the worst piece of work a studio could produce and 10 is the best possible outcome.

As an animator working in an agency, I normally end up involved in projects towards the end, so by the time I get my hands on a project I can add between 1 and 3 depending on how much effort I put in.

If a project is a 3 when I get it, how do I summon the energy to make it a 6 that I could to make a 7 a 10?

like

Hello Fishes,

I'm currently serving my notice period. LWD is on 06-Sep. My manager said that he will try for an onsite opportunity with other projects like the UK or europe as he doesn't have any onsite (US) opening in the current project. Yesterday he said he found a UK project having an onsite opportunity and said that the respective manager will contact.

I'm holding an offer for 26LPA with 8.5 YOE with product based company.

I really confused to make a decision. Pls help

like

I just found out I was promoted… in October. In November, my project ended and I was told I’d be fired if the client didn’t have another role for me. Am I crazy or is flip-flopping like this kind of ridiculous?

like

Client unsure about a pretty awesome execution, instead of saying we’ll work on it, account person blurts out to kill the idea and instead we’ll come up with a new one. WHAT IN THE ACTUAL FUCK?!

likefunny

Hi folks,

My current project is discontinued by client, so I’m on bench now. Im serving notice period and only 40 days are remaining. I asked HR for early release me but they denied, saying its our policy to complete NP

Is there any possibility to get early release? Whom to I contact?

like

Just got out of a meeting with a client. Talk about uncomfortable- they'd fired their director that morning and he ran in screaming at the team. They ended up calling security to kick him out!

Anyone have insight into Optiv and the client solutions advisor roles?

like

I love a sassy email, especially if I’m only copied because attorney-client privilege attaches 😝

likefunny

More Posts

Hi Fishes,

My last working day is 7th October and I have only one offer in hand. I'm trying hard to get some interview scheduled but in vain.

Can anyone please refer me or share some tips on how to get the interviews scheduled?

YOE - 3.2
Non-IT roles
Certified Investment Banker

like

Can someone from a risk background become a CISO?

like

Looking for a job change.. plz suggest if there are any openings..
Skillset: .Net Full Stack developer, YoE: 6 yrs.

I ran into my ex a couple days ago and it’s just all screwed with my head. We are kinda talking and he invited me to his company holiday party to be his +1.

And then he’s been ignoring me.

like

Anyone got interesting story or insight on Dalberg? How do they work, the culture, support infrastructure, career.. anything.. thanks! :)

likeupliftinghelpful

I’m going to roll out NightBooks by JA White this year anyone has resources for it? TPT only has 2 🥺

like

How does everyone manage updating PowerPoint decks. How do you indicate which slides still need updated or reformatted versus which ones are done?

like

Any good opportunities for PHP developer
YOE 7
CCTC 10 lpa

like

I applied to many new grad positions at Deloitte Canada. I gave two rounds of interviews for Risk Advisory. I see all the other positions in my portal as process complete.
Should I assume anything?

Recently I will be interviewed for the position director of community and connections belonging in the peck school in Morristown. Does any one have pros and cons of that school?

like

Hi! I joined a startup last month and was offered 30,000 stock options with a value of $60,000 with a 4 year vesting period with 1 year cliff. What does this mean? Is it good? It’s the first time I’m getting stock options and I haven’t yet been provided the stock options contract (they said it’s coming).

like

Can anyone tell me what's the market CTC for:
Stack - Analytics and Data Science
YoE - 8 years

like

How do you judge a low ball offer with how the market is changing? Earlier this year, you would look at comps and say this is the value. Now with rates going up and people pulling out, how do you justify the value? (View point from the buyers end)

like

Post MBA - MBB vs FAANG product management role vs Startup Biz Opps role vs IB (2 year Associate) for getting into Venture Capital?

like

I am interested in taking a new position at my current job - Electrical Engineering and Production Manager, in the Chicagoland area. Whats a good salary for this position? Is there anyone currently in this role - what are some of your duties?

like

What are the companies that pay well for Data Analyst, Business Intelligence roles, say above 30 lakhs. I know of Amazon and Uber.

like

Meta meme. (Memeta?)

Post Photo
likefunny

So... Trying to decide between buying a family car (7-8 seater) now vs later this year / early next year. Any suggestions on whether it makes sense to go for a new or old car and whether it makes sense to wait and buy now?

like

Any security engineer from MAANG, Microsoft, Flipkart here... I need some help.

Reasons to use Lexis over Westlaw?

like

Additional Posts in Oracle Consultants

I am about to take Oracle Data Integrator 12C. Can I have any tips or insight to pass this exam?

Which firm would you say has the best Oracle practice?

I am a HCM Technofunctional consultant for over 5 years with total EBS experience of 20 years. I am looking to change the project. How much is prevailing rate in the market?

like

Has anyone passed the 2021 Oracle Receivables certification exam?

like

How can you get Oracle Financial ERP experience without having an existing role. Are their any opportunities not requiring that specific ERP experience?

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

My husband is into Oracle. He has been Oracle HCM consultant for 6+ years in India and also learnt Oracle fusion. Now that we both have moved to Canada, he is looking for similar job role in Ontario. Any leads will be appreciated

like

Kpmg is looking for people with Cloud security experience (2+ YOE), if you’re interested let me know

like

Best Oracle practice among Big 4? From the perspective of comp (salary, bonus, benefits) and WLB

like

Are referrals affective at oracle?

like

For those who have moved to industry as a BA type role, how is that move? Compensation, Work life balance, stimulating work?

like

Looking to hire an Oracle Fusion System Administrator role for a Medical company in Miami, FL with relocation package, great salary, everything paid

Please let me know if you know someone with Oracle fusion background

Thanks and have a great rest of your week

like

What is salary range for Pre Sales Solution Consultant at Oracle? What about senior solutions engineer?

like

Dumb question but what’s the difference between EFF and DFF flex fields in Cloud?

like

Is Oracle Unifier a good product?

Anyone working in Perficient in oracle related technologies? How is it wrt work? Would it be any better than tcs?

like

Just a question from the community- Future of Oracle EBS.
Also any suggestions to get knowledge of cloud/fusion would be praiseworthy.

Background- 2 yoe joining a big4 soon from a service based company.

like

Anyone know what “premium cash pay” means on a check? I randomly just got 717$ on my check unexpectedly for that allocation.

What is the maximum CTC PWC India can offer for Manager Position (10 years experience)?

like

Client of mine looking to hire a Hyperion Systems Manager in Chicago. DM if intrested in an Exit of Consulting

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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