ALL POSTS

Using DBMS_SYS_SQL to Execute Statements as Another User

I do realize that for most of you, there may be nothing new about the dbms_sys_sql package knowledge of it has been floating around for quite a while. I myself discovered this package a couplI do realize that for most of you, there may be nothing new about the dbms_sys_sql package knowledge of it has been floating around for quite a while. I myself discovered this package a couple of years ago while playing around with HTMLDB’s (now APEX’s) internals. I’m posting this as a response to a vox populi demand: I often see people who could benefit from dbms_sys_sql, if they only knew about it.e of years ago while playing around with HTMLDB’s (now APEX’s) internals. I’m posting this as a response to a vox populi demand: I often see people who could benefit from dbms_sys_sql, if they only knew about it.

Oracle Outside In Technology 8.2.0

I found some interesting software pieces available for download from Oracle TechNet. “Oracle Outside In Technology” represents a set of SDK’s for various content management operations. Basically, those are excellent building blocks for content management applications and tasks. Here are couple descriptions to heat your interest up.

MySQL Toolkit – Archiver

The MySQL Toolkit can be found at http://mysqltoolkit.sourceforge.net/. It is coded and maintained by Baron Schwartz (www.xaprb.com). I’ve been using the archiver tool he wrote lately, and wanted to share this tool. In every web environment I’ve worked in, there is data that is collected for analysis and that grows quite rapidly. User activity logs…

Oracle Configuration Manager: Bane or Blessing?

I’m not sure how long this has been out there, but there is a new (to me) headline on Oracle’s support website, announcing that next month, they will be phasing out “manual configuration” information for service requests. Customers are now required to download and install something called Oracle Configuration Manager (OCM), which will gather their system/database configuration information automatically, and forward it to Oracle Support on their behalf. I don’t know a lot about this tool. Yet. The OCM page on on Metalink offers the following description…

Log Buffer #67: A Carnival of the Vanities for DBAs

Dave has been sick these past two days and as a result, we do not have a comprehensive log buffer ready. I had two choices – cancel this week’s log buffer, or try to make it great despite this adversity. Never one to accept defeat easily, I’ll go for the second option. So this week’s log buffer is as follows: we are counting on each and every one of you, our faithful readers, to propose the one article you read in the last week, and include a short paragraph as to why this article was interesting to you and why it should interest us.

Page 235 of 281« First...102030...233234235236237...240250260...Last »