This week’s three selections address some of our favorite topics: reading and writing. If you’re looking for inspiring and thought-provoking posts, you’re in luck. From the hunger that develops when a reader can’t find the time to read, to the power of the dictionary and your own memories, we’ve got something for everyone.
I miss the feel of bound paper between my fingers.
Here’s a quick and dirty script to create a procedure (in the SYS schema – so be careful) to check the Hakan Factor for an object. If you’re not familiar with the Hakan Factor, it’s the value that gets set when you use the command “alter table minimize records_per_block;”.
I was prompted to publish this note by an item on the OTN SQL forum describing a problem with partition exchange with a table when there were bitmap indexes in place and the table had been changed to have some extra columns added. (Problem as yet unresolved as I publish).
Over the past 16 months (or so) I have give a join presentation with Anthony Heljula called ‘Getting Real Business Value from Oracle Data Mining and OBIEE’, at a number of conferences and OUG SIGs. We have had a lot of very positive feedback on this presentation. The presentation is a busy 45 minutes (questions only at the end) that walks through a pilot data science project we did for a University in the UK.
Cloud computing has brought a host of advantages for businesses that have become impossible to ignore, from decreased capital spending to enhanced collaboration. However, the true benefits of these technologies come with time, and therefore, a more extensive and strategic cloud plan, with remote database support, can potentially offer enterprises a more significant competitive edge in the long run. By applying these initiatives more holistically to all aspects of the organization, firms stand to gain more flexibility and productivity than ever before.
Oracle’s advanced partitioning has some deficiencies. For example, partition info is missing in V$SESSION_LONGOPS for scan-operations ( full table scans, full index scans ). V$SESSION_LONGOPS.TARGET only shows OWNER.TABLE_NAME in these cases, even when the underlying table/index is partitioned, though the longop doesn’t refer to the whole segment but only to one (sub-)partition of it.
I filed an enhancement request several years ago concerning this matter, but never received any feedback.
Created an Unix user (e.g. tier1 ) in the Oracle database server that can perform some database administration tasks but cannot be used to view or modify any application data.
Current typical Unix/Liux Environment:
- OS user: "oracle" is the Oracle software owner and its primary group is "dba" (i.e. Oracle database files have ownership oracle:dba )
- Assuming OSDBA group is "dba" (i.e. every os user that belongs to "dba" group can login as sysdba and view any data)
1. The Ship I took some time off working on the development of several Oracle Certification Exams to participate in the Norwegian Oracle User Group conference. Many other speakers and attendees have described the wonderful environment of the conference, comprising a land day in Oslo, followed by two days aboard the Colour Magic Cruise Ferry […]
Business intelligence (BI) solutions have the potential to empower businesses in a multitude of ways by allowing professionals to mine extensive stores of information for enhanced insight. However, many firms still aren't fully leveraging these tools due to inadequate resources or expertise.