Обсуждение: Unending DB migration
Hi,
We are trying to migrate from Postgres to Oracle, although our DB is gigantic
but we started on Mar 14th 2012 & its still running with an average of 400000 records per day
How can we check what is going wrong.
Any memory leak, CPU issue or anything.
Please help me fix it
We are trying to migrate from Postgres to Oracle, although our DB is gigantic
but we started on Mar 14th 2012 & its still running with an average of 400000 records per day
How can we check what is going wrong.
Any memory leak, CPU issue or anything.
Please help me fix it
On Mon, 2012-04-16 at 16:27 -0700, ЇЯЅHAÐ wrote: > > > We are trying to migrate from Postgres to Oracle, Hmm. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Вложения
Need more info.
How is Postgres setup, what version.
How are you migrating?
How is Oracle setup, what version.
Etc.
--
Peter Steinheuser
psteinheuser@myyearbook.com
2012/4/16 ЇЯЅHAÐ <irshad.nazir@gmail.com>
Hi,
We are trying to migrate from Postgres to Oracle, although our DB is gigantic
but we started on Mar 14th 2012 & its still running with an average of 400000 records per day
How can we check what is going wrong.
Any memory leak, CPU issue or anything.
Please help me fix it
Peter Steinheuser
psteinheuser@myyearbook.com
On Mon, 16 Apr 2012 16:27:38 -0700, ЇЯЅHAÐ wrote: > Hi, > > We are trying to migrate from Postgres to Oracle, although our DB is > gigantic but we started on Mar 14th 2012 & its still running with an > average of 400000 records per day 400,000? That's pathetic. Why didn't you just use Postgres's "copy to" CSVS and then Oracle's SQL*Loader? How big is "gigantic"? > How can we check what is going wrong. > Any memory leak, CPU issue or anything. > > Please help me fix it Hi,<br><br>We are trying to migrate from Postgres > to Oracle, although our DB is gigantic<br>but we started on Mar 14th > 2012 & its still running with an average of 400000 records per > day<br><br>How can we check what is going wrong.<br> > Any memory leak, CPU issue or anything.<br><br clear="all">Please help > me fix it<br><br><br> Please don't post in HTML.
ЇЯЅHAÐ wrote on 17.04.2012 01:27: > Hi, > > We are trying to migrate from Postgres to Oracle, although our DB is gigantic > but we started on Mar 14th 2012 & its still running with an average of 400000 records per day > > How can we check what is going wrong. > Any memory leak, CPU issue or anything. If you are migrating *to* Oracle, then you should probably ask this question in an Oracle forum. Or is it the reading of the old data that is that slow? But anyway: without a lot more information about *how* you do the migration nobody will be able to help you Which program(s) do you use to migrate the data? What type of connection do you have between the two servers? What exactly is slow (inserting into Oracle, selecting from Postgres?)