Recent content by cmmrfrds

Hi Dave. We did upgrade to 12C but kept the 11G optimizer since we didn't eliminate all the problems with our queries. The 11G optimizer works okay in 12C and our DBA wants to wait until 12C release 2 before we run any more tests with the 12C optimizer. One of the things we want to do shortly...

If you have a way to rank the records you want to put into columns, do this is a subquery, then feed this information to an outer query where you do the group by. General example. select id_espisode, max(case when rnk = 1 then name else null end) as 1stname, max(case when rnk = 2 then name else...

I can't tell exactly what you are looking for, but it looks like the size of your Window is the whole data set. Is this what you want? over (order by trunc(date)) Perhaps you want the Window size to be the something. over(partition by something order by trunc(date))

Hi Dave, my company is in the process of upgrading to Oracle 12C and we are testing now. The environment is 12 CPU AIX Unix OS running 4 virtual Oracle Servers. We have installed 12C on one of the virtual servers. Each instance has 250 gigs of memory shared 70 for the OS and 180 for Oracle. The...

Oracle version 11G. How can I get the sessiontimezone variable to default or be the same as the bdtimezone. I need this at the database level not the client level. Right now our bdtimezone shows 'America/Chicago', but our sessiontimezone shows '-5'. Thank you, Jerry

Andy, I would not conclude that it doesn't matter. If you are dealing with small volume of rows in the tables, then it probably doesn't matter much, but it is always best to reduce the number of rows you select as early as possible and as discrete as possible. In your example, if the table...

Select * From ( Select CODE, CODESET, LANGUAGE, NAME, ORDER RANK() OVER (PARTITION BY LANGUAGE ORDER BY ORDER asc) RNK From MyTable Where LANGUAGE = 'ENG' ) ORDER BY RNK

I am trying to make a materialized view fast refreshable. It works for inserts on the base table but not for deletes and updates. Here is the code to create the MV Log. CREATE MATERIALIZED VIEW LOG ON commerfj.tdl_test WITH ROWID, PRIMARY KEY, SEQUENCE...

You might not need to create your own function depending on the requirements. Here is a list of possible solutions. There are a number of built in Oracle techniques that can be used. http://www.oracle-base.com/articles/misc/string-aggregation-techniques.php

Hi, this is an alternative approach. I see you are using Epic's Clarity database. I have worked with the Clarity database for a number of years and the tdl_tran table can be extremely large and the queries take a lot of resources. Are you aware that Epic summarizes the tdl_tran information into...

Does anyone know if there is an option to audit when PDF's or Excel are opened in BOE. If so, where is the event set. Thank you.

Oracle 11.2 G I am joining a table where I only need two fields the join key and one other field. If I created a concatenated index that contained the two fields would oracle determine that it can get all the needed information from the index and avoid a full table scan. The table has 71...

I can see the ondemand in the audit table now. Here is what happened. Everything was checked on the Web Intelligence Processing Server(s) including the "Document Refreshed", but there was a problem with the AdpativeProcessingServer(s). I found some documentation that says. "Client Auditing Proxy...

Does BOE 4.0 give better information on ondemand webi's? One of the reasons I was hoping to find information in the CMS about ondemand activity is that it is not being tracked in the Audit table. I am trying to get a handle on why there is no audit information. It seems to me that I have seen...

XI 3.1 fix pack 7.