SMP 3.0 Oracle DB sizing

[Setu_Shah]

Hi,

When we first installed the SMP 3.0 database on Oracle we were informed the database does not contain any data and will be relatively small (a couple hundred MB at most). However, after installation we've noticed the database was appx. 5GB and after a month or so of use it has grown to 8.5GB. Can someone shed some light as to what information is stored in the SMP database and how much growth is typical?

Thanks,

Setu

[Jitendra_Kansal · Accepted solution]

Hi Setu,

I can answer your query partially. This SMP 3.0 internal DB (Oracle in your case) has all smp related information like all application connection details, SMP endpoint configuration, connection ids registered for push notifications, end to end tracing and many other information.

All these information are available under table "TABLE" schema "GOMOBILE". If you want to access this database, you have to install Oracle 11gR2_client and you can access all table details through SQL developer then.

About sizing i guess  can share some points.

Rgrds

JK

[Former Member]

Hi,

Oracle DB growing (mainly SYSTEM Tablespace) due to Oracle Audit Trail is active on database.

check in your Mobile platform Database whether audit trail active or not.

SQL> show parameter Audit

check for audit_trail , and audit_sys_operations value,

for deactivate it should be

audit_sys_operations -> FALSE

audit_trail -> NONE

once you disable audit_trail  SMP database will not grow too quick.

if you don't want to disable Audit trail then configure Audit trail house keeping job, search for

Auditing Enhancements (DBMS_AUDIT_MGMT) in Oracle Database 11g Release 2.

Regards,

kaushal