• October 31, 2005 31 Oct'05

    Help with tkprof report

    My total CPU time is 214 minutes for 672 rows fetched. Under "query" I have 6830738. What does this mean?  Continue Reading

  • October 31, 2005 31 Oct'05

    Determining the space used by particular tables

    I'm reorganizing a database that has tables and indexes in the same tablespace. How do I determine the space used by the tables (not allocated) owned by a particular user with all the table names beginning with CT_? I want to know what size the ...  Continue Reading

  • October 31, 2005 31 Oct'05

    Is my table in the buffer pool keep?

    I created a table using the command 'create table t (no number)' followed by an alter, 'alter table t storage(buffer_pool keep).' There are 100 rows in this table. If I query v$db_object_cache, I do not find this table as kept. However if I query ...  Continue Reading

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close