public override void InitializeCommand(OracleCommand command) { command.CommandText = OracleDatabaseCommands.SelectTableAllocatedBytesCommandText; command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"')); command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"')); command.AddSimpleParameter("PARTITION_NAME", _partitionName.Trim('"')); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = OracleDatabaseCommands.SelectViewSelectCommand; command.InitialLONGFetchSize = Int32.MaxValue; command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"')); command.AddSimpleParameter("VIEW_NAME", _objectIdentifier.Name.Trim('"')); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = String.Format(OracleDatabaseCommands.SelectIndexDescriptionCommandText); command.AddSimpleParameter("TABLE_OWNER", _objectIdentifier.Owner.Trim('"')); command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"')); command.AddSimpleParameter("COLUMN_NAME", String.IsNullOrEmpty(_columnName) ? null : _columnName.Trim('"')); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = OracleDatabaseCommands.SelectColumnStatisticsCommandText; command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"')); command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"')); command.AddSimpleParameter("COLUMN_NAME", _columnName.Trim('"')); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = _commandText; command.AddSimpleParameter("OBJECT_TYPE", _objectType); command.AddSimpleParameter("NAME", _objectIdentifier.Name.Trim('"')); command.AddSimpleParameter("SCHEMA", _objectIdentifier.Owner.Trim('"')); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = BuildCommandText(OracleDatabaseCommands.SelectTableSubPartitionsDetailsCommandTextBase, _includeInMemorySettings); PartitionDataProvider.InitializeCommand(command, _subPartitionOwner); command.AddSimpleParameter("PARTITION_NAME", _partitionDataModel?.Name); command.AddSimpleParameter("SUBPARTITION_NAME", _subPartitionDataModel?.Name); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = OracleDatabaseCommands.SelectIndexColumnDescriptionCommandText; command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"')); command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"')); command.AddSimpleParameter("COLUMN_NAME", String.IsNullOrEmpty(_columnName) ? null : _columnName.Trim('"')); _indexes = DataModel.IndexDetails.ToDictionary(i => OracleObjectIdentifier.Create(i.Owner, i.Name)); }
public override void InitializeCommand(OracleCommand command) { command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"')); command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"')); if (String.IsNullOrEmpty(_columnName)) { command.CommandText = String.Format(OracleDatabaseCommands.SelectTableCommentCommandText); } else { command.CommandText = String.Format(OracleDatabaseCommands.SelectColumnCommentCommandText); command.AddSimpleParameter("COLUMN_NAME", _columnName.Trim('"')); } }
public override void InitializeCommand(OracleCommand command) { command.CommandText = OracleDatabaseCommands.SelectSessionsStatisticsCommandText; command.AddSimpleParameter("SID", DataModel.SessionId); DataModel.StatisticsRecords.Clear(); }
public override void InitializeCommand(OracleCommand command) { command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"')); command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"')); if (String.IsNullOrEmpty(_columnName)) { command.CommandText = OracleDatabaseCommands.SelectTableConstraintDescriptionCommandText; } else { command.CommandText = OracleDatabaseCommands.SelectColumnConstraintDescriptionCommandText; command.AddSimpleParameter("COLUMN_NAME", _columnName.Trim('"')); } command.InitialLONGFetchSize = 32767; }
public async Task Start(CancellationToken cancellationToken) { _debuggedSessionCommand.CommandText = OracleDatabaseCommands.StartDebuggee; _debuggedSessionCommand.AddSimpleParameter("DEBUG_SESSION_ID", null, TerminalValues.Varchar2, 12); var debuggedSessionIdParameter = _debuggedSessionCommand.Parameters[0]; await _debuggedSessionCommand.ExecuteNonQueryAsynchronous(cancellationToken); _debuggerSessionId = ((OracleString)debuggedSessionIdParameter.Value).Value; TraceLog.WriteLine($"Target debug session initialized. Debug session ID = {_debuggerSessionId}"); await Attach(cancellationToken); TraceLog.WriteLine("Debugger attached. "); var attachTask = Synchronize(cancellationToken).ContinueWith(AfterSynchronized, cancellationToken, TaskContinuationOptions.OnlyOnRanToCompletion); _debuggedAction = DebuggedCommand.ExecuteNonQueryAsynchronous(cancellationToken); TraceLog.WriteLine("Debugged action started. "); await attachTask; }
public override void InitializeCommand(OracleCommand command) { command.CommandText = OracleDatabaseCommands.SelectCompilationErrorsCommandText; command.AddSimpleParameter("OWNER", _owner); command.AddSimpleParameter("NAME", _objectName); }
private static void InitializeCommand(OracleCommand command, OracleObjectIdentifier partitionOwner) { command.AddSimpleParameter("TABLE_OWNER", partitionOwner.Owner.Trim('"')); command.AddSimpleParameter("TABLE_NAME", partitionOwner.Name.Trim('"')); command.InitialLONGFetchSize = HighValueMaxLength + 1; }
public override void InitializeCommand(OracleCommand command) { command.CommandText = OracleDatabaseCommands.SelectCursorExecutionStatisticsCommandText; command.AddSimpleParameter("SQL_ID", _sqlId); command.AddSimpleParameter("CHILD_NUMBER", _childNumber); }
public async Task <bool> IsRunning(CancellationToken cancellationToken) { _debuggerSessionCommand.CommandText = "BEGIN IF dbms_debug.target_program_running THEN :isRunning := 1; ELSE :isRunning := 0; END IF; END;"; _debuggerSessionCommand.Parameters.Clear(); _debuggerSessionCommand.AddSimpleParameter("ISRUNNING", null, TerminalValues.Number); await _debuggerSessionCommand.ExecuteNonQueryAsynchronous(cancellationToken); var isRunning = ((OracleDecimal)_debuggerSessionCommand.Parameters[0].Value).Value; return(Convert.ToBoolean(isRunning)); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = String.Format(OracleDatabaseCommands.SelectExecutionPlanTextCommandTextBase, _resolveAdaptivePlan ? "ADAPTIVE" : null); command.AddSimpleParameter("SQL_ID", _sqlId); command.AddSimpleParameter("CHILD_NUMBER", _childNumber); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = OracleDatabaseCommands.SelectTableDetailsCommandText; command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"')); command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"')); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = OracleDatabaseCommands.SelectUserAdditionalData; command.AddSimpleParameter("USERNAME", DataModel.Schema.Name.Trim('"')); }
private static void AddDebugParameters(OracleCommand command) { command.AddSimpleParameter(ParameterDebugActionStatus, null, TerminalValues.Number); command.AddSimpleParameter("BREAKPOINT", null, TerminalValues.Number); command.AddSimpleParameter("INTERPRETERDEPTH", null, TerminalValues.Number); command.AddSimpleParameter("LINE", null, TerminalValues.Number); command.AddSimpleParameter("OER", null, TerminalValues.Number); command.AddSimpleParameter("REASON", null, TerminalValues.Number); command.AddSimpleParameter("STACKDEPTH", null, TerminalValues.Number); command.AddSimpleParameter("TERMINATED", null, TerminalValues.Number); command.AddSimpleParameter("DBLINK", null, TerminalValues.Varchar2, 30); command.AddSimpleParameter("ENTRYPOINTNAME", null, TerminalValues.Varchar2, 512); command.AddSimpleParameter("OWNER", null, TerminalValues.Varchar2, 30); command.AddSimpleParameter("NAME", null, TerminalValues.Varchar2, 30); command.AddSimpleParameter("NAMESPACE", null, TerminalValues.Number); command.AddSimpleParameter("LIBUNITTYPE", null, TerminalValues.Number); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = OracleDatabaseCommands.SelectTableInMemoryAllocatedBytesCommandText; command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"')); command.AddSimpleParameter("SEGMENT_NAME", _objectIdentifier.Name.Trim('"')); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = OracleDatabaseCommands.SelectProfileDetails; command.AddSimpleParameter("PROFILE", DataModel.Name); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = String.Format(OracleDatabaseCommands.SelectExplainPlanCommandText, DataModel.TargetTableName); command.AddSimpleParameter("STATEMENT_ID", DataModel.ExecutionPlanKey); }
public override void InitializeCommand(OracleCommand command) { command.CommandText = OracleDatabaseCommands.SelectTablespaceDatafiles; command.AddSimpleParameter("TABLESPACE_NAME", DataModel.Name); }