Preamble
The Oracle/PLSQL LOG function returns the logarithm n at the base m.
Syntax of the Oracle/PLSQL LOG function
LOG( m, n )
Parameters and arguments
- m must be a positive number, except 0 or 1.
- n must be a positive number.
The LOG function returns a numeric value.
The LOG function can be used in the following versions of Oracle/PLSQL
|
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
|
Let’s consider some examples of the LOG function and learn how to use the LOG function in Oracle/PLSQL.
SELECT LOG(10, 20) FROM DUAL;
--Result: 1,30102999
SELECT LOG(2, 15) FROM DUAL;
--Result: 3.90689059
SELECT LOG(100, 1) FROM DUAL;
--Result: 0
About Enteros
Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
How Can Banks Improve Database Performance for Real-Time Payment Processing?
- 7 September 2026
- Database Performance Management
Strong bank database performance is essential for real-time payment processing because every payment depends on databases retrieving, validating, updating, and recording financial information with minimal delay. Banks can improve bank database performance by optimizing high-impact SQL queries, reducing locking and resource contention, monitoring transaction latency, establishing workload baselines, planning capacity, and using database observability to … Continue reading “How Can Banks Improve Database Performance for Real-Time Payment Processing?”
How Can Database Observability Help Banks Prevent Transaction Failures and Downtime?
With database observability, banks can identify performance anomalies, see how databases are performing, find bottlenecks, and troubleshoot the root causes of transaction failures before they turn into major service outages. Database observability provides banking IT teams with increased visibility into queries, workloads, resource consumption, waits, blocking and performance patterns as they evolve. This proactive visibility … Continue reading “How Can Database Observability Help Banks Prevent Transaction Failures and Downtime?”
How Can Database Observability Help Retail Companies Resolve Performance Issues Faster?
Database observability for retail helps retailers detect, understand, and resolve performance problems faster by providing deep visibility into database workloads, queries, waits, anomalies, and dependencies. Instead of reacting only after applications slow down, retail IT teams can identify root causes earlier, reduce troubleshooting time, improve uptime, and strengthen database performance monitoring for retail across stores, … Continue reading “How Can Database Observability Help Retail Companies Resolve Performance Issues Faster?”
How Can Database Observability Help Telecom Companies Resolve Performance Issues Faster?
Database observability for telecom helps telecom companies detect, investigate, and resolve database performance problems faster by providing deeper visibility into queries, workloads, waits, dependencies, and anomalies. Instead of relying only on basic infrastructure metrics, teams can identify root causes sooner, reduce troubleshooting time, improve service reliability, and support stronger telecom database performance across complex, high-volume … Continue reading “How Can Database Observability Help Telecom Companies Resolve Performance Issues Faster?”