what are the necessary steps to be take when server gets down? How can we increase size of a database?

subha gunasekaran

 Profile Answers by subha gunasekaran Questions by subha gunasekaran

• Jun 5th, 2008

1.Bring up the server. 2.Run the profile of the database 3.Bring up the database. 4.In server prompt, check ps- ef | grep pmon - This is used to check whether the database is up or not. 5.Bring u...

Answer Question  Select Best Answer

subha gunasekaran

 Profile Answers by subha gunasekaran Questions by subha gunasekaran

• Jun 5th, 2008

To see fragmentation:select sum(bytes)/1024 from  dba_data_files where tablespace_name='';output: 10select sum(bytes)/1024 from  dba_segments where tablespace_name='';ouput :...

sjpunshi

• Sep 25th, 2007

Query dba_segments, dba_free_space for the tablespace and table, if too many extents are avaiable, yet space availability is a problem, implies that the table is fragmented. Solution, export the segment. recreate and import, fragmentation is eliminated.

Answer Question  Select Best Answer

bapiora

 Profile Answers by bapiora Questions by bapiora

• Jun 29th, 2009

As a dba if you want such info. from your database side.You issue following command from server end.   select owner,table_name,tablespace_name from dba_tables or if you need some specific user info. issue   select owner, table_name ,tablespace_name from dba_tables where owner='< username>'

subha gunasekaran

 Profile Answers by subha gunasekaran Questions by subha gunasekaran

• Jun 5th, 2008

select sum(bytes)/1024 from dba_segments where segment_name='TABLE_NAME' and owner=' 'As segment_name represents table_name,index_name..provide the table_name and index_name in the above query

Answer Question  Select Best Answer