asked on
xml reader for oracle audit files

I need a simple way to read an xml file
I am not a programmer
the xml files are created by oracle with os auditing via xml
MikeOM_DBA
Try XML Viewer by MindFusion -- FREE

In order to view some xml files created by oracle you will need to enclose the whole document with some tab, for example "<root>" as first line and "</root>" as last line.

PS: Once you add the "tags", you can open with Excel, IE,...etc
bkreynolds48
ASKER
here is the test file,
can you show me where to put the tags?
I tried opening it with excel but it fails with some weird error
harxaud-ora-59572594-1.xml
bkreynolds48
ASKER
I tried opening it with xml viewer with the following error
The following tags were not closed: Audit.
Error processing resource harxaud_ora_59572594.xml
Line 0. Position 0

(null)
MikeOM_DBA
Maybe you attached the wrong file to the post, this is the content of your attachment:
XML Parsing Error: no element found
Location: http://filedb.experts-exchange.com/incoming/2013/07_w29/667242/harxaud-ora-59572594-1.xml
Line Number 229, Column 1:
Now, the error you mention "The following tags were not closed: Audit." seems to be that your file is incomplete.

You put "<root>" before (as) first line and "</root>" after (as) last line in your file.
bkreynolds48
ASKER
here is the file
<?xml version="1.0" encoding="UTF-8"?>
  <Audit xmlns="http://xmlns.oracle.com/oracleas/schema/dbserver_audittrail-10_2.xsd"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://xmlns.oracle.com/oracleas/schema/dbserver_audittrail-10_2.xsd">
   <Version>10.2</Version>
   <FormatModifiers>
     <FormatModifier>UTFEncoding</FormatModifier>
   </FormatModifiers>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>1</StatementId><EntryId>1</EntryId><Extended_Timestamp>2013-07-18T19:41:43.192572</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Action>100</Action><TransactionId>0000000000000000</TransactionId><Returncode>0</Returncode><Comment_Text>Authenticated by: DATABASE</Comment_Text><Priv_Used>5</Priv_Used><DBID>1702306840</DBID>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>2</StatementId><EntryId>2</EntryId><Extended_Timestamp>2013-07-18T19:41:43.234618</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>DUAL</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>SELECT USER FROM DUAL </Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>3</StatementId><EntryId>3</EntryId><Extended_Timestamp>2013-07-18T19:41:43.274750</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>DBMS_OUTPUT</Object_Name><Action>116</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>BEGIN DBMS_OUTPUT.DISABLE; END;</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>3</StatementId><EntryId>4</EntryId><Extended_Timestamp>2013-07-18T19:41:43.277601</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>DBMS_OUTPUT</Object_Name><Action>116</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>BEGIN DBMS_OUTPUT.DISABLE; END;</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>3</StatementId><EntryId>5</EntryId><Extended_Timestamp>2013-07-18T19:41:43.277772</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>PLITBLM</Object_Name><Action>116</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>BEGIN DBMS_OUTPUT.DISABLE; END;</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>4</StatementId><EntryId>6</EntryId><Extended_Timestamp>2013-07-18T19:41:43.307323</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYSTEM</Object_Schema><Object_Name>SQLPLUS_PRODUCT_PROFILE</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>SELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER(&apos;SQL*Plus&apos;) LIKE UPPER(PRODUCT)) AND (USER LIKE USERID) </Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>4</StatementId><EntryId>7</EntryId><Extended_Timestamp>2013-07-18T19:41:43.307503</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYSTEM</Object_Schema><Object_Name>PRODUCT_PRIVS</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>SELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER(&apos;SQL*Plus&apos;) LIKE UPPER(PRODUCT)) AND (USER LIKE USERID) </Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>5</StatementId><EntryId>8</EntryId><Extended_Timestamp>2013-07-18T19:41:43.312447</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYSTEM</Object_Schema><Object_Name>SQLPLUS_PRODUCT_PROFILE</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>SELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER(&apos;SQL*Plus&apos;) LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = &apos;PUBLIC&apos;)) AND   (UPPER(ATTRIBUTE) = &apos;ROLES&apos;) </Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>5</StatementId><EntryId>9</EntryId><Extended_Timestamp>2013-07-18T19:41:43.312613</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYSTEM</Object_Schema><Object_Name>PRODUCT_PRIVS</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>SELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER(&apos;SQL*Plus&apos;) LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = &apos;PUBLIC&apos;)) AND   (UPPER(ATTRIBUTE) = &apos;ROLES&apos;) </Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>6</StatementId><EntryId>10</EntryId><Extended_Timestamp>2013-07-18T19:41:43.333467</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>DBMS_APPLICATION_INFO</Object_Name><Action>116</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Bind> #1(8):SQL*Plus</Sql_Bind>
