Link to home
Start Free TrialLog in
Avatar of rgagli1
rgagli1

asked on

Oracle database - query could bring database to a halt??

I come from a very strong technical background and can write sql queries in my sleep.  I have since switched over to more strategic and functional role and have experienced some of the hardest push back ever from a technology professional.  Most tech workers love me b/c I will write the code, hand it over and ask them to run anything that needs a function/procedure.  I'm very rare in doing this but I can do my job that much faster.  Since I started at my new position, I have had tremendous push back from technology.  There's a system in place that's a mess.  I was put in charge of trying to eliminate millions of duplicate records occuring each day.  Originally this number was around 6mm and now its closer to 12mm.  I somehow managed to get read-only access and technology nearly died almost demanding that I have my id revoked.  I was asked by my boss to run a query last night on another very large table.  Somehow during the nightly batch process, my id was put in queue and this morning caused the system to run at a terribly slow rate.  The tech staff obviously doesn't know what they are doing.  Originally, they told me there were only 400k records in the database but upon further investigation, I discovered millions and was immediately put on the defense while explaining how I got this number.  I noticed the database has nearly run out of space, certain reports do not run and I even suggested the cache needs to be increased.  After yesterday, the tech girl decided to email everyone under the sun with a screenshot that I don't know what I'm doing.  Granted its senior level staff that don't know anything about technology.  I've tried pointing out several items that make no sense:
1. several "fix" tables
2.. no archive process
3. no backup process
4. the list goes on and on

In the past I had to ask for a query for over 2 months and I received nothing.  Last week, someone from the business asked to update 5,000 records.  Technology told them this is a manual process -- for an Oracle database, I suggested a dataloader or something and they gave me eyes of death.  Now they want to revoke my access and belittle me.  Any advice on how to handle this??

My query was this:

select min (date) from holdings

-- that was it and I was told I didn't know what I was doing although she can't run a simple query and if she does the results are all incorrect.  I now have a meeting with my boss tomorrow and was told not to run any queries...I don't want to but I was asked to by my boss.  Anything I can do beforehand???
ASKER CERTIFIED SOLUTION
Avatar of sshah254
sshah254

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Naveen Kumar
Naveen Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
i know why you might have got the query executed by yourself after struggling to get read only id etc ( basically to make your boss to get some trust on you etc which is well and good ) but when you do something which other people has to do ( whether they know or not ), they have all the right to say that you are a functional guy and you know nothing about tech and surprisingly your boss might nod for this statement as well. So don't be in that state for whatever reason it is.
Avatar of rgagli1
rgagli1

ASKER

I agree - the fact is I've had to create several complex queries and can't ever get a response from technology.  I've escalated to my boss and they have been waiting to evoke my id.  Now I'm trying to defend myself and want to at least not look stupid.  The database is in bad shape.  I pointed out a few months ago that it was about to run out of space, then technology laughed and had an emergency fix over the weekend.  The fact she emailed everyone this morning was uncalled for and I want to go in tomorrow with a plan.
that is the usual mentality of every human being, when we do things for years together thinking we do it the best way/we are the best in doing what we are doing etc and when new people come in and tell something, we don't kind of give importance/respect to what new comers say though they are a real genius. It will take sometime for you to gain trust, confidence, faith from them/your boss to make them understand what you are telling is the next problem to be in plate..

you need to understand one thing very clear, when a team of 10 members are running the show for the last few years ( with or without database issues, emergency fixes etc ) - and you try to steal the show from now on by imposing your views/ideas is not something everyone likes and hence the reason for this question posted here :)

there are some real genuine people in this world as well and they take upfront the suggestions/views of others to the betterment of systems/add value to the existing systems by doing whatever possible in their control and i would love to be one among this group of people :)

hope all your problems/issues will get resolved soon as time goes on.......
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rgagli1

ASKER

I have good news.  Thankfully it's not a team, she has had 2 open position for over 2 years.  And her email actually got her in a ton of trouble and these people are doubting her b/c after trying to evoke my access, she had to call me to ask how to run a particular type of query.  Thank you for the advice and I know as the new guy I have to prove myself but I always go in with the attitude of being a team player.
Glad to see this worked out for you!  First round to you.

Good luck in the position.  Hopefully the problem employee will come around and the system can be salvaged.