DBA

the following query list the size of sharepoint sites. select fullurl , sum ( datalength ( content ))/ 1024 / 1024 from alldocstreams a , webs b where a . siteid = b . siteid group by fullurl order by 2 desc sharepoint table info can be found in the url below. http://www.sharepointkings.com/2008/06/sql-queries-for-sharepoint-content.html   Features Table that holds information about all the activated features for each site collection or site. Sites Table that holds information about all the site collections for this content database. Webs Table that holds information about all the specific sites (webs) in each site collection. UserInfo Table that holds information about all the users for each site collection. Groups Table that holds information about all the SharePoint groups in each site collection. Roles Table that holds information about all the SharePoint roles (permission levels) for each site. AllLists Table that holds information about lists

# we have a script to re-create controlfile when the mount point of datafiles changed, however, the number of datafiles are increasing but the script is not catching up, so when the re-create controlfile is executed, it sometime missing the new added datafiles and leaving some MISSING000XXX files in dba_data_files dictionary. #this script check if re-create controlfile script is missing any datafiles in it, if it does, the filenames will be displayed to the standard output. 1. unix shell script for myfile in /redo_prod/PROD/* /orasys_prod/PROD/* /data_prod/PROD/* /index_prod/PROD/* do grep  -q $myfile $HOME/dba/control_prod.sql status=$? if test $status -eq 1 then         echo $myfile "is missing in the re-create controlfile script"         fi done 2. re-create controlfile script control_prod.sql CREATE CONTROLFILE REUSE DATABASE "PRODUCTION" NORESETLOGS  ARCHIVELOG --  SET STANDBY TO MAXIMIZE PERFORMANCE     MAXLOGFILES 5     MAXLOGMEMBERS 3     MAXDATAFIL

From unix: ps aux|grep oraclePROD|awk '{if ($3 == 0.0) i=i+1; else j=j+1;} END {print "number of oracle process use 0 cpu is: " i; print "number of oracle process use more than 0 cpu is :" j;}'   the results are shown below: number of oracle process use 0 cpu is: 143 number of oracle process use more than 0 cpu is :48   from database: 10:32:50 PROD> select status,count(*) from v$session group by status; STATUS        COUNT(*) ---------- ---------- INACTIVE           178 ACTIVE              46

http://www.obieefans.com/create-environment-patch-environmentalization/ Create Environment Patch (Environmentalization) Posted by root on 27 March, 2012No comments yetThis item was filled under [ OBIEE MISC ] During RPD migrations we constantly need to change metadata for the target environment such as physical connection pool(s) and LDAP source(s). To do this manually is time consuming and open for error. Thus, there needs to be a way to script or automate this process. This document will address the automated solution using what is termed in OBI as the patching process. The first migration from Dev->Test, Dev->Prod, or source->target will need to be done manually. Meaning, the RPD that is ready to be migrated to the target environment will need to have its physical connections and LDAP source(s) manually changed for that target environment. That would be done using the BI Admin Tool in offline mode. After which, we can test our changes to ensure that the connections and

http://blogs.devhorizon.com/reza/2008/10/20/say-goodbye-to-iis-say-hello-to-httpsys/ Say Goodbye to IIS, Say Hello to HTTP.SYS! With all the issues IIS caused in the previous versions of SSRS, specially to configure it to interact with other applications (such as SharePoint) hosted in IIS , in SSRS 2008, Microsoft made a major architectural shift to move toward to a *real* Single Service Architecture that would eliminate dependency on IIS. You no longer require having IIS installed on the RS box and, even nicer; you don’t have to install SQL on that RS box! Well, let me rephrase what I just said above. SSRS doesn’t require IIS to function, but this only applies when you configure it in native mode. In integrated mode and since you have to join the SSRS machine to the farm, you have to install SharePoint WFE components on RS machine and this means dependency on IIS, but again that’s the dependency SharePoint has on IIS , not SSRS! This shifting architectural decision took care of two ve

To generate oracle workload metrics report, use the following query to generate date sqlplus> col metric_name format a39 select metric_name,substr(to_char(begin_interval_time,'hh24:mi'),1,4)||'0' snapshot, sum(case to_char(begin_interval_time,'yyyymmdd') when '20120208' then round(average) end) as date20120208, sum(case to_char(begin_interval_time,'yyyymmdd') when '20120209' then round(average) end) as date20120209, sum(case to_char(begin_interval_time,'yyyymmdd') when '20120210' then round(average) end) as date20120210 from DBA_HIST_SYSMETRIC_SUMMARY,dba_hist_snapshot where dba_hist_snapshot.snap_id=DBA_HIST_SYSMETRIC_SUMMARY.snap_id and metric_name in ('Physical Reads Per Sec','Physical Writes Per Sec','Redo Generated Per Sec','Logical Reads Per Sec','Host CPU Utilization (%)','Current Logons Count','Executions Per Sec') and to_char(begin_interval_time,'yyyym

http://www.dba-oracle.com/t_OracleAutotrace.htm Oracle autotrace supports the following options: • autotrace on – Enables all options. • autotrace on explain – Displays returned rows and the explain plan. • autotrace on statistics – Displays returned rows and statistics. • autotrace trace explain – Displays the execution plan for a select statement without actually executing it. "set autotrace trace explain" • autotrace traceonly – Displays execution plan and statistics without displaying the returned rows. This option should be used when a large result set is expected.