|
oci_set_db_operationSets the database operation Description
bool oci_set_db_operation(resource
$connection , string $action )Sets the DBOP for Oracle tracing. The database operation name is registered with the database when the next 'round-trip' from PHP to the database occurs, typically when a SQL statement is executed.
The database operation can subsequently be queried from database administration
views such as The oci_set_db_operation function is available when OCI8 uses Oracle 12 (or later) Client libraries and Oracle Database 12 (or later). Parameters
Return Values
Returns Examples
Example #1 Setting the DBOP
// While the script is running, the administrator can see the database operations // being performed: sqlplus system/welcome SQL> select dbop_name from v$sql_monitor; NotesCaution
Round-trip GotchaSome but not all OCI8 functions cause round-trips. Round-trips to the database may not occur with queries when result caching is enabled. See Also
|