oracle gather table statistics
Solutions on MaxInterview for oracle gather table statistics by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle gather table statistics"
Juan Manuel
31 Jan 2021
1CALL DBMS_STATS.GATHER_TABLE_STATS(
2 'OWNER_NAME',
3 'TABLE_NAME',
4 ESTIMATE_PERCENT => 50, -- longer but better than 1 for exec plans
5 GRANULARITY => 'PARTITION', -- or SUBPARTITION or nothing
6 PARTNAME => 'PARTITION_NAME', -- or nothing
7 DEGREE => 8 -- parallelism
8);similar questions
oracle size of tables in schemaoracle show proceduresoracle session statisticsoracle tables with column nameoracle tablespace usageoracle all tables in schemaoracle get table schemaoracle table statistics last analyzedlocked tables in oracleoracle tablespace tables listtablespace oraclehow to check last gather stats on table in oracleoracle get table column namesoracle table privilegesoracle all tablesoracle table statisticshow to check table lock in oracle sql developeroracle user quota on tablespaceoracle list datafiles in tablespaceoracle check table lockoracle show grants on tableoracle table sizeoracle dependencies tablesize of all tables in a schema oracleoracle function return tableoracle columns tableoracle tablespace size your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful