News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Gennady Feldman's Blog:
Leveraging Oracle connection metadata functionality
May 27, 2010 @ 12:48:11

Gennady Feldman has a new post to his site looking at a feature of the Oracle connection functionality that comes with PHP's integration with the powerful database - metadata functionality.

Now with OEM finding what the query is is really easy (you might need to buy Oracle Performance pack to monitor vitals and performance information). So you know which query caused the spike. Do you know where that query is in your application code? [...] You already have a ton of applications written, having to go through every query to add this meta information is a ton of dev effort. What do you do?

He's found a way to help solve the problem - you can use a few handy functions to let you set some more information about the connection. These settings can give you more information about the client, a client identifier, module information and what action or function is performing the query. This information can then be queried in via the V$session variable on the server side.

0 comments voice your opinion now!
oracle connection metadata function


blog comments powered by Disqus

Similar Posts

Zend Developer Zone: Accessing DB2 Data Inside of i5/OS

Community News: Zend & Oracle Partner to Integrate Zend Server into ULN Packages

Oracle Technology Network: DeployPHP Series, Part 5 - Zend Core for Oracle Quick Start

Matthew Weir O'Phinney's Blog: exuberant ctags with PHP in Vim

PHPit.net: No more spam; Akismet and PHP to the rescue!


Community Events





Don't see your event here?
Let us know!


security tool opinion series language list community interview framework podcast voicesoftheelephpant symfony version release composer introduction artisanfiles laravel conference library

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework