what is the size of ur database(like oracle)

Answer Posted / dheeraj patidar

ur calculate size of data base in oracle



select sum(bytes)/1024/1024 from dba_data_files;

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1878


What can we do to improve the performance of informatica aggregator transformation?

620


Does an informatica transformation support only aggregate expressions?

612


Suppose we do not group by on any ports of the aggregator what will be the output?

582


What is difference between a gateway node and worker node?

630






What do you mean by channel change?

549


Explain lookup transformation in informatica

650


What is the difference between writing a joiner query in ANSI style and THETA style?

1925


How do you load first and last records into target table?

672


How can we store previous session logs?

572


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1539


What is flashback table ? Advance thanks

1484


What is meant by incremental aggregation?

589


How can we use batches?

606


What are the settings that you use to configure the joiner transformation?

617