Featured
The Latest
-
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
-
|
snapshot controlfile and RMAN-08512
As RMAN needs a consistent view of the control file it takes a backup of the controlfile by creating a… READ MORE
-
How to find length of a TEXT column?
The “LEN” function cannot be used to find length of a column of datatype “TEXT” so using function “DATALENGTH” one… READ MORE
-
|
How to find permissions granted on individual objects in a database?
Run the following SQL to find permissions granted on individual objects on the database select case when p.protecttype = 205… READ MORE
-
How to find average row length for a table?
Using the following PL/SQL code one can find average size of a row in a table, the following code samples… READ MORE
-
|
Sample program that transfers data from MySQL to Oracle (CLOB)
Table structure in Oracle SQL> desc scott.oracletable; Name Null? Type —————————————– ——– ———- TRANSDATE NOT NULL DATE SEQUENCE_NO NOT NULL… READ MORE
-
|
How to skip blank lines in between SQL statements in SQL*Plus?
If a SQL script file has blank lines in between SQL statements one may see errors when executing the script… READ MORE
-
|
How to turn off case sensitive in 11g
SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON NAME TYPE VALUE ———————————— ———– —————————— sec_case_sensitive_logon boolean TRUE SQL> SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON =… READ MORE
-
How to find users with default password in 11g?
Now Oracle has a quick way to find users with detault password. SQL> SELECT * FROM dba_users_with_defpwd; And here is… READ MORE
Recent posts
Quote of the week
“Control what I can control”
~ Alex Lima
Categories
- 18c
- 19c
- AIX
- Archivelog
- Auditing
- 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
- kubernetes
- Leadership
- Linux
- Listener
- LOB
- Lock
- Log Miner
- mac
- Microservices
- Monitor
- Motocycling
- MySQL
- NetApp for Oracle
- networking
- OCI
- OEM – Grid Control
- Open Shift
- 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
