# Copying RoR Session Data Into Oracle v$session

**URL:** <https://www.ruby-forum.com/t/copying-ror-session-data-into-oracle-v-session/136032>\
**Category:** Rails\
**Created:** [April 28, 2008, 9:40am UTC](https://www.ruby-forum.com/t/copying-ror-session-data-into-oracle-v-session/136032 "2008-04-28T09:40:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bikle](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/9e8a1a/32.png) [@bikle](https://www.ruby-forum.com/u/bikle)\
**Post date:** [April 28, 2008, 9:40am UTC](https://www.ruby-forum.com/t/copying-ror-session-data-into-oracle-v-session/136032/1 "2008-04-28T09:40:25Z")

</div>

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

> **[Bikle.com may be for sale - PerfectDomain.com](https://perfectdomain.com/domain/bikle.com)**
>
> Checkout the full domain details of Bikle.com. Click Buy Now to instantly start the transaction or Make an offer to the seller!

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

---

<div class="post-metadata">

**Author:** ![bikle](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/9e8a1a/32.png) [@bikle](https://www.ruby-forum.com/u/bikle)\
**Post date:** [April 28, 2008, 1:31pm UTC](https://www.ruby-forum.com/t/copying-ror-session-data-into-oracle-v-session/136032/2 "2008-04-28T13:31:42Z")

</div>

Dan B. wrote:

> Copying Data From A Ruby On Rails Session Into An Oracle Session

But 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…

---

<div class="post-metadata">

**Author:** ![bikle](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/9e8a1a/32.png) [@bikle](https://www.ruby-forum.com/u/bikle)\
**Post date:** [April 30, 2008, 12:59am UTC](https://www.ruby-forum.com/t/copying-ror-session-data-into-oracle-v-session/136032/3 "2008-04-30T00:59:27Z")

</div>

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.