» VIEW ALL POSTS Sep 24 2007   10:52AM GMT

Your Oracle wish list



Posted by: Clinek
Tags:
Managing an Oracle shop
Oracle applications
Oracle database administration

If you had five wishes to improve Oracle, what would they be?

That’s the question several Oracle pros have been asking in the blogosphere recently. For example, consultant Chris Muir’s top 5 is as follows:

5. Fix the email .zip issue
4. Allow more OTN forum markups
3. Regular Oracle XE (Express) updates
2. Free ADF libraries for JDeveloper
1. Open Metalink to the web

And here is Mikael Gueck’s slightly more ambitious list:

5. A new, modern database product
4. Stop using PL/SQL for applications
3. An incredibly valuable support offering . . . for free
2. Get out of the application server and IDE “business”
1. Roll out standardized quality metrics, and automated quality measurement tools for every product and platform

A few more lists are floating around the blogosphere, including:

I know for a fact that Oracle reps do read our blog, so let’s see your top 5. You never know — your wish may come true!

Cheers, Tim

18  Comments on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Clinek
    My Top 5 Oracle Wish list are listed below 1)Please give us a new IDE (Similar to SQL Server Management Studio for 2005) with all in One Integrated Management Capabilities 2) An Integrated XQuery/SQL Query Interface 3) Enhanced Data Import / Export Capabilities 4) Wizards, Wizards and more Wizards 5) Make the product work on Desktop Linux Distributions(Ubuntu,OpenSUSE,Mandriva) and making sure that all files are needed for installation as a Defacto apart from Enterprise Class Linux Distributions(RHEL, SLES etc). Best Regards Anil Mahadev Bangalore INDIA
    0 pointsBadges:
    report
  • Clinek
    1 - From the metalink and other sources you've a very big data source for bugs/fixes/improvements. Pleas fix them in the first place and make sure that they'll not happen in the later releases again 2 - Change the very very very old interfaces and switch to a more modern interface. You should work with some people from art/painting/psychology etc. not with technical members. Look at MAC/Microsoft etc. to see a sample. Not only for artictic results but also intuitive usability 3 - Continuing from 2 you should make everything easier with simple interfaces. We're in 2007 and still trying to integrate/backup/recovery/administer etc. with using some command-line tools. Make intuitive interfaces for your systems 4 - Make your support cheaper and aldo spent some of the support money you've taken from us to train your god damn support members and support structure. Everytime they ask did you try this? Look at the logs I've tried everything before you man. 5 - Learn the meaning of TOTAL QUALITY. When we say there are problems you reply "Ok but the core has not a problem. We did not loose any data". It's something like to have a mercedes motor on a 20 years old body. Hey my tires are flat. And you reply "But engine is working with no problem. Everything is ok" TOTAL QUALITY, TOTAL QUALITY, TOTAL QUALITY in every process and product. I don't think Oracle is at CMMI 5 level. You should be at most CMMI 2.
    0 pointsBadges:
    report
  • Clinek
    Top Wish List from oracle 1- I Wish oracle to open a university for master and PHD in oracle 2- Control and supervise each and every implementation of E-business Suite since successfull implementation increase respect and turnover to oracle itself. 3- oracle is having now many products , applications ,,,etc and it should provide categories and usage path for these products. 4- Oracle should create a new certificates for managers such as oracle apps expert , oracle technology expert , oracle business expert ,,,,etc 5- more specialized invitation to customers in specific industry to explain new producs and share ideas with customer's themself thanks
    0 pointsBadges:
    report
  • Clinek
    Top 2 Schema level privileges, such as grant select on schema to user Ability to rename schemas. Backup and restore in RMAN at the table level. I can't think of the other two.
    0 pointsBadges:
    report
  • Clinek
    1. Open the metalink for Apps developer/Implementors. Or atleast partially. Also clean up metalink. 'Find' should include a cut-off date (any articated older than this date will be filtered out) 2. A Toad or Plsql developer like free tool from Oracle for PLSQL Developer. 3. Forget Application server/Java/OC4j/FusionBlah. Just dump them! Oracle has sunk lot of many on this than they have earned from here. Make "Forms Developer" cheaper instead. Dont change name (like #2*&16h, %$**23j), keep it D2K (forever), keep selling (make it affordable/value for money). 4. Keep improving Oracle Database! 5. Make Application set up in a module itself(metadata). Make Quality 100% before shipping the modules (don't pay the developer until all bugs are fixed). Make extensive (useful) documentation of internals like APIs/TRM/data models blah blah and make it public/published (as much as possible). 6. Make a product which can trouble shoot application setup issues for dummies (use artificial intelligence/expert systems that will use the metadata as said in 5 as much as possible -it is not a rocket science, less RS than Fusionware/Apps server). 7. USE DATABASE and ORACLE APPS as ONLY TWO products from Oracle Corp (built in RWShore,USA.). make these 100% bug free product before dumping on the customers. 8. That will be enough to keep Oracle busy and CFO of Oracle happy.
    0 pointsBadges:
    report
  • Clinek
    1. QUALITY CONTROL 2. keep working on grid control, we need more information with less clicks 3. make streams more recoverable, rebuilding should not be an option 4. see #1 5. see #4
    0 pointsBadges:
    report
  • Clinek
    My Oracle wish list is endless. However, the following beats everything and I am sure it is a very simple change for Oracle. We all know that Optimizer is the heart of Oracle server. Optimizer uses the statistics collected and stored in DBA_TABLES to find the most efficient execution path for queries. (I ask my users to compare the statistics collection to a MAPQUEST for the optimizer, to find shortest route to execute queries). We very frequently face the situation where the application suddenly runs slowly, however nothing has changed in the database. When was the statistics collected last time? The quickest way of finding this is by querying the following data dictionary table. Select LAST_ANALYZED, SAMPLE_SIZE from dba_tables where table_name = 'xxxxxx'; My smart users issue this command and see some date prior to six months (even a year some cases) and blame me for not running my DBMS_STATS package against the database more frequently. LAST_ANALYZED column from DBA_TABLES reflects the date when DBMS_STATS package was successfully run and COLLECTED STATISTICS. There are cases when Oracle server decides that collecting statistics is not necessary and hence skips it for those tables. In those cases, LAST_ANALYZED column will not be updated, even though DBMS_STATS package was run. This is specially the case, when sampling is involved. If you had specified sampling PERCENT (generally 5% to 20%), only, when that many rows are changed, would the real statistics be collected. So even though you run DBMS_STATS package, LAST_ANALYZED column would reflect the date when the criteria for sampling was met last time and statistics indeed were needed. How do we know that, the 10% or 20% of my rows are not changed? Oracle provides a table called DBA_TAB_MODIFICATIONS to store that information. Every time INSERTS,DELETES and UPDATES happen, it is stored in the DBA_TAB_MODIFICATION tables. I had to defend myself many times , by querying the table and sending the report to the users/developers to justify that the table changes are not exceeded 10%, which is why LAST_ANALYZED column is not updated even though my Table analyze process had run previous night. Some smart developers turn off MONITORING for their tables, thinking that might impact their performance. If so, I have nothing to prove that I analyzed tables since we need MONITORING=YES for DBA_TAB_MODIFICATIONS table to collect information about table changes. So, what is my wish? I want Oracle to add another column in the DBA_TABLES data dictionary table, to indicate when the statistics was last run, say LAST_STATS_RUN to reflect the date when the statistics was run not necessarily the date that the stats were indeed collected. This would make the DBAs and developers life much easier to query the table to get the last run, especially when you are managing 300 databases. Even better would be to store the information about what percent is analyzed. Instead of providing a SMAPLE_SIZE column and let others figure out the sample, all we need is percent analyzed column to indicate 10, 20 or 25 percent. I wish someone from Oracle read this and provide the enhancement in the next release. Or if it is already available somewhere, let them share the information. Rama Balaji Oracle Consultant
    0 pointsBadges:
    report
  • Clinek
    My #1 - very simple: Change the error message for ORA-00942 to include the NAME of the table or view that doesn't exist.
    0 pointsBadges:
    report
  • Clinek
    Hi I wish oracle to be like this in future 1.E-business suite's patch level has to be extremely streamlined. It should not release patches as and when it feels .It has to maintain a stringent patch level methodology for all the modules like SAP. 2.Online patching without downtime. 3.Focus towards automatic tuning of the database should be stopped and should concentrate more on interfacing the database with non-oracle databases and external files ,XML etc. 4.Internals to be tuned to get more out of the CPU and Disk.
    0 pointsBadges:
    report
  • Clinek
    My wishlist: 1) customers should be payed money if they run into bugs that disrupt their business transactions (and for the time spent by internal or external consultants to troubleshoot and find workarounds) 2) all packs for free for everyone but most importantly provisioning pack which can ease the pain of patching 3) not play hide and seek when important security issues have been reported that won't be fixed in the near future (eg 6454409 LISTENER LOCAL OS AUTHENTICATION CAN BE BYPASSED..) 4) no need to tune the self tuning, manage the self managing 5) AI in the rdbms kernel so it can learn
    0 pointsBadges:
    report
  • Clinek
    Items that come to mind: 1) ability change table name, not just schema, using import: i.e. fromname=a toname=a1 2) ability to create a profile in metalinks that excludes whole categories from your searches, or perhaps to create several profiles that can be used to widen a search. Seldom do I need an Oracle 7 answer for my 9i questions. 3) Make reasonable subcategories under the 'products' part of the advanced search. I shouldn't have to search through dozens of inapplicapable categories to get to "oracle server, enterprise edition". Usually I don't bother, which is more work for me and for you. 4) Make a general search area for ONLY the reference articles. Often I waste time looking at threads that lead nowhere. Then eventually I notice that there is an oracle-authored reference article farther down the page that tells me what I need to know. 5) Give us a glossary area to find out what some of the new release functions are all about. Often in looking through threads I find references that I haven't met before. A thumbnail description in some standard place would likely move me, or people like me, on down the road to using new functionality instead of clinging to our old ways.
    0 pointsBadges:
    report
  • Clinek
    I wish Oracle would make changes to how its temporary tables function. I switched from a Sybase to Oracle environment and was shocked that Oracle temp tables did not perform the way Sybase designed theirs to work.
    0 pointsBadges:
    report
  • Clinek
    The area i feel requires improvement is in Oracle Streams. 1. There is a high and continuous redo log generation inspite of tuning the streams_pool_size parameter. Initial design of sizing the offline relog log file space goes havoc. 2. Simpler handlers to be introduced as this is plus point of streams so as to pre-calculate and store data into tables. 3. Performance issues and high cpu conusumtion as there is a continuous backgroud job queue process running. 4. Continuous logs being written. If we could set a time interval where the queue process could wake and replicate data it would benefit, queue process then should be stopped.. The same goes to scns. Log files to be generated only based on some time interval.
    0 pointsBadges:
    report
  • Clinek
    My top wish for Oracle Applications would be for Oracle to provide the source java files etc that are used in the apps environment. For many years when the build of the app was built with Oracle forms, reports etc customers had access to the source files which allowed for amongst others 1 key thing which I believe helps promote the use of Oracle Apps: 1) Customers who employ technical people can determine exactly how something works and also importantly how it does not. There are still many people in the ICT business and I am sure always will be who will spend their own time be they employees, non-employees clarifying how a process has been designed to work and who then pass that knowledge onto others. The user guides with an application/piece of s/w can only cover so much and do not always provide detail on a process and the relationships with other processes. This can cost a lot of time. So this would be my big wish. As the range of technologies employed ever expands and as defacto stds do get established for many reasons, a common goal from the past of open systems/ common platforms in a competitive fast moving area are probably still unlikely while software and other is purchased. So when a vendor adopts new technolgy in a product it benefits all if users can see how it is has been applied. You do not need to be a java expert to read and understand how java has been used and what it does. By doing so people also improve and extend their knowledge which further promotes the use of the technology. So I think that Oracle should provide all source code for application based objects except for some that are crucial for business reasons/ core property rights. This will as in the past expand the knowledge of the Oracle community which in turn directly benefits Oracle as the resource pool quality improves and so customers considering ERP/technology stacks etc as standards, are more likely to continue to choose a vendor who provides the opportunity to companies and individuals to become quality Oracle users and providers. You can log a SR and get assistance but sometimes you need to know how something 'really' works.
    0 pointsBadges:
    report
  • Clinek
    ANOTHER suggestion: Make it possible to install a complete test install of a new level. I'm on AIX unix and in today's world have no control of the root password so the /etc/oraInst.loc is not updateable by me. I should not have to back up the entire ORACLE_BASE *AND* take all databases down on the node just to do a test install of 10g, then restore the old ORACLE_BASE. Even though this lpar has only test databases on it, I'm no more fond of useless work and evening/weekend work than anyone else. Let me define an oracle inventory location that doesn't run over the current oui repository like a freight train. It ought to be separate anyway.
    0 pointsBadges:
    report
  • Clinek
    My #1 should be a trivial fix - if a query includes a "... = '' ..." expression on a NOT NULL column, the query optimizer should immediately respond with "no rows found" to that clause part instead of doing a full table scan, full index scan, or other ridiculous action as it does today. Yes, the developer shouldn't have allowed a null valued argument in the expression, but the massive waste of a table/index scan (to return zero rows!) shouldn't be the punishment for the error. This seems to be a particular problem for PL/SQL parameterized expressions, where a parameter is null at run time.
    0 pointsBadges:
    report
  • Clinek
    Minor readability fix to #17 above. My typing "bracket-column-bracket = " got parsed as an XML tag and vanished... The expression I was trying to convey was: ...and table.column = (null-valued-expression)... which I frequently encounter as: ... and mytable.mycolumn = :b2 ... in the V$SQL table. When the parameter is null, this often causes full table or index scans before returning no rows (duh!), depending on a variety of circumstances.
    0 pointsBadges:
    report
  • Young
    The only wish I think worth my while (and Oracle Corp's too) to put here is to add indexing feature to external tables (or external ASCII files e.g. in CSV format). The benefits would be: reduce the latency in making data searchable (before their loading into tables); make archived files searchable (for data copmpliance etc), ...... The related areas are data warehousing, data retention compliance, huge feed/archiving of event data, the 11g compress of LOB....
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: