listener.log too big

My listener.log file is growing and now it is very big; I have difficulties to open it. What can I do when the listener.log is growing? Indeed, if you delete the LISTENER.LOG, the file will be recreated only after stopping and starting the listener … I want to archive it without boucing the listener (online […]

remove_agent_gridcontrol

— ################################################ — # Creator: Grégory RECHIGNAC (DBA Oracle) — # Created: 2012/03/01 — # Name: remove_agent_gridcontrol.sql — ################################################ — # — # Compatible: Oracle Grid Control 10g 11g 12c — # — ################################################ — # — # Remove agent and it s target from Grid Control — # — ################################################ SELECT ‘exec mgmt_admin.cleanup_agent(”’ || […]

External table Use

How the DBA Oracle can use external table. Here is a small example — ################################################ — # Creator: Vincent Fenoll (DBA Oracle) — # Created: 2011/11/08 — # Name: External table Use — ################################################ — # — # Compatible: Oracle 10g 11g — # — ################################################ — # — # Insert data into a table […]