You must be kidding.....
--
On Sat, 12 Apr 2003 09:52:56
Pete Sharman wrote:
>Of course you do! Send 3 bottles of Black Adder my way and I'll see what I
>can do for you! :)
>
>Pete
>
>"Controlling developers is like herding cats."
>
>Kevin Loney, Oracle DBA Handbook
>
>"Oh no, it's not. It's much harder than that!"
>
>Bruce Pihlamae, long-term Oracle DBA
>
>
>
>-----Original Message-----
>Sent: Friday, April 11, 2003 5:49 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Do we need permission from Oracle to attach? I am sure that many tools and
>features today are used in a way they were never intended ;-) and we do that
>also without their explicit permission.
>
>----- Original Message -----
>To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com>
>Sent: Saturday, April 12, 2003 1:38 AM
>
>It's not that difficult as long as you know what you are looking for. And
>it does vary, depending on platform, oracle release, 32bit, 64bit, and SGA
>size ( >2gb, or < 2gb)
>
>
>
>-----Original Message-----
>Sent: Friday, April 11, 2003 3:04 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>Just an observation: In this context, there is no such thing as a "vendor
>with an intimate relationship with Oracle." Anyone who attaches to your SGA
>does so without Oracle Corporation's explicit permission.
>
>
>
>..Well, except for the Oracle Enterprise Manager development group. But
>even some of those guys figured out how to map the SGA without help from
>Oracle Corporation (that is, they did it before they ever went to work for
>Oracle Corp).
>
>
>
>Cary Millsap
>Hotsos Enterprises, Ltd.
>http://www.hotsos.com
>
>Upcoming events:
>- Hotsos <http://www.hotsos.com/training/clinic101> Clinic 101 in London,
>Reykjavik, Ottawa, Denver, Sydney
>- Visit www.hotsos.com for schedule details...
>- IOUG-A Live 2003 <http://www.ioug.org> , Orlando, 10am Monday 28 April:
>Oracle Operational Timing Data
>
>-----Original Message-----
>Dick
>Sent: Friday, April 11, 2003 2:02 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>Mladen,
>
>
>
> Thanks for taking the words almost out of my mouth. I may be a bit old
>fashioned, but I believe that the manufacturer of my truck put a red line on
>the Tach for a purpose. Will the engine blow up beyond that point, maybe
>not but your treading in waters your not meant to tread. The same goes for
>messing around in the SGA in my book. I have not seen an API or map of the
>SGA published by Oracle. Therefore if your messing around your on your own.
>If the DB is hung out to dry as one respondent stated, and Yes that has
>happen to me, then that's what you pay OTS for. I know they have methods
>and what not that will take you into those waters, but let them navigate for
>you & then tell you what happen. OH Yes, It';s fast, well if your needs are
>for sub second data from the SGA I think your problem is most likely
>elsewhere and even getting what you want is not going to make any
>difference. And if you really do want to get data from the SGA, go find a
>vendor with am intimate relationship with Oracle and but their product.
>
>
>
>BTW: My basic reason for saying this is that I once tried to use C to
>extract VMS from a VAX. Well that worked pretty good, now I wonder can I??
>Answer was, Yes you can. Ever see how fast a VAX 11-780 can shutdown
>corrupting every file on the disk drives?? Answer: DAMN FAST.
>
>
>
>Dick Goulet
>Senior Oracle DBA
>Oracle Certified 8i DBA
>
>-----Original Message-----
>Sent: Friday, April 11, 2003 12:19 PM
>To: Multiple recipients of list ORACLE-L
>
>The other solution would be to redefine a second. I am still inclined to
>consider a bigger box
>
>before trying to shmat an SGA of a database.
>
>-----Original Message-----
>Sent: Friday, April 11, 2003 11:54 AM
>To: Multiple recipients of list ORACLE-L
>
>Dick,
>
>
>
>To answer your question about motive, the reason someone might want to is
>that unless you can poll the V$ structures 100 times per second, you miss
>important event occurrences. It's impossible to do this with SQL. Not
>difficult. Impossible.
>
>
>
>One test that'll be documented in my book in a few months is a query upon a
>50-row V$SESSION fixed view. Our 800MHz Linux server can only do about 65
>queries/second. And that's just one of about 30 fixed views that would need
>to be queried. And that's just with 50 sessions going (not the hundreds that
>most people have).
>
>
>
>Cary Millsap
>Hotsos Enterprises, Ltd.
>http://www.hotsos.com
>
>Upcoming events:
>- Hotsos <http://www.hotsos.com/training/clinic101> Clinic 101 in London,
>Reykjavik, Ottawa, Denver, Sydney
>- Visit www.hotsos.com for schedule details...
>- IOUG-A Live 2003 <http://www.ioug.org> , Orlando, 10am Monday 28 April:
>Oracle Operational Timing Data
>
>-----Original Message-----
>Dick
>Sent: Thursday, April 10, 2003 4:59 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>Raj,
>
>
>
> Why are you trying to access the SGA? There are plenty of dynamic
>performance views to extract data from & messing with the SGA may cause your
>DB to crash.
>
>
>
>Dick Goulet
>Senior Oracle DBA
>Oracle Certified 8i DBA
>
>-----Original Message-----
>Sent: Thursday, April 10, 2003 5:39 PM
>To: Multiple recipients of list ORACLE-L
>
>Has anyone been able to make direct SGA access work for 64 bit databases?
>My C knowledge is as good as my lisp knowledge, i.e. just about zero.
>
>I tried playing with the xksuse.c, but all it does is dumps core ...
>
>If anyone has done this successfully, could you please let me know what
>needs to be changed in the code?
>
>Thanks in advance
>Raj
>----------------------------------------------------------------------------
>----
>Rajendra dot Jamadagni at nospamespn dot com
>All Views expressed in this email are strictly personal.
>QOTD: Any clod can have facts, having an opinion is an art !
>
>
____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: C.S.Venkata Subramanian
INET: csvenkata_at_lycos.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Apr 14 2003 - 05:13:36 CDT
