Group of tables physically stored together because they share common columns and are often used together is called Cluster.
Latest Answer : Yes that is true, For creating cluster we first create the cluster via index/hash, then we all the tables in the cluster. ...
Latest Answer : You can search Top ten sql.Top 10 Sql. SELECT *FROM (SELECT rownum,Substr(a.sql_text,1,200) sql_text, Trunc(a.disk_reads/Decode(a.executions,0,1,a.executions)) reads_per_execution, ...
When a user comes to you and asks that a particular SQL query is taking more time. How will you solve this?
What are the common problems while taking backups? What are the necessary steps to take backup on to tapes and disks in real time?