Mention what problem one might face while writing log information to a data-base table in pl/sql?
Answer / 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 |
Why use stored procedures?
What data types does pl/SQL have?
difference between oracle 8i and oracle 9i
What is the difference between jpql and sql?
define sql delete statement ? : Sql dba
how many no of table can be join in a sql query.
What is not null in sql?
What are different joins used in sql?
how view used for security purposes?
Difference between aggregate function and analytical function?
What is sap sql?
explain normalization concept? : Sql dba
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)