<Sql_Text>BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END; </Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>6</StatementId><EntryId>11</EntryId><Extended_Timestamp>2013-07-18T19:41:43.333688</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>DBMS_APPLICATION_INFO</Object_Name><Action>116</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Bind> #1(8):SQL*Plus</Sql_Bind>
<Sql_Text>BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END; </Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>7</StatementId><EntryId>12</EntryId><Extended_Timestamp>2013-07-18T19:41:43.334913</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>DUAL</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>SELECT DECODE(&apos;A&apos;,&apos;A&apos;,&apos;1&apos;,&apos;2&apos;) FROM DUAL</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>8</StatementId><EntryId>13</EntryId><Extended_Timestamp>2013-07-18T19:41:43.340127</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>DUAL</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>select user &quot;unm&quot; from dual</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>9</StatementId><EntryId>14</EntryId><Extended_Timestamp>2013-07-18T19:41:43.367480</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>X$KCCDI</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>select rpad(name||&apos;-&apos;||user||&apos; &gt;&apos;,length(name)+10 ) dbname from v$database</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>9</StatementId><EntryId>15</EntryId><Extended_Timestamp>2013-07-18T19:41:43.367721</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>X$KCCDI2</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>select rpad(name||&apos;-&apos;||user||&apos; &gt;&apos;,length(name)+10 ) dbname from v$database</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>9</StatementId><EntryId>16</EntryId><Extended_Timestamp>2013-07-18T19:41:43.367898</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>GV$DATABASE</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>select rpad(name||&apos;-&apos;||user||&apos; &gt;&apos;,length(name)+10 ) dbname from v$database</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>9</StatementId><EntryId>17</EntryId><Extended_Timestamp>2013-07-18T19:41:43.368085</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>V$DATABASE</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>select rpad(name||&apos;-&apos;||user||&apos; &gt;&apos;,length(name)+10 ) dbname from v$database</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>9</StatementId><EntryId>18</EntryId><Extended_Timestamp>2013-07-18T19:41:43.368262</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>V_$DATABASE</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384714</Scn><DBID>1702306840</DBID>
<Sql_Text>select rpad(name||&apos;-&apos;||user||&apos; &gt;&apos;,length(name)+10 ) dbname from v$database</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>10</StatementId><EntryId>19</EntryId><Extended_Timestamp>2013-07-18T19:45:17.912000</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>TS$</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384787</Scn><DBID>1702306840</DBID>
<Sql_Text>select table_name from user_tables</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>10</StatementId><EntryId>20</EntryId><Extended_Timestamp>2013-07-18T19:45:17.912249</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>SEG$</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384787</Scn><DBID>1702306840</DBID>
<Sql_Text>select table_name from user_tables</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>10</StatementId><EntryId>21</EntryId><Extended_Timestamp>2013-07-18T19:45:17.912398</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>OBJ$</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384787</Scn><DBID>1702306840</DBID>
<Sql_Text>select table_name from user_tables</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>10</StatementId><EntryId>22</EntryId><Extended_Timestamp>2013-07-18T19:45:17.912542</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>TAB$</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384787</Scn><DBID>1702306840</DBID>
<Sql_Text>select table_name from user_tables</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>10</StatementId><EntryId>23</EntryId><Extended_Timestamp>2013-07-18T19:45:17.912691</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>OBJ$</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384787</Scn><DBID>1702306840</DBID>
<Sql_Text>select table_name from user_tables</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>10</StatementId><EntryId>24</EntryId><Extended_Timestamp>2013-07-18T19:45:17.912835</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>OBJ$</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384787</Scn><DBID>1702306840</DBID>
<Sql_Text>select table_name from user_tables</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>10</StatementId><EntryId>25</EntryId><Extended_Timestamp>2013-07-18T19:45:17.912981</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>USER$</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384787</Scn><DBID>1702306840</DBID>
<Sql_Text>select table_name from user_tables</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>10</StatementId><EntryId>26</EntryId><Extended_Timestamp>2013-07-18T19:45:17.913122</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>X$KSPPCV</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384787</Scn><DBID>1702306840</DBID>
<Sql_Text>select table_name from user_tables</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>10</StatementId><EntryId>27</EntryId><Extended_Timestamp>2013-07-18T19:45:17.913283</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>X$KSPPI</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384787</Scn><DBID>1702306840</DBID>
<Sql_Text>select table_name from user_tables</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>10</StatementId><EntryId>28</EntryId><Extended_Timestamp>2013-07-18T19:45:17.913432</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>SYS</Object_Schema><Object_Name>USER_TABLES</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384787</Scn><DBID>1702306840</DBID>
<Sql_Text>select table_name from user_tables</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>11</StatementId><EntryId>29</EntryId><Extended_Timestamp>2013-07-18T19:45:25.893538</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>12</Action><TransactionId>002B002A00019202</TransactionId><Returncode>0</Returncode><Scn>2359400384803</Scn><DBID>1702306840</DBID>
<Sql_Text>drop table audit_test</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>12</StatementId><EntryId>30</EntryId><Extended_Timestamp>2013-07-18T19:45:27.334669</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>1</Action><Returncode>907</Returncode><DBID>1702306840</DBID>
<Sql_Text>create table audit_test
( fname varchar2(50) ,
lname varchar2(50),
address varchar2(50),
city varchar2(50),
state varchar2(50),
zip varchar2(15),
country varchar2(50)</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>13</StatementId><EntryId>31</EntryId><Extended_Timestamp>2013-07-18T19:45:47.371367</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>1</Action><Returncode>907</Returncode><DBID>1702306840</DBID>
<Sql_Text>create table audit_test
( fname varchar2(50) ,
lname varchar2(50),
address varchar2(50),
city varchar2(50),
state varchar2(50),
zip varchar2(15),
country varchar2(50)</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>14</StatementId><EntryId>32</EntryId><Extended_Timestamp>2013-07-18T19:46:02.596145</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>1</Action><Returncode>907</Returncode><DBID>1702306840</DBID>
<Sql_Text>create table audit_test
( fname varchar2(50) ,
lname varchar2(50),
address varchar2(50),
city varchar2(50),
state varchar2(50),
zip varchar2(15),
country varchar2(50)</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>15</StatementId><EntryId>33</EntryId><Extended_Timestamp>2013-07-18T19:46:20.202104</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>1</Action><Returncode>907</Returncode><DBID>1702306840</DBID>
<Sql_Text>create table audit_test
( fname varchar2(50) ,
lname varchar2(50),
address varchar2(50),
city varchar2(50),
state varchar2(50),
zip varchar2(15),
country varchar2(50)</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>16</StatementId><EntryId>34</EntryId><Extended_Timestamp>2013-07-18T19:46:22.783001</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>1</Action><Returncode>907</Returncode><DBID>1702306840</DBID>
<Sql_Text>create table audit_test
( fname varchar2(50) ,
lname varchar2(50),
address varchar2(50),
city varchar2(50),
state varchar2(50),
zip varchar2(15),
country varchar2(50)</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>17</StatementId><EntryId>35</EntryId><Extended_Timestamp>2013-07-18T19:46:55.658060</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>1</Action><TransactionId>002A001B00015BD8</TransactionId><Returncode>0</Returncode><Scn>2359400384849</Scn><Priv_Used>40</Priv_Used><DBID>1702306840</DBID>
<Sql_Text>create table audit_test
( fname varchar2(50) ,
lname varchar2(50),
address varchar2(50),
city varchar2(50),
state varchar2(50),
zip varchar2(15),
country varchar2(50))</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>18</StatementId><EntryId>36</EntryId><Extended_Timestamp>2013-07-18T19:46:58.504382</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>1</Action><Returncode>955</Returncode><Scn>2359400384850</Scn><Priv_Used>40</Priv_Used><DBID>1702306840</DBID>
<Sql_Text>create table audit_test
( fname varchar2(50) ,
lname varchar2(50),
address varchar2(50),
city varchar2(50),
state varchar2(50),
zip varchar2(15),
country varchar2(50))</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>19</StatementId><EntryId>37</EntryId><Extended_Timestamp>2013-07-18T19:47:10.447591</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>12</Action><TransactionId>002B00290001921A</TransactionId><Returncode>0</Returncode><Scn>2359400384863</Scn><DBID>1702306840</DBID>
<Sql_Text>drop table audit_test
</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>20</StatementId><EntryId>38</EntryId><Extended_Timestamp>2013-07-18T19:47:13.432015</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>1</Action><TransactionId>0027002B000151AC</TransactionId><Returncode>0</Returncode><Scn>2359400384875</Scn><Priv_Used>40</Priv_Used><DBID>1702306840</DBID>
<Sql_Text>create table audit_test
( fname varchar2(50) ,
lname varchar2(50),
address varchar2(50),
city varchar2(50),
state varchar2(50),
zip varchar2(15),
country varchar2(50))</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>21</StatementId><EntryId>40</EntryId><Extended_Timestamp>2013-07-18T19:49:28.994715</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>2</Action><TransactionId>002A002D00015BE6</TransactionId><Returncode>0</Returncode><Scn>2359400384929</Scn><DBID>1702306840</DBID>
<Sql_Text>insert into audit_test values
(
&apos;Beverley&apos;,&apos;Belk&apos;,&apos;123 ABC Street&apos;,&apos;Cedar Hill&apos;,&apos;Missouri&apos;,&apos;12345&apos;,&apos;USA&apos;
)</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>22</StatementId><EntryId>42</EntryId><Extended_Timestamp>2013-07-18T19:49:41.335355</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>2</Action><TransactionId>002A002D00015BE6</TransactionId><Returncode>0</Returncode><Scn>2359400384934</Scn><DBID>1702306840</DBID>
<Sql_Text>insert into audit_test values
(
&apos;AG&apos;,&apos;Belk&apos;,&apos;456 ABC Street&apos;,&apos;Cedar Hill&apos;,&apos;Missouri&apos;,&apos;12345&apos;,&apos;USA&apos;
)</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>24</StatementId><EntryId>43</EntryId><Extended_Timestamp>2013-07-18T19:50:06.693394</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384943</Scn><DBID>1702306840</DBID>
<Sql_Text>select count(*) from bkbelk.audit_test where state = &apos;Missouri&apos;</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>25</StatementId><EntryId>45</EntryId><Extended_Timestamp>2013-07-18T19:50:14.715347</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>2</Action><TransactionId>00270002000151A9</TransactionId><Returncode>0</Returncode><Scn>2359400384947</Scn><DBID>1702306840</DBID>
<Sql_Text>insert into audit_test values
(
&apos;Bev&apos;,&apos;Belk&apos;,&apos;456 ABC Street&apos;,&apos;Berryville&apos;,&apos;Arkansas&apos;,&apos;67891&apos;,&apos;USA&apos;
)</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>27</StatementId><EntryId>46</EntryId><Extended_Timestamp>2013-07-18T19:51:16.670168</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384969</Scn><DBID>1702306840</DBID>
<Sql_Text>select count(*) from bkbelk.audit_test where state = &apos;Arkansas&apos;</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>28</StatementId><EntryId>47</EntryId><Extended_Timestamp>2013-07-18T19:51:25.839836</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400384972</Scn><DBID>1702306840</DBID>
<Sql_Text>select fname from audit_test</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>29</StatementId><EntryId>50</EntryId><Extended_Timestamp>2013-07-18T19:51:36.739089</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>7</Action><TransactionId>0026002C00015187</TransactionId><Returncode>0</Returncode><Scn>2359400384976</Scn><DBID>1702306840</DBID>
<Sql_Text>delete from audit_test where state = &apos;Arkansas&apos;</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>31</StatementId><EntryId>52</EntryId><Extended_Timestamp>2013-07-18T19:51:51.538727</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>2</Action><TransactionId>0028002D000151C2</TransactionId><Returncode>0</Returncode><Scn>2359400384985</Scn><DBID>1702306840</DBID>
<Sql_Text>insert into audit_test values
(
&apos;Shaugn&apos;,&apos;Reynolds&apos;,&apos;999 Big Street&apos;,&apos;Berryville&apos;,&apos;Arkansas&apos;,&apos;67891&apos;,&apos;USA&apos;
)</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>33</StatementId><EntryId>54</EntryId><Extended_Timestamp>2013-07-18T19:52:06.598457</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>6</Action><TransactionId>002600250001518A</TransactionId><Returncode>0</Returncode><Scn>2359400384993</Scn><DBID>1702306840</DBID>
<Sql_Text>update audit_test set fname = &apos;Shaugnessy&apos; where state = &apos;Arkansas&apos;</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>35</StatementId><EntryId>55</EntryId><Extended_Timestamp>2013-07-18T19:52:18.997773</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400385003</Scn><DBID>1702306840</DBID>
<Sql_Text>select * from audit_test where state = &apos;Arkansas&apos;</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>36</StatementId><EntryId>57</EntryId><Extended_Timestamp>2013-07-18T19:52:30.507137</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400385007</Scn><DBID>1702306840</DBID>
<Sql_Text>select state, count(*) from audit_test group by state</Sql_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>60973149</Session_Id><StatementId>37</StatementId><EntryId>58</EntryId><Extended_Timestamp>2013-07-18T19:52:43.260591</Extended_Timestamp><DB_User>BKBELK</DB_User><OS_User>bkbelk</OS_User><Userhost>sla765q1</Userhost><OS_Process>59572594</OS_Process><Terminal>pts/9</Terminal><Instance_Number>0</Instance_Number><Object_Schema>BKBELK</Object_Schema><Object_Name>AUDIT_TEST</Object_Name><Action>3</Action><Returncode>0</Returncode><Scn>2359400385012</Scn><DBID>1702306840</DBID>
<Sql_Text>select lname, count(*) from audit_test group by lname</Sql_Text>
</AuditRecord>
Open in new window
bkreynolds48
ASKER
ok -add<root>
I opened it with excel but for the most part it is unreadable
I need something that will make sense of what is in the file please
ASKER CERTIFIED SOLUTION
MikeOM_DBA
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer