Some oracle F/S files were slow and erratic.
I needed something outside the database to show the issues. Less than a benchmark, but sufficient for showing the issue outside the db.
github.com/jkstill/disk-t…
Here is something I learned about a couple years ago involving the oraaccess.xml file.
Control fetch size with oraaccess.xml
pythian.com/blog/technical…
Just got notice that my Oracle ATP DB was paused due to inactivity. #oracle
me:
'@uptime'
UPTIME
----------------------------------------
01:15am up 41 days, 1:15, 1 users
1 row selected.
Create a map of file and directory permissions found in oracle homes. It didn't seem important to map log, trc, trm and aud extensions.
# cd /u01/app # find app oradata | grep -vE '\.log$|\.aud$|\.tr[mc]$' | xargs stat -c '%n:%a:%U:%G:%F' | tee perm-map.log
#oracle
one liner fun: get all error messages from an oracle alert log, and send to oerr
grep -oE '(TNS|ORA)-[[:digit:]]+' alert_ORCL.log| sort -u | perl -p -e '$_=lc($_); s/-/ /' | xargs -n 2 oerr
Adventures with Oracle's Client Result Cache.
My suggestion is to first scroll to the bottom and read a couple of errata in the comments.
@Pythian#Oraclepythian.com/blog/mitigatin…
17K Followers 540 FollowingHi I'm Connor McDonald!
🔥keen on tech esp. SQL/database
🔥keen on fitness
🔥keen on coffee
🔥keen on gin
🔥keen on sarcasm
I speak for me not my employer
12K Followers 1K FollowingCreator of https://t.co/w1Pz4s2EhV and a long time computer performance nerd.
Performance & Troubleshooting Training: https://t.co/lRKHSCFE6M
4K Followers 138 Followinghusband & father;
Real-World Performance Engineer @Oracle;
Oracle ACE Alumnus;
proud member of @SYM_42;
Views are my own;
Not active here anymore
5K Followers 601 FollowingProduct Manager at Oracle. Technology enthusiast. Author, blogger, speaker. Ace Director alumnus, ex Enkitec. I work for Oracle but do not speak for them.
3K Followers 1K FollowingBeerlover especially Geuze and Lambik Oracle product manager in the MAA team for FPP, photographer. https://t.co/6UYvR4v1Wz opinions and views expressed are my own
4K Followers 5K FollowingMachine Learning and AI at Oracle. Amateur photographer , reader , traveller. Opinions expressed here are my own and not my employer’s
10K Followers 358 FollowingOracle Database Product Manager with a passion for SQL, AI, and the Optimizer. Wildlife photographer and Lego builder. Views expressed are my own.
1K Followers 582 FollowingSenior Data Administrator @capgemini Views my own. I share tips and info on Postgresql, SQLServer, MongoDB and the Oracle database.
4K Followers 1K FollowingPythian is a global IT services company that helps organizations transform by leveraging data, analytics and the cloud #DataAnalytics #Cloud #Databases #BigData
4K Followers 5K FollowingLiving, breathing Oracle Security; Oracle ACE on security; OAK table member. Database security audits, consulting and training on all aspects of Oracle security
551 Followers 191 FollowingCloud, data geek and a runner. Cloud Advocate, Databases @ #GoogleCloud running in any weather. All opinions are my own. @[email protected]
15 Followers 267 FollowingWorks legally to find and fix security weaknesses in systems before malicious hackers exploit them. Usually hired by companies or governments
140 Followers 2K FollowingI’m Julie leach the winner of $310,500 ,000 in a while I’m giving out100 ,000 for my 1k followers I’m Julie leach the winner of $310,500 ,000 in a while I’m giv
323 Followers 7K FollowingI'm caring and honest lady I'm a billionaire I’m on Instagram and Facebook to help people financially especially disabled and less people. and so on
17K Followers 540 FollowingHi I'm Connor McDonald!
🔥keen on tech esp. SQL/database
🔥keen on fitness
🔥keen on coffee
🔥keen on gin
🔥keen on sarcasm
I speak for me not my employer
10K Followers 40 Following50 years using computers, 40 years freelancing, 35 years dealing with Oracle design and performance issues; mostly retired.
Now tweeting at https://t.co/jgM903GCKq
12K Followers 1K FollowingCreator of https://t.co/w1Pz4s2EhV and a long time computer performance nerd.
Performance & Troubleshooting Training: https://t.co/lRKHSCFE6M
4K Followers 138 Followinghusband & father;
Real-World Performance Engineer @Oracle;
Oracle ACE Alumnus;
proud member of @SYM_42;
Views are my own;
Not active here anymore
5K Followers 601 FollowingProduct Manager at Oracle. Technology enthusiast. Author, blogger, speaker. Ace Director alumnus, ex Enkitec. I work for Oracle but do not speak for them.
3K Followers 425 FollowingEnjoying a new life as a playful artist. Retired Oracle Database Guy. David Bowie fanatic. Crystal Palace FC tragic, Book lover. Dislike RWFWs.
386K Followers 623 FollowingLove Linux/Unix, open source, and programming? Into Sysadmin & DevOps? Follow us! Boost your IT career with daily new tools, apps, and humor ⤵️
4K Followers 5K FollowingMachine Learning and AI at Oracle. Amateur photographer , reader , traveller. Opinions expressed here are my own and not my employer’s
10K Followers 358 FollowingOracle Database Product Manager with a passion for SQL, AI, and the Optimizer. Wildlife photographer and Lego builder. Views expressed are my own.
4K Followers 1K FollowingPythian is a global IT services company that helps organizations transform by leveraging data, analytics and the cloud #DataAnalytics #Cloud #Databases #BigData
2K Followers 1K FollowingAuthor of AI, Quantum Computing and Web3, formerly CTO at ProvenDB. Database/blockchain guy, author of eight books on DB tech. Hopeless old geek.
4K Followers 6K FollowingExperienced Oracle DBA with a Chemistry degree, principal author of Oracle Exadata Survival Guide. Oracle ACE. #BlueCrew 🚫NO DMs🚫, you will be blocked. 🟧💙
2K Followers 724 Following[OakTable member] [Oracle ACE Director & OCM] [Oracle Database Whisperer, performance maker and story teller] [founder and board member of POUG]
1K Followers 69 FollowingI'm Nigel Bayliss. I work for Oracle. The opinions expressed here are my own. I'm the Oracle Optimizer PM and my background is doing stuff with very large DBs.
888 Followers 215 FollowingSr. Principal Software Engineer, Oracle. Former Sr. DBA At Zione, Education Director at Hotsos. Optimizing Oracle Databases and SQL for over 30 years.
123K Followers 739 FollowingGRR is the official Goodwood channel sharing all the best motorsport and motoring content from Goodwood and beyond... Send in your photos and vids to feature!
278K Followers 432 FollowingRacing driver, commentator, TV presenter, public speaker. For Media / appearances: [email protected] ; Instagram: https://t.co/s3vgFx80WZ
3K Followers 204 FollowingCEO of JabPerf, Contributing Author to "Performance Analysis & Tuning on Modern CPUs" (1st & 2nd Edition available on Amazon), Blogger, and Former Amateur Boxer
1.4M Followers 0 FollowingA universe of atoms, an atom in the universe. Tribute to the great explainer. Tweets about Science and Wisdom. Portrait by L.V Patten.
3K Followers 562 Followingloves data. Relational, Big, Fast, Streaming. Product manager at Google Cloud.
The opinions stated here are my own, not those of my company.
869 Followers 91 FollowingOraPub founder, Craig Shallahamer, works with Oracle DBAs to help them learn solutions to database problems via on-site, online and webinar training events.
57 Followers 103 FollowingI love #Autocross and all things #AutoX, especially the people. Sharing a passion for driving stick and connecting with fellow enthusiasts.
1K Followers 1K FollowingData Engineer @CERN and @ATLASexperiment - I work with databases, data lakes, and data analytics - Oracle RDBMS - Apache Spark
5K Followers 143 FollowingFrom the makers of Oracle SQL Developer, your new Oracle Database command line interface. Click the Website link for instant download of latest version.
3K Followers 285 FollowingFrom Aug 2023, retired. Previously, Technical Product Mgr at Yugabyte, Inc. Before that, Product Mgr at Oracle HQ. OakTable member. Not known for my brevity.