If you have an example table, what is the best way to get sizing data for the production table implementation?
- 1 Answers
- 659 Views
- I also Faced
- E-Mail Answers
Answer / Shadab Ali
"To gather sizing data for a production table in Oracle, you can use the following commands: To see the number of rows and the storage required for the table, execute `SELECT COUNT(*), SUM(DBMS_ROWS.GET_LENGTH()) FROM your_table;`. To get an overview of storage consumption for all tablespaces, run `SHOW SGA STATISTICS` and look at the 'Total Active Session Memory' (TASM) section."
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the possible ways to gain information regarding the control file?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
How does one create a new database?
What happens if a tablespace clause is left off of a primary key constraint clause?
How can you find dead processes?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
How many types of dba are there?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
Why do we need a database?
How can you find your id on a system?
What do you mean by dba?
How should a many-to-many relationship be handled?
Oracle General 
