select segment_name,sum(bytes) from dba_segmentswhere segment_name='TABLE_NAME' AND OWNER='OWNER of the table'group by segment_name

satish penugonda

• Jul 7th, 2006

And adding to the previous...view are not physical entities like tables which occupy space in the database..they are logical and whenever you select, the query underlying the view gets fired and results are returned. Hence, you cannot get the space information for views

Answer Question  Select Best Answer

These are a few of the advantages of using DBCA:You can use its wizards to guide you through a selection of options providing an easy means of creating and tailoring your database. It allows you to provide varying levels of detail. You can provide a minimum of input and allow Oracle to make decisions for you, eliminating the need to spend time deciding how best to set parameters or structure the database....

oradba

• Apr 6th, 2006

The Database Configuration Assistant guides you through the process of creating a new database, changing the configuration of an existing database, or deleting a database. Many of the database creatio...

Answer Question  Select Best Answer

krisna

• Feb 3rd, 2006

NO we can't create index on long raw column.

Answer Question  Select Best Answer

sheela

• Sep 7th, 2005

Function-based indexes can use any Function or Object method that is declared as repeatable. Queries using expressions can use the index. Ex:- CREATE INDEX sales_margin_inx  ON ...

Answer Question  Select Best Answer

ritesh raj singh

• Jul 4th, 2006

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM?...

Answer Question  Select Best Answer

paparao03

 Profile Answers by paparao03 Questions by paparao03

• Nov 3rd, 2006

.ora files contain Oracle Engine papameters info.net files contain O.S engine parameter info

Answer Question  Select Best Answer

What is Oracle Reserved Memory and Unreserved Memory? What is the size of Oracle Reserved Memory?

bassem_farouk

 Profile Answers by bassem_farouk Questions by bassem_farouk

• Sep 21st, 2008

Is the meomory that is allocated to each connection to Oracle, this memory is not recliamed even if the session is inactiveit is recliamed if the session is disconnected onlyto see it:D:appadminproduc...

Answer Question  Select Best Answer

sviru

 Profile Answers by sviru Questions by sviru

• Jul 11th, 2011

DBA_INDEXES, ALL_INDEXES and USER_INDEXES

Answer Question  Select Best Answer

 The  related columns of the tables are called the cluster key.  The cluster key  is indexed using a cluster index and its value is stored only once for multiple tables in the cluster.

 It consists ofone or more data files.one or more control files.two or more redo log files.The Database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesData dictionary tablesUser objects (table,indexes,views etc.,)The server that access the database consists ofSGA  (Database  buffer,  Dictionary  Cache  Buffers, Redo log buffers, Shared...

This is extract from Oracle10g Advanced Replication Book. How Materialized Views Work with Object Types and CollectionsOracle object types are user-defined datatypes that make it possible to model complex real-world entities such as customers and orders as single entities, called objects, in the database. You create object types using the CREATE TYPE ... AS OBJECT statement. You can replicate object...

Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for a very specific purpose.A virtual index is created in a slightly different manner than the normal indexes. A virtual index has no segment pegged to it, i.e., the DBA_SEGMENTS view will not show an entry...

How you spend a day as a DBA. Explain DBA activities in detail.

What is simple replication and advance replication? What is the difference between simple replication and advance replication? How can we do simple replication?

Describe four properties of database isolation. In which situation lock contention will happen. What is transaction lock?

Tell me any instance when your database encountered any problem. How you dealt with that problem.

How to write script for export backup in shell.

What are the changes that happen in Database buffer cache(List of all changes in DB Buffer Cache)

Discuss the advantages and disadvantages of hierarchical database management system in comparison with RDBMS. Discuss types of applications suitable for hierarchical DBMS and RDBMS.

Why do we need unmanaged node?