在SERVER jargon,它是PROFILER。
在ORACLE jargon(问题)中,情况如何?
或者是否有任何第三方工具(免费)工作?
我是新来的,请向我提供指导。
增 编
在Oracle, 您将使用SQL 痕量和TKPROF。 关于SO,答案太大了,但主修是,你“回到”在会议一级(通常是)“回旋”的轨道上,从而向服务器撰写了载有你所寻求的信息的追踪文件。 然后,你利用TKPROF方案将追查档案转换成可阅读的报告。
转而将“追踪”引向“补充”会议:
SQL> alter session set sql_trace=true;
之后,所有事情都与追查档案相挂钩,直到你签发:
SQL> alter session set sql_trace=false;
之后,你不得不在服务器上找到所生成的.子,并将之转换成使用TKPROF的类似报告:
OS> tkprof xxxx.trc mytrace.txt
然后,你们会看到我的经历。 txt with a text Editor. <代码>tkprof的指挥有上述链接中记载的许多选择。
您也可以通过称之为“房舍管理事务-SESSION.SET_SQL_TRACE程序,在《规则》/《SQL守则》范围内追踪和查询。
I have installed ASP.NET application with database on our server. ASP.NET application created database using connection string below. The problem is that I do not see database in SQL Server Management ...
What datatype is the most efficient to store a number such as 11.111. The numbers will have up 2 digits before the point and up to three after. Currently the column is a bigint , I am guessing that ...
是否需要在提瓜表之后更新表格统计数据,还是自动更新?
Ok, so I ve got a bit of a SQL and Powershell problem. There are 2 SQL scripts, one to setup 4 different global stored procedures. Another to execute them and manipulate data before returning it to PS ...
I add a column of type tinyint and being set to not allow nulls in a table and generate the change scripts. The table has data in it at this time. The script has code that creates a temp table and ...
I am currently working on a particularly complex use-case. Simplifying below :) First, a client record has a many-to-one relationship with a collection of services, that is, a single client may have ...
I have a particularly troublesome xml column to query data from. The schema is fixed by the Quebec Ministry of Revenue so "it is what it is" The important part of the query looks like this: with ...
I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...