Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: space, performace

Re: space, performace

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: Sat, 07 Oct 2000 18:53:43 GMT
Message-ID: <8rnrfl$j3b$1@nnrp1.deja.com>

Hi.

 Look at USER_EXTENTS table.

 Michael.

In article <8rm19t$ana$1_at_nnrp1.deja.com>,   hosu_at_cs.umbc.edu wrote:
>
>
> Hi, there,
>
> Please forgive me if such question has been asked before. (I searched
> the archive, could not find the exact same. So, I ask you to save my
> time.)
>
> I have a table in Oracle 8i, then I use Java program which creates
 JDBC
> connection to insert thousands of rows into the table. How can I know
> how much disk space the table occupies? I/O? CPU?
>
> Then when I conduct a query against the table, to evaluate the
> performace, which tool shall I use? OEM Tuning Pack(SQL Analyze)?
>
> Thanks a lot!
>
> Honglin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 07 2000 - 13:53:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US