How to delete all audit and trace logs of a database , 5 min past, of a database in RDS(AWS)?

How to delete all audit and trace logs of a database , 5 min past, of a database in RDS(AWS)?

I tried below trace command but getting error as invalid SQL query.

db error

And also, has a doubt, will it reflect in the AWS logs section?


org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error (900) (42000): ORA-00900: invalid SQL statement


    at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:134)

    at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:488)

    at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:425)

    at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:170)

    at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:417)

    at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:775)

    at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:2914)

    at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:111)

    at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:170)

    at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:109)

    at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$17.run(ResultSetViewer.java:3423)

    at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:103)

    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

Caused by: java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement


    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)

    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)

    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)

    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)

    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)

    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)

    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)

    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896)

    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)

    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737)

    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692)

    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300)

    at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:338)

    at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131)

    ... 12 more

Caused by: Error : 900, Position : 0, Sql = EXEC rdsadmin.manage_tracefiles.purge_tracefiles(5), OriginalSql = EXEC rdsadmin.manage_tracefiles.purge_tracefiles(5), Error Msg = ORA-00900: invalid SQL statement


    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)

    ... 26 more