xplain plan of sql_id from cursorxplain plan of sql_id from AWRGet sql_text from sidxplain plan of a sql statementxplain plan of a sql baselineGet bind values of a sql_idFlush a sql query from cursorTracing all session of a userEnable trace for a session10053 OPTIMIZER TRACEEnable trace for a sql_idexecution detail of a sql_id in cursorEnable tracing for a listenerPga usage by sessionssegments with high physical readI/O usage of each tempfileCurrent SGA usageTop running queries from ASHFind blocking sessions from ASHTop cpu consuming sessionsSessions holding library cache lockObjects locked by library cacheSessions accessing an objectSqls doing full table scanDictionary cache hit ratioMutex sleep in databaseQueries causing high physical readObjects causing latch contentionLatch type and sql hash valueObjects causing flushing of shared poolSql tuning advisor for sql_id from cursorrun sga target advisoryRun shared pool advisoryGenerate addm report
oradump to mysql full 24
rman full database backup scriptRMAN INCR db backup run blockrman tablespace backup run blockRMAN datafile(s) backup run blockdelete archive older than 1 daybackup archivelogs using RMANCopy archive from ASM to Mount pointbackup archive between 2 sequence numberEnable trace for RMANRecover dropped table with RMAN 12cMonitor rman backup progressRestore archivelog from rman tapeEnable block change trackingcheck the syntax of RMAN commands
select module,parsing_schema_name,inst_id,sql_id,plan_hash_value,child_number,sql_fulltext,to_char(last_active_time,'DD/MM/YY HH24:MI:SS' ),sql_plan_baseline,executions,elapsed_time/executions/1000/1000,rows_processed from gv$sqlwhere sql_id in ('&sql_id');
LSNRCTL> set trc_level ADMINConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_TEST)))LISTENER_TEST parameter "trc_level" set to adminThe command completed successfully
MySQL Repair Toolbox is the best solution for how to repair database in MySQL 200, MySQL Studio Express and MySQL Server 2005. MySQL Repair Toolbox provides a simple, step-by-step restore process which uses simple wizards to guide the user through the process. MySQL Repair Toolbox supports all major encoding systems with selective saving of restored data and creates a detailed database restore log. MySQL Repair Toolbox is the leading download utility for repairing MySQL easily and performing general MySQL Windows repairs. MySQL repair Toolbox supports MySQL 2000, MySQL Server 2005 and MySQL Studio Express; MySQL repair Toolbox is the leading MySQL Windows repair solution and without doubt, the best solution for how to repair database in MySQL 2000 and all major MySQL databases. There are two major components used in the MySQL Repair Toolbox - an error detection engine which is combined with an error database. The error detection engine will uncover any file anomaly no matter how it is created - by hardware failure, an error during saving or copying, or by computer infection. Once an error is detected it is matched to the error library which will identify the error and provide the recommended recovery solution for it. In addition, MySQL Repair Toolbox provides a host of database recovery features - it supports all major encoding systems, provides repair tools for MySQL database support preview of restored data with selective saving of restored data (providing the user with full control of the process). Users can export data directly to a new database on the server and MySQL Repair Toolbox provides a detailed database restore log. You can download MySQL Repair Toolbox simply from our secure, high-speed download site and we also provide full installation support - we even provide a guarantee that if you cannot recover your MySQL database, simply send it to us and we will recover it for you - no other product provides this - download MySQL Repair Tool now! 2ff7e9595c
Comentários