Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
SQL Management Base (Read 2796 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
SQL Management Base
01.04.11 at 09:53:21
 
SQL Management Base
 
The SQL management base (SMB) is a part of the data dictionary that resides in the SYSAUX tablespace. It stores statement log, plan histories, SQL plan baselines, and SQL profiles. To allow weekly purging of unused plans and logs, the SMB is configured with automatic space management enabled.
 
You can also add plans manually to the SMB for a set of SQL statements.  
 
Importing and Exporting SQL Plan Baselines
Oracle Database supports the export and import of SQL plan baselines using its import and export utilities or Oracle Data Pump. Use the DBMS_SPM package to define a staging table, which is then used to pack and unpack SQL plan baselines.
 
 
Source:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/optplanmgmt.htm#C HDDAEIC
Back to top
 
« Last Edit: 01.04.11 at 09:54:36 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1