dan.bikle-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
2008-Apr-28 07:39 UTC
Copying RoR Session Data Into Oracle v$session
People, I just wrote a short paper and put it on my site: Copying Data From A Ruby On Rails Session Into An Oracle Session http://bikle.com/protected/roracle_session The intended audience is people who know a little about Rails and/or a little about Oracle. It might be of interest to webmasters/DBAs who want to "link" SQL they see in V$SQL with controller methods in their RoR sites. I''m wrestling with this issue at a site which uses Java technology (JBoss). We see a lot of resource intensive SQL hitting the database but we don''t always know where it is coming from. Rails makes some things so easy. --Dan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Dan Bikle wrote:> Copying Data From A Ruby On Rails Session Into An Oracle SessionBut aren''t the Oracle sessions on an application basis (or, at least, application server basis) and the RoR session on a user basis? There is not a new Oracle session for each user connected to an application, so I''m not clear on how useful it would be to have the Oracle session constantly being updated by every user request... -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Excellent article Dan. I''ll be testing the use of v$session in my Rails applications asap. It''s a type of instrumentation that links the Rails logs into the Oracle diagnostics, which is great. Hopefully gone will be the days of peering at Oracle sessions trying to figure out which one of them is attached to a particular Rails session. On Apr 28, 5:39 pm, "dan.bi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org" <dan.bi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> People, > > I just wrote a short paper and put it on my site: > > Copying Data From ARubyOnRailsSession Into AnOracleSession > > http://bikle.com/protected/roracle_session > > The intended audience is people who know a little aboutRailsand/or a > little aboutOracle. > > It might be of interest to webmasters/DBAs who want to "link" SQL > they see in V$SQL with > controller methods in their RoR sites. > > I''m wrestling with this issue at a site which uses Java technology > (JBoss). > > We see a lot of resource intensive SQL hitting the database but we > don''t always know where it is coming from. > > Railsmakes some things so easy. > > --Dan--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---