552 reputation
1821
bio website dba010.wordpress.com
location Tbilisi, Georgia
age 23
visits member for 2 years, 9 months
seen Apr 15 at 7:22

I am 11g OCP and I work as a Senior DBA at Ministry of Justice of Georgia.


May
30
asked How to troubleshoot enq: TX - row lock contention?
May
11
accepted My database dramatically increased in size. Why?
May
11
comment My database dramatically increased in size. Why?
@ipip Haven't yet. Now I am analyzing archived log files using Log Miner.
May
11
asked My database dramatically increased in size. Why?
May
7
asked Is commit necessary after DML operation in Function/Procedure?
May
7
comment How to schedule function in Oracle?
that was what I wanted to read thank you...
May
7
accepted How to schedule function in Oracle?
May
7
comment How to schedule function in Oracle?
I have added some lines in my post, please see and help me. Thank you a lot.
May
7
revised How to schedule function in Oracle?
Additional information, to better clarify the situation.
May
7
comment How to schedule function in Oracle?
Current user........
May
7
comment How to schedule function in Oracle?
It says: ORA-06550: line 1, column 729: PLS-00221: 'AUD_CLEAR_FUN' is not a procedure or is undefined ORA-06550: line 1, column 729: PL/SQL: Statement ignored ORA-06512: at "SYS.DBMS_ISCHED", line 185 ORA-06512: at "SYS.DBMS_SCHEDULER", line 486 ORA-06512: at line 2 View program sources of error stack?
May
7
comment How to schedule function in Oracle?
it means that I cannot schedule function, right? I have opportunity to call procedure but not function?
May
7
asked How to schedule function in Oracle?
Apr
4
accepted Oracle: Read from CLOB column line by line and insert to the table
Apr
4
accepted RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?
Apr
4
accepted ORA-01555: snapshot too old: rollback segment number with name “” too small
Apr
4
accepted Oracle RAC on Virtual machine
Apr
2
comment Oracle RAC on Virtual machine
@Phil it is production , can be said that it is not highly loaded.
Apr
2
comment Oracle RAC on Virtual machine
@Phil I just want your opinion about RAC on virtual machine. I think it is not good idea. One guy told me that Oracle do not give support for RAC on virtual machine...
Apr
2
asked Oracle RAC on Virtual machine