How to estimate the size of SGA?
Latest Answer: SQL> show sgaTotal System Global Area 167772160 bytesFixed Size 1247900 bytesVariable Size 58721636 bytesDatabase Buffers 104857600 bytesRedo Buffers 2945024 bytes ...
What do you do when the server cannot start due to a corrupt master database?
What will you do when the ASE server's performance is bad?
Latest Answer: Bad performance" is not a very meaningful term, so you'll need to get a more objective diagnosis first. Find out (i) what such a complaint is based on (clearly increasing response times or just a "feeling" that it's slower?), (ii) ...
Explain how will you setup Replication Server & sync it?
Latest Answer: Replication server can be setup using many ways1)Using Oracle Streams2)Using Advanced replication 3)Using Mviews.Each has their own mechanism to sync data. Regards,Vijay Kaushik ...
What do you do when tempdb is full?
How to load data into multiple tables at once?
Latest Answer: You can use SQL loader to do this. Using the When condition in SQL Loader control file this is possible. ...
What should you do when you find a stacktrace in the server errorlog?
Is it possible to resize tablespaces and data files? If yes, how?
Latest Answer: Hi all,Yes i agree with the answer but resize in the sense,the size should also get decrease.we can decrease even the size of the datafile but the condition is the datafile should be empty. ...
How to monitor how fast a table is imported? How to modify data as it loads into the database?
Latest Answer: Use below script to monitor how speed import is happening.SELECT SUBSTR(sql_text, INSTR(sql_text,'INTO "'),30) table_name, rows_processed, ROUND( (sysdate-TO_DATE(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1) minutes,
TRUNC(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd ...
How does one use the import/export utilities?
Latest Answer: Logical Backup using export utility works as an alternative backup method.we can export from one user and import into another within the same database.we can export from one database and import into another database(but both source and destination databases ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
