adspace


Mention what problem one might face while writing log information to a data-base table in pl/sql?

Answer Posted / Ankit Varshney

One potential issue could be performance degradation due to frequent writes, as logging large amounts of data can slow down the execution of other operations. Another problem might be data consistency issues if not properly handled in case of errors or concurrent transactions.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the advantages of sql ? : Sql dba

1142


what is collation? : Sql dba

1229


What is the current version of sql?

1094


Do we need to rebuild index after truncate?

1138


what is bcp? When does it used? : Sql dba

1055


How do I remove duplicates in two columns?

1186


What is the current version of postgresql?

1177


Can delete statement be rollbacked?

1054


Is inner join faster than left join?

1276


what are aggregate and scalar functions? : Sql dba

1129


What is your daily office routine?

2346


Can we rollback truncate?

1074


define sql insert statement ? : Sql dba

1098


how to use regular expression in pattern match conditions? : Sql dba

1113


If a cursor is open, how can we find in a pl/sql block?

1238