Monitor Index Usage

Hi  all,   is there a way to monitor index usages in oracle 8i ,like 9i v$object_usage?   Thanks   Arvind Kumar

Accessing forms server through proxy server

,error is 'FRM-29050 failed to connect to server' what can be problem. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

oracle full table scan

Dear All, is there any way to find which tables (table name) are suffering from full table scan ,so that i can create indexes on them to enhance the performance. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar INET: [EMAIL

RE: help

size, sort_area_size, and db_block_buffer for verifying that there's enough memory asigned. Of course, you should diagnose memory problems on your OS and Oracle. HTH JL --- Arvind Kumar <[EMAIL PROTECTED]> wrote: > > Hello all, > > i am facing swapping problem ..below is th

RE: help

size, sort_area_size, and db_block_buffer for verifying that there's enough memory asigned. Of course, you should diagnose memory problems on your OS and Oracle. HTH JL --- Arvind Kumar <[EMAIL PROTECTED]> wrote: > > Hello all, > > i am facing swapping problem ..below is th

RE: help

size, sort_area_size, and db_block_buffer for verifying that there's enough memory asigned. Of course, you should diagnose memory problems on your OS and Oracle. HTH JL --- Arvind Kumar <[EMAIL PROTECTED]> wrote: > > Hello all, > > i am facing swapping problem ..below is th

RE: help

R CACHE HIT RATIO IS ABOVE > 93% > > Now the problem is of swapping there are about 70 oracle users using this > database ,swap utilization is always above 1.5gb. > > what could be the problem... > > > Thanks > Arvind Kumar > -- > Please see the official ORAC

help

database ,swap utilization is always above 1.5gb. what could be the problem... Thanks Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar INET: [EMAIL PROTECTED]> (by way of Jared Still <[EMAIL PROTECTED] Fat City Network Services-- 858-53

PGA

hello all, how does increasing the value of SORT_AREA_SIZE affect the unix system perfomance. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: DB link problem

ind; select * from zone_mst@arvind * ERROR at line 1: ORA-22804: remote operations not permitted on object tables or user-defined type columns. Regards Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Netw

DB link problem

on object tables or user-defined type columns. Regards Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acc

RE: deploy forms on web

sed by the > various env setting FORMS60_... not mapping correctly > to the virtual directories defined on the web server > > hth > connor > > --- Arvind Kumar <[EMAIL PROTECTED]> wrote: > > DearAll > > > > > > i want to deploy my appli

deploy forms on web

ards Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing L

deploying forms & reports on web problem

ards Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing L

deploying forms & reports on web problem

ards Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing L

Table Lock

Hi,     i am running Oracle 8.1.6 on RedHat 6.1 , the problem is one of my Table is getting locked and not getting unlocked until i kill the session. the users r reporting that they r not using anything which may lock this table ,     Regards Arvind