TweetThe idea of providing databases as a service to customers and companies can be a very foreign idea to the database administrator. The DBA’s job is to carefully control and dole out resources. The concept that “in the cloud” the user can just “order up” a database on demand ...
The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation.
-
-
Checking Oracle Directory Object Path Validity
Bit of a mouthful that title. Today I was asked to check which, if any, directory objects had an invalid path. Normally this would be trivial but on the system I was on there were more than 90. So I knocked up a quick bit of SQL/KSH to do ...
-
For My Sister, Kristi
TweetAs many know, I joke about being a strange, ADHD kid. I didn’t really fit in with the other kids and was really, really small for my age. I was bullied and very much a loner. Growing up, my closest friend was my middle sister, Kristi who is 2 ...
-
Oracle Dictionary fragmentation
The purpose of this post is mainly to highlight the performance degradation due to dictionary index fragmentation. It is something that oracle not widely announce but it came from the physical structure of the database. Oracle databases have the AGE and the age mainly came from the number of DDL ...
-
SCNs and Timestamps
The function ORA_ROWSCN returns an SCN from a row (or more commonly the block, unless ROWDEPENDENCIES has been used).select distinct ora_rowscn from PLAN_TABLE;But unless you're a database, that SCN doesn't mean much. You can put things in some sort of order, but not much more.Much ...
-
I have seen the future of ERP
I’m at Oracle HQ in Redwood Shores this week for a workshop on implementing Oracle’s best user experience (UX) design practices in ADF. Yesterday, the Oracle UX team hosted a confidential (strictly no photography!) event demoing some of the new stuff they are working on. If I told ...
-
-
lollol
#()#ism #()#ism #()#ism #()#ism #()#ism #()#ism #()#ism #()#ism
-
UKOUG Database Server SIG (Leeds 2013)
On Thursday I attended the UKOUG Database Server SIG in Leeds. All slides have been uploaded to the UKOUG website. https://www.ukoug.org/events/ukoug-database-server-sig-meeting-may-2013/ It’s the first SIG I’ve attended this year and after enjoying it so much I ought to try harder to get to ...
-
The account is locked on APEX
I have used APEX 4.2.2. I was unable to logon my APEX with INTERNAL workspace as admin. It showed "The account is locked".What was I able to do? ... run "apxchpwd.sql" script. I didn't think so. After checking in "apxchpwd.sql" script.So, I checked in ...