Maximum buffer size for DBMS_OUTPUT.ENABLE
Asked By
10 points
N/A
Posted on - 04/11/2012
When using the DBMS_OUTPUT.ENABLE, what is the maximum buffer size that can be specified by it?
Best Answer
Best Answer
Maximum buffer size for DBMS_OUTPUT.ENABLE
The maximum size of The DBMS_OUTPUT.ENABLE function is 1,000,000 and the minimum size is 2,000 up to oracle 10g versions when the user specifies buffer size (NOTNULL).And Buffer_size IN INTEGER DEFAULT 2000The syntax is DBMS_OUTPUT.ENABLE (the default is 20,000 for backwards compatibility with earlier database versions that did not support unlimited buffering. Now oracle 10g release 2 buffer size is unlimited. The DBMS_OUTPUT.ENABLE enables calls to various functions PUT, PUT_LINE, NEW_LINE, GET_LINE, and GET_LINES and DBMS_OUTPUT Package needs to be activated for calls to procedures. The buffer size is NULL where string buffer limit is not specified.
Maximum buffer size for DBMS_OUTPUT.ENABLE
Hello Francine,
It will depend on the version of Oracle that you're using. In case you are using Oracle 10g (10.1) and before, then you will use a maximum buffer size of 1,000,000 bytes.
But if you are using Oracle 10gR2 (10.2) and above, then you have no limit to the buffer size:
- The maximum buffer size that you can use is unlimited (when buffer_size = NULL).
- In the event that a user specifies buffer_size (NOT NULL), then the maximum size will be 1,000,000. Naturally, you will need to set buffer_size = NULL for unlimited size.
- If you type SET SERVEROUTPUT ON in SQL*Plus, it will have the effect of invoking DBMS_OUTPUT.ENABLE (buffer_size => NULL); with no limit on the output.
Regards,
Carl
Latest Articles
GeniusTutor Review: AI Tutor Transformation In Education
In the contemporary educational landscape, where technology plays a pivotal role in shaping learning experiences, GeniusTutor has emerged as a beacon of innovation for students grappling with the complexities of mathematics.
This comprehensive review delves...
Krikya Bangladesh Review: A Comprehensive Guide To Its Betting Services
Discover the ins and outs of Krikya Bangladesh, a prominent bookmaker in the online betting scene. This detailed review covers everything from the diversity of sports betting options and casino games to user experience, security measures, and customer support efficiency. Whether you're a seasoned bettor or new to the online gambling world,
find out how Krikya stands out in the competitive market of Bangladesh.
Top Construction Management Apps
Construction management is essential to ensure project completion in a timely and cost-effective manner. Construction management software support businesses to operate efficiently. The software is available for all types of construction projects, including residential...
Latest Blogs
Top 10 New Laptop Entrants That Shook The Public
The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...
10 Facts About The Dark Web
Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...
Top 10 Latest Steam Cleaner Machines
While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...
Latest Tips
Top 10 Internet Monitoring Software
Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...
Top 10 Best Partition Manager Software
A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software.
1....
Top 10 Best Online Music Production Software
Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...
