/explore
|
You are here 
|
oralytics.com | ||
| | | | |
chandlerdba.com
October 2024 - Oracle 19C, 23ai Photo by Julius Drost on Unsplash So a while ago I spoke about passwords but forgot to mention a key element of account control in the blog. I was giving a talk on Security a few days ago and told an audience member that this information was in my... |
|
| | | | | ||
| | | | |
connor-mcdonald.com
One of the cool features in Oracle AI Database 26ai is the ability for sessions to have different levels of priority for their transaction locks. I've covered how the feature works in the video below In a nutshell, a session can nominate whether their locking priority is LOW, MEDIUM or HIGH. When a session tries... |
|
| | | | | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
tanelpoder.com
Update: As this original article is from 2007, there are better options available in the modern times for example DBMS_UTILITY.EXPAND_SQL_TEXT as explained by Maria Colgans blog entry here. If you have been involved in tuning SQL code which you have never seen before, you are probably familiar with the challenges of understanding what the code is trying to do. This can be especially time consuming when the SQL references lots of views, which reference views, which reference more views etc. So there may ... |
|
| | | |||
