In Toad I can't see any historgram on TAB1 in the schema browser.. Running Oracle 11.2 on Linux.. Question:If a table with columns are "in" dba_tab_historgarms does this actually mean that there are a histogram on the tables/column?
We are playing with Toad 9.7 and seems like the right tools for Trade. The schema browser on left hand side I am keeping on Multi Tab type.The one problem is that when I select Table or Constraint from there, the tabs rearrange and is quite annoying to find another tab say View again since it has changed its location.
Is there any way to keep the TABS fixed to their location so when you select no changing of their position occur.
I'm trying to collect histograms for column COL_C of table TAB_A(150K records), So an index "BAD_IDX" will *not* be used in a query when the value is not selective.
This is my query:
SELECT COL_A, COL_B , COL_C , COL_D , COL_E , COL_F FROM TAB_A WHERE COL_A = 050 AND COL_B = 13012345 AND COL_C = 0 AND COL_D = 0 AND COL_D >= '07/23/2013 00:00:00' ORDER BY COL_E ASC;
Now, I have index "BAD_IDX" on columns (COL_C, COL_E ).and the distribution of values looks like this:
select COL_C, count(*) FROM TAB_A --very not selective for 0, selective for the rest, also no histogram group by rollup(COL_C) order by 2 desc;
and the result is 20k row long (20k distincts), So I'll post just the top part of it:
Now, the problem with the query was that "COL_B = 13012345" was the most selective predicate, And an index for it did not exist, so the index "BAD_IDX" is used, and is scanning 86k records (all the "0" value records for column COL_C)!
So, I created an index
Create index GOOD_IDX on TAB_A(COL_B) compute statistics;
However, that BAD_IDX index is still being used! I've thought that maybe it's because the lack of histograms for the column COL_C.I've also understood from documentation I've read that the suitable histogram type is TOP FREQUENCY, Because although I have 20k distincts here for the column COL_C, what does the difference is the 86k records of value 0.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "MVANMANNEKES"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded Starting "MVANMANNEKES"."SYS_IMPORT_SCHEMA_01": mvanmannekes/******** schemas=cmsstagingb remap_tablespace=cmsliveb_data:cmslivea_data
I captured the process id of the browser. I wanted to know whether the process id of the browser is dead or not after we close the browser. How can I check the condition for the process id in oracle forms?
Probably if I give the installation procedure I went through and specified Error messages,. Installation Option: - Create and configure database was selectedSystem Class: -Sever Class was selected Install Product:-Oracle Database Installation= Succeeded· Prepare= Succeeded· Copy files= Succeeded· Setup files= SucceededOracle database configuration= Succeeded· Oracle Net Configuration Assistant=Succeeded· Oracle database configuration Assistant=Ignored· Oracle configuration Manager Configuration (optional)=Succeeded In the process of the Install Product the following Error messages
When I click on 'Run Form', the Applet is not opening in Internet Explorer.
Giving Error like " Internet Explorer has encountered a problem and needs to close. We are sorry for the inconvenience." Even I have re-installed the oracle 10g the same problem is coming.
Note: When I remove jinitiator and then reinstall jinitiator the applet is opening once and again if I run the form second time the same above error is coming.
Currently i am using IE 6 for running my forms 10g, I like to know upto which IE Versions i can update so it must not affect my Oracle forms 10g running.
i like to update to IE 8, but it must not affect my forms runtime functionality!
Is there a way to start a new browser session from a call in an existing 11g form. I have a situation where in the client / server world I open a form in a new window .
I have a list box that is populated from a record group using a WHEN-NEW-FORM trigger. When I run the form this displays fine when the list box is set as Poplist or Tlist, but when I change this to combo box and run the form it doesn't load properly in the browser (a blank screen followed by the background a a toolbar that says window).
I am working on Forms [32 Bit] Version 11.1.1.4.0 (Production). OS is Win 7 (32 bit). Internet Explorer 8. My Requirement is I need to raise an alert when user close the browser window before closing the Form.
When I try to run the form by clicking Program/Run form, it opens a webpage(explorer) and displays ?ORACLE FORMS? label, but does not show the form only blank screen appear. When I try to run the form by clicking Program/Run form, it opens a webpage(Firefox), but does not show the form only blank screen appear.
I have noticed that in Start OC4J Instance it has some thing like as below:
SYSDATE TIME FormsServlet init(): configFileName: E:DevSuiteHome_2/forms/server/formsweb.cfg testMode: false
pop-ups is not blocked in my browser I have allow active content to run in files on your computer.directory name (where the form is stored) also doesn't contain any spaces.
Also I have change the
baseHTMLjinitiator=basejini.htm to this baseHTMLjinitiator=basejpi.htm.
I have done all the things mention in this forum to overcome this error.But, still the same problem is there.Also please take a note that I am using JRE not JINITIATOR. Beacuse when I am using the JINITIATOR it give me the problem of browser crash in both IE and firefox.Also I am using Windows XP and oracle form 10g.
For all my client machine Internet Explorer 8 is not working. Internet Explorer 7 is working fine . For a machine with Internet Explorer 8 after Installing Mozilla Firefox it's working under Mozilla Firefox Browser well.
i have developed an oracle form application in oracle developer 10g, now i want to make it accessible based on a browser to the clients(make it a web aaplication form)
I have a table with about 15-20 constraints and when I look up the tables constraints in SQL workshop, I can only see 10 constraints. Not sure if its a bug or I need to configure something, somewhere to make it show alll my constraints. I can see all constraints by querying the user_constraints view.
I have problems with calling procedure directly from webbrowser. I have a procedure test in test_pkg package. I granted execute on it to anonymous , added it to wwv_flow_epg_include_mod_local function and still have error 404.searched this forum and found this: Does listener use wwv_flow_epg_include_mod_local
So I granted to apex_public_user and created synonym for him to my package. And it starts working. But then I wanted to add next proceudre to my package the same way, and change my test procedure and it stop working again. Now I have 404 error again.
A single master schema where many developers are accessing. all share same password.
now i would like to trace all the changes made by each users. so i create a individual users for all and grant permission to access that schema.do i have a possibility of auditing the changes did by each user for that particular schema
We have an application with many separate databases (one per customer). Given they share the same business requirements (service hours, change mgmt etc), we're interested in potentially consolidating the separate DBs (which are relatively small) into separate schemas within a fewer no of databases to reduce the overhead.
Our issue is that the application is hard-coded to use a specific administrator and application connection user name. Changing this is unfortunately not an option.
Given this limitation, is there any possibility to map a generic user into a customer-specific schema based on the database service that they connect to? Each customer connects to different database services but may use the same user name. We considered using private synonyms but this seems to acheive the opposite (i.e. many different users could connect and map to a single users schema). One thing to point out is that where there is a single user name, it is acceptable for a single password to be used across the different customer DBs as they will be a single admin/user.
I would like to create a table in another schema(CBF) as already exist in my schema(TLC) without data but related indexes,synonyms and grants should be include.
How could I do this without using export import. I am using TOAD 9.0.1.
move the tables with data present in the user scott(full) to another schema named test. In my case scott is in user tablespace and for test schema i have created different tablespace named test_tbs.
