473,403 Members | 2,222 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,403 software developers and data experts.

Starter

1
Pls Tell me how we have to see the performance of the querry.
Time required to execute a querry and the other details.
Mar 1 '07 #1
1 1093
Dave44
153 100+
Pls Tell me how we have to see the performance of the querry.
Time required to execute a querry and the other details.
well if you are working in sqlplus you can:
-set timing on and run the query to see the time.
-explain plan for <your query here>; and then select * from table(dbms_xplan.display); to see the explain plan

and if you really want to get into in and see what is happening then you will want to run a trace on the session and tkprof it. (if you decide to run a trace make sure you shut the trace off again... an easy oversite that can hamper performance of the system ) this will show you number of parses (hard vs soft) etc.
Mar 1 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Bob | last post by:
I'm looking at the docs in VS2005 regarding starter kits and I noticed that the starter kits to download from the site are in vsi files (compressed), all except the shareware starter kit. MS docs...
3
by: Dan Sikorsky | last post by:
How can I install the Portal starter kit to a different Solution/Project name, having a different SQL Server database name? I'd like to start a new solution using the Portal starter kit as a...
0
by: Stephen Walther | last post by:
Microsoft has released the final version of the ASP.NET Issue Tracker Starter Kit. The Issue Tracker Starter Kit is a free application produced by Microsoft which illustrates best-practices when...
8
by: Jensen Bredahl | last post by:
Hello, This should be very basic but i'm having hard time finding the C# version of the starter kits. There is a link in the Visual Web Developer 2005 Express Edition but that only opens the VB...
4
by: rpm | last post by:
I have started using Personal Site Starter Kit with Visual Web Developer 2005. I realized that for the photo gallery portion, I can have an album set to be public or not. And if I set it not to be...
1
by: beaverme | last post by:
Hi, I found this and wondered if/when Microsoft planned to release this starter kit: http://www.goldmandesign.com/folio/microsoft-starter-kit-classifieds.shtml Regards, B
1
by: oldgent | last post by:
I am having a problem installing the starter kits. I have reinstalled VS 2005, think that might be the problem. I then installed both 'Personal Website" and the "Club Website" starter kits. I...
1
by: rodriguez | last post by:
Hi, Yes, I'm one of the lonely ones who hasn't upgraded to VS2005.NET. Does anyone know where in MSDN, the code for the Starter-Kits for VS2003.NET? It seems like MSDN is very nicely ignoring...
2
by: craigkenisston | last post by:
So, I wanted to implement a very, very basic job posting capability to one of my website. I made some searches and I found there is a JOBS STARTER KIT !! Wow, "it's my lucky", I thought. I...
7
by: Mr. SweatyFinger | last post by:
I downloaded t he time tracker starter kit. Now where the hell is it? honest to god what is the problem. And no it is not under "n ew project/ starter kits" I mean how much of a hassle can...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.