Re: Import taking a long time.

Thanks. Granted 6 megs is a small import, but I'm performing the import on a machine with a 233 Cyrix with 64 megs of memory...

-greg
"Bell" <ohnoyoudont_at_servernotfound.com> wrote in message news:dnNt6.417900$f36.13896950_at_news20.bellglobal.com...
> Find the session of the person who is running the import and use the
> sql_address to lookup the sql that it is running. Using that address
 value
> to lookup the rows_processed column in v$sql to see if more inserts are
> happening.
>
> However, if your file is only 6megs I think you have bigger problems.
>
> Hope that helps.
> Scott.
>
>
>
> "Greg Akins" <insomnia_at_cvzoom.net> wrote in message
> news:3ab78a43_3_at_corp.newsfeeds.com...
> > I'm doing an import into a 8.1.6 database running on Linux (Total size
 of
> > the export file is about 6megs).
> >
> > It's taking a long time and I'm wondering if there is a way to determine
> > whether it's making progress, or just hanging.
> >
> > If anyone could send me some scripts, or at least some suggestions for
> > tables to examine I'd really appreciate it.
> >
> > -greg
> >
> >
> >
> >
> > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Tue Mar 20 2001 - 19:10:20 CST