Its really pays out - to click on all url's (just kidding) - as not regular vscode user, was not aware - documentation to plugins is on marketplace. Have already given up on diagrams - pressed Shift just not allow drag anything. Till i read NOTE: Hit 'Shift' button when cursor is over diagram 😀
quick test shows that at least KEEP doesn't raise any error by using it in identity column, so maybe it is just lack of documentation, but maybe ofcourse it is intention to prevent anomalies as you suggest
Never worked with proxmox - but run into similar issue with OEL 9 on vanilla qemu - the workaround/fix in my case was to use -cpu max. Maybe you can try this setting in qm.conf or similar...
GROUP BY ALL makes me really motivated to be yet more lazy than i am (just kidding)
In case you didn't see, #Oracle #database 23.9 has landed
docs.oracle.com/en/database/...
#SQL #NewFeatures
In sqlcl wallet connection worked in the past either - just not out of the box, the connection string had to be extended by @jdbc:oracle:thin/oci - so, i wrote kilobytes of shell aliases/doskey macros to hide it. Now i can send them all to /dev/null. Am very sad about it (not really) 😘
It seems - 23.7 RU was the last one where _exadata_feature_on=true worked, 23.8 just ignores this hack. Otherwise, maybe it was removed shortly before release on premise for non engineered, who knows 😀
Thx for sharing, seems to be related to access.redhat.com/errata/RHBA-...
For geeks: two bpftrace scripts to map UTS event and component names to their internal ids.
t.ly/bGj0M
t.ly/ypKuv
Didn’t plan on it, but sometimes the rabbit hole chooses you... Turns out "oradebug doc" doesn't expose all trace events.
just to mention one of alternatives
count(*) over(order by n rows between unbounded preceding and current row)
It's to be tested, i guess. I for myself will try to follow this method for a month and then compare, whether i feel better or not
on a serious note - recently read one doctor, who claims we can mostly compensate sunlight shortage even at winter season being at least 2 hours outside of office, also walking, whatever. Somehow feel in agreement with that
tribune.com.pk/story/252149...
In a podcast interview, Zuckerberg also announces his plan to replace AI Agents with Mid-level engineers this year at the Meta labs. Also, what's now - recursion ? Mid-level enginieurs to be replaced by AI-agents to be replaced by Mid-level engineurs?
Recommended reading for Oracle Database
Deep dive on Binary JSON formats (the first in a series) from @loiclefevre.bsky.social
medium.com/db-one/jsonb...
The only issue i discovered till yet - that i need to use the jdbc url (oci8 and thin - both are ok) - in case of wallet, without the jdbc url - no flags work (-thin, -thick, -oci) - but as i understood - bug is already filled for this issue, so i need only wait till it get fixed and released ;-)
Right, thanks, already figured it out, i was not aware of ojdbc.properties - have seen it by browsing sqlcl oracle forum, thanks for prompt hint and happy new year!
No, it just seems... using the jdbc url - like /@jdbc:oracle:oci8:@tns_alias does the job. Still a bit hacky( besides that - it tightly bound to the libocijdbc23.so version - the sqlcl.24.3.2.330.1718 requires (for oci connection) the instant client 23.5.0.24.07, thereas 23.6.0.24.10 is the current)
It seems, current sqlcl refuses to work with external secure store (oracle walet). Tried -oci flag, -thick flag, no flags at all (as stated in Doc ID 2987845.1 ) - get continuosly ORA-01017 (just vanilla oracle database, no cloud, no adb), whereas sqlplus works flawlessly
find scripts in sqlplus: scoop install fzf fd bat,add to windows terminal "command":{"action": "splitPane","commandline": "cmd /c (for %a in (\"%SQLPATH:;=\" \"%\") do @(fd . -e sql %~a))|fzf --preview=\"bat -f -l sql {}\" --bind ctrl-k:preview-up,ctrl-j:preview-down |clip","split": "down"}
Screenshot of 'crsctl stat res -t' in a Linux bash
Boring #Christmastime ahead? My latest #blog shows how to install #Oracle #ASM (and #database) #23ai from #Exadata sources on a #Linux #Server.
www.usn-it.de/2024/12/20/i...
Thanks @julianfrey.ch and the @sym42.bsky.social folks for help!
@oracleace.bsky.social @ora2know.bsky.social
It drives me crazy to find a certain bookmark in firefox (have tons of them) - fortunately, it can be queried with sql
gist.github.com/Maxim4711/9c...
still the first question by oracle support if you fill a service request due to some error - is this behaviour reproducible in sqlplus 😜
Fun Oracle Database 19c error message fact: there are 7 ORA-xxxxx messages that say “Don’t do that”, 4 of them w/o an exclamation point, 3 of them do.
ORA-30658: attempt was made to create a temporary table with EXTERNAL organization
Cause: . . . This is not supported.
Action: Don’t do that!
thanks for that, just discovered Godspeed You! Black Emperor - Anthem For No State - it's genious!
Regards
Maksim
set YAZI_FILE_ONE=%GIT_INSTALL_ROOT%/file.exe
set YAZI_CONFIG_HOME=%HOME%/.config/yazi
scoop install yazi imagemagick ffmpeg jq 7z zoxide fd ripgrep fzf
mkdir %HOME%/.config/yazi
git clone github.com/sxyazi/yazi....
cp -pr yazi\yazi-plugin\preset\* yazi\yazi-config\preset\* %HOME%/.config/yazi
