Posts:
598
Registered:
07/17/07
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 20, 2007 7:35 AM
in response to: jhmartin1
|
|
|
|
Something else about OEM: The sheer greediness of it! Bye, bye RAM! Bye Bye CPU!
|
|
|
Posts:
5,205
Registered:
08/04/98
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 20, 2007 7:57 AM
in response to: HarryP
|
|
|
|
Not on my site.
--
Sybrand Bakker
Senior Oracle DBA
|
|
|
Posts:
598
Registered:
07/17/07
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 20, 2007 7:58 AM
in response to: sybrandb
|
|
|
|
|
|
Posts:
5,205
Registered:
08/04/98
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 20, 2007 8:10 AM
in response to: HarryP
|
|
|
|
Why?
Are your claims substantiated?
--
Sybrand Bakker
Senior Oracle DBA
|
|
|
Posts:
598
Registered:
07/17/07
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 20, 2007 9:22 AM
in response to: sybrandb
|
|
|
Why?
Well, it'd be interesting to know why your system is immune to the greediness I mentioned.
Are your claims substantiated?
I don't have EM installed anymore, so no "top", "sar", etc. details to share. But the minimum requirements for it are pretty steep, considering it's web-based, and I was taken aback at how much CPU & RAM it consumed, for, it has to be said, comparatively little "magic". Maybe I'm just OEM-phobic.
--
Harry P
Unbelievably Talented, Ultra-Senior, Really, Really Brilliant, I Jest Ye Not DBA. |
|
|
Posts:
4,882
Registered:
09/08/98
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 20, 2007 9:39 AM
in response to: burleson
|
|
|
Hi DB,
somehow I missed your entry.
Thanks for reminding me, I should be golfing, not
sitting here, chain smoking and getting fat . . .
Too many risk factors, if you ask me. Health is one of those things (some) people only value when it's gone.
Personally, I find command-line to be infinitely more
flexible than OEM. OTOH, OEM is great for the
advisory tools, performance pack, etc, especially ehe
workload-based tools like SPA.
Plus, I think that OEM can become a crutch for a
noob, and mask a poor knowledge of the database
functionality. Me, I see too many DBA's who are as
helpless as a baby without OEM, TOAD or SQL
Deverloper.
When using non-XE licenses, I'd probably think about using OEM and additionals packs/tools, if I'd be tasked with DBA duties. However, this is beeing done by other individuals in the company I work for, and for private use XE is quite sufficient, at least for those things I'll do in my spare time.
I've been a heavy duty Toad user and neglected the usefulness of SQL*PLUS, but today I appreciate the scripting abilities that SQL*PLUS allows. However I'm also using GUI tools such as SqlNavigator for my daily work. For XE I've grown fond of using SQLDeveloper.
Thanks for the links, but I'm using Linux for the XE installation.
C. |
|
|
Posts:
518
Registered:
05/04/99
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 20, 2007 11:52 AM
in response to: damorgan
|
|
|
|
The simple fact is, if you work for a consulting organization, or a software company like I do you absolutely CANNOT make assumptions about what any given customer has installed or licensed if you suddenly have to go to someone else's site. In fact it would be pure stupidity to do so. If I showed up somewhere and found out that there was no flavor of OEM/Grid Control/whatever available and had no clue about basic Unix shell commands, Windows command prompt, or basic Windows functionality I'd be deep in the doo-doo and so would my employer. Maybe you ought to think about about what other types of things people have to deal with before making such blanket assumptions about the "ideal" world.
|
|
|
Posts:
2,343
Registered:
05/06/98
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 20, 2007 12:36 PM
in response to: sybrandb
|
|
|
Are your claims substantiated?
Ha! Good Joke!
This, coming from someone who hides every aspect of his own identity?
Sybrand, I heard a rumor that you are really a young Swedish girl named Heidi, and that you have a major crush on me . . . . .
That would explain your obsession with me, etc . . . .
Is that true Sybrand (Heidi)?
You want me, don't you? |
|
|
Posts:
2,343
Registered:
05/06/98
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 20, 2007 12:42 PM
in response to: user8606670
|
|
|
Morgan wrote: "Shell scripts, with rare exceptions, are for dinosaurs. ". . . .
Yeah, that's a tad presumptious, but I understand where he is coming from. . . .
ALL DBA's should know the commands, IMHO:
- DDL - It's too easy to click a GUI into disaster!
- vi - A lost art, but the ONLY editor that you can count to to always be there!
- UNIX/Linux scripting - It's still quite popular in many shops
In fact, while OEM is a great tool, it's too often used a crutch by dangerous neophytes:
http://www.dba-oracle.com/t_dilettantes.htm |
|
|
Posts:
9,443
Registered:
10/20/03
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 20, 2007 1:29 PM
in response to: burleson
|
|
|
|
Close but my point was that with DBMS_SCHEDULER, DataPump, and External Tables, almost everything can be done from within the database. Nothing I wrote was intended to indicate that the choice was between vi and a GUI.
Performing activities from inside the database, rather than with shell scripts, provides tremendous benefits. Among them:
* Things don't try to run when the database is down.
* Passwords are secured.
* Auditing is in place.
* Single code base for all operating systems and shells.
* Fewer skill sets required for development, testing, and maintenance.
* No fixes required to implement on RAC clusters no matter their size.
* Exception handling is built in
* Messaging is built in
* Job dependencies are built in
* Scheduling is built in
Certainly a good DBA should be comfortable in vi and be able to write a script. A good developer should be able to write a cursor loop. But a good developer should also take that knowledge of how a cursor loop functions and use it to replace cursor loops with SQL or array processing ... not to write another one.
|
|
|
Posts:
5,205
Registered:
08/04/98
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 20, 2007 2:44 PM
in response to: burleson
|
|
|
|
Burleson,
Go visit a shrink.
You really belong there. Your ego is inflating all over the world, as is your ugly photograph.
You are arrogant, pompous and paranoid.
I'm not surprised you are promoting the password cracker of Amjad Daoud, also known as Omlet, the guy who posted so often imposting Daniel Morgan about Janet Burlesons inflated breasts. Mr. Daoud is a lunatic.
By suggesting I am in reality a Swedish girl, called Heidi, you finally dropped your mask: It appears you are a lunatic too.
--
Sybrand Bakker
Senior Oracle DBA
|
|
|
Posts:
2,343
Registered:
05/06/98
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 21, 2007 1:06 AM
in response to: sybrandb
|
|
|
I am in reality a Swedish girl, called Heidi
Aha! I knew it! |
|
|
Posts:
5,205
Registered:
08/04/98
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 21, 2007 1:12 AM
in response to: burleson
|
|
|
|
Burleson
You are SICK.
Please STOP IT
You are a 'savyy professional', aren't you?
Then STOP IT
Or are you 'Omlet'?
--
Sybrand Bakker
Senior Oracle DBA
|
|
|
Posts:
19,247
Registered:
08/22/02
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 21, 2007 1:25 AM
in response to: sybrandb
|
|
|
|
Donald, Sybrand,
Please keep the thread on the right way. And avoid to show us your animosity, and personal attacks. Open a private chat and continue this sad discussion without us.
Thanks in advance for your professionalism side.
Nicolas.
|
|
|
Posts:
157
Registered:
01/19/07
|
|
|
|
Re: Need Info Regarding Unix Scripts for DBA's
Posted:
Nov 21, 2007 6:16 AM
in response to: damorgan
|
|
|
|
Id be much obliged if someone could 'show me the way'. Ive tried to become a born-again OEM convert, but it takes up all the memory on my PC, it runs like a pig and the UI isn't like anything else Ive ever seen.
It must be my jurassic tendencies that mean I use a ksh script together with Nagios or BB for Oracle monitoring even though its served me so well, for so long.
Im sure our company would welcome a second monitoring system based on OEM which they have to pay for. Maybe it would persuade them to give out even more money for a third, Openview or Tivoli? Who knows?
I hear Java is about to become obsolete in favour of Java++ or Java - The sequel, so maybe I wait for the next version of OEM ..or the one after that..
|
|
|
|
Legend
|
|
Guru : 2500
- 1000000
pts
|
|
Expert : 1000
- 2499
pts
|
|
Pro : 500
- 999
pts
|
|
Journeyman : 200
- 499
pts
|
|
Newbie : 0
- 199
pts
|
|
Oracle ACE Director
|
|
Oracle ACE Member
|
|
Oracle Employee ACE
|
|
Helpful Answer
(5 pts)
|
|
Correct Answer
(10 pts)
|
|
