Explain the way to audit the SQL sent to the server
Explain the way to audit the SQL sent to the server.
Expert
This does not appear to be well documented; therefore here is a quick means of auditing the SQL text which is sent to the server. Note that it simply audits the SQL sent to the server. Therefore, if your user process executes a big stored procedure, all you will observe here is a call to the stored procedure. No one of the SQL which is executed as part of the stored procedure will be listed.
Initially, you need to have installed Sybase security (that involves installing the sybsecurity database and loading this using the script as $SYBASE/scripts/installsecurity). And read the Sybase Security Administration Manual, you may wish for to enable a threshold procedure to toggle between couples of audit tables. Be aware, that the default configuration option "delay auditing when device full”, which is set to 1. It means that the server will suspend all normal SQL operations when the audit database becomes full and the so logs in and gets rid of several data. You might want to seem changing it to 0 unless yours is a above all sensitive installation.
Briefly describe the term dimension tables and fact tables?
State some of the sectors where the data warehousing and data mining are utilized.
Explain the advantage of Table Partitioning with bcp in Sybase?
Explain the term Container and also its types?
Illustrates the perfect competition?
Explain does PL/SQL carry overloading?
Illustrates the cold backup in case of Oracle?
Briefly describe the differentiation between star and snowflake schemas?
Explain the Stored Procedure transformation?
In Sybase illustrates the term Table Partitioning?
18,76,764
1944196 Asked
3,689
Active Tutors
1421414
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!