How the SMON process is used to write into LOG files ?
Answers were Sorted based on User's Feedback
Answer / guest
SMON process CAN'T be used to write into LOG files
| Is This Answer Correct ? | 7 Yes | 6 No |
Answer / siva
In SGA Memory Struture,the SMON,PMON,Redo Log Buffer and
others.When the redo log buffer full then only with the help
of LGWR writed into the logfiles.
| Is This Answer Correct ? | 1 Yes | 1 No |
What is user and end user?
What is different keys in dbms?
Enlist the various transaction phases.
Describe the purposes and advantages stored procedure?
How to drop all foreign keys in database?
What is Normalization and its different forms?
Have you heard about sixth normal form?
What does <> mean in database?
What are different types of joins in the sql?
How do you start a database?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
what is the difference between securityand protection in dbms?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)