2012-04-30

understanding LOB s in Oracle

http://www.slideshare.net/tanelp/oracle-lob-internals-and-performance-tuning

emnoseed.rsp

Attempting to Launch the Installer for 11.1.0.1 Grid Control Agent on Linux x86_64 Results in "Error: emnoseed.rsp file does not exists" [ID 1109397.1]

2012-04-25

Disabling histogram creation


If your environment only has SQL statements with bind variables then it is better to drop the existing
histograms and disable histograms from being created in the future. Disabling histogram creation
ensures the execution plan will not change depending on the bind variable value and will furthermore
reduce the time it takes to gather statistics. Without the histograms on the column the Optimizer will
assume a uniform distribution of rows across the distinct values in a column and will use NDV to
determine the cardinality estimate when it peeks at the initial bind values in the SQL statements

ex:  exec dbms_stats.delete_schema_stats('SH');


Next, change the default value for the METHOD_OPT parameter to prevent histograms from being
created in the future by using the DBMS_STATS.SET_PARAM procedure. This ensures that both the
DBMS_STATS.GATHER_*_STATS procedures and the automatic statistics gathering job will not collect
histograms in the future.
            exec dbms_stats.set_param( pname => 'METHOD_OPT', pval => 'FOR ALL COLUMN SIZE 1') ;


Note in Oracle database 11g you can drop unwanted histograms without dropping all column statistics 
by using DBMS_STATS.DELETE_COLUMN_STATS and setting the col_stat_type to histogram. 


RMAN ORA-17629

RMAN active database duplicate fails with ORA-17627 ORA-17629 [ID 1268962.1]

alter database open resetlogs upgrade;

Recovery Through Upgrade returns ORA-1092 on Open [ID 560417.1]

2012-04-24

eur

Aproape 4.200 de europeni si-au pierdut joburile in fiecare zi a acestui an, 50% din tinerii spanioli si greci sunt someri, unul din cinci muncitori straini este supracalificat pentru jobul pe care il are ori la care aplica. In total, peste 24,5 milioane de europeni cauta de lucru pentru ca au venituri cel mult din somaj. 

disable automatic statistics gathering


Manually statistics collection
If you already have a well-established statistics gathering procedure or if for some other reason you
want to disable automatic statistics gathering for your main application schema, consider leaving it on
for the dictionary tables. You can do so by changing the value of AUTOSTATS_TARGET parameter to
ORACLE instead of AUTO using DBMS_STATS.SET_GLOBAL_PREFS procedure.


exec dbms_stats.set_global_prefs('AUTOSTATS_TARGET','ORACLE');

ORA-00918

ORA-00918 After Upgrade To 10.2.0.5 [ID 1450531.1]

2012-04-18

money

"Money talks! Unfortunately, mine usually says 'Goodbye'."

2012-04-04

Instance terminated by VKTM

You  could see errors like the following :



ORA-00445: background process "ARC2" did not start after 120 seconds
Wed Apr 04 04:59:39 2012
Incident details in:

Wed Apr 04 05:02:33 2012
VKTM (ospid: 5604): terminating the instance due to error 1092
Wed Apr 04 05:02:40 2012
System state dump requested by (instance=1, osid=5641 (LGWR)), summary=[abnormal instance termination].
System State dumped to trace file
Instance terminated by VKTM



PMON (ospid: 11508): terminating the instance due to error 471
Wed Apr 04 12:04:31 2012
System state dump requested by (instance=1, osid=11530 (DIAG)), summary=[abnormal instance termination].
System State dumped to trace file
Dumping diagnostic data in directory=[cdmp_20120404120431], requested by (instance=1, osid=11530 (DIAG)), summary=[abnormal instance termination].
Wed Apr 04 12:04:35 2012
Instance terminated by PMON, pid = 11508


Solution : check ntp server and the date on your server 



2012-04-02

40d503

cum activezi functia de citire usb, la 40d503 

" Un mic truc pentru a activa functia de citire filme de pe usb:
1. se intra in meniul service cu combinatia de taste de pe telecomanda: info, meniu, mute, power(tastele se apasa succesiv, cu tv-ul stins)
2.in meniul service la options-model se schimba din le503 in le550
3. se apasa return pana la fereastra principala
4. power off, power on, dupa care veti vedea ca s-a activat functia de citire video de pe usb.
o singura obs, va fi putin dificil daca veti vrea sa puneti filmul pe pauza de ex, pt ca telecomanda nu are butoanele de media player.
in rest tv-ul este perfect functional, la mine am facut modificarea din prima zii de achizitie si totul e ok.
in fond si la urma urmei veti transforma tv-ul dvs. din le40d503 in le40d550 care sunt identice la soft, mai putin la conectica(40d503 nu are 4 hdmi, nu are pc in, lan)
 "


"Daca modifici tipul de codare si modelul de TV din meniul de service, va trebui sa schimbi din telecomanda si sursa, si apoi, dai reset la factory. Altfel nu va lua noile optiuni.

Nota: Resetarea la default se refera doar la informatiile adaugate de utilizator, adica posturi si setari, dar NU va reseta si modelul de TV sau alte modificari facute in meniul de service.
"