RE: OT -- # tables in your db (was: Slow database)
Lisa, No we did not. It's still there. It's a ridiculous design but it was there when I got here and it's not going away anytime soon. Cherie Machler Gelco Information Network "Koivu, Lisa" [EMAIL PROTECTED] on 03/29/2001 06:58:20 PM To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED], "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] cc: Nope, Cherie wins. Before I left, I realized I had a database that had 19,000+ tables in it. There were a ridiculous number of schemas. Cherie, did you guys ever bust that database up into two? -Original Message- Sent: Thursday, March 29, 2001 11:01 AM To: Multiple recipients of list ORACLE-L "very complex" at 300 tables. I checked on mine, excluding SYS and SYSTEM, I have 3185 tables. 159 database links. 1064 views, again excluding SYS and SYSTEM. This is on Oracle 7.3.4. I am sure this is not the smallest db out there... (It's my birthday, so what if I feel a bit competitive today -- let's start a thread). allright, allright got the hint happy birthday Patrice :-)) : ) Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Subject: Slow database We are running an oracle database 8i, we have several Ms Access applications connected by ODBC to this database. The database is very complex ,in total about 300 tables and of course PL/SQL procedures We also have many different schemas in this database. But we have a big problem, when we are quering the database( a procedure runs) it sometimes take so long time to get the result, almost one hour, but sometimes it just takes about 20 seconds to get the result. Which means that this doesnt happen everytime. What do you suggest that I should do? Do we need to split the database? Is there any problem with the Accessapplication, i mean is it possibility that MsAccess cant access oracledatabases always when the database is very big. And that the reason to slow access to the database should be in the Access environment? Please help me with any suggestions how to solve this. /Roland Skoldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT -- # tables in your db (was: Slow database)
"very complex" at 300 tables. I checked on mine, excluding SYS and SYSTEM, I have 3185 tables. 159 database links. 1064 views, again excluding SYS and SYSTEM. This is on Oracle 7.3.4. I am sure this is not the smallest db out there... (It's my birthday, so what if I feel a bit competitive today -- let's start a thread). : ) Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Subject: Slow database We are running an oracle database 8i, we have several Ms Access applications connected by ODBC to this database. The database is very complex ,in total about 300 tables and of course PL/SQL procedures We also have many different schemas in this database. But we have a big problem, when we are quering the database( a procedure runs) it sometimes take so long time to get the result, almost one hour, but sometimes it just takes about 20 seconds to get the result. Which means that this doesnt happen everytime. What do you suggest that I should do? Do we need to split the database? Is there any problem with the Accessapplication, i mean is it possibility that MsAccess cant access oracledatabases always when the database is very big. And that the reason to slow access to the database should be in the Access environment? Please help me with any suggestions how to solve this. /Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- # tables in your db (was: Slow database)
Happy Birthday Patrice! Here you go: SQL select object_type, count(*) 2 from dba_objects 3 where owner != 'SYS' 4 andowner != 'SYSTEM' 5 andowner != 'CTXSYS' 6 andowner != 'DBSNMP' 7 group by object_type; OBJECT_TYPE COUNT(*) --- -- DATABASE LINK6 FUNCTION 6 INDEX 6173 PACKAGE 3674 PACKAGE BODY 3650 PROCEDURE 11 SEQUENCE 1280 SYNONYM 4758 TABLE 2961 TRIGGER595 VIEW 4430 11 rows selected. Oracle 8.0.5 For those of you on 8i take out the MDSYS, ORDSYS, etc OWNERS. No fair counting Oracle cartridge OWNERS. On Thursday 29 March 2001 08:26, Patrice Boivin wrote: "very complex" at 300 tables. I checked on mine, excluding SYS and SYSTEM, I have 3185 tables. 159 database links. 1064 views, again excluding SYS and SYSTEM. This is on Oracle 7.3.4. I am sure this is not the smallest db out there... (It's my birthday, so what if I feel a bit competitive today -- let's start a thread). : ) Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- # tables in your db (was: Slow database)
"very complex" at 300 tables. I checked on mine, excluding SYS and SYSTEM, I have 3185 tables. 159 database links. 1064 views, again excluding SYS and SYSTEM. This is on Oracle 7.3.4. I am sure this is not the smallest db out there... (It's my birthday, so what if I feel a bit competitive today -- let's start a thread). allright, allright got the hint happy birthday Patrice :-)) : ) Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Subject:Slow database We are running an oracle database 8i, we have several Ms Access applications connected by ODBC to this database. The database is very complex ,in total about 300 tables and of course PL/SQL procedures We also have many different schemas in this database. But we have a big problem, when we are quering the database( a procedure runs) it sometimes take so long time to get the result, almost one hour, but sometimes it just takes about 20 seconds to get the result. Which means that this doesnt happen everytime. What do you suggest that I should do? Do we need to split the database? Is there any problem with the Accessapplication, i mean is it possibility that MsAccess cant access oracledatabases always when the database is very big. And that the reason to slow access to the database should be in the Access environment? Please help me with any suggestions how to solve this. /Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- # tables in your db (was: Slow database)
Title: RE: OT -- # tables in your db (was: Slow database) Nope, Cherie wins. Before I left, I realized I had a database that had 19,000+ tables in it. There were a ridiculous number of schemas. Cherie, did you guys ever bust that database up into two? -Original Message- From: Alex Apostolopoulos [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 11:01 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT -- # tables in your db (was: Slow database) very complex at 300 tables. I checked on mine, excluding SYS and SYSTEM, I have 3185 tables. 159 database links. 1064 views, again excluding SYS and SYSTEM. This is on Oracle 7.3.4. I am sure this is not the smallest db out there... (It's my birthday, so what if I feel a bit competitive today -- let's start a thread). allright, allright got the hint happy birthday Patrice :-)) : ) Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Subject: Slow database We are running an oracle database 8i, we have several Ms Access applications connected by ODBC to this database. The database is very complex ,in total about 300 tables and of course PL/SQL procedures We also have many different schemas in this database. But we have a big problem, when we are quering the database( a procedure runs) it sometimes take so long time to get the result, almost one hour, but sometimes it just takes about 20 seconds to get the result. Which means that this doesnt happen everytime. What do you suggest that I should do? Do we need to split the database? Is there any problem with the Accessapplication, i mean is it possibility that MsAccess cant access oracledatabases always when the database is very big. And that the reason to slow access to the database should be in the Access environment? Please help me with any suggestions how to solve this. /Roland Skoldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).