12,246 reputation
12035
bio website ddbcinc.com
location Rochester Hills, MI
age 38
visits member for 3 years, 9 months
seen 1 hour ago
Oracle ACE

2d
comment The most important oracle database performance metrics
What is the problem that you're trying to solve? Identifying 10 metrics which are most relevant to my systems probably does you little good because your systems probably have very different characteristics. Some systems have I/O as their primary bottleneck, some have CPU, some have networking, some have user locks. My systems might be more (or less) memory constrained than yours leading me to care about different metrics than you.
Oct
21
comment Is there anyway to search PL/SQL reserved words with contains function?
What do you consider "Oracle reserved words"? "do", for example, is not a reserved word in v$reserved_words.
Oct
20
comment Is there anyway to search PL/SQL reserved words with contains function?
Are you trying to search the text of code stored in Oracle (which is what I initially read your question as asking)? Or are you trying to search for data stored in a user-defined table? If you're searching for data in a user-defined table, can you create an Oracle Text index on that table?
Oct
20
comment Is there anyway to search PL/SQL reserved words with contains function?
@Andy - Sorry, I'm afraid that comment doesn't clarify anything for me. It may be useful to expand your question to include, say, a few example pieces of code, the types of searches you want to run, and the expected results of those searches on that sample code. Neither "for test" or "do test" are keywords in PL/SQL-- "for" is a keyword but neither "do" nor "test" are.
Oct
17
comment grant permissions in oracle from one database to another
@KyleM - It would be whatever the TNS alias on the EmployeeDB database for the ContractorDB database is. That's generally going to be the same as the name of the database but that's just a naming convention-- your TNS alias might be different.
Oct
14
comment What do these pstart and pstop values mean?
@jubil - Short of tracing the session, I don't know of a way to do that.
Oct
13
comment work with json in oracle
What version of Oracle? 12c introduces native JSON types.
Oct
9
comment Is it impossible to iterate table rows in Oracle PL/SQL without using a cursor?
Why do you ask? What problem are you trying to solve? "without using a cursor" is also rather problematic since each and every SELECT statement opens a cursor. Both your examples use exactly the same number of cursors (or would if they worked). A SELECT ... INTO that returns anything other than 1 row will throw an exception no_data_found or too_many_rows so it would never make sense to check the rowcount (which I assume you meant rather than rownum) after doing a SELECT INTO.
Sep
26
comment Oracle Support Identifiers?
Your tags indicate that you're using Oracle XE, the unsupported, free version of Oracle. You can't buy support for Oracle XE. You can upgrade to the standard edition (Oracle SE or Oracle SE 1 depending on the server) in which case you'd purchase your first year of support when you purchase your license.
Aug
27
comment PL/SQL operating system call
@Ekevoo - Any number of queuing mechanisms can be implemented without polling (though one process polling even every few seconds for a very small number of requests shouldn't come close to putting a dent in a tiny server). Oracle AQ can be configured so that the message automatically kicks off the process (once the triggering transaction completes of course). For sufficiently small volumes of requests, your APEX process could also submit a dbms_job job that runs (more or less) immediately after the triggering transaction commits and calls a Java stored proc to shell out.
Aug
26
comment In PL/SQL what is the usage of row level and column level attributes?
What do you mean by "row level and column level attributes"? Do you have an example of what you're talking about? Or a link to a document with some context?
Aug
21
comment Escape characters in Oracle dump
What does "take a dump" mean in this context? A "dump file" is a common term for the output of the Oracle export utility, either the regular version or the DataPump version. If you are using the Oracle export utility, however, the question doesn't make sense. That leads me to believe that you are using some other tool to generate some other sort of file.
Aug
13
comment Exporting scheduled jobs in Oracle
@ik_zelf - D'oh, you're right. Updated my answer to use the old PROCOBJ trick. I thought that was no longer necessary but apparently I was mistaken.
Aug
5
comment How to move 200 materialized views without having to re-create in the new home
What does "moving" mean to you? I would read that to mean something like "taking an RMAN backup, shutting down the existing database, restoring the backup on the new server, starting up the database". But if that's what you're doing, I don't see why you would need to re-create anything.
Aug
4
comment Oracle 12c, exclude rows wher two columns are both null
Are the varchar2(508 byte) columns expected contain non-numeric characters (i.e. you have some rows that have the string "foo" and other rows that have the string "1.25" and you expect that predicates in the view return only those strings that have numeric characters)?
Aug
4
comment Oracle 12c, exclude rows wher two columns are both null
Are these two columns in the view selecting data from table(s) where the data is numeric? Or is the view selecting data from table(s) where the data is a varchar2 and you are implicitly or explicitly casting the data to a number in the view? Are there rows in the underlying table that have non-numeric data in those columns?
Jul
31
comment Oracle Tables Visible to Other Users
A DBA would generally have the SELECT ANY TABLE privilege so a DBA would be able to query any table in the database without needing any additional grants. The SELECT ANY TABLE privilege is part of the DBA role so any user with the DBA role would be able to select any table in the database. Of course, as @Vérace points out, that doesn't really constitute "tightening up security".
Jul
31
comment Oracle Tables Visible to Other Users
Post exactly what statements you are executing and what errors, if any, you are getting. If you are actually granting a user select access on a table and that user is using the fully qualified table name to query the table, that would be successful. If your query isn't successful, we'd need to see what you're doing before we can guess where you're going wrong.
Jul
31
comment Oracle Tables Visible to Other Users
What does "no tables visible to the users" mean? Are you using some sort of front-end GUI? Are you querying all_tables? Or user_tables? Are you running a query against the table? If so, are you using the fully qualified table name?
Jul
25
comment different outcome based on function execution method
@Andrew - If there was one feature that I could remove, or at least require an extensive examination before it was used, it would be autonomous transactions. They are very useful in a couple of very specific situations. But they are giant "manual override" lets you overrule Oracle when it attempts to stop you from doing something stupid. And the vast majority of people using them are not smarter than the database.