These are Oracle features that TOAD 9.0 will support. AWR is the Automatic Worlkoad Repository. It's basically a stats pack on steroids replacement. Please...
32152
Delia, Stephen [ETHUS]
boobooeileen
Mar 30, 2006 3:17 pm
I did try right-click -- and nothing happened ... because : I was in the Compare Scenarios layout. Right-click doesn't work there. It *does* work in the SQL...
32153
run4247
Mar 30, 2006 3:58 pm
Can anyone suggest resources that would be the best place for me to find quality Oracle Database Engineers? I work at Sankyo Pharma in Parsippany and we need a...
32154
Jeff Smith
toaddev
Mar 30, 2006 4:48 pm
r-click in the SQL Details, scenarios section and choose 'Unselect all rewrites' if its not selected, it won't get executed i believe. ...
32155
rsimonea@...
Mar 30, 2006 5:13 pm
Good Morning; In the SQL Editor, you should see a tab labled: Auto Trace Click on it, if it's off, it'll prompt you to see if you want to turn it on. At this...
32156
WHGWannabe
Mar 30, 2006 5:13 pm
I have options/Oracle/general/dbms output/default buffer size set to 1,000,000 (I assume it was the default because I don't recall changing it), but when I try...
32157
Ed Klinger
eklinger
Mar 30, 2006 6:56 pm
I 9.x and below there is a 255 char limit per *line* in Oracle not Toad. The buffer refers to total number of characters outputted. Ed [TeamT] ... From:...
32158
Phillips, Kenneth S (...
ken.phillips@...
Mar 30, 2006 9:54 pm
I'm very new to the Oracle and Toad world of computers. I was looking for a good book that could help me to learn how best to use Toad and all its little...
32159
Delia, Stephen [ETHUS]
boobooeileen
Mar 30, 2006 9:54 pm
Toad for Oracle 8.6.0.38 I have another question related to SQL Tuner : After creating many scenarios, I unselected all and then picked 3 to try. I then...
32160
Chris Johnson
WHGWannabe
Mar 30, 2006 9:54 pm
Okay, either I'm having a blonde moment (duh...), a senior moment (huh???) or a blonde senior moment (I forgot what duh means)... I'm not sure I follow. Is...
32161
rsimonea@...
Mar 30, 2006 9:54 pm
Mornin' Bert; One question: Would the AWR functionality be good for tracking resources used by a specific package or procedure? If not, I'd agree that...
32162
Joseph Charpak
jcharpak
Mar 30, 2006 9:54 pm
each line must be at most 255 chars. You can only output 1000000 characters *total* (no matter how short each line is) before the buffer must be polled. ... ...
32163
Evans, Pete (DotComm)
petergriffin...
Mar 30, 2006 9:54 pm
Here is a great piece of code written by Steven Feuerstein that will defeat the 255 char limit. You can use P.L in place of DBMS_Output.Put_Line. Steven had...
32164
Booth.Steve
stevebooth8739
Mar 30, 2006 10:13 pm
That's typically NOT what I've experienced using the tool. Tomorrow, send me a private e-mail and maybe I can walk you through how I use it. Us Steves got to...
32165
Ed Klinger
eklinger
Mar 30, 2006 10:19 pm
Chris, Ok to be more accurate in 10gR2 the line length was increased to 32k and overall limit was removed. Below is from the New features doc for 10gR2. Ed ...
32166
Jeff Smith
toaddev
Mar 30, 2006 10:20 pm
We've got 2 books on toad available, they're both listed here http://www.toadsoft.com/toad_oracle.htm Bert's book does a great job on showing WHY you would...
32167
Udsen, Dean (Calgary)
dudsen99
Mar 31, 2006 1:18 pm
HI all, I recently upgraded to Toad 8.5.3.7 and I'm working with a database on Oracle 9i. I cannot see any data in the data grid when querying nvarchar2...
32168
Aci - MRI
acip@...
Mar 31, 2006 1:18 pm
Thank you very much Aci POLAJNAR IS Consultant MRI d.o.o. Celje Quest Partner for Adriatic Region Mariborska 7, SI - 3000 Celje Tel: +386 3 428 25 25 Fax:...
32169
dbaip1tool@...
johnketta
Mar 31, 2006 1:18 pm
Hi, Here the references to the books: Toad Pocket Reference for Oracle, 2nd Edition By Jeff Smith <http://www.oreillynet.com/cs/catalog/view/au/2258> , Patrick...
32170
Chris Johnson
WHGWannabe
Mar 31, 2006 1:18 pm
Ah. Okay. Got it. Now it makes sense. Thanks. ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]On Behalf Of Joseph Charpak Sent: Thursday, March 30,...
32171
Chris Johnson
WHGWannabe
Mar 31, 2006 1:19 pm
Good info, but I'm stuck on 9i for a while (at least at this client). Thanks Ed. ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]On Behalf Of Ed ...
32172
Norman Dunbar
normandunbar
Mar 31, 2006 2:30 pm
Hi Dean, I'm on 8.5.0.38 and nvarchar2 columns are fine for me. No problems at all. Not much help to you I'm afraid :o( Are you sure you have the correct...
32173
Stephen Rooney
sjrooney
Mar 31, 2006 4:07 pm
OK another Steve chipping in here... I haven't been able to get the 8.6 version to work at all. It would launch and then after about 25-30 minutes just shut...
32174
neal clark
thomp21588
Mar 31, 2006 4:08 pm
What does this mean? It comes up every few seconds on my TOAD: "No root element found in xml" EurekaLog 4.6.4 ... 1.1 Start Date : Fri, 31 Mar 2006...
32175
Phillips, Kenneth S (...
ken.phillips@...
Mar 31, 2006 4:09 pm
Thanks much!!!! Ken g GE Capital Solutions Kenneth S. Phillips III Informix/SQLServer/Oracle DBA GE Capital Solutions ken.phillips@... <...
32176
Jeff Smith
toaddev
Mar 31, 2006 4:09 pm
We have a new tuner coming out, will be available next week with Toad. Maybe you can try that one... ... From: toad@yahoogroups.com...
32177
John Dorlon
jdorlon3
Mar 31, 2006 4:14 pm
if it's what I think it is, it's been fixed for 9.0. to prevent it, open the shcema browser, and click a few objects so you have something in the history. ... ...
32178
dudsen99
Mar 31, 2006 9:29 pm
Sorry Norm, My mistake, the version is 8.5.3.2. We just upgraded corporately in the last couple of weeks. Thanks for the reply. Dean. ... at ... or ... on ......
32179
Strong, Stephen
stephen.strong@...
Mar 31, 2006 9:29 pm
I am using 8.6.0.38. This question may mean I need some remedial Oracle learnin. If so, please forgive me. When I look at the script for a table or function or...
32180
Jesse, Rich
r2qti
Mar 31, 2006 10:07 pm
Hey Stephen, Try entering the word "owner" in Search box under View->Options Let us know if this is what you're looking for! Rich -- [TeamT] ... From:...
