interesting post<\/a> on Dominic Delmolino’s blog recently about the value of browsing through the SQL scripts in $ORACLE_HOME\/rdbms\/admin to learn more about how Oracle works – particularly sql.bsq – and I’d recommend a glance at some of the make files, for the same reason. But, please, if you’re going to start relinking executables, think carefully about it first, consult Metalink and if you screw up your server, don’t come running to me! 😉<\/p>\n","protected":false},"excerpt":{"rendered":"Hooray! Something vaguely technical – at last. My new client is hot on software licence compliance and what seemed a minor issue to me reared it’s slightly ugly head this week. When connecting to our 10.2.0.2 database instances using sqlplus, the version banner displays options that we aren’t using, for example Data Mining and OLAP.… Continue reading Re-linking oracle<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1264","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":972,"url":"http:\/\/orcldoug.com\/blog\/2005\/06\/12\/dba_registry\/","url_meta":{"origin":1264,"position":0},"title":"dba_registry","date":"June 12, 2005","format":false,"excerpt":"It's true I learn something new all the time. Is it just me? Did everyone know about this?I was talking to one of the other DBAs at work on Friday who was telling me that one of the dbs we've taken over looks like it wasn't upgraded properly. I connected\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":884,"url":"http:\/\/orcldoug.com\/blog\/2006\/01\/12\/something-else-i-didnt-know\/","url_meta":{"origin":1264,"position":1},"title":"Something Else I Didn’t Know","date":"January 12, 2006","format":false,"excerpt":"This one is courtesy of Andrew Campbell at Sun Microsystems. He noticed in an Oracle Magazine article that you can use a URL as a script name in sqlplus.SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProdPL\/SQL Release 10.2.0.1.0 - ProductionCORE 10.2.0.1.0 ProductionTNS for 32-bit Windows:\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1335,"url":"http:\/\/orcldoug.com\/blog\/2007\/11\/01\/rac-and-aix\/","url_meta":{"origin":1264,"position":2},"title":"RAC and AIX","date":"November 1, 2007","format":false,"excerpt":"One of the interesting aspects of working at my current site is that the DBAs don't install Oracle. Yes, I know, and I'm not going to elaborate on that statement other than to say it's a little frustrating and software management has become a much more interesting experience than I\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":957,"url":"http:\/\/orcldoug.com\/blog\/2005\/08\/10\/a-shortcut-for-oracle_home\/","url_meta":{"origin":1264,"position":3},"title":"A shortcut for ORACLE_HOME","date":"August 10, 2005","format":false,"excerpt":"I've enjoyed quite a few of the tips in other people's Oracle-related blogs (see the links in the right hand pane) so thought I'd chuck in a few as well. This one's an old one, so many of you will know about it already, but for those that don't ...In\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1649,"url":"http:\/\/orcldoug.com\/blog\/2011\/09\/21\/real-time-sql-monitoring-retention-part-2\/","url_meta":{"origin":1264,"position":4},"title":"Real-Time SQL Monitoring – Retention (part 2)","date":"September 21, 2011","format":false,"excerpt":"As I mentioned in my last post, I've been looking at increasing the SQL Monitoring Retention at my current site using _sqlmon_max_plan but, as well as confirming with Oracle Support that they're happy for us to do so, it would be nice to know what the resulting memory footprint would\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1112,"url":"http:\/\/orcldoug.com\/blog\/2009\/10\/29\/10g-consolidated-trace-files-and-px\/","url_meta":{"origin":1264,"position":5},"title":"10g Consolidated Trace Files and PX","date":"October 29, 2009","format":false,"excerpt":"At the end of my Tracing Parallel Execution presentation at the Scottish OUG conference, Michael M\u00f8ller of Miracle asked whether the consolidated trace files produced by the DBMS_MONITOR package and trcsess utility are in strict time order. i.e. Will I see the actions of the query coordinator, then the actions\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1264","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1264"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1264\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1264"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}