DBTools Software - Forums

Anonymous

Home » Forums » DBManager General

Opening Oracle Tables (1240 previews)
Opening Oracle Tables	Posted in 19th, 09/2005 03:02 by brandc.rd
Hi, Have a problem with the way you open Oracle tables in DB Manager. We work on a Peoplesoft system with 6 schemas and about 34000 table in a schema so the SID got about +-210000 tables (YES you read correctly). Now to open a user/schema it every time takes one proccesser of our server 25 min to scan through all the table to see hoe they belong to, so reducing the preformance of the Database Server. With Oracle Enterprise it only takes about 60 sec at most. thax Cecil Brand University of the Free State
Re: Opening Oracle Tables	Posted in 19th, 09/2005 09:37 by support
Hi, Have you tried to disable Preferences=>Data=>Enable COUNT()? This options ia activated by default and executes a SELECT COUNT() FORM TABLE in order to count its records. As you have lots of tables this should be turned off to avoid slow processes. Best Regards, Support / DBTools Software
Re: Opening Oracle Tables	Posted in 20th, 09/2005 03:33 by brandc.rd
Thx, it worked like a charm. It shows small details makes a big differnce. Cecil Brand University of the Free State
Opening Oracle Tables (1240 previews)

Legends

Topic has Replies

Topic With no Replies

Home » Forums » DBManager General