Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: migrating oracle to postgres Date: Sun, 26 Jun 2011 19:08:19 +0000 (UTC) Organization: solani.org Lines: 20 Message-ID: References: <1308640710.210659@proxy.dienste.wien.at> <96h5hqFo39U1@mid.individual.net> <96p1t7Fcg6U1@mid.individual.net> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1309115299 14602 eJwVysERwDAIA7CVSsAGj9OQsP8IveotOI2dQTAwmPCt4cnWOnGxMfdR8yhtuQ1VZX/TW+YpfR1cEKE= (26 Jun 2011 19:08:19 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Sun, 26 Jun 2011 19:08:19 +0000 (UTC) User-Agent: Pan/0.133 (House of Butterflies) X-User-ID: eJwFwQkBwCAMA0BLA5I+diiJfwm744kVkwgGaFp0ET7yBqa1PiRedpbf7ZJvva0Jj1ht/iXrEcc= Cancel-Lock: sha1:mFqapPcbntfch4BhQz+oeYbAO28= X-NNTP-Posting-Host: eJwFwQkBwDAIA0BLkBIeOZRR/xJ2x+PqE+Z04+PLykmvUXTQSrvuuT4ry0uEctHAeS2JFQis7JPbceqTKWoQnoH9IrQzfp/aGHk= Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:154 On Sun, 26 Jun 2011 17:35:02 +0200, Robert Klemme wrote: > IIRC it was Oracle 10 which packaged > Enterprise Manager with the DB by default the first time. Yes, but there were both commercial and freeware monitors like Karma, Tora, Oracletool and others. There is nothing like that for Postgres. The reason for that is that there cannot be because Postgres doesn't store the execution plan in a shared location where it can be picked up and displayed. There is no way of seeing the execution plan of a running SQL statement. > At that time I still considered Microsoft SQL Server's tools better. I still do. -- http://mgogala.byethost5.com