logs archiveIRC Archive / Freenode / #oracle / 2015 / August / 24 / 1
baako
i got an error from oracle, it says 15-OCT-14 is not a valid month how is that invalid
la00
hello
MatheusOl
baako: what is your NLS env?
la00
is there a tool that given a table datatype, presents the max total bytes of each record?
baako
MatheusOl, how do i find that out?
MatheusOl
show parameter nls
generic method (any client): select name, value from v$parameter where name like 'nls%';
baako
MatheusOl, ENGLISH
MatheusOl
?
baako
LANGUAGE = ENGLISH TERRITORY = united kingdom and CHARACTER SET = AL32UTF8
         

MatheusOl
baako: what happens when you do: select cast('15-OCT-14' as date) from dual; ??
baako
MatheusOl, i ran thios query https://oraclespin.wordpress.com/2008/10/22/how-to-find-the-nls_lang-of-the-database/
MatheusOl, 15/10/2014
MatheusOl
The NLS I wanted is in fact nls_date_format
baako
MatheusOl, http://kopy.io/DU0zG line 30
MatheusOl
What are the data types of sfrwdrl_eff_wdrl_date, sfbetrm_ests_date
baako
MatheusOl, the datetype is DATE and the format is 10/01/2007
dd/mm/yyyy
MatheusOl
Of both?
baako
yes
MatheusOl
I'd try CAST(('01/08/' || substr(p_term_code, 1, 4)) AS date)
The same for the other
baako
CAST(('01/08/'||substr(p_term_code, 1, 4)) AS DATE) AND CAST(('31/07/' || substr(p_term_code, -2, 2)) AS DATE)
THEN
as date for both of them?
MatheusOl, still error about IF my_rec.wdrl_date BETWEEN
MatheusOl
AS date on both, yes
What is the full error?
baako
0ra-01843, 0ra-06512 line 29 which is IF my_rec.wdrl_date BETWEEN and 0ra-06512 line 3
GenteelBen
blaako I didn't know you were an Oracle person.
baako
GenteelBen, i am when am at work
at home am mysql :D
MatheusOl, got it working now to_date('01/08/' || substr(p_term_code, 1, 4), 'DD/MM/YYY')
MatheusOl
I tend to use ISO dates and avoid such issues
vinnix
somebody is using tunning pack with 11g?
Rudemeister
me
using tuning with 11
vinnix
Rudemeister: how do you use it? with Enterprise Manager (cloud control, etc.. ) or directly from console?
sorry if its a very noob question, but I just remember to use it with Cloud Control (ADDR was the name of the section that will be possible to run the feature)
Rudemeister
Enterprise Manager (cloud control
vinnix
humm nice
         

Rudemeister
is doest exist in the database
is does exist in the target database
and is accessible through oem
but also from the db itself
oem is user friendly tough
keep in mind, this is a payed option! You have to license it from Oracle
!!
only works with Enterprise Edition
vinnix
sure, here in brazil this feature is about R$ 42,000.00 per CPU
(around 12K USD)
Rudemeister
https://seelt.nl/zerobin/?d555f62071d0b839#MaDNYluXWVZAFFYhIjrrJrK2MqlvEehZ7qoET5sopVU=
see tuning usage
SQL> show parameter control_management_pack_access
if not licensed Oracle'd say: SQL> ALTER SYSTEM SET control_management_pack_access=NONE;
MatheusOl
vinnix, Rudemeister: is that feature that enable the AWR Report?
vinnix
MatheusOl: I guess so
MatheusOl: is that feature that when I was giving some consulting about oracle (tuning etc.. ) we could change from 16hours to 5minutos the execution of some query, by automatically changing the execution plan
Rudemeister
AWT is part of diag pack
AWR
upgrade to 12 and benefit from adaptive execution plan:P
but you're refering to sql profiles I guess
vinnix
something like that, was 2 years ago and since then I do not use it any more :(
but I was very impressed with this feature
Rudemeister
vinnix
Rudemeister: I run that query here: http://pastie.org/10372767
Rudemeister
and
show parameter control_management_pack_access
?
vinnix
string DIAGNOSTIC+TUNING
when I installed, I decide to install the enterprise, even that the instance is used only to development
so we can play around :)
but I do not install EM yet
Rudemeister
download and install 12cr5
and pay for the diag+tuning pack, then you're off to go