Oracle 18c new feature’s in SQL*Plus utility

Display the SQL_ID for each SQL statement using  SET FEEDBACK ON SQL_ID option.

SET FEEDBACK ON SQL_ID feature is used to display the SQL_ID for each SQL statement.
This feature will provide the SQL_ID on the end of our executed SQL Statement.

Set the number of rows displayed for particular SQL statement using SET ROWLIMIT option.

SET ROWLIMIT feature is used to set the limit for number of rows displayed for each SQL statement.
By default, ROWLIMIT is OFF.

 

Dynamically change the output display to fit the screen size using SET LINESIZE option.

The SET LINESIZE feature is a WINDOW option. Automatically it will be change the linesize and pagesize for the given output based on width and height of the screen size.

 

Catch Me On:- Hariprasath Rajaram

LinkedIn:    https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:   https://www.facebook.com/HariPrasathdba
FB Group:   https://www.facebook.com/groups/894402327369506/
FB Page:      https://www.facebook.com/dbahariprasath/?
Twitter:       https://twitter.com/hariprasathdba

Oracle 18c : MEMOPTIMIZE_POOL_SIZE in SGA

Description:-

  • Oracle 18c introduces new feature called MemOptimize pool, a memory area in the system global area (SGA).
  • We can increase the size of the memoptimize pool by manually adjusting the MEMOPTIMIZE_POOL_SIZE initialization parameter.
  • We have use this feature’s to frequently access tables in database level. Those tables are pined into buffer cache using primary key values
  • Tables must have primary key column then only we will achieve the expected performance from the query level.
  • Tables should not be compressed. Compressed tables not suitable for Memoptimized Rowstore option.

To check the value of Memoptimized _Pool_size parameter

To set the size of MEMOPTIMIZE_POOL_SIZE parameter.

Note this parameter is not dynamic and required database restart.

Now the MEMOPTIMIZE_POOL_SIZE parameter value has been changed to 1GB.

Create table with  Memoptimized Rowstore option.

Alter the existing table for memoptimized read.

We can load the table data into pool using DBMS_MEMOPTIMIZEpackage:

Catch Me On:- Hariprasath Rajaram

LinkedIn:    https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:   https://www.facebook.com/HariPrasathdba
FB Group:   https://www.facebook.com/groups/894402327369506/
FB Page:      https://www.facebook.com/dbahariprasath/?
Twitter:       https://twitter.com/hariprasathdba