Explore >> Select a destination
|
You are here 
|
snapdba.com | ||
| | | | |
sqlmaria.com
|
|
| | | | | Database views have been used for decades to help simplify both ad-hoc queries and reporting for developers, analysts, and end-users. But the problem with defining views is they tend to be either t... | |
| | | | |
dbamarco.wordpress.com
|
|
| | | | | I just had some fun with Oracle 12c PDBs and snapshot clones. In the alert.log I found some unexpected errors "ORA-01157: cannot identify/lock data file XX". The file was part of a PDB which I used for testing. So I investigated that and found the file which was pretty small. So my assumption was that... | |
| | | | |
parvu.org
|
|
| | | | | To identify unused PL/SQL code in an Oracle database, several methods are recommended. Strategies include auditing PL/SQL execution, using DBA_DEPENDENCIES views to track dependencies, and analyzing execution data through DBMS_PROFILER. A process for safely removing unused code should be established, including renaming suspected units and ensuring backups before deletion. | |
| | | | |
blog.yannickjaquier.com
|
|
| | | SQL Plan Management feature overview through concrete example and its interactions with Adaptive Cursor Sharing (ACS) and SQL Profile | ||
