Featured
The Latest
-
|
How to enable/disable a job scheduled in SQLServer Agent?
http://blog.flimatech.com/?p=1291 READ MORE
-
|
DBA_TAB_MODIFICATIONS
DBA_TAB_MODIFICATIONS view contains tables that were modified since last time statistics was gathered on the table. It contains the number… READ MORE
-
|
SET STATISTICS
SET STATISTICS TIME [ON|OFF] – Tells how much CPU time and time taken to parse and compile and also the… READ MORE
-
Truncate statement in SQLSever
In SQLServer TRUNCATE TABLE can be rolled back when within a transaction. TRUNCATE still doesn’t log each row when it’s… READ MORE
-
|
How to see job owner, Email operator, Event Notification, Email Notification on jobs scheduled?
Using the SELECT statement below one can list notications that occur for jobs scheduled on SQLServer. SELECT –Job name sj.name… READ MORE
-
Built-in functions
— SQL server version SELECT @@version output: Microsoft SQL Server 2005 – 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright… READ MORE
-
How to see history of jobs scheduled in SQL Server?
Information on sysjobhistory Information on sysjobs — shows job history with the most recent one to show the most recent… READ MORE
-
|
Run Command Shortcuts for Administrative Tools
http://msmvps.com/blogs/ad/archive/2006/10/27/Run-Command-Shortcuts-for-Adminstrative-Tools.aspx READ MORE
-
How to monitor shared pool?
http://www.dba-oracle.com/t_x$ksmlru_x$ksmsp_shared_pool_monitoring.htm READ MORE
-
|
Window tools
Here are some of the windows tools that can be used when working on window internals. Autoruns (autoruns.exe) – http://technet.microsoft.com/en-us/sysinternals/bb963902.aspx… READ MORE
-
How to see backup history through the back-end?
By querying msdb.dbo.backupset and msdb.obackupmediafamily one can see backup history like start and end time, type of backup, location of… READ MORE
-
|
How to create differential backup?
Using the following T-SQL one can create differential backup or make it part of scheduled job. declare @datetimestamp varchar(20) declare… READ MORE
-
How to find the trace file name?
To find the trace file one using oradebug one can find it using the example below: SQL> oradebug mysetpid Statement… READ MORE
-
How to set unlimit size of trace file?
Using oradebug unlimit one can set to unlimit the size of the trace file. SQL> oradebug setmypid Statement processed. SQL>… READ MORE
-
|
How to use oradebug to connect to a session?
To use oradebug one first needs to connect to a session using the process id or ora pid. One can… READ MORE
-
How to monitor jobs that are running on SQLServer through SQLServer Agent?
By calling msdb..sp_get_composite_job_info or msdb.dbo.sp_help_job one can find the current jobs running on SQLServer. Example: exec msdb..sp_get_composite_job_info @execution_status=1 Or exec… READ MORE
-
Information on using dbms_stats.copy_table_stats
http://dioncho.wordpress.com/tag/copy_table_stats/ READ MORE
-
|
Information on dynamic sampling
http://www.oracle.com/technology/oramag/oracle/09-jan/o19asktom.html READ MORE
-
How to extend an account whose password is expiring?
One of the ways to extend the password of an expiring account is to change the profile of the user.… READ MORE
-
DDL to disable triggers in Oracle and SQLServer
To disable to trigger that are enabled in cases when loading data manually in a particular schema or table can… READ MORE
Recent posts
Quote of the week
“Control what I can control”
~ Alex Lima
Categories
- 18c
- 19c
- AIX
- Archivelog
- Auditing
- AWR
- Backup
- Backup & Recovery
- Batch
- Big Data
- Built-in stored procedures
- Connections
- Control file
- Cursor
- Database
- Dataguard
- Dataguard
- Datatypes
- Date
- Docker
- events
- exp
- Export
- Flashback
- General DBA
- Globalization
- GoldenGate
- Grant
- Initialization
- install
- Internal
- JDBC
- Jobs
- Leadership
- Linux
- Listener
- LOB
- Lock
- Log Miner
- mac
- Microservices
- Monitor
- Motocycling
- MySQL
- NetApp for Oracle
- networking
- OCI
- OEM – Grid Control
- OpenWorld 2010
- ORA Errors
- Oracle RAC
- oradebug
- OS
- osql
- Parameters
- partition
- Password
- performance
- PL/SQL
- postgres
- Power Shell
- Primavera
- Product Management
- Profiler
- Project Management
- Python
- REST API
- RMAN
- role
- Scheduler
- Scripts
- Security
- sga
- Shared Pool
- Shell
- snapshot
- SQL – DDL
- SQL Developer
- SQL Server
- SQL*Plus
- SQLcl
- startup
- Statistics
- Statspack
- Table
- tablespace
- trace
- Transaction
- Tuning
- Tuning
- Undo
- Unix
- Upgrade
- vi
- windows
Alex Lima 