Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cmmrfrds

    12C first experience

    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...
  2. cmmrfrds

    FIELD from row to COLUMN

    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...
  3. cmmrfrds

    Counting occurrences inside a table

    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))
  4. cmmrfrds

    12C first experience

    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...
  5. cmmrfrds

    sessiontimezone variable in Oracle

    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
  6. cmmrfrds

    WHERE and HAVING issue

    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...
  7. cmmrfrds

    Return unique row from a given set of rows

    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
  8. cmmrfrds

    Materialized View (Fast Refresh) How to?

    ...then insurance_amount else 0 end) as cnt_ins, min(original_payor_id) as original_payor_id, max(cur_payor_id) as cur_payor_id, count(*) as cnt FROM commerfj.tdl_test group by tx_id When I try a delete on the base table, I an error. ORA-32314: REFRESH FAST of...
  9. cmmrfrds

    Oracle function that return multiple rows

    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
  10. cmmrfrds

    Comparison of values in CASE statements

    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...
  11. cmmrfrds

    BOE auditing of PDF or Excel

    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.
  12. cmmrfrds

    Use index to avoid full table scan

    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...
  13. cmmrfrds

    Get info on ondemand jobs from CMS

    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...
  14. cmmrfrds

    Get info on ondemand jobs from CMS

    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...
  15. cmmrfrds

    Get info on ondemand jobs from CMS

    XI 3.1 fix pack 7.
  16. cmmrfrds

    Get info on ondemand jobs from CMS

    ...refresh on open. This will give me the object id and owner which is sufficient since we are already unraveling the CMS blobs into sql tables using MetaMiner from Infolytks. Select * from boecms.cms_infoobjects6 where schedulestatus = 0 Any ideas on how to identify the ondemand? Thank you.
  17. cmmrfrds

    Webi Intelligence forum

    Thank you.
  18. cmmrfrds

    Webi Intelligence forum

    Does Tek-Tips have a forum for Business Objects Web Intelligence?
  19. cmmrfrds

    Cancel Reports on the database server

    We have noticed that if we cancel a long running report in either Infoview or on the CMC that the query will continue to run on the database server. Our Admin person talked to Business Objects support and they told him that this was by design. Hmmm. So, now if we cancel a report we need to call...
  20. cmmrfrds

    How to get the timezone difference as a number

    ...a relative number. where 1=1 and alog.access_instant >= ((trunc(to_date('01/24/2012','MM/DD/YYYY') - to_date('12/31/1840','MM/DD/YYYY'),0)*86400)+ to_number((EXTRACT(TIMEZONE_HOUR FROM FROM_TZ(CAST(to_date('01/24/2012','MM/DD/YYYY') AS TIMESTAMP), 'America/Chicago')...

Part and Inventory Search

Back
Top