Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,1834,1844,1854,1864,187»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Friday, October 18, 2013 9:25 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 12:34 PM
Points: 31,181, Visits: 15,626
jasona.work (10/18/2013)
Gads it takes a long time for an Oracle patch to apply...

I probably could've just installed a new, updated instance by now...


Maybe that's a test to run. Can you do the equivalent of detach, uninstall, reinstall, attach?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1506223
Posted Friday, October 18, 2013 9:42 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 2:39 PM
Points: 4,241, Visits: 3,675
jasona.work (10/18/2013)
Gads it takes a long time for an Oracle patch to apply...

I probably could've just installed a new, updated instance by now...

Oracle patches have always taken a very, very long time to run. The Oracle installer certainly doesn't make the process any better. I remember them taking hours sometimes when you have large databases. Unfortunately, you have to move from disbelief and thinking you're doing something wrong into acceptance.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1506236
Posted Friday, October 18, 2013 10:13 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 11:53 AM
Points: 730, Visits: 5,333
Ed Wagner (10/18/2013)
jasona.work (10/18/2013)
Gads it takes a long time for an Oracle patch to apply...

I probably could've just installed a new, updated instance by now...

Oracle patches have always taken a very, very long time to run. The Oracle installer certainly doesn't make the process any better. I remember them taking hours sometimes when you have large databases. Unfortunately, you have to move from disbelief and thinking you're doing something wrong into acceptance.


Yeah, I know, just wanted to complain...
It's actually the second time I've had to load the Oracle Quarterlies, which should give you an idea how long we've been without an Oracle DBA if *I'm* getting pressed into service as one!

Now if only I got the Oracle DBA pay on top of the MS SQL DBA pay, I might complain less...
Post #1506257
Posted Friday, October 18, 2013 10:15 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 11:53 AM
Points: 730, Visits: 5,333
Steve Jones - SSC Editor (10/18/2013)
jasona.work (10/18/2013)
Gads it takes a long time for an Oracle patch to apply...

I probably could've just installed a new, updated instance by now...


Maybe that's a test to run. Can you do the equivalent of detach, uninstall, reinstall, attach?


Sure, if I could figure out how to do that in Oracle!


Thankfully, the patch process completed, which means I get to leave on time (1:00pm! Yay!) so I can join the wife and a friend for lunch (Yay!) before tomorrow night installing the current round of MS OS updates on my production servers (boo!)
Post #1506258
Posted Friday, October 18, 2013 7:39 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 10:53 PM
Points: 3,421, Visits: 5,359
Greg Edwards-268690 (10/18/2013)
jasona.work (10/18/2013)
You know, people may complain about the hassles of installing SPs and CUs and updating the OS of their SQL servers, but that's nothing compared to doing Oracle Quarterly patches...

Having to rename DLLs that the Oracle service doesn't let go of, even when you've stopped the DB, having to actually STOP the various Oracle services, because the patch utility is a batch file making sure you're in the right directory, having to remember to run your CMD Prompt as Administrator...

I realize a dedicated, determined Oracle admin could probably put together a Powershell or Python script to do all of this automatically, but give me an EXE / MSI / MSU to double-click and click Next a few times any day...

Written while backing up an Oracle system before applying the current quarterly patches to a QA environment...



Just curious, maybe a business could be started.
How much do you think you would pay for such an exe?


Actually I worked for a company a few years back that was developing a tool for this. I think they called it RapidPatch or something like that. Google on that or Rapid Solutions and you may find them (in Thailand). Not sure how far they've gotten with it or whether it is intended for the db or for Oracle EBS though.



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1506352
Posted Friday, October 18, 2013 11:33 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 7:16 AM
Points: 489, Visits: 1,265
rodjkidd (10/18/2013)
As Jack said I finally tracked him down...

All you had to do was look for a little hobbit running around under your legs. In all seriousness, Jack is awesome.


rodjkidd (10/18/2013)
Also as a bonus on the Bucket List, met Jim Murphy on the way to the NASCAR hall of fame. So that was cool. Nice guy as well! E aren't we all on this thread?

Hey thanks man. You are quite cool yourself. Got me in a t-shirt pose for your wall of shame where you post other suckers willing to wear the shirt. You'll have to post a pic.

After walking up to Rod and company, they said "hey, I know you." I literally responded with "I doubt that." Hahahaha. What are the odds with so many people there since I just blindly walked up after seeing his First Timer flag so I tried to make this wandering stranger feel welcome? I just didn't recognize y'all.

"Do you post on The Thread?" Me: "I used too!"


Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
Post #1506363
Posted Sunday, October 20, 2013 1:32 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:06 AM
Points: 13,289, Visits: 11,075
GilaMonster (10/18/2013)
Koen, you are awesome.

Koen Verbeeck (10/18/2013)
hoseam (10/18/2013)
I don't have a backup


Sorry to hear that.
Let this be an incentive to implement a backup plan.




I know I know

But when do most people adapt some best practices?
After they messed up (one time too many).




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1506507
Posted Sunday, October 20, 2013 2:28 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 10:48 AM
Points: 4,126, Visits: 3,427
Koen Verbeeck (10/20/2013)
GilaMonster (10/18/2013)
Koen, you are awesome.

Koen Verbeeck (10/18/2013)
hoseam (10/18/2013)
I don't have a backup


Sorry to hear that.
Let this be an incentive to implement a backup plan.




I know I know

But when do most people adapt some best practices?
After they messed up (one time too many).
... hopefully still keeping their job.
Post #1506515
Posted Sunday, October 20, 2013 8:45 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 7,801, Visits: 9,551
Revenant (10/20/2013)
Koen Verbeeck (10/20/2013)
GilaMonster (10/18/2013)
Koen, you are awesome.

Koen Verbeeck (10/18/2013)
hoseam (10/18/2013)
I don't have a backup


Sorry to hear that.
Let this be an incentive to implement a backup plan.




I know I know

But when do most people adapt some best practices?
After they messed up (one time too many).
... hopefully still keeping their job.

Or hopefully not keeping it, depending on what "one time too many" means.

I don't have a problem with people screwing up. I do have a problem with people repeating the same screw-up multiple times, unless the screw-up is so trivial that it can do no harm, even when repeated continually (in which case, it isn't really a screw-up, is it?).


Tom
Post #1506529
Posted Monday, October 21, 2013 10:04 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:51 PM
Points: 1,061, Visits: 2,577
Thanks, Koen, and thanks for the tip on the photo. I've finally caught up on the thread after PASS Summit and got a chance to change my Twitter photo.

Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1506744
« Prev Topic | Next Topic »

Add to briefcase «««4,1834,1844,1854,1864,187»»»

Permissions Expand / Collapse