Oracle 10g has a feature where it gathers optimizer statistics automatically at night. This is done through a scheduled job called GATHER_STATS_JOB. If you want to disable this, you have to issue :
EXEC dbms_scheduler.disable(’GATHER_STATS_JOB’);
To enable it again :
EXEC dbms_scheduler.enable(’GATHER_STATS_JOB’);
The following query shows when this job was run :
SELECT * [...]
The day after I hyped the Getting Started with PyParsing book, I got to use it. Here’s the script :
from pyparsing import SkipTo, Suppress, CaselessLiteral
import glob
# Example to match
# delete from TABLENAME
# where CUSTOMER_ID = ‘INTERNAL’;
table_name = [...]
To get the language setting of the current session :
SELECT USERENV (’language’) FROM DUAL;
This returns the database character set, not the user’s though.
The NLS settings can be found in the following list, in this order. If a value is specified in NLS_SESSION_PARAMETERS, it has preference over a value in NLS_INSTANCE_PARAMETERS.
NLS_SESSION_PARAMETERS
NLS_INSTANCE_PARAMETERS
NLS_DATABASE_PARAMETERS
I just bought and read the Getting Started with Pyparsing PDF book. And it’s good. PyParsing is a way of building a parser using Python code. You should think Yacc/Lex, but readable. It can be used to parse text, and it can also handle HTML.
This is the example from the PyParsing website :
from [...]
