# Describes very slow to respond

**URL:** <https://forums.toadworld.com/t/describes-very-slow-to-respond/28548>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 27, 2014, 9:15am UTC](https://forums.toadworld.com/t/describes-very-slow-to-respond/28548 "2014-01-27T09:15:48Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![rwagner33](https://avatars.discourse-cdn.com/v4/letter/r/d78d45/32.png) [@rwagner33](https://forums.toadworld.com/u/rwagner33)\
**Post date:** [January 27, 2014, 9:15am UTC](https://forums.toadworld.com/t/describes-very-slow-to-respond/28548/1 "2014-01-27T09:15:48Z")

</div>

I upgraded to a new Dell 64bit laptop running Windows 7 with 8gb of RAM. I installed Toad 12.1.0.22 with the Oracle 12 client.

Any time I do a desc on an object in any oracle database, the window appears in a few seconds but the data can sometimes take a couple minutes to populate.

Any advice?

Thanks!

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [January 27, 2014, 9:20am UTC](https://forums.toadworld.com/t/describes-very-slow-to-respond/28548/2 "2014-01-27T09:20:59Z")

</div>

Could you send spool (Database|Spool|Spool to screen) of whole action?

Please set spool before you issue problematic action

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 27, 2014, 9:23am UTC](https://forums.toadworld.com/t/describes-very-slow-to-respond/28548/3 "2014-01-27T09:23:25Z")

</div>

Hmmm…There really isn’t a lot of processing that happens as those dialogs are shown. It sounds like query execution is slow, but it’s interesting that this happens with every database. Do you think something could be ‘off’ in your network settings? If you go to the Schema Browser and click around on objects there, is it slow there too? Does a clean set of user files make any difference?

---

<div class="post-metadata">

**Author:** ![rwagner33](https://avatars.discourse-cdn.com/v4/letter/r/d78d45/32.png) [@rwagner33](https://forums.toadworld.com/u/rwagner33)\
**Post date:** [January 27, 2014, 9:39am UTC](https://forums.toadworld.com/t/describes-very-slow-to-respond/28548/4 "2014-01-27T09:39:10Z")

</div>

This is a new install on a new Dell Precision with 8GB of RAM.

Schema browsing is slow as well.

Actions I perform in SQLPlus via putty are very fast however.

Richard Wagner

Chippewa Valley Technical College | Oracle DBA/IT Application Admin

620 West Clairemont Avenue | Eau Claire WI 54701

[www.cvtc.edu](http://www.cvtc.edu/) | 715-858-1894 |  
rwagner33@cvtc.edu

**From:** John Dorlon [[mailto:bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com)]

**Sent:** Monday, January 27, 2014 11:24 AM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** RE: [Toad for Oracle - Discussion Forum] Describes very slow to respond

**[RE: Describes very slow to respond](http://www.toadworld.com/products/toad-for-oracle/f/10/p/21186/43950.aspx#43950)**

Reply by John Dorlon

Hmmm…There really isn’t a lot of processing that happens as those dialogs are shown. It sounds like query execution is slow, but it’s interesting that this happens with every database. Do  
you think something could be ‘off’ in your network settings? If you go to the Schema Browser and click around on objects there, is it slow there too? Does a clean set of user files make any difference?

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/21186.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/21186/43950.aspx?AbuseContentId=c5820ec1-ca85-41ff-b390-b13df3ee3cce&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/o/04j0/348dce72/poyu946e.gif)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 27, 2014, 9:45am UTC](https://forums.toadworld.com/t/describes-very-slow-to-respond/28548/5 "2014-01-27T09:45:06Z")

</div>

It sounds like queries are executing slowly. Does it make any difference if you look at objects in your login schema or other schemas? In your own schema, we use the USER\_ views, which are generally pretty fast. When you browse to other schemas, we use ALL\_ or DBA\_, depending on privileges, and if you have the “Check for access to DBA views” option checked. That’s in Options -\> Startup. If that’s not checked, check it, reconnect, and try again.

if that’s not the problem, see Damir’s reply above. Maybe the spool SQL output will tell us something.

---

<div class="post-metadata">

**Author:** ![rwagner33](https://avatars.discourse-cdn.com/v4/letter/r/d78d45/32.png) [@rwagner33](https://forums.toadworld.com/u/rwagner33)\
**Post date:** [January 27, 2014, 9:53am UTC](https://forums.toadworld.com/t/describes-very-slow-to-respond/28548/6 "2014-01-27T09:53:16Z")

</div>

After activating the spool, I did two things:

desc spriden

and it actually came up fairly quickly. But then I clicked the “Scripts” tab and had a delay of approximately 30 seconds. Sometimes the delay takes up to  
two minutes.

* * *

Session: SYS@PCLONE

Timestamp: 11:47:16.231

Select owner, object\_name, object\_type

from sys.ALL\_OBJECTS

where object\_name = :obj

and object\_type not like ‘%PARTITION%’

and owner = :own

union all

Select owner, constraint\_name as object\_name, ‘CONSTRAINT’ as object\_type

from sys.ALL\_CONSTRAINTS

where constraint\_name = :obj

and owner = :own

order by 3

:obj(VARCHAR[7])=‘SPRIDEN’

:own(VARCHAR[3],IN/OUT)=‘SYS’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:16.262

Select owner, object\_name, object\_type

from sys.ALL\_OBJECTS

where object\_name = :obj

and object\_type not like ‘%PARTITION%’

union all

Select owner, constraint\_name as object\_name, ‘CONSTRAINT’ as object\_type

from sys.ALL\_CONSTRAINTS

where constraint\_name = :obj

order by 3

:obj(VARCHAR[7])=‘SPRIDEN’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:16.473

Select table\_owner, table\_name, db\_link

from sys.ALL\_SYNONYMS

where synonym\_name = :obj

and owner = :own

:obj(VARCHAR[7])=‘SPRIDEN’

:own(VARCHAR[6],IN/OUT)=‘PUBLIC’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:17.238

Select owner, object\_name, object\_type

from sys.ALL\_OBJECTS

where object\_name = :obj

and object\_type in (‘VIEW’, ‘PROCEDURE’, ‘PACKAGE’, ‘FUNCTION’, ‘TABLE’, ‘SEQUENCE’, ‘SNAPSHOT’, ‘MATERIALIZED VIEW’, ‘OPERATOR’, ‘QUEUE’, ‘JAVA CLASS’, ‘JAVA  
SOURCE’, ‘SYNONYM’, ‘TYPE’, ‘UNDEFINED’)

and owner in (:own, ‘PUBLIC’)

and not (object\_type = ‘SYNONYM’ and owner = ‘PUBLIC’ and object\_name = ‘SPRIDEN’)

order by 3

:obj(VARCHAR[7])=‘SPRIDEN’

:own(VARCHAR[6],IN/OUT)=‘SATURN’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:19.415

Select last\_ddl\_time

from sys.ALL\_OBJECTS

where owner = :own

and object\_name = :nam

and object\_type = :typ

:own(VARCHAR[6],IN/OUT)=‘SATURN’

:nam(VARCHAR[7],IN/OUT)=‘SPRIDEN’

:typ(VARCHAR[17],IN/OUT)=‘MATERIALIZED VIEW’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:19.448

Select t.table\_name,t.owner, t.cluster\_name,

```
    t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows

   , t.temporary, t.table_type, t.table_type_owner, t.nested

   , decode(nvl(tablespace_name, 'x') || upper(partitioned) || nvl(iot_type, 'x') || to_char(pct_free), 'xNOx0', 'YES', 'NO') is_External

   , t.dropped

    , t.initial_extent

```

from sys.ALL\_ALL\_TABLES t

where 1=1

and t.owner = :own

and t.table\_name = :obj

:own(VARCHAR[6],IN/OUT)=‘SATURN’

:obj(VARCHAR[7],IN/OUT)=‘SPRIDEN’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:19.582

Select created, last\_ddl\_time, object\_id, status

from sys.ALL\_OBJECTS

where object\_name = :nm

and owner = :o

and object\_type = :t

:nm(VARCHAR[7],IN/OUT)=‘SPRIDEN’

:o(VARCHAR[6],IN/OUT)=‘SATURN’

:t(VARCHAR[5],IN/OUT)=‘TABLE’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:19.631

Select cols.column\_id, cols.column\_name as Name, nullable,

data\_type as Type,

decode(data\_type, ‘CHAR’, char\_length,

```
               'VARCHAR', char_length,

               'VARCHAR2', char_length,

               'NCHAR', char_length,

               'NVARCHAR', char_length,

               'NVARCHAR2', char_length,

               null) nchar_length,

```

Decode( data\_type, ‘NUMBER’, data\_precision + data\_scale, data\_length ) Length,

data\_precision Precision, data\_scale Scale, data\_length dlength, data\_default

,’ ’ comments

, DATA\_TYPE\_MOD

,cols.CHAR\_USED

,cols.hidden\_column, cols.internal\_column\_id

, qualified\_col\_name

,InitCap(histogram) histogram

,cols.virtual\_column

,num\_distinct, num\_nulls, round(density, 5) density

FROM

sys.ALL\_TAB\_COLS cols

where 1=1

and cols.table\_name = :TABNAME

and cols.owner = :OWNNAME

order by internal\_column\_id

:TABNAME(VARCHAR[7],IN/OUT)=‘SPRIDEN’

:OWNNAME(VARCHAR[6],IN/OUT)=‘SATURN’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:19.698

select column\_name, encryption\_alg, salt

from sys.ALL\_ENCRYPTED\_COLUMNS

where owner = :own

and table\_name = :tn

:own(VARCHAR[6],IN/OUT)=‘SATURN’

:tn(VARCHAR[7],IN/OUT)=‘SPRIDEN’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:19.798

SELECT CN.NAME

FROM SYS.CDEF$ C, SYS.CON$ CN, SYS."\_CURRENT\_EDITION\_OBJ" O, SYS.USER$ U

WHERE C.Type# = 2

AND C.CON# = CN.CON#

AND C.OBJ# = O.OBJ#

AND O.OWNER# = U.USER#

AND U.NAME = :uname

AND O.NAME = :tname

:uname(VARCHAR[6],IN/OUT)=‘SATURN’

:tname(VARCHAR[7],IN/OUT)=‘SPRIDEN’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:20.032

Select t.trigger\_name, t.trigger\_type, t.triggering\_event,

```
    t.when_clause, t.status enabled, null status, t.owner, -1 object_id, t.trigger_body

```

from sys.ALL\_TRIGGERS t

where t.table\_owner = :own

and t.table\_name = :obj

:own(VARCHAR[6],IN/OUT)=‘SATURN’

:obj(VARCHAR[7],IN/OUT)=‘SPRIDEN’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:20.115

select owner, object\_name, object\_id, status

from sys.ALL\_OBJECTS

where object\_type = ‘TRIGGER’

and (

(owner = ‘BANIMGR’ and object\_name = ‘ET\_SPRIDEN\_AIR\_EXTSOL’) or

(owner = ‘BANIMGR’ and object\_name = ‘ET\_SPRIDEN\_AUR\_EXTSOL’) or

(owner = ‘SATURN’ and object\_name = ‘ST\_SPRIDEN\_NAME\_COMPRESS’) or

(owner = ‘SATURN’ and object\_name = ‘ST\_SPRIDEN\_AS\_LDI’) or

(owner = ‘SATURN’ and object\_name = ‘ST\_SPRIDEN\_AR\_LDI’) or

(owner = ‘SATURN’ and object\_name = ‘ST\_SPRIDEN\_INSERT\_ODS\_CHANGE’)

```
)

```

* * *

Session: SYS@PCLONE

Timestamp: 11:47:20.166

SELECT VALUE FROM V$OPTION WHERE PARAMETER=‘Objects’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:20.174

Select t.\*

from SYS.ALL\_TRIGGERS t

where t.owner = :own

and t.trigger\_name = :OneObjectName

order by t.trigger\_name

:own(VARCHAR[6],IN)=‘SATURN’

:OneObjectName(VARCHAR[24],IN)=‘ST\_SPRIDEN\_NAME\_COMPRESS’

* * *

Session: SYS@PCLONE

Timestamp: 11:47:20.236

Select t.\*

from SYS.ALL\_TRIGGERS t

where t.owner = :own

and t.trigger\_name = :OneObjectName

order by t.trigger\_name

:own(VARCHAR[7],IN)=‘BANIMGR’

:OneObjectName(VARCHAR[21],IN)=‘ET\_SPRIDEN\_AIR\_EXTSOL’

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [January 27, 2014, 10:02am UTC](https://forums.toadworld.com/t/describes-very-slow-to-respond/28548/7 "2014-01-27T10:02:29Z")

</div>

some reading that might apply:

[www.toadworld.com/…/help-toad-for-oracle-seems-slow.aspx](http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/05/06/help-toad-for-oracle-seems-slow.aspx?Redirected=true)

[www.toadworld.com/…/speed-up-toad-for-oracle-s-schema-browser.aspx](http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/06/20/speed-up-toad-for-oracle-s-schema-browser.aspx)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 27, 2014, 10:04am UTC](https://forums.toadworld.com/t/describes-very-slow-to-respond/28548/8 "2014-01-27T10:04:28Z")

</div>

Thanks. Yeah, a lot of queries are run when you click on the script tab. I see one query against all\_indexes that’s taking a long time…search for Timestamp: 11:47:20.765, then look at the next query - it doesn’t happen until about 35 seconds later. Most of the other queries are executing in less than 1 second. So you might check to make sure the stats are up to date on the tables that make up ALL\_INDEXES.

It looks like that “check for access to dba views” option is unchecked…because I see you are querying against ALL\_ views, but at the end of the script, there is a query that’s executing against SYS’s tables (we check for privileges regardless of the option on a few of these because it makes a big difference in performance). From the main menu, click View -\> Toad Options. In the options window, type “DBA” in the search box and that will take you to the option that I’m referring to. Make sure it’s checked. The DBA views are usually a lot faster than the ALL\_ views.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [January 27, 2014, 10:24am UTC](https://forums.toadworld.com/t/describes-very-slow-to-respond/28548/9 "2014-01-27T10:24:23Z")

</div>

> This is a new install on a new Dell Precision

> upgraded to a new Dell 64bit laptop running Windows 7 with 8gb of RAM

What is the true of both statements? What is upgraded?

---

<div class="post-metadata">

**Author:** ![rwagner33](https://avatars.discourse-cdn.com/v4/letter/r/d78d45/32.png) [@rwagner33](https://forums.toadworld.com/u/rwagner33)\
**Post date:** [January 27, 2014, 10:35am UTC](https://forums.toadworld.com/t/describes-very-slow-to-respond/28548/10 "2014-01-27T10:35:11Z")

</div>

Sorry for any confusion. I simply meant that I moved from an older Dell laptop to a new Dell laptop 64-bit. Both had Windows 7.

Richard Wagner

Chippewa Valley Technical College | Oracle DBA/IT Application Admin

620 West Clairemont Avenue | Eau Claire WI 54701

[www.cvtc.edu](http://www.cvtc.edu/) | 715-858-1894 |  
rwagner33@cvtc.edu

**From:** damir.vadas\_531 [[mailto:bounce-damirvadas\_531@toadworld.com](mailto:bounce-damirvadas_531@toadworld.com)]

**Sent:** Monday, January 27, 2014 12:25 PM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** RE: [Toad for Oracle - Discussion Forum] Describes very slow to respond

**[RE: Describes very slow to respond](http://www.toadworld.com/products/toad-for-oracle/f/10/p/21186/43958.aspx#43958)**

Reply by damir.vadas\_531

> This is a new install on a new Dell Precision

In first post you said this is Windows upgrade?

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/21186.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/21186/43958.aspx?AbuseContentId=68015d6b-618f-454d-8f98-bf534b0a730c&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [January 27, 2014, 11:18am UTC](https://forums.toadworld.com/t/describes-very-slow-to-respond/28548/11 "2014-01-27T11:18:38Z")

</div>

I suspect something in Windows configuration … so here are mine questions.

1. Where is your database-on separate server or on this laptop (seems to me separate server but want to recheck)?
2. If on the same server, what is the speed of disk (i.e 5400 , 7200 rpm etc… is there any performance donwgrade in this case?)  
Is there any change in antivirus software?
3. If is on separate server, what is the result of “tnsping db\_sid”?
4. What are Windows experience benchmark results (old-\>new laptop)