Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
| Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 13th, 2006, 10:28 AM
Registered User
 
Join Date: Jun 2006
Location: BeraPoor, , India.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Tunning Through Forms 6i

Hi,

I am the student of Oracle Developer forms 6i.
I am using Windows XP O/S and 10 G database with forms 6i.

With regard to SQL Tracing I would like to ask the following please suggest me :

1. I want to enable SQL Tracing through forms 6i, in this regard there is no clear concept coming in my mind that how should I enable SQL Trace for a particular Session from forms 6i.
 I read in another book that ifrun60 command with statsistic= yes on command line would enable forms 6i sql tracing. If yes then how should I automize this command in my forms application. I mean where should I place this command in forms 6i in order to start sql tracing of this form application. As well as what should we do if I want to enable tracing for a particular session from forms 6i and the output of a SQL Trace file would be generated on forms screen.

           I know there is a Sys.dbms_system.set_sql_trace package and Alter session command available for enabling Sql Tracing, but how should we do that via forms 6i.
I will appreciate if you please suggest me and give me the clear picture about what I am wanting. I know there are several GUI tools available in Oracle but I have to do this through forms.

Thanks,

 Malan



 
Old June 21st, 2006, 11:58 PM
Registered User
 
Join Date: Jun 2006
Location: BeraPoor, , India.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

could I pay an amount in order to get the solution on that forum?
Please inform me that how much I pay in orde to get membership so I will recieve answers.

thanks

malan

 
Old July 1st, 2006, 12:42 AM
Registered User
 
Join Date: Jun 2006
Location: BeraPoor, , India.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am sorry to say that This P2p forum are not good as other forums regarding respone.
So in future I will not waste my time in order to post to this forum.

Malan





Similar Threads
Thread Thread Starter Forum Replies Last Post
Fine Tunning a Program ToniDe Java Basics 0 October 19th, 2006 12:59 AM
migration from form 5 to form 6i saqib81 Oracle 1 June 20th, 2005 01:47 AM
Opening forms from other forms Paulsh Access VBA 1 September 30th, 2004 06:54 PM
Run Script via Forms 6i bilal Oracle 0 August 12th, 2003 11:47 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.