Amit Oracle DBA Blog

This blog is to share oracle concept and real time experience for Oracle beginner.....

Saturday, 2 December 2023

Transport Good Execution Plan(Hash Plan) from one database to another database

›
1. Create Empty Tuning Set BEGIN   DBMS_SQLTUNE.CREATE_SQLSET (     sqlset_name  => 'SQLT_WKLD_STS',      description  => ...
Monday, 20 November 2023

Datapump FILESIZE parameter

›
FILESIZE : It specifies the maximum size of each dump file. If the size is reached for any member of the dump file set, that file is closed ...
‹
›
Home
View web version
Powered by Blogger.