Getting a SQL Statement trace

Is it possible to get a SQL Statement trace when running an application on .NET using the DB2 provider for .NET? I tried capturing a trace as described here: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0007959.htmbut this didn't result in anything.Basi ...

Oracle How to read SQl*net trace files and which parameter I choose?

Hi,I wanted to get some information about SQL*Net tracing.As far as my knowledge is concern there are several approaches available to enable tracing of SQL*NET.For Example:TRACE_LEVEL_SERVER=SUPPORT (For Server Tracing)TRACE_LEVEL_CLIENT=USER (For client tracing)I like to say that for (For Server Tr ...

Oracle lock monitor, top sql and trace data viewer

can any one please tell me how can i access lock monitor, top sql and trace data viewer i am also not sure whether these tools are installed on my machine or not, if they are please tell me how can i access them, if not please tell me how can i install them ...

Oracle How to generate SQL*Net trace with Instant Client

I'm testing deployment of a test OCI app using Instant Client Light (ICL) win32 11g (11.1.0.6.0), on a WinXP machine which also has the server installed.I've copied my exe and dll along with the ICL dll/sym files in a separate dir (C:\deploy), and running at the command line in a shell where no ORA* ...

Oracle SQL*Net Trace of JDBC Thin Client Connections

I'm having database application modules that are failing without any error logging. I've applied SQL*Net Trace to SQLNet.ora on the client side to see if there are any network related issues. I know that the database connection is established, though I don't know why there is a disconnect/failure. T ...

Oracle sql net trace file

Our prod db is 2 nodes RAC 10g in MS window 2003 servers. It is located in a remote place. Recently one of our local app servers lost connection to this db although we can tnsping it but got ORA3113 error when we tried to logon using sql plus. Most of our local PCs did not have problem logon at all. ...

Oracle method execution trace and SQL performance trace using OEM

1. Can we get a method execution trace and SQL performance trace 2. Capture the method execution times using EM console - and identify the time taken to individual methods of the flow 3. Capture the DB SQL trace for the user session / all sessions at the time of the above report generation4. Generat ...

SQL 2008 trace and PeopleSoft

I've got a SQL 2008 Profiler Trace of a long running session. The client code is all PeopleSoft 8.9, so (by design) literally EVERY SQL batch is either a client cursor prepare or a fetch.Does anyone have a clean way to extract the Application's SQL statements from this Trace File so that I can prepa ...

DB2 SQL command trace

HiMaybe already discussed.Is there a trace/debug facility in the OS/390 7 DB2, we could see the SQL statement's and all the parameters?Our DB2 application running by different customers and sometimes it would be very useful to see everything. ...

Oracle pls/sql in trace file

The problem is appearence of pl/sql code in trace file instead of separate cursors of SQL statements. So, I can't get information about each SQL statement separatelly. What's wrong? How to separate SQL statements?Nosorog ...

Oracle Tuning: how distinguish PL/SQL timings from SQL in trace and/or tkprof output?

we have a performance problem with one of our customer's databases and are trying to tune it out.The activity in question is a long-running PL/SQL stored procedure operating more-or-less in batch mode, calling many sub-procedures along the way. The PL/SQL code has been instrumented to take timings o ...

SQL Server trace logs for Access queries

We have many Access applications that read data from an SQL Server using linked tables.Looking at the trace logs on the SQL server to try to identify poorly performing Access apps, and looking at the SQL that is acutually being executed, we have come across sql that appears to be using SQL parameter ...

Oracle SQL command trace/log

I would like to trace/log every SQL command that is run on ORACLE 10g database. I’m interested in INSERT/UPDATE commands. I have tried to use following commands: dbms_system.SET_EV(SID,SERIAL#,10046,12,'');dbms_system.set_sql_trace_in_session (l_sid, l_serial, TRUE);alter system set timed_statisti ...

Oracle SQL Session Trace files generating out of control - How do I stop???

I have a production 11.1.0.7 database running and somehow it is generating trace files to the diag trace directory at a rate of 4 per minute filling up the filesystem.No sql_trace or 10046 are set at database level. I suspect possibly that some performace monitoring feature in OEM Grid Control was s ...

sql 2000 trace

someone knows how to make partial savings in a file for the trace (sp_create_trace)????because i saw that if you use the profiler, the events are saved as soon as they ocurrs, but if you create a trace in the query analyzer the file is not saved until you close and delete the trace or until it reach ...

Analyzing SQL Profiler trace

I am going over the output of a Profiler trace and I've found that the duration for many occurrences of EventClass 15 (Logout) is several seconds, up to a maximum of 20 seconds. That seems excessive just to complete a logout, so my question is, does the duration figure reflect only the time to compl ...

SQL Server Trace

WotchaIs there a trace that will inform me if an authenticated login attempts to access a resource that they do not have permissions to? For example:REVOKE SELECT on dbo.table TO [this user] Is there an event I can trap this command?EXECUTE AS USER = 'this user'; SELECT * FROM dbo.system_parameters ...

sql profiler trace logs question

Recently one of our database has been corrupted but I'm not sure if sql profiler is running. do you need to run sql profiler in the production server track activities in the production server? and how will i be able to know if sql profiler is already running? tnx in advance ...

Oracle How to retrieve sql statement trace in audit table

I activate audit mode for operation(update, insert, delete) on some table of my database.With dba_audit_object a see information about this operation.But i want to know how can i obtain the sql statement witch create each row in the dba_audit_object view. ...

Oracle sql opt

Can anybody help me with this sql:SQL> SET AUTOTRACE ONSQL> select msg_oid2 from (select msg_oid, msg_log_time3 from mb_fix_message4 where (msg_message_type!='0' and msg_message_type!='1')5 order by msg_log_time desc, msg_oid desc)6 where rownum <= 107 order by msg_log_time desc, msg_oid de ...

How to distinguish b/w normal trace file and different Sessions enabled SQL trace fil

Is there any way to differentiate between normal trace files and different Session's SQL enabled trace files which generate in udump folder on Operating System? I want to have a script which distinguishes between different Session's SQL enable trace files and normal trace files. So we can know that ...

Oracle How to distinguish b/w normal trace file and different Sessions enabled SQL

Is there any way to differentiate between normal trace files and different Session’s SQL enabled trace files which generate in udump folder on Operating System? I want to have a script which distinguishes between different Session’s SQL enable trace files and normal trace files. ...

SQL 2000 Traces in SQL 7.0

Can I analyze SQL 2000 trace files in SQL 7.0s version of Profiler? I'm getting error messages when I try to open them in Profiler. Sounds like backwards compatability to me. ...

SQL Profiler & Bind Variables

Greetings,1st of all newbie with SQL Server, Oracle DBA by trade, so excuse me if my wording is too Oracle-eze...Situation:Have an application that uses some Mertech middleware to convert native ISAM calls into SQL. Need to trace a problem and have successfully created large SQL Profiler trace table ...

Oracle SQL*Net - Where is the missing millisecond ?

I have done a SQL*Net trace and when i examine the trace file, 15 milliseconds have disappeared ?? Can someone explain me this ? Here, i partial copy/paste from the trace file :...[15-NOV-2005 11:29:06:312] nttbnd2addr: entry[15-NOV-2005 11:29:06:312] nttgetport: entry[15-NOV-2005 11:29:06:312] nttg ...

Oracle How to trace OCI calls on client side?

I have been using DB2 CLI, where the DB2CLIINIPATH environment variable and the db2cli.ini configuration file can be specified appropriately on the client side to generate trace files. The trace files record the dynamic SQL statements, the parameters, bind variables, error and return codes, etc. Thi ...

Trace problem

In my program, I have something like this:int cc=0;try{m_command.CommandText = strQuery;cc = m_command.ExecuteNonQuery();}catch (Exception e){cc = Defines.CC_NOTOK;Trace.WriteLine("Failed to Execute: "+strQuery,"SQL Error");Trace.WriteLine("Exception: "+e.Message," ...

Oracle Database link to SQL Server Init error

i´m tryng to create a dblink between Oracle 10.2.0 in a RHEL4 and a SQL Server.I can connect using isql but when i try using sqlplus i obtain this error:SQL> CREATE DATABASE LINK dblCONNECT TO "user"IDENTIFIED BY "pwd"USING 'hsodbc'; 2 3 4Enlace con la base de datos creado.SQL> SELECT * FROM ...

Oracle Listener trace file: Winsock 54 errors

I am seeing many of the following error ("soc nnn error - operation=5, ntresnt[0]=517, ntresnt[1]=54...") in my Listener trace file.This is on an Oracle 9.2.0.4 server (Windows 2003 Server R2).If my intepretation of the Listener trace is correct, this corresponds to Winsock Error 10054 (Connection r ...

Oracle error conecting linux(sqlplus(ora8/9 client)) to SCO(ora7( DB))

HI. I apologize of my poor english.... Im trying to connect a new linux machine with ora8 to an old sco with ora7points about...:1- tnsping works fine. and I can see it in the logs2- (here the problem) on "sqlplus user/pass@AUDI"#######################################SQL*Plus: Release 9.2.0.1.0 - Pr ...

REORGCH RUNSTAT and indexes

1.Does REORGCHK allow to update statisticts on all tables at once,butnot on indexes ?2 How to update statistics on all indexes at once ?3. Is running SQL statment trace is best way to obtain "magic" info onmost frequently used indexes , or this information available in systemtables of views ?4.If ta ...

*** Can anyone explain me this ?????? ***

I'm having a very strange and problematic behavior of SQL Server 2000 in myprogram.Program execution:----------------------------------------------1.BEGIN TRANSACTION2.EXECute for the first time a SP called sp_GAupdARMAZ_MOV, which inserts into a table ARMAZ_MOV a new record.3.Til this point everyth ...

Batch processing of Stored Procedure via ODBC

According to MSDN http://msdn.microsoft.com/library/de...6_035_2msz.aspIt is possible to batch stored procedure calls.I am trying to batch processing stored procedures with SQL 2000, MDAC2.8. All settings are default. SQLSetStmtAttr is called with SQL_ATTR_PARAMSET_SIZE set to the number array eleme ...

Report on users accessing a database

I need a way to automatically generate a daily report of user names, time of access, and type of access (login, select, insert, update, delete, etc.) to a database.We need to audit all accesses from all accounts to find out who is accessing the payroll system. We have already defined the security to ...

Dual usage of a openquery in a select statemnet

I need return a table from a stored procedures in MS SQL. It must run in MS SQL 7.0 and MS SQL 2000 too. Therefore I use for it an openquery function, where is executing a stored procedure, which return a table.Openquery function calls stored procedures in the same SQL server,in which the select sta ...

MySQL Unable to set root password after installation of 5.0.67 on Solaris 10

I have just installed MySQL 5.0.67 on Solaris 10 - using the MySQL bug 31164 workaround http://bugs.mysql.com/bug.php?id=31164 so that the postinstall script would complete successfully. I was then unable to set the root password as documented by the installation procedure: PLEASE REMEMBER TO SET A ...

reporting services report deployment issues

I am a having a little trouble with the Reporting Services on one of our new database servers. I did the whole prerequisite setup starting with IIS, front page server extensions, ASP.Net, Visual Studio.Net etc… and that went OK. I installed Reporting Services to run under a domain account just like ...

New install - replication test takes 14 seconds

SQL 2000 Installation - Clustered6 GB of RAMDual Core with hyperthreading (shows 4 procs)Created the simplest of tests, created 2 DB's (1 for publication, 1 for subscription), 1 table with 2 columns, a PK int and a varchar(50).Setup distributionSetup the publication on that 1 tableSetup a pull subsc ...

SS Agent Alerts - Deadlock Event detection

I have setup the following in an attempt to trace deadlocks on event ocurrance. I'm using SS05 / SP3 Standard 64-bit on Win 2003/R2.1. SS Agent alert setup on Error number: 59103 (deadlock)2. Response is setup to invoke a sql server trace 3. Trace is an SS Agent job-- this works, been tested standal ...

Anyway to find out the last time a proc was called?

Is there some new usage stats system table that I can query for 2005/2008?Boss asked me how long it took for us to redirect traffic off of one of our DB servers. I told him we typically need to be proactive and run a SQL profiler trace. Alternatively we could look at the web logs, he said that wasn' ...

Text for db2/400 table

HiI created a table using SQL in db2/400used a LABEL ON statement at the end and gave a text for the detailed description of the table.But when i do wrkobj lib/table, no text is getting displayed.Is there anyway to get that text filled out when creating objects using SQL Opt Object Type Library Attr ...

sed -f clears the file

sed -f /opt/DBACheck.sql.sed /opt/DBACheck.sql > /opt/DBACheck.sql.tmpmv -f $DBACheck.sql.tmp $DBACheck.sql where the contents of DBACheck.sql.sed is {s%${DBMS_USER}%SYSTEM%g}DBACheck.sql is a one line file , that contains line with string DBMS_USER which i want to replace it with SYSTEM.But on e ...

MySQL DBA: Mountain View, CA

CTG has been asked to assist our client, a world-renowned online search services company based in Mountain View, in staffing several consulting opportunities. If interested in the following opportunity, please respond with a soft copy of your resume, your expected rate of compensation and your avail ...

Ubuntu Add date suffix to file name during mySQL dump

I have a script (below) which works ok, but I have tried to modify it as I want to keep the older files for a restore if needed. I have tried adding a date suffix to the newly created files (second lump of code), but it doesn't seem to work.I get the error: $SOURCEDIR/p1db_$DATEVAR.sql: ambiguous re ...

Ubuntu bash script help please!

everyone, I've spent all day working out how to sync my live website including a mysql database to my local xampp installation. The commands all work fine when copied and pasted into the terminal, but when I try to automate it in a bash script.....well I don't really know where to start. here's what ...

Oracle Workspace Provisioning

I recently upgraded my database from 10.0.2 to 10.0.3.Since then I have been unable to create/provision new workspaces. I tracked it down to an error in the patch application process which I need to fix.However, I am curious to know why the workspace provisioning process interacts with Oracle's Chan ...

Oracle sqlplus.exe : what is the maximum length line

My OS is Windows XP.I try to execute the following command :sqlplus -S infolig/edfinfo@BDI02 @.\..\..\Patchs\Patch1GET\EvoSmart\Upgrade\triggers\CreTriggersGET.sqlc:\trace\BDI02_2007-03-01_09H30\LIV6_PATCH1\BDI02\BDI02_06_CreTriggersGET.log REFI .\..\..\Patchs\Patch1-GET\EvoSmart\Upgrade\triggersBut ...

Oracle Possible solution to "Unable Attach to Analytic Workspace"?

I think I'm closing into why I've been Unable to Attach to Analytic Workspace. I have a list of post database creation scripts to run in Oracle 10g. However, the list I have is of Oracle 9i. When I looked at one in particular, I saw: connect / as SYSDBA@/opt/oracle/product/9.2.0.5.0/olap/admin/olap. ...

Oracle Autonomous Transaction

is it possible to figure out if an update happened in an autonomous transaction or not using the level 8 or 12 database trace files?I know if a pl/sql block with pragma etc..is executed as dynamic SQL, the trace file will contain that statement. But if the autonomous transaction is started somewhere ...

exec statement in SP issue

I am using Crystal report to export the report to an PDF file, but it's fail to get the right result. The issue I am wondering is I am using the Exec statement in my SP, my SP is like below:DECLARE @XMLDataFormat as nvarchar(4000)SELECT @XMLDataFormat = XMLDataFormat FROM tbDocs where DocID = @DocID ...