On reporting queries, there are too many “enq: KO – fast object checkpoint” wait event. All reporting queries are doing full table scans concurrently. Oracle uses direct path reads instead of db file scattered reads. And direct path reads require a checkpoint “_serial_direct_read”=NEVER Parameter Session Value Instance Value ————————————————– —————————— —————————— _serial_direct_read auto auto
Following code will be used for adding multiple entries to <?php // This is needed to use WP functions. require_once(‘../wp-load.php’); //echo “%%%%”. preg_replace(“/:/”, ” “, “21-Dec-2010:10:37:27”, 1); // Category tables are // wp_terms here term_id will present category_id, // wp_term_relationship show relationships with posts. // wp_term_taxonomy-for total post count // 4= oracle, 10-sqlscripts // Read…
Read More “PHP code to add WordPress posts in bulk programmatically” »
SET MARKUP HTML ON SPOOL ON generates an HTML page for each subsequently spooled file. The HTML tags in a spool file are closed when SPOOL OFF is executed or SQL*Plus exits. You can use SET MARKUP HTML ON SPOOL OFF to generate HTML output suitable for embedding in an existing web page. HTML output…
